Advertisement
Guest User

yooo

a guest
Apr 10th, 2016
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.38 KB | None | 0 0
  1. <html>
  2. <body>
  3. <?php$username="username";$password="password";$database="your_database";
  4. mysql_connect(localhost,$username,$password);
  5. @mysql_select_db($database) or die( "Unable to select database");
  6. $query="SELECT * FROM tablename";$result=mysql_query($query);
  7. $num=mysql_numrows($result);mysql_close();?>
  8. <table border="0" cellspacing="2" cellpadding="2">
  9. <tr>
  10. <td>
  11. <font face="Arial, Helvetica, sans-serif">Value1</font>
  12. </td>
  13. <td>
  14. <font face="Arial, Helvetica, sans-serif">Value2</font>
  15. </td>
  16. <td>
  17. <font face="Arial, Helvetica, sans-serif">Value3</font>
  18. </td>
  19. <td>
  20. <font face="Arial, Helvetica, sans-serif">Value4</font>
  21. </td>
  22. <td>
  23. <font face="Arial, Helvetica, sans-serif">Value5</font>
  24. </td>
  25. </tr>
  26. <?php$i=0;while ($i < $num) {$f1=mysql_result($result,$i,"field1");
  27. $f2=mysql_result($result,$i,"field2");$f3=mysql_result($result,$i,"field3");
  28. $f4=mysql_result($result,$i,"field4");$f5=mysql_result($result,$i,"field5");?>
  29. <tr>
  30. <td>
  31. <font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font>
  32. </td>
  33. <td>
  34. <font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font>
  35. </td>
  36. <td>
  37. <font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font>
  38. </td>
  39. <td>
  40. <font face="Arial, Helvetica, sans-serif"><?php echo $f4; ?></font>
  41. </td>
  42. <td>
  43. <font face="Arial, Helvetica, sans-serif"><?php echo $f5; ?></font>
  44. </td>
  45. </tr>
  46. <?php$i++;}?>
  47. </body>
  48. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement