Page 1 of 1

insert commands

Posted: Thu Feb 17, 2005 3:07 am
by papacharlie

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&#1111;unit_no]', '$_POST&#1111;unit_name]', '$_POST&#1111;result]', '$_POST&#1111;sem]', '$_POST&#1111;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

Posted: Thu Feb 17, 2005 3:15 am
by markl999