Advertisement
dergunovs

Untitled

May 24th, 2017
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.79 KB | None | 0 0
  1. <?php
  2. $db_host='localhost';
  3. $db_name='global';
  4. $db_user='dergunov';
  5. $db_pass='neto1055';
  6. mysql_connect($db_host,$db_user,$db_pass);
  7. mysql_select_db($db_name);
  8. mysql_set_charset('utf8');
  9. $result=mysql_query('SELECT * FROM `books`');
  10. ?>
  11.  
  12. <table border="1" cellpadding="8" cellspacing="0">
  13.     <tr>
  14.     <th>Название</th>
  15.     <th>Автор</th>
  16.     <th>Год выпуска</th>
  17.     <th>Жанр</th>
  18.     <th>ISBN</th>
  19.     </tr>
  20.  
  21. <?php
  22.     while ($row = mysql_fetch_assoc($result)) {
  23.         $name = $row['name'];
  24.         $author = $row['author'];
  25.         $year = $row['year'];
  26.         $genre = $row['genre'];
  27.         $isbn = $row['isbn'];
  28.         echo "<tr>
  29.                 <td>$name</td>
  30.                 <td>$author</td>
  31.                 <td>$year</td>
  32.                 <td>$genre</td>
  33.                 <td>$isbn</td>
  34.               </tr>";
  35.     }
  36. ?>
  37.  
  38. </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement