Untitled

///////////////////////////////login.html///////////////////////////////////////////////

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>The Moray College Surf Shop </title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" type="text/css" href="mystyle.css" />

</head>
<center>
<div id="bodyone">
<body>
<div id="title"
<p><font size="3"><strong>The Moray College Surf Shop </strong></font></p>
</div>
<div id="bar">
</div>


<form name="form1" method="post" action="loginshop.php">
 <div id="cusone">
 <p><strong>Existing Customers</strong></p>

  <p>User Name
    <input name="username" type="text" >

     Password
    <input name="password" type="password" size="40" maxlength="40">
</p>
  <p>
    <input type="submit" name="Submit" value="Submit">
    <input type="reset" name="Submit2" value="Reset">
  </p>
  </div>

</form>
<p>For new customers <a href="register.php">click here</a></p>
</div>
</center>
<div id="bar">
</div>
<p>&nbsp;</p>
<p>&nbsp;</p>
</body>
</div>
</html>

/////////////////////////////////////////////
/////////////////register.php////////////////////

     <html>

      <head>

      The Moray College Surf Shop

      </head>

      <body>

      <?php
  session_start();

      ?>

      <form name="form1" action="memberregistered.php" method = "post">

      <?php


      if (isset($_SESSION['info'])) {

        echo "<input type=\"hidden\" name=\"customerno\" value=\"customerno". $_SESSION['info']['customerno'] ."\">";

      }

      ?>

        <p><h1>UHI Surf shop New Customer</h1></p>

        <p>First Name

          <input name="firstname" type="text" size="20" <?php if (isset($_SESSION['info'])) {echo " value=\"". $_SESSION['info']['firstname'] ."\"";}?>>

      </p>

        <p>Surname

          <input name="lastname" type="text" size="20" <?php if (isset($_SESSION['info'])) {echo " value=\"". $_SESSION['info']['surname'] ."\"";}?>>

        </p>

        <p>Address

          <input name="address" type="text"  size="25" <?php if (isset($_SESSION['info'])) {echo " value=\"". $_SESSION['info']['address'] ."\"";}?>>

      </p>

        <p>Town

          <input name="town" type="text"  size="20" <?php if (isset($_SESSION['info'])) {echo " value=\"". $_SESSION['info']['town'] ."\"";}?>>

      </p>

        <p>Post Code

          <input name="postcode" type="text" size="10" <?php if (isset($_SESSION['info'])) {echo " value=\"". $_SESSION['info']['postcode'] ."\"";}?>>

        </p>

        <p>Email Address

          <input name="email" type="text" size="40" <?php if (isset($_SESSION['info'])) {echo " value=\"". $_SESSION['info']['emailaddress'] ."\"";}?>>

      </p>

        <p>User name

          <input name="username" type="text" size="40" <?php if (isset($_SESSION['info'])) {echo " value=\"". $_SESSION['info']['username'] ."\"";}?>>

      </p>

        <p>Password

          <input name="password" type="text" size="40" <?php if (isset($_SESSION['info'])) {echo " value=\"". $_SESSION['info']['password'] ."\"";}?>>

              </p>

              <br><br>


          <input type="submit" name="submit" value="submit">

         <input type="reset" name="Reset" value="Reset">  </p>

      </form>

      </body>

      </html>

////////////////////////////////////
////////////////loginshop.php///////////

<html><head>The Moray College Surf Shop </head><body><h1>Member Search Results</h1>

      <?php
  session_start();


        $username=@$_POST['username'];

        $password=@$_POST['password'];


       $db = mysql_connect('127.0.0.1', 'root', '') or die(mysql_error());


        mysql_select_db('surf');

        $query = "select * from customers where username = '$username' and password = '$password'";

        $result = mysql_query($query);

        $num_results = mysql_num_rows($result);


        if (!$num_results > 0) {

          echo "<form action='loginshop.php' method='post'>

          Username


          <input type='text' name='username' maxlength='13' size='13'></br>

          Password

          <input type='text' name='password' maxlength='60' size='30'></br>


          <input name='Continue' type='submit' value='Continue'>

          </form>";

        } else {


          echo "If you would like to change your details please <a href='register.php?a=change'>click here</a>";


          $_SESSION['info'] = mysql_query($query);

        }

      ?>

      </body></html>

//////////////////////////////////////
/////////////////memberregister.php

<html>
<head>
  <title>The Moray College Surf Shop MEMBER REGISTRATION</title>
</head>
<body>
<h1>The Moray College Surf Shop  Member Registration</h1>

<?php
  $firstname=$_POST['firstname'];
  $lastname=$_POST['lastname'];
  $address=$_POST['address'];
  $town=$_POST['town'];
  $postcode=$_POST['postcode'];
  $email=$_POST['email'];
  $username=$_POST['username'];
  $password=$_POST['password'];

  $db = mysql_connect('127.0.0.1', 'root', '');
  if (!$db)
  {
     echo 'Error: mysql_error() Could not connect to database.  Please try again later.';
     exit;
  }
  else
  {
  mysql_select_db('surf');
    $query = "insert into customers(firstname,lastname,address,town,postcode,email,username,password) values ('$firstname','$lastname','$address','$town','$postcode','$email','$username' ,'$password')";
  $result = mysql_query($query);
  if ($result)
  	echo 'Member inserted';
   else
   echo 'Did not work';
   }
?>
<p>Click <a href="login.html">here</a> to return to the login page</font></p>
</body>
</html>
/////////////////