Please debug my php code?

F

Fiery Heart

New member
<html>
<head>
<title>
Input Records
</title>
</head>


<?php
if(isset($_GET['submit']))
{
$db = mysql_connect('localhost', 'JJGV', 'it213');
mysql_select_db('project') or die( "Unable to select database");
$studno = $_GET['studno'];
$fname = $_GET['fname'];
$lname = $_GET['lname'];
$course = $_GET['course'];
$courseYr = $_GET['courseYr'];
$age = $_GET['age'];
$email = $_GET['email'];
$homeAdd = $_GET['homeAddress'];
$cityAdd = $_GET['cityAddress'];
$contactNo = $_GET['contactNo'];
$sql = "INSERT INTO student (studno, fname, lname, course, courseYr, age, email, homeAddress, cityAddress, contactNo)
VALUES ('$studno' , '$fname' , '$lname' , '$course' , '$courseYr' , '$age' , '$email' , '$homeAdd' , 'cityAdd' , 'contactNo')";

mysql_query($sql);

}

else
{
?>



<body>


<table border="0" width="50%" cellspacing="10">

<form name="inputform" action="input.php" method="GET">

<th align="center" colspan=2>STUDENT INFORMATION</th>
<tr>
<td align="right">
Student Number:
</td>
<td>
<input type="text" name="studno" size="3">
</td>
</tr>
<tr>
<td align="right">
First Name:
</td>
<td>
<input type="text" name="fname" size="30">
</td>
</tr>
<tr>
<td align="right">
Last Name:
</td>
<td>
<input type="text" name="lname" size="30">
</td>
</tr>
<tr>
<td align="right">
Course
</td>
<td>
<input type="text" name="course" size="10">
</td>
</tr>
<tr>
<td align="right">
Year Level:
</td>
<td>
<input type="text" name="courseYr" size="1">
</td>
</tr>
<tr>
<td align="right">
Age:
</td>
<td>
<input type="text" name="age" size="2">
</td>
</tr>
<tr>
<td align="right">
E-mail Address:
</td>
<td>
<input type="text" name="email" size="30">
</td>
</tr>
<tr>
<td align="right">
Home Address:
</td>
<td>
<input type="text" name="homeaddress" size="60">
</td>
</tr>
<tr>
<td align="right">
City Address:
</td>
<td>
<input type="text" name="cityaddress" size="60">
</td>
</tr>
<tr>
<td align="right">
Contact Number:
</td>
<td>
<input type="text" name="contactNo" size="11">
</td>
</tr>
<td align="center" colspan="2">
<input type="submit" value="Enter Information">
***
<input type="reset" value="Clear">
</td>
</tr>
</form>


</table>

</body>

<?php
}
?>


</HTML>


that's my code.. i don't know why the all the inputs won't be saved in the database i created.. please help me..
 
Back
Top