Adding to a database from a form

tjbarr

How and where do I put a submit and and how do I edit the form line and write the insert query?

<?php
$_GET['cboInst'];

switch ($_GET['submit']) {

case 'Add_Vessel': ?>
      <form>

		   <table width="100%"  border="0">

</table>

  </form>

tjbarr

o.k. I tried this but I think I am connecting twice and it says no database selected.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<?php include("../ccdsv/dbconn3.php"); ?>
<title>Untitled Document</title>
</head>

<?php 
  $_GET['cboInst'];

switch ($_GET['submit']) {

case 'Add_Vessel': ?>
      <form>

		   <table width="100%"  border="0">

<tr>
<td width="17%">Inventory Number </td>
<td width="27%"><input name="Inv_num" type="text" id="Inv_num" maxlength="50"></td>
<td width="20%">Mark</td>
<td width="36%"><input name="sv_mark" type="text" id="sv_mark" maxlength="50"></td>
</tr>
<tr>
<td>Sacred Vessel Type </td>
<td><input name="sv_type" type="text" id="sv_type"></td>
<td>Location of the Mark </td>
<td><input name="sv_mark_loc" type="text" id="sv_mark_loc" maxlength="50"></td>
</tr>
<tr>
<td>Sacred Vessel Name </td>
<td><input name="sv_name" type="text" id="sv_name"></td>
<td>Mark Description</td>
<td><input name="sv_mark_desc" type="text" id="sv_mark_desc" maxlength="50"></td>
</tr>
<tr>
<td>Artist</td>
<td><input name="sv_artist" type="text" id="sv_artist"></td>
<td>Inscription</td>
<td><input name="sv_inscript" type="text" id="sv_inscript" maxlength="50"></td>
</tr>
<tr>
<td>Exact Year </td>
<td><input name="sv_ex_year" type="text" id="sv_ex_year"></td>
<td>Location of Inscription </td>
<td><input name="sv_inscr_loc" type="text" id="sv_inscr_loc" maxlength="50"></td>
</tr>
<tr>
<td>Exact Year Source</td>
<td><input name="sv_ex_year_srce" type="text" id="sv_ex_year_srce"></td>
<td>Inscription Description</td>
<td><input name="sv_inscr_desc" type="text" id="sv_inscr_desc" maxlength="50"></td>
</tr>
<tr>
<td>Date/Period</td>
<td><input name="sv_date_period" type="text" id="sv_date_period"></td>
<td>Object Description </td>
<td><input name="sv_obj_desc" type="text" id="sv_obj_desc" maxlength="50"></td>
</tr>
<tr>
<td>How Determined </td>
<td><input name="sv_determined" type="text" id="sv_determined"></td>
<td>Provenance</td>
<td><input name="sv_provenance" type="text" id="sv_provenance" maxlength="50"></td>
</tr>
<tr>
<td>Certainty of Date/Period </td>
<td><input name="sv_date_certain" type="text" id="sv_date_certain"></td>
<td>Provenance Prior Owners </td>
<td><input name="sv_prior_own" type="text" id="sv_prior_own" maxlength="50"></td>
</tr>
<tr>
<td>Material</td>
<td><input name="sv_material" type="text" id="sv_material"></td>
<td>Description of Provenance </td>
<td><input name="sv_prov_desc" type="text" id="sv_prov_desc" maxlength="50"></td>
</tr>
<tr>
<td>Height</td>
<td><input name="sv_height" type="text" id="sv_height"></td>
<td>Acquisition</td>
<td><input name="sv_acquisition" type="text" id="sv_acquisition" maxlength="50"></td>
</tr>
<tr>
<td>Width</td>
<td valign="top"><input name="sv_width" type="text" id="sv_width"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Depth</td>
<td><input name="sv_depth" type="text" id="sv_depth"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Length</td>
<td><input name="sv_length" type="text" id="sv_length"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Diameter</td>
<td><input name="sv_diameter" type="text" id="sv_diameter"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Unit of Measure </td>
<td><input name="sv_uom" type="text" id="sv_uom"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Size Notes </td>
<td><textarea name="sv_size_notes" id="sv_size_notes"></textarea></td>
<td><p align="center">

    <p align="center"></td>
<td>&nbsp;</td>

</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<?php

$conn = pg_connect("host=server.edu user=admindb password=2008root dbname=testdb");
if (!$conn)
{
echo "An error occured\n";
exit;
}

$query("INSERT INTO tbl_vessel (inv_no) VALUES($Inv_num)")
or die(mysql_error());

echo "Data Inserted!";

  </form>

<?php

break;

case 'Edit_Vessel': 
  print 'This is what happens when Edit_Vessel button is clicked.'; 
  break; 

case 'Add_Window': 
  print 'This is what happens when the Add_Window button is clicked.'; 
  break; 

case 'Edit_Window': 
  print 'This is what happens when the Edit_Window button is clicked.'; 
  break; 
default: 
  print 'You can put the html form here.'; 
  break;

} // End: switch ($_GET['submit'])

?></FORM> </td>
</tr>
</table>
<p>  </p>
<tr>
<td height="2" colspan="3">
<p> </p></td>
</tr>
<div align="right"> </div>
<div align="right"> </div>
</body>
</html>