curd registration form with mysql in php code example
Example: registration form in php and mysql
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Registration Form</title>
<style>
input,textarea{width:200px}
input[type=radio],input[type=checkbox]{width:10px}
input[type=submit],input[type=reset]{width:100px}
</style>
</head>
<body>
<form method="post" enctype="multipart/form-data">
<table width="393" border="1">
<tr>
<td colspan="2"><?php echo @$msg; ?></td>
</tr>
<tr>
<td width="159">Enter your Name</td>
<td width="218">
<input type="text" placeholder="your first name" name="n" pattern="[a-z A-Z]*" required /></td>
</tr>
<tr>
<td>Enter your Email</td>
<td><input type="email" name="e"/></td>
</tr>
<tr>
<td>Enter your Password</td>
<td><input type="password" name="p"/></td>
</tr>
<tr>
<td>Enter your Address</td>
<td><textarea name="add"></textarea></td>
</tr>
<tr>
<td>Enter your Mobile</td>
<td><input type="text" pattern="[0-9]*" name="m" /></td>
</tr>
<tr>
<td height="23">Select your Gender</td>
<td>
Male<input type="radio" name="g" value="m"/>
Female<input type="radio" name="g" value="f"/>
</td>
</tr>
<tr>
<td>Choose your Hobbies</td>
<td>
Cricket<input type="checkbox" value="cricket" name="hobb[]"/>
Singing<input type="checkbox" value="singing" name="hobb[]"/>
Dancing<input type="checkbox" value="dancing" name="hobb[]"/>
</td>
</tr>
<tr>
<td>Choose your Profile Pic </td>
<td><input type="file" name="pic"/></td>
</tr>
<tr>
<td>Select your DOB</td>
<td>
<select name="mm">
<option value="">Month</option>
<?php
for($i=1;$i<=12;$i++)
{
echo "<option value='$i'>".$i."</option>";
}
?>
</select>
<select name="dd">
<option value="">Date</option>
<?php
for($i=1;$i<=31;$i++)
{
echo "<option value='$i'>".$i."</option>";
}
?>
</select>
<select name="yy">
<option value="">Year</option>
<?php
for($i=1900;$i<=2015;$i++)
{
echo "<option value='$i'>".$i."</option>";
}
?>
</select>
</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" name="save" value="Register Me"/>
<input type="reset" value="Reset"/>
</td>
</tr>
</table>
</form>
</body>
</html>