Re: php inserting problem
Posted: Fri Apr 18, 2008 3:15 pm
Code: Select all
[color=#0000FF]<html>
<body>
<?php
// connection string
$con = mysql_connect("agagg", "aggag", "afdaf") or die("could not connect to server");
mysql_select_db("agagadg", $con) or die('Sorry, could not connect to database');
// 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
echo $cases;
mysql_query($query) or die ('origdepat query'.mysql_error());
}
// original department checkboxes
$query = "INSERT into origdepart (ACINTEG, CIVENG, ENRMGT, IA, OFFCAMP, PUBREL, UCS, ADSVC, CLUBS, ENGR, IACUC, OIA, RETRVR, UHS, AFSTDS, COMMONS, ERICSCH, IS, OIR, R_PARK, UMFNDN, ALREL, CONTED, ESH, IES, OIT, SGA, UPWBD, AMERSTD, CSEE, FACSEN, IRB, ORL, SHRVR, USM, ANCSTD, CSST, FINSERV, IRC, OSP, SOCWRK, VART, ASCRV, CWIT, GALLRY, JCET, OTD, SOCY, VPA_F, ATHL, DANCE, GEOG, LIBRY, PHIL, SJP, VPACAFF, BIO, DEANAHSS, GEST, LRC, PHYS, STUAFF, VPFACAF, BKSTR, DEANCOEIT, GRAD, MAS, POLTSCI, STULIFE, VPIA, CAREER, DEANUE, GSA, MATH, POLICE, STUSIPSRV, VPIT, CASPR, DEANCNMS, GUESTSRV, MECHENG, PPLNT, TECHCTR, VPRDGS, CAST, DPET_CPS, HIST, MIPAR, PRES, TEI, WMCTR, CUERE, ECON, HLTHSCI, MLL, PROC, TELECOMM, WMSTD, CHEM, EDUC, HNRSCOL, MUSIC, PROV, THTR, CHEMENG, EHS, HREL, MYRHOF, PSYC, TRANSIT, CHPDM, ENGL, HRES, OAG, PUBPOL, TRNCTRS) VALUES (";
if($ACINTEG == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($CIVENG == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($ENRMGT == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($IA == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($OFFCAMP == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($PUBREL == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($UCS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($ADSVC == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($CLUBS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($ENGR == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($IACUC == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($OIA == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($RETRVR == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($UHS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($AFSTDS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($COMMONS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($ERICSCH == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($IS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($OIR == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($R_PARK == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($UMFNDN == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($ALREL == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($CONTED == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($ESH == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($IES == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($OIT == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($SGA == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($UPWBD == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($AMERSTD == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($CSEE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($FACSEN == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($IRB == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($ORL == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($SHRVR == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($USM == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($ANCSTD == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if(CSST == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if(FINSERV == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($IRC == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($OSP == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($SOCWRK == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($VART == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($ASCRV == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($CWIT == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($GALLRY == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($JCET == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($OTD == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($SOCY == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($VPA_F == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($ATHL == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($DANCE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($GEOG == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($LIBRY == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($PHIL == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($SJP == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($VPACAFF == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($BIO == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($DEANAHSS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($GEST == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($LRC == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($PHYS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($STUAFF == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($VPFACAF == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($BKSTR == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($DEANCOEIT == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($GRAD == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($MAS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($POLTSCI == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($STULIFE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($VPIA == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($CAREER == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($DEANUE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($GSA == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($MATH == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($POLICE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($STUSIPSRV == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($VPIT == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($CASPR == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($DEANCNMS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($GUESTSRV == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($MECHENG == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($PPLNT == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($TECHCTR == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($VPRDGS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($CAST == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($DPET_CPS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($HIST == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($MIPAR == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($PRES == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($TEI == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($WMCTR == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($CUERE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($ECON == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($HLTHSCI == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($MLL == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($PROC == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($TELECOMM == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($WMSTD == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($CHEM == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($EDUC == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($HNRSCOL == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($MUSIC == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($PROV == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($THTR == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($CHEMENG == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($EHS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($HREL == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($MYRHOF == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($PSYC == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($TRANSIT == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($CHPDM == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($ENGL == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($HRES == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($OAG == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($PUBPOL == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($TRNCTRS == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
$result = mysql_query($query);
echo $query;
mysql_query($query) or die ('origdepart query'.mysql_error());
//responsible offices
$query = "INSERT into respoff (DEANAHSS2, PRES2, VPIT2, DEANCNMS2, PROV2, VPRDGS2, DEANCOEIT2, VPA_F2, VPSA, DEANERK, VPDUE, DEANUE, VPIA2) VALUES (";
if($DEANAHSS2 == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($PRES2 == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($VPIT2 == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($DEANCNMS2 == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($PROV2 == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($VPRDGS2 == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($DEANCOEIT2== "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($VPA_F2 == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($VPSA == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($DEANERK == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($VPDUE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($DEANUE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($VPIA2 == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
$result = mysql_query($query);
echo $query;
mysql_query($query) or die ('respoff query'.mysql_error());
// requests
$query = "INSERT into request (ADVISE, DRAFT, MEDIATE, REPORT, CONTACT, NEGOTIATE, REVIEW, RESEARCH, INVESTIGATE, COORDINATE, MEETING_ATTEND, PRESENTATION) VALUES (";
if($ADVISE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($DRAFT == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($MEDIATE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($REPORT == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($CONTACT == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($NEGOTIATE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($REVIEW == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($RESEARCH == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($INVESTIGATE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($COORDINATE == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($MEETING_ATTEND == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($PRESENTATION == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
$result = mysql_query($query);
echo $query;
mysql_query($query) or die ('request query'.mysql_error());
// completed
$query = "INSERT into cases (COMPLETED) VALUES (";
if($COMPLETED == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
$result = mysql_query($query);
echo $query;
mysql_query($query) or die ('cases query'.mysql_error());
// referred to
$query = "INSERT into cases (OAG3, WTP2, OTHER2) VALUES (";
if($OAG3 == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($WTP2 == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
if($OTHER2 == "1")
{
$query = $query . "'1', ";
} else
{
$query = $query . "'0', ";
}
$result = mysql_query($query);
echo $query;
mysql_query($query) or die ('cases query'.mysql_error());
?>
</body>
</html>