Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
dg:greenbox:add [14 Sep 2011 21:07] jamesdg:greenbox:add [14 Sep 2011 22:43] (current) james
Line 1: Line 1:
 ====== 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  + VALUES ('$_POST[Year]','$_POST[Type]','$_POST[Freq]','$_POST[Class]','$_POST[Description]','$_POST[Comments]','$_POST[SAN]','$_POST[Contributor]','$_POST[Email]','$_POST[MoreInfoURL]','$_POST[Cell]')";
-           ('$Year','$Type','$Freq','$Class','$Description','$Comments','$SAN','$Contributor','$Email','$MoreInfoURL','$Cell')";+
   $result = mysql_query($query)   $result = mysql_query($query)
        or die ("Couldn't execute query.");        or die ("Couldn't execute query.");
-  $ItemID = mysql_insert_id();                                    // 46 +        
- +$Year=$_POST['Year']; 
-while ($row mysql_fetch_assoc($result)) +echo $Year;
-+
-  echo $row['Type']; +
-+
-  echo "</ul>"; +
-  echo "Add Another Item\n"; +
 </php> </php>
  
Line 23: 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)