This is an old revision of the document!

<php>

include(“/var/www/html/greenbox/sqlconnect.php”); include(“/var/www/html/greenbox/sqlconnect2.php”);

$query = “INSERT INTO Items (Year,Type,Freq,Class,Description,Comments,SAN,Contributor,Email,MoreInfoURL,Cell) VALUES ('$_POST[Year]','$_POST[Type]','$_POST[Freq]','$_POST[Class]','$_POST[Description]','$_POST[Comments]','$_POST[SAN]','$_POST[Contributor]','$_POST[Email]','$_POST[MoreInfoURL]','$_POST[Cell]')”;

$result = mysql_query($query)
     or die ("Couldn't execute query.");
     

$Year=$_POST['Year']; echo $Year;

echo "The following item has been added to the database:<br>
      <ul>
       <li>Type: 	'$Type'
 <li>Frequency:	'$Freq'
 <li>Class: 	'$Class'
 <li><b>'$Description' </b> '$Comments'
 <li>SAN penalty:	'$SAN'
 <li>Contributed by: '$Contributor'  '$Email'
 <li>More info from: '$MoreInfoURL'
 <li>Cell '$Cell' available from '$Year'

\n“;

echo "</ul>";

</php>

Add another item