insert commands

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
papacharlie
Forum Newbie
Posts: 4
Joined: Thu Feb 17, 2005 3:02 am

insert commands

Post 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
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post by markl999 »

Post Reply