Advertisement
Guest User

Untitled

a guest
May 22nd, 2016
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <!DOCTYPE>
  2. <html>
  3.   <head>
  4.     <link href="CSS/web.css" type="text/css" rel="stylesheet" >
  5.   </head>
  6.   <body>
  7.     <?php
  8.     $servername = "localhost";
  9.     $username = "root";
  10.     $password = "";
  11.     $dbname = "senseipizza";
  12.  
  13.     // Create connection
  14.     $conn = mysqli_connect($servername, $username, $password, $dbname);
  15.     // Check connection
  16.     if (!$conn) {
  17.         die("Connection failed: " . $conn->connect_error);
  18.     }
  19.     $sql = "SELECT staffID, staffName, staffSurname, staffPhone, staffAddress,
  20.              staffEmail FROM staff";
  21.     $result = mysqli_query($conn, $sql);
  22.  
  23.     ?>
  24.     <div id="content">
  25.       <div id="header">
  26.         <img src="Pictures/senseiPizza.jpg" alt="Logo" width="100" height="90">
  27.         <h1>Sensei Pizza</h1>
  28.         <div class="address">
  29.           <h2>Restaurant Location:</h2>
  30.           <span>28 Sewer Street, (Shredder Town) New York</span>
  31.         </div>
  32.       </div>
  33.       <div class="motto">
  34.         <h3>Sensei Pizza will fufill its mission ... to feed you.</h3>
  35.       </div>
  36.       <div class="subContent">
  37.         <nav>
  38.           <ul>
  39.             <li><a href="home.php">Home</a></li>
  40.             <li><a href="register.php">Register</a></li>
  41.           </ul>
  42.         </nav>
  43.         <div id="main">
  44.           <p>Dear customer
  45.              To indulge in our wonderful pizza online system please register
  46.                filling in the relevant information below and click the register button.
  47.           </p>
  48.           <form method="post" action="enter.php">
  49.                 Name:<input type="text" name="user"><br>
  50.             Surname:<input type="text" name="user"><br>
  51.             Address:<input type="text" name="user"><br>
  52.             Phone No:<input type="text" name="user"><br>
  53.             Email:<input type="text" name="user"><br>
  54.             Username:<input type="text" name="user"><br>
  55.                 Password:<input type="password" name="pass"><br>
  56.                 <input type="submit" value="Register Details">
  57.             </form>
  58.         </div>
  59.       </div>
  60.       <?php
  61.       if (mysqli_num_rows($result) > 0) {
  62.           echo "<div>";
  63.  
  64.           while($row = mysqli_fetch_assoc($result)) {
  65.               echo $row["staffID"]." ".$row["staffName"]." ".$row["staffSurname"]." "
  66.               .$row["staffPhone"]." ".$row["staffAddress"]." ".$row["staffEmail"]." ";
  67.           }
  68.           echo "</div>";
  69.       } else {
  70.           echo "0 results";
  71.       }
  72.       ?>
  73.       <footer>
  74.         <p> Sensei Pizza is a pizza registered restaurant and copywrited by the unifications act of the United States &#169; 2016 </p>
  75.       </footer>
  76.     </div>
  77.   </body>
  78.   <?php
  79.     mysqli_close($conn);
  80.    ?>
  81. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement