Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE>
- <html>
- <head>
- <link href="CSS/web.css" type="text/css" rel="stylesheet" >
- </head>
- <body>
- <?php
- $servername = "localhost";
- $username = "root";
- $password = "";
- $dbname = "senseipizza";
- // Create connection
- $conn = mysqli_connect($servername, $username, $password, $dbname);
- // Check connection
- if (!$conn) {
- die("Connection failed: " . $conn->connect_error);
- }
- $sql = "SELECT staffID, staffName, staffSurname, staffPhone, staffAddress,
- staffEmail FROM staff";
- $result = mysqli_query($conn, $sql);
- ?>
- <div id="content">
- <div id="header">
- <img src="Pictures/senseiPizza.jpg" alt="Logo" width="100" height="90">
- <h1>Sensei Pizza</h1>
- <div class="address">
- <h2>Restaurant Location:</h2>
- <span>28 Sewer Street, (Shredder Town) New York</span>
- </div>
- </div>
- <div class="motto">
- <h3>Sensei Pizza will fufill its mission ... to feed you.</h3>
- </div>
- <div class="subContent">
- <nav>
- <ul>
- <li><a href="home.php">Home</a></li>
- <li><a href="register.php">Register</a></li>
- </ul>
- </nav>
- <div id="main">
- <p>Dear customer
- To indulge in our wonderful pizza online system please register
- filling in the relevant information below and click the register button.
- </p>
- <form method="post" action="enter.php">
- Name:<input type="text" name="user"><br>
- Surname:<input type="text" name="user"><br>
- Address:<input type="text" name="user"><br>
- Phone No:<input type="text" name="user"><br>
- Email:<input type="text" name="user"><br>
- Username:<input type="text" name="user"><br>
- Password:<input type="password" name="pass"><br>
- <input type="submit" value="Register Details">
- </form>
- </div>
- </div>
- <?php
- if (mysqli_num_rows($result) > 0) {
- echo "<div>";
- while($row = mysqli_fetch_assoc($result)) {
- echo $row["staffID"]." ".$row["staffName"]." ".$row["staffSurname"]." "
- .$row["staffPhone"]." ".$row["staffAddress"]." ".$row["staffEmail"]." ";
- }
- echo "</div>";
- } else {
- echo "0 results";
- }
- ?>
- <footer>
- <p> Sensei Pizza is a pizza registered restaurant and copywrited by the unifications act of the United States © 2016 </p>
- </footer>
- </div>
- </body>
- <?php
- mysqli_close($conn);
- ?>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement