WordPress, Shopify ir PHPFusion programuotojų bendruomenė

Parašė -· 2009 Sau. 17 10:01:41

nu va turiu toki koda

#

//first you need to define db info

  define('mySQL_hostname', 'lia');  //database IP

  define('mySQL_database', 'lia');  //database name

  define('mySQL_username', 'lia');  //database user

  define('mySQL_password', 'lia');  //database password



//connects to mysql

  $db_link = mysql_pconnect( mySQL_hostname, mySQL_username, mySQL_password )

    or die( 'Error connecting to mysql<br><br>'.mysql_error() );



//connects to Database

  $db_select = mysql_select_db( mySQL_database, $db_link )

    or die( 'Error connecting to Database<br><br>'.mysql_error() );



//selects desired table

   $chars=mysql_query("SELECT * FROM characters");



//tells how much rows are there (will come helpfull with while loops)

   $rows =mysql_numrows($characters);



   $i=0;

   $x=0;



//while $i is smaller than number of rows repeat the code

   while ($i < $rows) {

    $online=mysql_result($chars,$i,"online"); //looks into characters table, under column online(if player is online its "0" else "1"), at row $i

    if ($online == 1) { $x++; } // if column online at row $i is "1", increase $x

    $i++; //increase $i

    }

   print 'Online players:<em>'.$x.'<em>'; //prints out the $x number of players online

Nu ten surasau savo db duomenis ir raso 0 online.Man atrodo nes db neturi is kur imt serverio duomenu ,o gal ce isvis reik serverio db duomenis surasit ? jei galit padekit

Redagavo -· 2009 Sau. 17 10:01:26