Guest User

Untitled

a guest
Jul 19th, 2018
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. <?php
  2. $host = "localhost";
  3. $user = "root";
  4. $password = "nopass";
  5. $db = "jiguri";
  6. $conn = mysql_connect($host,$user,$password) or die("Problems connecting:" . mysql_error());
  7. $dbselect = mysql_select_db($db, $conn) or die("Error selecting DB:" . mysql_error());
  8. $check = "select * from `seriale`";
  9. $result_check = mysql_query($check);
  10. $count = mysql_numrows($result_check);
  11.  
  12. echo '<table border="1" cellpadding="15" cellspacing="0">
  13. <tbody>
  14. <tr>
  15. <th>id</th>
  16. <th>serial</th>
  17. </tr>
  18. ';
  19. for ($i=0;$i<$count;$i++)
  20. {
  21. $id = "select id from `seriale`";
  22. $result_id = mysql_query($id);
  23. $id_list = mysql_result($result_id,$i);
  24. $serial = "select serial from `seriale`";
  25. $result_serial = mysql_query($serial);
  26. $serial_list = mysql_result($result_serial,$i);
  27. echo "<tr><td>" . $id_list . "</td><td>" . $serial_list . "</td></tr>"."\n";
  28. }
  29. echo "</tbody></table>";
  30. ?>
Add Comment
Please, Sign In to add comment