Advertisement
Guest User

Untitled

a guest
Oct 2nd, 2018
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.83 KB | None | 0 0
  1.     $DBhost = '127.0.0.1';
  2.     $DBname = 'mojedomena_cz';
  3.     $DBuser = 'root';
  4.     $DBpassword = '';
  5.    
  6.     $link = MySqli_Connect($DBhost,$DBuser,$DBpassword, $DBname) or die ('<B>Nelze konektovat databázový server!<B>');
  7.  
  8.     $select = 'select * from uzivatel where id>1 order by id';
  9.  
  10.     $vysledek = MySQLi_Query($link, $select);
  11.    
  12.     echo mysqli_error($link);
  13.  
  14.     $pocet_radku = mysqli_num_rows($vysledek);
  15.    
  16.     if ($pocet_radku>0)
  17.     {
  18.       echo '<table border=1>';
  19.       for ($i=1;$i<=$pocet_radku;$i++)
  20.       {
  21.           echo '<tr>';
  22.           $ntice = MySQLi_Fetch_Array($vysledek);
  23.           //print_r($ntice);
  24.           echo '<td>'.$ntice[0].'</td><td>'.$ntice[1].'</td><td>'.$ntice[2].'</td>';
  25.           echo '</tr>'."\n";
  26.       }
  27.       echo '</table>';
  28.     }
  29.    
  30.     mysqli_close($link);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement