» Unlabelled » Simple Registration Page values inserting into database PHP

Simple Registration Page values inserting into database PHP

- on Tuesday, September 20, 2011 - No comments
<html>
<body>
<form method="post" action="form.php">
<table width="100%" border="0">
    <tr>
        <td>Username</td>
        <td><input type="text" name="username" /></td>
    </tr>
    <tr>
        <td>Password</td>
        <td><input type="password" name="password" /><br>
    </tr>
    <tr>
        <td>Email</td>
        <td><input type="text" name="email" /></td>
    </tr>
    <tr>
        <td><p>Gender</p></td>
       
        <td><input type="radio" name="gender" value="female" />Female
            <input type="radio" name="gender" value="male" /> Male </td>
    </tr>
    <tr>
        <td>Phone Number</td>
        <td><input type="text" name="phno" /></td>
    </tr>
    <tr>
        <td>Url</td>
        <td><input type="text" name="url" ></td>
    </tr>
    <tr>
        <td>Address</td>
        <td><textarea rows="10" cols="23" name="address"></textarea></td>
    </tr>
    <tr>
        <td align="center" colspn="2"><input type="submit" name="submit" value="Submit"></td>
    </tr>
</table>
</form>
<?php
if(isset($_POST['submit'])){
$conn=mysql_connect("localhost","root","password");
mysql_select_db("test",$conn) or die('Could not connect: ' . mysql_error());
$name=$_POST['username'];
$password=$_POST['password'];
$email=$_POST['email'];
$gender=$_POST['gender'];
$phno=$_POST['phno'];
$url=$_POST['url'];
$address=$_POST['address'];
$query="INSERT INTO users(id,name,password,email,gender,phno,url,address) VALUES ('','".$name."','".$password."','".$email."','".$gender."','".$phno."','".$url."','".$address."')";
mysql_query($query);
}
?>
</body>
</html>

Post a Comment

Analytics