<?php
$gender=$_POST["gen"];
$user=$_POST[username];
$check="SELECT username FROM first where username=$user";
$finally=mysql_query($check);
$query="INSERT INTO first(username,password,fname,lname,gender) VALUES('$_POST[username]','$_POST[password]','$_POST[fname]','$_POST[lname]','$gender')";
$result=mysql_query($query);
mysql_close($con);
echo "Registration successful!</br> username:$_POST[username]<br>first name:$_POST[fname]<br> last name:$_POST[lname]";
?>

foreach( username as $user)
if(mysql_num_rows($check)==1)
echo "the username already exist";
else
{
$query="INSERT (username.....

$canIHas = 'Can I has';
$string = '{$canIHas} cheezebuger?'; //Would be seen as "{$canIHas} cheezeburger?"
$string = "{$canIHas} cheezeburger"; //Would be seen as "Can I has cheezeburger?"

<?php

session_start();
include 'connect.php';

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

    if(isset($_POST['login']))
    {
        if( empty($username) || empty($password) )
        {
            include 'Login.php';
            ?>
                <script language="javascript1.2">
                    alert("Empty Fields. Fill up all the fields");
                </script>
            <?
         }
    
      else
      {
          //check if the username and password is in the database
          $query = "SELECT username,password FROM accounts WHERE username = '$username' and password= '$password' ";
          $result = mysql_query($query) or die(mysql_error());
          
              if(mysql_num_rows($result)==0)
            {
                //if either username name or password doesn't exist
                ?>
                    <script language="javascript1.2">
                        temp=confirm("Invalid username or password or not yet registerd. Do you want to register?");
                            if(temp)
                                window.location = "Register.php"
                               else
                                window.location = "Login.php"
                     </script>
                <?
              }
            
             else{
                
                //if username and password exist
                if($username==admin)
                {
                    $session_username = mysql_fetch_row($result);
                    $_SESSION['username'] = $session_username[0];
                       header("Location: Admin.php");
                }
                
                else if($username==admin2)
                {
                    $session_username = mysql_fetch_row($result);
                    $_SESSION['username'] = $session_username[0];
                       header("Location: Admin.php");
                }
            
                else
                {
                     $session_username = mysql_fetch_row($result);
                    $_SESSION['username'] = $session_username[0];
                       header("Location: Customer.php");
                }
            }
        }
   }
?>