Advertisement
Guest User

Untitled

a guest
Mar 25th, 2018
908
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
HTML 1.92 KB | None | 0 0
  1. <html>
  2.   <body>
  3.     <?php
  4. $username="username";
  5. $password="password";
  6. $database="your_database";
  7. $mysqli = new mysqli("localhost", $username, $password, $database); @mysql_select_db($database) or die( "Unable to select database");
  8. $query2="SELECT * FROM tablename";
  9. $result=$mysqli->query($query2);
  10. $num=$mysqli->mysqli_num_rows($result);?>
  11.     <table border="0" cellspacing="2" cellpadding="2">
  12.       <tr>
  13.         <td>
  14.           <font face="Arial, Helvetica, sans-serif">Value1
  15.           </font>
  16.         </td>
  17.         <td>
  18.           <font face="Arial, Helvetica, sans-serif">Value2
  19.           </font>
  20.         </td>
  21.         <td>
  22.           <font face="Arial, Helvetica, sans-serif">Value3
  23.           </font>
  24.         </td>
  25.         <td>
  26.           <font face="Arial, Helvetica, sans-serif">Value4
  27.           </font>
  28.         </td>
  29.         <td>
  30.           <font face="Arial, Helvetica, sans-serif">Value5
  31.           </font>
  32.         </td>
  33.       </tr>
  34.       <?php
  35. $i=0;
  36. while ($i < $num) {
  37. $f1=mysql_result($result,$i,"field1");
  38. $f2=mysql_result($result,$i,"field2");
  39. $f3=mysql_result($result,$i,"field3");
  40. $f4=mysql_result($result,$i,"field4");
  41. $f5=mysql_result($result,$i,"field5");?>
  42.       <tr>
  43.         <td>
  44.           <font face="Arial, Helvetica, sans-serif">
  45.             <?php echo $f1; ?>
  46.           </font>
  47.         </td>
  48.         <td>
  49.           <font face="Arial, Helvetica, sans-serif">
  50.             <?php echo $f2; ?>
  51.           </font>
  52.         </td>
  53.         <td>
  54.           <font face="Arial, Helvetica, sans-serif">
  55.             <?php echo $f3; ?>
  56.           </font>
  57.         </td>
  58.         <td>
  59.           <font face="Arial, Helvetica, sans-serif">
  60.             <?php echo $f4; ?>
  61.           </font>
  62.         </td>
  63.         <td>
  64.           <font face="Arial, Helvetica, sans-serif">
  65.             <?php echo $f5; ?>
  66.           </font>
  67.         </td>
  68.       </tr>
  69.       <?php
  70. $i++;
  71. }?>
  72.       </body>
  73.     </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement