Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host='localhost';
- $database='mydatabase';
- $user='root';
- $password='';
- $table = 'pairs_of_department';
- $connect = mysql_connect($host, $user, $password)
- or die("Не могу соединиться с MySQL.");
- mysql_select_db($database)
- or die("Не могу подключиться к базе.");
- $query = "SELECT * FROM " + $table;
- $res = mysql_query($query);
- echo '<table border="1">';
- echo '<thead>';
- echo '<tr>';
- echo '<th>Имя</th>';
- echo '<th>Телефон</th>';
- echo '<th>E-Mail</th>';
- echo '</tr>';
- echo '</thead>';
- echo '<tbody>';
- while($data = mysql_fetch_array($res))
- {
- echo '<tr>';
- echo '<td>' . $data['Stud_Surname'] . '</td>';
- echo '<td>' . $data['Teacher_Surname'] . '</td>';
- echo '<td>' . $data['Department'] . '</td>';
- echo '</tr>';
- }
- echo '</tbody>';
- echo '</table>';
- mysql_close($connect_to_db);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement