insert commands
Posted: Thu Feb 17, 2005 3:07 am
Code: Select all
<?php
// connect to server, database, table.
$linkID = @mysql_connect("localhost","root","") or die("Could not connect to MySQL server");
@mysql_select_db("results") or die("Could not select database");
// add the new information into the database
$query="INSERT INTO subjects (unit_no, unit_name, result, sem, year) VALUES ('$_POSTїunit_no]', '$_POSTїunit_name]', '$_POSTїresult]', '$_POSTїsem]', '$_POSTїyear]')";
$final = mysql_query($query);
// Display an appropriate message
if ($final) echo "<p>Data successfully inserted!</p>";
else echo "<p>There was a problem inserting the data!</p>";
mysql_close();
// Include the insertion form
include "subjectsubmitform.php";
?>
<form action="subjects_post.php" method="post" name="subjects">
<table width="482" border="1">
<tr>
<td width="153">Unit Number </td>
<td width="313"><input name="unit_no" type="text" size="10" maxlength="10"></td>
</tr>
<tr>
<td>Unit Name </td>
<td><input name="unit_name" type="text" size="20" maxlength="20"></td>
</tr>
<tr>
<td>Result</td>
<td><select name="result">
<option value="HD">High Distinction</option>
<option value="DI">Distinction</option>
<option value="CR">Credit</option>
<option value="PA">Pass</option>
<option value="PC">Pass Conceded</option>
<option value="FF">Fail</option>
<option value="RP">Result Pending</option>
</select></td>
</tr>
<tr>
<td>Semester</td>
<td><select name="sem">
<option value="1">1</option>
<option value="2">2</option>
</select></td>
</tr>
<tr>
<td>Year</td>
<td><select name="year">
<option value="2001">2001</option>
<option value="2002">2002</option>
<option value="2003">2003</option>
<option value="2004">2004</option>
<option value="2005">2005</option>
<option value="2006">2006</option>
<option value="2007">2007</option>
<option value="2008">2008</option>
<option value="2009">2009</option>
<option value="2010">2010</option>
<option value="2011">2011</option>
<option value="2012">2012</option>
<option value="2013">2013</option>
<option value="2014">2014</option>
<option value="2015">2015</option>
</select></td>
</tr>
<tr>
<td>Submit</td>
<td><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
</form>Can anyone see the problem? I am conecting to the database but not submitting the data to the database.
Thanks
feyd | use the post formatting tags