| Both sides previous revisionPrevious revision | Last revisionBoth sides next revision |
| dg:greenbox:add [14 Sep 2011 22:14] – james | dg:greenbox:add [14 Sep 2011 22:29] – james |
|---|
| ====== Add Item to Green Box ====== | ====== Add Item to Green Box ====== |
| <php> | <php> |
| | error_reporting(E_ALL); |
| | |
| | ini_set('display_errors', true); |
| | |
| include("/var/www/html/greenbox/sqlconnect.php"); | include("/var/www/html/greenbox/sqlconnect.php"); |
| include("/var/www/html/greenbox/sqlconnect2.php"); | include("/var/www/html/greenbox/sqlconnect2.php"); |
| |
| $query = "INSERT INTO Items (Year,Type,Freq,Class,Description,Comments,SAN,Contributor,Email,MoreInfoURL,Cell) | $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]')"; | 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) | $result = mysql_query($query) |
| or die ("Couldn't execute query."); | or die ("Couldn't execute query."); |
| | |
| $Year=$_POST['Year']; | $Year=$_POST[Year]; |
| echo $Year; | echo $Year; |
| </php> | </php> |
