College-Eats/y_d_feedback.php at master · mohammadBasher/College-Eats · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
<!DOCTYPE html>
<html>
<head>
<title>Feedback form</title>
<link rel="stylesheet" type="text/css" href="table_style.css">
</head>
<body>
<?php
$server_NAME="localhost";
$admin_NAME="admin";
$password="localhost";
$database="first_DB";
$connect=mysqli_connect($server_NAME,$admin_NAME,$password,$database);
if(!$connect){
    die('connection failed:'.mysql_error());
    }
    $feedback="SELECT * FROM feedback_table
    WHERE canteen='yamuna'";
    $result=mysqli_query($connect,$feedback);
    echo "<table class='table'><thead><th>Registration number</th><th>Item</th><th>Feedback</th></thead><tr>";
    while($row=mysqli_fetch_assoc($result)){
        echo "<td>".$row['Reg_no']."</td><td>".$row['item']."</td><td>".$row['feedback'];
        echo "</td></tr><tr>";
    }
    echo "</table>";

    mysqli_close($connect);
?>
</body>
</html>