Untitled

<html>
<head>
<title>Assignment</title>
</head>
<?php


include "connect.php";


if(isset($_POST['submit'])){
    $fname = $_POST['fname'];
    $lname = $_POST['lname'];
    $email = $_POST['email'];
    $username = $_POST['username'];
    $pword = $_POST['pword'];


    echo "You are welcome $fname $lname an email has been sent to $email, please remember to use  $username when logging in";


    $kin = mysql_query("INSERT INTO form1(firstname, lastname, email, username, password)VALUES($fname, $lname, $email, $username, $pword)") or die(mysql_error());
    //echo "Data Inserted";
    if(!$kin){
     echo "Fields cannot be empty";
    }else{
        echo "Data Inserted";
    }


    }
    ?>

<body>
<form method="POST" action="assignment.php">
<table>
    <tr>
        <td>First Name:</td>
        <td><input type="text" name="fname"/></td>
    </tr>
    <tr>
        <td>Last Name:</td>
        <td><input type="text" name="lname"/></td>
    </tr>
    <tr>
        <td>Email:</td>
        <td><input type="text" name="email" /></td>
    </tr>
    <tr>
        <td>Username:</td>
        <td><input type="text" name="username"/></td>
    </tr>

    <tr>
        <td>Password:</td>
        <td><input type="password" name="pword"/></td>
    </tr>
    <tr>
        <td></td>
        <td><input type="submit" name="submit" value="Submit"/></td>
    </tr>

</table>


</form>


</body>


</html>