MySql Insert Query With PHP Program
<!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” lang=”en_US” xml:lang=”en_US”>
<!–
* Created on 05-Feb-08
*
* To change the template for this generated file go to
* Window – Preferences – PHPeclipse – PHP – Code Templates
–>
<head>
<title> Student Registration Form </title>
<style type=”text/css”>
.text {
color : #FFFFFF;
font-family: Sans,TimesNewRoman;
}
</style>
</head>
<body class=”text”>
<form name=”insert” action=”MySqlInsert.php” method=”post”>
<br />
<br/>
<table border =”0″ align=”center” cellpadding=”17″ bgcolor=”#49496E”>
<tr>
<td colspan=”2″ align=”center”><b>Student Registration Form</b></td>
</tr>
<tr>
<td>Student Name</td>
<td><input type =”text” name = “studentName” size =”20″ /> </td>
</tr>
<tr>
<td>Date of Birth</td>
<td>
<select name =”day”>
<option selected>Day</option>
<option value=”01″>1</option>
<option value=”02″>2</option>
<option value=”03″>3</option>
<option value=”04″>4</option>
<option value=”05″>5</option>
<option value=”06″>6</option>
<option value=”07″>7</option>
<option value=”08″>8</option>
<option value=”09″>9</option>
<option value=”10″>10</option>
<option value=”11″>11</option>
<option value=”12″>12</option>
<option value=”13″>13</option>
<option value=”14″>14</option>
<option value=”15″>15</option>
<option value=”16″>16</option>
<option value=”17″>17</option>
<option value=”18″>18</option>
<option value=”19″>19</option>
<option value=”20″>20</option>
<option value=”21″>21</option>
<option value=”22″>22</option>
<option value=”23″>23</option>
<option value=”24″>24</option>
<option value=”25″>25</option>
<option value=”26″>26</option>
<option value=”27″>27</option>
<option value=”28″>28</option>
<option value=”29″>29</option>
<option value=”30″>30</option>
<option value=”31″>31</option>
</select>
<select name =”month”>
<option selected>Month</option>
<option value=”01″>1</option>
<option value=”02″>2</option>
<option value=”03″>3</option>
<option value=”04″>4</option>
<option value=”05″>5</option>
<option value=”06″>6</option>
<option value=”07″>7</option>
<option value=”08″>8</option>
<option value=”09″>9</option>
<option value=”10″>10</option>
<option value=”11″>11</option>
<option value=”12″>12</option>
</select>
<select name =”year”>
<option selected>Year</option>
<option value=”1975″>1975</option>
<option value=”1976″>1976</option>
<option value=”1977″>1977</option>
<option value=”1978″>1978</option>
<option value=”1979″>1979</option>
<option value=”1980″>1980</option>
<option value=”1981″>1981</option>
<option value=”1982″>1982</option>
<option value=”1983″>1983</option>
<option value=”1984″>1984</option>
<option value=”1985″>1985</option>
<option value=”1986″>1986</option>
<option value=”1987″>1987</option>
<option value=”1988″>1988</option>
<option value=”1989″>1989</option>
<option value=”1990″>1990</option>
</select>
</td>
</tr>
<tr>
<td>Select the Course </td>
<td>
<select name =”course”>
<option value =”mit”> M.TECH-IT</option>
<option value=”mcs”> M.TECH -CS</option>
<option value =”bit”> B.TECH-IT</option>
<option value=”bcs”> B.TECH -CS</option>
</select>
</td>
</tr>
<tr>
<td> Nationality</td>
<td>
<input type=”radio” name=”nation” value=”Indian” checked /> Indian <br />
<input type=”radio” name=”nation” value=”Other” /> Other
</td>
</tr>
<tr>
<td>DD Number</td>
<td><input type =”text” name = “ddNumber” size =”20″ /></td>
</tr>
<tr>
<td colspan=”2″ align=”center”><input type=”submit” value=”Submit”/> </td>
</tr>
</table>
</form>
</body>
</html>
PHP Program for Insertion
<?php
/*
* Author : Antony
* Created on 05-Feb-08
* Program Name : MySqlInsert.php
*/
//initilaize the mysql user name and oassword
$user=”root”;
$password=”123456″;
//database name
$database=”studentinfo”;
//get the information from Registration form
$name = $_POST['studentName'];
$dob = $_POST['year'].”-”.$_POST['month'].”-”.$_POST['day'];
$course = $_POST['course'];
$nationality = $_POST['nation'];
$ddNumber=$_POST['ddNumber'];
echo “$regId<br />$name<br/>$dob<br /> $course<br/>$nationality<br>$ddNumber <br>”;
//connect the mysql database
$link=mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die(“Unable to Open Databse”);
//execute the query
$sql =”INSERT INTO registration VALUES (‘$name’,'$dob’,'$course’,'$nationality’,'$ddNumber’)”;
$result = mysql_query($sql);
if (!$result)
{
die(‘Invalid query: ‘ . mysql_error());
}
else
{
echo “Your Course has been registred successfully”;
}
/* $num = mysql_affected_rows($result);
echo $num;
if($num!=0)
{
echo “Your Course has been registred successfully”;
$regId++;
}
else
{
echo “Error in registration ,Please Try Later”;
}
*/
mysql_free_result($result);
mysql_close($link);
?>