uikolas

PHP Mysql prisijungimas ir lentelių rodymas

Dec 29th, 2011
152
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.48 KB | None | 0 0
  1. <?php
  2.  // Connects to your Database
  3.  mysql_connect("localhost", "root", "password") or die(mysql_error());
  4.  mysql_select_db("testas") or die(mysql_error());
  5.  
  6.  /*$result = mysql_query("SELECT * FROM info");
  7.  $row = mysql_fetch_assoc($result);
  8.  echo"".$row['name']."";*/ //rodo viena elelemta (pirma)
  9.  
  10.  
  11. $result = mysql_query("SELECT * FROM info ORDER BY id");
  12.  
  13. while($row = mysql_fetch_assoc($result)){
  14. echo"".$row['id']." - ".$row['name']." <br />";
  15. }
  16.  
  17. mysql_close();
  18. ?>
Advertisement
Add Comment
Please, Sign In to add comment