Advertisement
Guest User

Untitled

a guest
Sep 7th, 2016
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.01 KB | None | 0 0
  1. <?php // login.php
  2. $db_hostname = 'localhost';
  3. $db_database = 'test';
  4. $db_username = 'root';
  5. $db_password = '555555';
  6. ?>
  7.  
  8. <?php // query.php
  9. require_once 'login.php';
  10. $db_server = mysql_connect($db_hostname, $db_username, $db_password);
  11. if (!db_server)
  12. die("невозможно подключиться к базе данных: " , mysql_error());
  13. mysql_select_db($db_database)
  14. or die("невозможно подключиться к базе данных: " , mysql_error());
  15. $query = 'select * from class';
  16. $result = mysql_query($query);
  17. if (!$result)
  18. die("невозможно подключиться к базе данных: " , mysql_error());
  19. $rows = mysql_num_rows($result);
  20. for ($j = 0 ; $j < $rows; ++$j)
  21. {
  22. echo 'Author' . mysql_result($result,$j,'autor') . '<br/>';
  23. echo 'Title' . mysql_result($result,$j,'title') . '<br/>';
  24. echo 'Category' . mysql_result($result,$j,'category') . '<br/>';
  25. echo 'Year' . mysql_result($result,$j,'year') . '<br/>';
  26. echo 'ISBN' . mysql_result($result,$j,'isbn') . '<br/>';
  27. }
  28. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement