Posted By

juanchifc on 10/15/10


Tagged

show mysql database sql php fields recover


Versions (?)

Who likes this?

2 people have marked this snippet as a favorite

bobbym245
koyotebr


Recover fields from a database


 / Published in: PHP
 

By using this snippnet we can recover and show on a table the items stored into a sql database managed with mysql.

  1. <?php
  2.  
  3. $servidor="localhost";
  4. $usuario="root";
  5. $pass="";
  6. $base_datos="db_amigos";
  7.  
  8. $link=mysql_connect($servidor, $usuario, $pass);
  9. mysql_select_db("db_amigos", $link);
  10. $result = mysql_query("SELECT nombre, movil, mail, twitter FROM amigos", $link);
  11.  
  12. if ($row = mysql_fetch_array($result)){
  13.  
  14. echo "<table border = '1'> \n";
  15. echo "<tr> \n";
  16. echo "<td><b>Nombre</b></td> \n";
  17. echo "<td><b>Móvil</b></td> \n";
  18. echo "<td><b>Mail</b></td> \n";
  19. echo "<td><b>Twitter</b></td> \n";
  20. echo "</tr> \n";
  21.  
  22. do {
  23.  
  24. echo "<tr> \n";
  25. echo "<td>".$row["nombre"]."</td> \n";
  26. echo "<td>".$row["movil"]."</td>\n";
  27. echo "<td>".$row["mail"]."</td> \n";
  28. echo "<td>".$row["twitter"]."</td>\n";
  29. echo "</tr> \n";
  30.  
  31. } while ($row = mysql_fetch_array($result));
  32.  
  33. echo "</table> \n";
  34. } else {
  35.  
  36. echo "¡ La base de datos está vacia !";
  37. }
  38.  
  39. ?>

Report this snippet  

You need to login to post a comment.