Okay, I'm writing a script to update information in an SQL DB, and I know that the problem is just a newbie typo or mistake, but I cant find it.
Everything works, except the insertion into the database. Can you all spot anything wrong with my code?
<?
include('config.php');
$JID = $_GET['JID'];
//The Edit Variables
$CIDe = $_POST['CID'];
$WEBe = $_POST['WEB'];
$PRINTe = $_POST['PRINT'];
$GRAPHICe = $_POST['GRAPHIC'];
$CODEe = $_POST['CODE'];
$JDESCe = $_POST['JDESC'];
$PASSe = $_POST['PASS'];
$CSIGNEDe = $_POST['CSIGNED'];
$ENDDATEe = $_POST['ENDDATE'];
$QUOTEe = $_POST['QUOTE'];
$PAIDe = $_POST['PAID'];
$OWEINGe = $_POST['OWEING'];
$SITEURLe = $_POST['SITEURL'];
$JSTATUSe = $_POST['JSTATUS'];
$submit = $_POST['submit'];
$query1 = mysql_query("SELECT * FROM jobs WHERE JID = '$JID'");
$row = mysql_fetch_array($query1);
//Get Rows Section
$CID = $row['CID'];
$JNAME = $row['JNAME'];
$WEB = $row['WEB'];
$PRINT = $row['PRINT'];
$GRAPHIC = $row['GRAPHIC'];
$CODE = $row['CODE'];
$JDESC = $row['JDESC'];
$PASS = $row['PASS'];
$CSIGNED = $row['CSIGNED'];
$ENDDATE = $row['ENDDATE'];
$QUOTE = $row['QUOTE'];
$PAID = $row['PAID'];
$OWEING = $row['OWEING'];
$SITEURL = $row['SITEURL'];
$JSTATUS = $row['JSTATUS'];
if( isset( $_POST["submit"] ) ){
$aWEB = "UPDATE clients SET WEB ='$WEBe' WHERE JID='$JID'";
$aPRINT = "UPDATE clients SET PRINT ='$PRINTe' WHERE JID='$JID'";
$aGRAPHIC = "UPDATE clients SET GRAPHIC ='$GRAPHICe ' WHERE JID='$JID'";
$aCODE = "UPDATE clients SET CODE ='$CODEe' WHERE JID='$JID'";
$aJNAME = "UPDATE clients SET WEB ='$JNAMEe' WHERE JID='$JID'";
$aJDESC = "UPDATE clients SET JDESC ='$JDESCe' WHERE JID='$JID'";
$aCSIGNED = "UPDATE clients SET PASS ='$CSIGNEDe' WHERE JID='$JID'";
$aENDDATE = "UPDATE clients SET ENDDATE ='$ENDDATEe' WHERE JID='$JID'";
$aQUOTE = "UPDATE clients SET QUOTE ='$QUOTEe' WHERE JID='$JID'";
$aPAID = "UPDATE clients SET PAID ='$PAIDe' WHERE JID='$JID'";
$aOWEING = "UPDATE clients SET OWEING ='$OWEINGe' WHERE JID='$JID'";
$aSITEURL = "UPDATE clients SET SITEURL ='$SITURLe' WHERE JID='$JID'";
$aJSTATUS = "UPDATE clients SET JSTATUS ='$JSTATUSe' WHERE JID='$JID'";
mysql_query($aWEB); mysql_query($aPRINT); mysql_query($aGRAPHIC); mysql_query($aCODE);
mysql_query($aJDESC);
mysql_query($aJNAME);
mysql_query($aCSIGNED);
mysql_query($aENDDATE);
mysql_query($aQUOTE);
mysql_query($aPAID);
mysql_query($aOWEING);
mysql_query($aSITEURL);
mysql_query($aJSTATUS);
echo "Information Updated";
}
else {
//FORM
echo "<form method=\"post\">
<p>Job Type:";
if($WEB) { echo "<p><input type=\"checkbox\" name=WEB value=\"WEB\" checked>Web</p>"; } else { echo "<p><input type=\"checkbox\" name=WEB value=\"WEB\">Web</p>"; }
if($PRINT) { echo "<p><input type=\"checkbox\" name=PRINT value=\"PRINT\" checked>Print</p>"; } else { echo "<p><input type=\"checkbox\" name=PRINT value=\"PRINT\">Web</p>"; }
if($GRAPHIC) { echo "<p><input type=\"checkbox\" name=GRAPHIC value=\"GRAPHIC\" checked>Graphic</p>"; } else { echo "<p><input type=\"checkbox\" name=GRAPHIC value=\"GRAPHIC\">Web</p>"; }
if($CODE) { echo "<p><input type=\"checkbox\" name=CODE value=\"CODE\" checked>Code</p>"; } else { echo "<p><input type=\"checkbox\" name=CODE value=\"CODE\">Code</p>"; }
echo "
<hr height=\"1\" noshade>
<p>Job Name:<br>
<textarea name=\"JNAME\" id=\"JDESC\">$JNAME</textarea>
</p>
<p>Job Description:<br>
<textarea name=\"JDESC\" id=\"JDESC\">$JDESC</textarea>
</p>
<p>Contract Signed On:<br>
<input name=\"CSIGNED\" type=\"text\" id=\"CSIGNED\" value=\"$CSIGNED\">
</p>
<p>Agreed Completion Date:<br>
<input name=\"ENDDATE\" type=\"text\" id=\"ENDDATE\" value=\"$ENDDATE\">
</p>
<hr height=\"1\" noshade>
<p>Final Quote:<br>
$<input name=\"QUOTE\" type=\"text\" id=\"QUOTE\" value=$QUOTE>
</p>
<p>Amount Paid:<br>
$<input name=\"PAID\" type=\"text\" id=\"PAID\" value=$PAID>
</p>
<p>Amount Oweing:<br>
<input name=\"OWEING\" type=\"text\" id=\"OWEING\" value=\"$OWEING\">
</p>
<hr height=\"1\" noshade>
<p>Client URL:<br>
<input name=\"SITEURL\" type=\"text\" id=\"SITEURL\" value=\"$SITEURL\">
</p>
<p>Job Status:<br>
<select name=\"JSTATUS\">";
if($JSTATUS == "Pending") { echo "<option value=\"Pending\" selected>In Progress</option>"; } else { echo "<option value=\"Pending\">In Progress</option>"; }
if($JSTATUS == "Completed") { echo "<option value=\"Completed\" selected>Completed</option>"; } else { echo "<option value=\"Completed\">Completed</option>"; }
echo "
</select>
</p>
<p>
<input name=\"submit\" type=\"submit\" id=\"submit\" value=\"submit\"> <input name=\"reset\" type=\"reset\" id=\"reset\" value=\"reset\">
</p></form>";
}
?>
I really dont see anything. I hope you can 🙁
