Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
dg:greenbox:add [14 Sep 2011 22:29] jamesdg:greenbox:add [14 Sep 2011 22:43] (current) james
Line 2: Line 2:
 <php> <php>
 error_reporting(E_ALL);  error_reporting(E_ALL); 
- 
 ini_set('display_errors', true); ini_set('display_errors', true);
  
Line 9: Line 8:
  
 $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>
Line 20: Line 19:
 <br> <br>
 <b>Add as much detail as you can in the form below, fields which cannot be blank are indicated with an Asterisk <font color=red>*</font></b> <b>Add as much detail as you can in the form below, fields which cannot be blank are indicated with an Asterisk <font color=red>*</font></b>
-<form action="/doku.php/dg/greenbox/add" method="post">+<form action="/doku.php/dg/greenbox/confirm" method="post">
  <table>  <table>
   <tr>   <tr>
Print/export
QR Code
QR Code Add Item to Green Box (generated for current page)