Advertisement
Guest User

Untitled

a guest
Jun 15th, 2014
180
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.89 KB | None | 0 0
  1. <?php
  2.     $host='localhost';
  3.     $database='mydatabase';
  4.     $user='root';
  5.     $password='';
  6.     $table = 'pairs_of_department';
  7.     $connect = mysql_connect($host, $user, $password)
  8.         or die("Не могу соединиться с MySQL.");
  9.     mysql_select_db($database)
  10.         or die("Не могу подключиться к базе.");
  11.     $query = "SELECT * FROM " + $table;
  12.     $res = mysql_query($query);
  13.     echo '<table border="1">';
  14.     echo '<thead>';
  15.     echo '<tr>';
  16.     echo '<th>Имя</th>';
  17.     echo '<th>Телефон</th>';
  18.     echo '<th>E-Mail</th>';
  19.     echo '</tr>';
  20.     echo '</thead>';
  21.     echo '<tbody>';
  22.     while($data = mysql_fetch_array($res))
  23.     {
  24.         echo '<tr>';
  25.         echo '<td>' . $data['Stud_Surname'] . '</td>';
  26.         echo '<td>' . $data['Teacher_Surname'] . '</td>';
  27.         echo '<td>' . $data['Department'] . '</td>';
  28.         echo '</tr>';
  29.     }
  30.     echo '</tbody>';
  31.     echo '</table>';
  32.     mysql_close($connect_to_db);
  33. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement