Untitled

<!DOCTYPE>
<html>
  <head>
    <link href="CSS/style.css" type="text/css" rel="stylesheet" >
    <script src="Javascript/validate.js" type="text/javascript">
    </script>
  </head>
  <body>
    <div id="content">
      <div id="header">
        <img src="Pictures/adLove.jpg" width="250" height="100">
        <br>
        <h1>FingerPrintsNK</h1>
      </div>
      <div class="motto">
        <h3>FingerPrintsNK is a open website for those that want to demonstrate their
          advertising skills to potential clients or new friends. Use FingerprintsNK to display your skills
          and make your mark in the world or simply receive constructive criticism on your content.</h3>
      </div>
      <div class="subContent">
        <nav>
          <ul>
            <li><a href="about_us.php">About us</a></li>
            <li><a href="login.php">Login</a></li>
            <li><a href="register.php">Register</a></li>
          </ul>
        </nav>
        <div id="main">
          <form method="post" action="<?php $_PHP_SELF ?>" id="registerForm" onsubmit="return valdate()">
            Name:<input type="text" name="name"><br>
            Surname:<input type="text" name="surname"><br>
            Email:<input type="text" name="email"><br>
            Phone No:<input type="text" name="phone"><br>
            Username:<input type="text" name="user"><br>
            Password:<input type="password" name="pass"><br>
            <input type="submit" name="register" id="register" value="Register Details">
      		</form>
          <br>
          <p> If you are a guest simply type in your guest name in the column below: </p>
          <br>
          <form method="post" action="<?php $_PHP_SELF ?>">
            Guest Name:<input type="text" name="gname"><br>
            <input type="submit" name="registerGuest" id="register" value="Register Guest">
      		</form>
          <?php
          if(isset($_POST['register']))
          {
            $servername = "localhost";
            $username = "root";
            $password = "";
            $dbname = "fingerprintsnk";

            // Create connection
            $conn = mysqli_connect($servername, $username, $password, $dbname);
            // Check connection
            if (!$conn) {
                die("Connection failed: " . $conn->connect_error);
            }
            $advertiserName = $_POST['name'];
            $advertiserSurname = $_POST['surname'];
            $advertiserPhone = $_POST['phone'];
            $advertiserEmail = $_POST['email'];
            $advertiserUser = $_POST['user'];
            $advertiserPass = $_POST['pass'];
              //$sql1 = "SELECT * FROM customer";
              //$result1 = $conn->query($sql1);
              // if ($result1->num_rows > 0) {
              //   while($row = $result1->fetch_assoc()) {
              //     $increment += 1;
              //   }
              // } else {
              //   //echo "no stock results";
              // }
            $sql = "INSERT INTO advertisers (advertiserName, advertiserSurname, advertiserPhoneNo,
               advertiserEmail, advertiserUsername, advertiserPassword)
              VALUES
      ('$advertiserName','$advertiserSurname','$advertiserPhone','$advertiserEmail','$advertiserUser','$advertiserPass')";
            if ($conn->query($sql) === TRUE) {

                echo "Your advertiser profile has been created: please login to get started.";
            } else {
                echo "<p>Error: " . $sql . "<br>" . $conn->error . "</p>";
            }

            mysqli_close($conn);
        }
        if(isset($_POST['registerGuest']))
        {
          $servername = "localhost";
          $username = "root";
          $password = "";
          $dbname = "fingerprintsnk";

          // Create connection
          $conn = mysqli_connect($servername, $username, $password, $dbname);
          // Check connection
          if (!$conn) {
              die("Connection failed: " . $conn->connect_error);
          }
          $guestName = $_POST['gname'];
          $sql = "INSERT INTO guest (guestName) VALUES ('$guestName')";
          if ($conn->query($sql) === TRUE) {
              echo "Your guest profile has been created: please login to get started.";
          } else {
              echo "<p>Error: " . $sql . "<br>" . $conn->error . "</p>";
          }
          mysqli_close($conn);
        }
           ?>
        </div>
      </div>
      <footer>
        <p> FingerPrintsNK is a civilian based website that serves to display other user content and does
          not plan to use client information for advertising or infringement of any kind. </p>
      </footer>
    </div>
  </body>
</html>