Guest User

Untitled

a guest
Jun 27th, 2018
230
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.56 KB | None | 0 0
  1. <?
  2. $username="username";
  3. $password="password";
  4. $database="your_database";
  5.  
  6. mysql_connect(localhost,$username,$password);
  7. @mysql_select_db($database) or die( "Unable to select database");
  8. $query="SELECT * FROM contacts";
  9. $result=mysql_query($query);
  10.  
  11. $num=mysql_numrows($result);
  12.  
  13. mysql_close();
  14.  
  15. echo "<b><center>Database Output</center></b><br><br>";
  16.  
  17. $i=0;
  18. while ($i < $num) {
  19.  
  20. $first=mysql_result($result,$i,"name");
  21. $last=mysql_result($result,$i,"rank");
  22. $phone=mysql_result($result,$i,"uuid");
  23.  
  24.  
  25. echo "$first,$last,$phone";
  26.  
  27. $i++;
  28. }
  29.  
  30. ?>
Add Comment
Please, Sign In to add comment