php inserting problem
Posted: Fri Apr 18, 2008 10:35 am
I have created a form that has a numerous amount of checkboxes and a few text fields. Whenever I try to submit the form I receive my die statements and the tables aren't updated. How can I fix these problems?
[/color]
Code: Select all
[color=#0000FF]<html>
<body>
<?php
// connection string
$con = mysql_connect("localhost", "ferf", "sfdsdf") or die("could not connect to server");
mysql_select_db("dafdaf", $con) or die('Sorry, could not connect to database');
$caseid = $_GET['id'];
// checks to see if the values have been set for all text fields
//delcare all posts as variables
$DRCVD = $_POST['DRCVD'];
$OCONT = $_POST['OCONT'];
$CONTENTS= $_POST['CONTENTS'];
$DEADLINE = $_POST['DEADLINE'];
$GIVENTO = $_POST['GIVENTO'];
$STATUS= $_POST['STATUS'];
$OUTCOME= $_POST['OUTCOME'];
$NOTES= $_POST['NOTES'];
if(isset ($_POST['DRCVD']) && isset($_POST['OCONT']) && isset($_POST['CONTENTS']) && isset($_POST['DEADLINE']) && isset($_POST['GIVENTO']) && isset($_POST['STATUS']) && isset($_POST['OUTCOME']) && isset($_POST['NOTES']))
{
// sql insert query for the variables into the cases table
$query = "INSERT INTO cases(DRCVD, OCONT, CONTENTS, DEADLINE, GIVENTO,STATUS,OUTCOME, NOTES ) VALUES ('$DRCVD', '$OCONT', '$CONTENTS', '$DEADLINE', '$GIVENTO', '$STATUS', '$OUTCOME', '$NOTES')";
// sql query either processes or fails and outputs an error message
mysql_query($query) or die ('Error, insert into query failed');
}
// original department checkboxes
$query = "INSERT into origdepart VALUES (";
if($ACINTEG == "1")
{
$query = $query . "ACINTEG = 1, ";
} else
{
$query = $query . "ACINTEG = 0, ";
}
if($CIVENG == "1")
{
$query = $query . "CIVENG = 1, ";
} else
{
$query = $query . "CIVENG = 0, ";
}
if($ENRMGT == "1")
{
$query = $query . "ENRMGT = 1, ";
} else
{
$query = $query . "ENRMGT = 0, ";
}
if($IA == "1")
{
$query = $query . "IA = 1, ";
} else
{
$query = $query . "IA = 0, ";
}
if($OFFCAMP == "1")
{
$query = $query . "OFFCAMP = 1, ";
} else
{
$query = $query . "OFFCAMP = 0, ";
}
if($PUBREL == "1")
{
$query = $query . "PUBREL = 1, ";
} else
{
$query = $query . "PUBREL = 0, ";
}
if($UCS == "1")
{
$query = $query . "UCS = 1, ";
} else
{
$query = $query . "UCS = 0, ";
}
if($ADSVC == "1")
{
$query = $query . "ADSVC = 1, ";
} else
{
$query = $query . "ADSVC = 0, ";
}
if($CLUBS == "1")
{
$query = $query . "CLUBS = 1, ";
} else
{
$query = $query . "CLUBS = 0, ";
}
if($ENGR == "1")
{
$query = $query . "ENGR = 1, ";
} else
{
$query = $query . "ENGR = 0, ";
}
if($IACUC == "1")
{
$query = $query . "IACUC = 1, ";
} else
{
$query = $query . "IACUC = 0, ";
}
if($OIA == "1")
{
$query = $query . "OIA = 1, ";
} else
{
$query = $query . "OIA = 0, ";
}
if($RETRVR == "1")
{
$query = $query . "RETRVR = 1, ";
} else
{
$query = $query . "RETRVR = 0, ";
}
if($UHS == "1")
{
$query = $query . "UHS = 1, ";
} else
{
$query = $query . "UHS = 0, ";
}
if($AFSTDS == "1")
{
$query = $query . "AFSTDS = 1, ";
} else
{
$query = $query . "AFSTDSG = 0, ";
}
if($COMMONS == "1")
{
$query = $query . "COMMONS = 1, ";
} else
{
$query = $query . "COMMONS = 0, ";
}
if($ERICSCH == "1")
{
$query = $query . "ERICSCH = 1, ";
} else
{
$query = $query . "ERICSCH = 0, ";
}
if($IS == "1")
{
$query = $query . "IS= 1, ";
} else
{
$query = $query . "IS = 0, ";
}
if($OIR == "1")
{
$query = $query . "OIR = 1, ";
} else
{
$query = $query . "OIR = 0, ";
}
if($R_PARK == "1")
{
$query = $query . "R_PARK = 1, ";
} else
{
$query = $query . "R_PARK = 0, ";
}
if($UMFNDN == "1")
{
$query = $query . "UMFNDN = 1, ";
} else
{
$query = $query . "UMFNDN = 0, ";
}
if($ALREL == "1")
{
$query = $query . "ALREL = 1, ";
} else
{
$query = $query . "ALREL = 0, ";
}
if($CONTED == "1")
{
$query = $query . "CONTED = 1, ";
} else
{
$query = $query . "CONTED = 0, ";
}
if($ESH == "1")
{
$query = $query . "ESH = 1, ";
} else
{
$query = $query . "ESH = 0, ";
}
if($IES == "1")
{
$query = $query . "IES = 1, ";
} else
{
$query = $query . "IES = 0, ";
}
if($OIT == "1")
{
$query = $query . "OIT = 1, ";
} else
{
$query = $query . "OIT = 0, ";
}
if($SGA == "1")
{
$query = $query . "SGA = 1, ";
} else
{
$query = $query . "SGA = 0, ";
}
if($UPWBD == "1")
{
$query = $query . "UPWBD = 1, ";
} else
{
$query = $query . "UPWBD = 0, ";
}
if($AMERSTD == "1")
{
$query = $query . "AMERSTD = 1, ";
} else
{
$query = $query . "AMERSTD = 0, ";
}
if($CSEE == "1")
{
$query = $query . "CSEE = 1, ";
} else
{
$query = $query . "CSEE = 0, ";
}
if($FACSEN == "1")
{
$query = $query . "FACSEN = 1, ";
} else
{
$query = $query . "FACSEN= 0, ";
}
if($IRB == "1")
{
$query = $query . "IRB = 1, ";
} else
{
$query = $query . "IRB= 0, ";
}
if($ORL == "1")
{
$query = $query . "ORL = 1, ";
} else
{
$query = $query . "ORL = 0, ";
}
if($SHRVR == "1")
{
$query = $query . "SHRVR = 1, ";
} else
{
$query = $query . "SHRVR = 0, ";
}
if($USM == "1")
{
$query = $query . "USM = 1, ";
} else
{
$query = $query . "USM = 0, ";
}
if($ANCSTD == "1")
{
$query = $query . "ANCSTD = 1, ";
} else
{
$query = $query . "ANCSTD= 0, ";
}
if($CSST == "1")
{
$query = $query . "CSST = 1, ";
} else
{
$query = $query . "CSST = 0, ";
}
if($FINSERV == "1")
{
$query = $query . "FINSERV = 1, ";
} else
{
$query = $query . "FINSERV = 0, ";
}
if($IRC == "1")
{
$query = $query . "IRC = 1, ";
} else
{
$query = $query . "IRC = 0, ";
}
if($OSP == "1")
{
$query = $query . "OSP = 1, ";
} else
{
$query = $query . "OSP = 0, ";
}
if($SOCWRK == "1")
{
$query = $query . "SOCWRK = 1, ";
} else
{
$query = $query . "SOCWRK = 0, ";
}
if($VART == "1")
{
$query = $query . "VART = 1, ";
} else
{
$query = $query . "VART= 0, ";
}
if($ASCRV == "1")
{
$query = $query . "ASCRV= 1, ";
} else
{
$query = $query . "ASCRV = 0, ";
}
if($CWIT == "1")
{
$query = $query . "CWIT = 1, ";
} else
{
$query = $query . "CWIT = 0, ";
}
if($GALLRY == "1")
{
$query = $query . "GALLRY = 1, ";
} else
{
$query = $query . "GALLRY = 0, ";
}
if($JCET == "1")
{
$query = $query . "JCET = 1, ";
} else
{
$query = $query . "JCET = 0, ";
}
if($OTD == "1")
{
$query = $query . "OTD = 1, ";
} else
{
$query = $query . "OTD = 0, ";
}
if($SOCY == "1")
{
$query = $query . "SOCY = 1, ";
} else
{
$query = $query . "SOCY = 0, ";
}
if($VPA_F == "1")
{
$query = $query . "VPA_F = 1, ";
} else
{
$query = $query . "VPA_F = 0, ";
}
if($ATHL == "1")
{
$query = $query . "ATHL = 1, ";
} else
{
$query = $query . "ATHL = 0, ";
}
if($DANCE == "1")
{
$query = $query . "DANCE = 1, ";
} else
{
$query = $query . "DANCE = 0, ";
}
if($GEOG == "1")
{
$query = $query . "GEOG = 1, ";
} else
{
$query = $query . "GEOG = 0, ";
}
if($LIBRY == "1")
{
$query = $query . "LIBRY = 1, ";
} else
{
$query = $query . "LIBRY = 0, ";
}
if($PHIL == "1")
{
$query = $query . "PHIL = 1, ";
} else
{
$query = $query . "PHIL = 0, ";
}
if($SJP == "1")
{
$query = $query . "SJP = 1, ";
} else
{
$query = $query . "SJP= 0, ";
}
if($VPACAFF == "1")
{
$query = $query . "VPACAFF = 1, ";
} else
{
$query = $query . "VPACAFF = 0, ";
}
if($BIO == "1")
{
$query = $query . "BIO = 1, ";
} else
{
$query = $query . "BIO = 0, ";
}
if($DEANAHSS == "1")
{
$query = $query . "DEANAHSS = 1, ";
} else
{
$query = $query . "DEANAHSS = 0, ";
}
if($GEST == "1")
{
$query = $query . "GEST = 1, ";
} else
{
$query = $query . "GEST = 0, ";
}
if($LRC == "1")
{
$query = $query . "LRC = 1, ";
} else
{
$query = $query . "LRC = 0, ";
}
if($PHYS == "1")
{
$query = $query . "PHYS = 1, ";
} else
{
$query = $query . "PHYS = 0, ";
}
if($STUAFF == "1")
{
$query = $query . "STUAFF = 1, ";
} else
{
$query = $query . "STUAFF = 0, ";
}
if($VPFACAF == "1")
{
$query = $query . "VPFACAF = 1, ";
} else
{
$query = $query . "VPFACAF = 0, ";
}
if($BKSTR == "1")
{
$query = $query . "BKSTR = 1, ";
} else
{
$query = $query . "BKSTR = 0, ";
}
if($DEANCOEIT == "1")
{
$query = $query . "DEANCOEIT = 1, ";
} else
{
$query = $query . "DEANCOEIT = 0, ";
}
if($GRAD == "1")
{
$query = $query . "GRAD = 1, ";
} else
{
$query = $query . "GRAD = 0, ";
}
if($MAS == "1")
{
$query = $query . "MAS = 1, ";
} else
{
$query = $query . "MAS = 0, ";
}
if($POLTSCI == "1")
{
$query = $query . "POLTSCI = 1, ";
} else
{
$query = $query . "POLTSCI = 0, ";
}
if($STULIFE == "1")
{
$query = $query . "STULIFE = 1, ";
} else
{
$query = $query . "STULIFE = 0, ";
}
if($VPIA == "1")
{
$query = $query . "VPIA = 1, ";
} else
{
$query = $query . "VPIA = 0, ";
}
if($CAREER == "1")
{
$query = $query . "CAREER = 1, ";
} else
{
$query = $query . "CAREER = 0, ";
}
if($DEANUE == "1")
{
$query = $query . "DEANUE = 1, ";
} else
{
$query = $query . "DEANUE = 0, ";
}
if($GSA == "1")
{
$query = $query . "GSA = 1, ";
} else
{
$query = $query . "GSA = 0, ";
}
if($MATH == "1")
{
$query = $query . "MATH = 1, ";
} else
{
$query = $query . "MATH = 0, ";
}
if($POLICE == "1")
{
$query = $query . "POLICE = 1, ";
} else
{
$query = $query . "POLICE = 0, ";
}
if($STUSIPSRV == "1")
{
$query = $query . "STUSIPSRV = 1, ";
} else
{
$query = $query . "STUSIPSRV = 0, ";
}
if($VPIT == "1")
{
$query = $query . "VPIT = 1, ";
} else
{
$query = $query . "VPIT = 0, ";
}
if($CASPR == "1")
{
$query = $query . "CASPR = 1, ";
} else
{
$query = $query . "CASPR = 0, ";
}
if($DEANCNMS == "1")
{
$query = $query . "DEANCNMS = 1, ";
} else
{
$query = $query . "DEANCNMS = 0, ";
}
if($GUESTSRV == "1")
{
$query = $query . "GUESTSRV= 1, ";
} else
{
$query = $query . "GUESTSRV = 0, ";
}
if($MECHENG == "1")
{
$query = $query . "MECHENG = 1, ";
} else
{
$query = $query . "MECHENG = 0, ";
}
if($PPLNT == "1")
{
$query = $query . "PPLNT = 1, ";
} else
{
$query = $query . "PPLNT = 0, ";
}
if($TECHCTR == "1")
{
$query = $query . "TECHCTR = 1, ";
} else
{
$query = $query . "TECHCTR = 0, ";
}
if($VPRDGS == "1")
{
$query = $query . "VPRDGS = 1, ";
} else
{
$query = $query . "VPRDGS = 0, ";
}
if($CAST == "1")
{
$query = $query . "CAST = 1, ";
} else
{
$query = $query . "CAST = 0, ";
}
if($DPET_CPS == "1")
{
$query = $query . "DPET_CPS = 1, ";
} else
{
$query = $query . "DPET_CPS = 0, ";
}
if($HIST == "1")
{
$query = $query . "HIST = 1, ";
} else
{
$query = $query . "HIST = 0, ";
}
if($MIPAR == "1")
{
$query = $query . "MIPAR = 1, ";
} else
{
$query = $query . "MIPAR = 0, ";
}
if($PRES == "1")
{
$query = $query . "PRES = 1, ";
} else
{
$query = $query . "PRES = 0, ";
}
if($TEI == "1")
{
$query = $query . "TEI = 1, ";
} else
{
$query = $query . "TEI = 0, ";
}
if($WMCTR == "1")
{
$query = $query . "WMCTR = 1, ";
} else
{
$query = $query . "WMCTR = 0, ";
}
if($CUERE == "1")
{
$query = $query . "CUERE = 1, ";
} else
{
$query = $query . "CUERE = 0, ";
}
if($ECON == "1")
{
$query = $query . "ECON= 1, ";
} else
{
$query = $query . "ECON = 0, ";
}
if($HLTHSCI == "1")
{
$query = $query . "HLTHSCI = 1, ";
} else
{
$query = $query . "HLTHSCI = 0, ";
}
if($MLL == "1")
{
$query = $query . "MLL = 1, ";
} else
{
$query = $query . "MLL = 0, ";
}
if($PROC == "1")
{
$query = $query . "PROC = 1, ";
} else
{
$query = $query . "PROC = 0, ";
}
if($TELECOMM == "1")
{
$query = $query . "TELECOMM = 1, ";
} else
{
$query = $query . "TELECOMM = 0, ";
}
if($WMSTD == "1")
{
$query = $query . "WMSTD = 1, ";
} else
{
$query = $query . "WMSTD = 0, ";
}
if($CHEM == "1")
{
$query = $query . "CHEM = 1, ";
} else
{
$query = $query . "CHEM = 0, ";
}
if($EDUC == "1")
{
$query = $query . "EDUC = 1, ";
} else
{
$query = $query . "EDUC = 0, ";
}
if($HNRSCOL == "1")
{
$query = $query . "HNRSCOL = 1, ";
} else
{
$query = $query . "HNRSCOL = 0, ";
}
if($MUSIC == "1")
{
$query = $query . "MUSIC = 1, ";
} else
{
$query = $query . "MUSIC = 0, ";
}
if($PROV == "1")
{
$query = $query . "PROV = 1, ";
} else
{
$query = $query . "PROV = 0, ";
}
if($THTR == "1")
{
$query = $query . "THTR = 1, ";
} else
{
$query = $query . "THTR = 0, ";
}
if($CHEMENG == "1")
{
$query = $query . "CHEMENG = 1, ";
} else
{
$query = $query . "CHEMENG = 0, ";
}
if($EHS == "1")
{
$query = $query . "EHS = 1, ";
} else
{
$query = $query . "EHS = 0, ";
}
if($HREL == "1")
{
$query = $query . "HREL = 1, ";
} else
{
$query = $query . "HREL = 0, ";
}
if($MYRHOF == "1")
{
$query = $query . "MYRHOF = 1, ";
} else
{
$query = $query . "MYRHOF = 0, ";
}
if($PSYC == "1")
{
$query = $query . "PSYC = 1, ";
} else
{
$query = $query . "PSYC = 0, ";
}
if($TRANSIT == "1")
{
$query = $query . "TRANSIT= 1, ";
} else
{
$query = $query . "TRANSIT = 0, ";
}
if($CHPDM == "1")
{
$query = $query . "CHPDM = 1, ";
} else
{
$query = $query . "CHPDM = 0, ";
}
if($ENGL == "1")
{
$query = $query . "ENGL = 1, ";
} else
{
$query = $query . "ENGL = 0, ";
}
if($HRES == "1")
{
$query = $query . "HRES = 1, ";
} else
{
$query = $query . "HRES = 0, ";
}
if($OAG == "1")
{
$query = $query . "OAG = 1, ";
} else
{
$query = $query . "OAG = 0, ";
}
if($PUBPOL == "1")
{
$query = $query . "PUBPOL = 1, ";
} else
{
$query = $query . "PUBPOL = 0, ";
}
if($TRNCTRS == "1")
{
$query = $query . "TRNCTRS = 1, ";
} else
{
$query = $query . "TRNCTRS = 0, ";
}
//responsible offices
$query = "INSERT into respoff VALUES (";
if($DEANAHSS2 == "1")
{
$query = $query . "DEANAHSS2 = 1, ";
} else
{
$query = $query . "DEANAHSS2 = 0, ";
}
if($PRES2 == "1")
{
$query = $query . "PRES2 = 1, ";
} else
{
$query = $query . "PRES2 = 0, ";
}
if($VPIT2 == "1")
{
$query = $query . "VPIT2 = 1, ";
} else
{
$query = $query . "VPIT2 = 0, ";
}
if($DEANCNMS2 == "1")
{
$query = $query . "DEANCNMS2 = 1, ";
} else
{
$query = $query . "DEANCNMS2 = 0, ";
}
if($PROV2 == "1")
{
$query = $query . "PROV2 = 1, ";
} else
{
$query = $query . "PROV2 = 0, ";
}
if($VPRDGS2 == "1")
{
$query = $query . "VPRDGS2 = 1, ";
} else
{
$query = $query . "VPRDGS2 = 0, ";
}
if($DEANCOEIT2== "1")
{
$query = $query . "DEANCOEIT2 = 1, ";
} else
{
$query = $query . "DEANCOEIT2 = 0, ";
}
if($VPA_F2 == "1")
{
$query = $query . "VPA_F2 = 1, ";
} else
{
$query = $query . "VPA_F2 = 0, ";
}
if($VPSA == "1")
{
$query = $query . "VPSA = 1, ";
} else
{
$query = $query . "VPSA= 0, ";
}
if($DEANERK == "1")
{
$query = $query . "DEANERK = 1, ";
} else
{
$query = $query . "DEANERK = 0, ";
}
if($VPDUE == "1")
{
$query = $query . "VPDUE = 1, ";
} else
{
$query = $query . "VPDUE = 0, ";
}
if($DEANUE == "1")
{
$query = $query . "DEANUE = 1, ";
} else
{
$query = $query . "DEANUE = 0, ";
}
if($VPIA2 == "1")
{
$query = $query . "VPIA2 = 1, ";
} else
{
$query = $query . "VPIA2 = 0, ";
}
// requests
$query = "INSERT into request VALUES (";
if($ADVISE == "1")
{
$query = $query . "ADVISE = 1, ";
} else
{
$query = $query . "ADVISE = 0, ";
}
if($DRAFT == "1")
{
$query = $query . "DRAFT = 1, ";
} else
{
$query = $query . "DRAFT = 0, ";
}
if($MEDIATE == "1")
{
$query = $query . "MEDIATE = 1, ";
} else
{
$query = $query . "MEDIATE = 0, ";
}
if($REPORT == "1")
{
$query = $query . "REPORT = 1, ";
} else
{
$query = $query . "REPORT = 0, ";
}
if($CONTACT == "1")
{
$query = $query . "CONTACT = 1, ";
} else
{
$query = $query . "CONTACT = 0, ";
}
if($NEGOTIATE == "1")
{
$query = $query . "NEGOTIATE = 1, ";
} else
{
$query = $query . "NEGOTIATE = 0, ";
}
if($REVIEW == "1")
{
$query = $query . "REVIEW = 1, ";
} else
{
$query = $query . "REVIEW = 0, ";
}
if($RESEARCH == "1")
{
$query = $query . "RESEARCH = 1, ";
} else
{
$query = $query . "RESEARCH = 0, ";
}
if($INVESTIGATE == "1")
{
$query = $query . "INVESTIGATE = 1, ";
} else
{
$query = $query . "INVESTIGATE = 0, ";
}
if($COORDINATE == "1")
{
$query = $query . "COORDINATE = 1, ";
} else
{
$query = $query . "COORDINATE = 0, ";
}
if($MEETING_ATTEND == "1")
{
$query = $query . "MEETING_ATTEND = 1, ";
} else
{
$query = $query . "MEETING_ATTEND = 0, ";
}
if($PRESENTATION == "1")
{
$query = $query . "PRESENTATION = 1, ";
} else
{
$query = $query . "PRESENTATION = 0, ";
}
// completed
$query = "INSERT into cases VALUES (";
if($COMPLETED == "1")
{
$query = $query . "COMPLETED = 1, ";
} else
{
$query = $query . "COMPLETED = 0, ";
}
// referred to
$query = "INSERT into cases VALUES (";
if($OAG3 == "1")
{
$query = $query . "OAG3 = 1, ";
} else
{
$query = $query . "OAG3 = 0, ";
}
if($WTP2 == "1")
{
$query = $query . "WTP2 = 1, ";
} else
{
$query = $query . "WTP2 = 0, ";
}
if($OTHER2 == "1")
{
$query = $query . "OTHER2 = 1, ";
} else
{
$query = $query . "OTHER2 = 0, ";
}
?>
</body>
</html>