agr8lemon
-
Posts
5 -
Joined
-
Last visited
Never
Everything posted by agr8lemon
-
Wow, Thank you. I was trying to do $Depart_ID = (int)$_POST['Depart_ID']; because it wanted to make sure it was an integer and my fingers and brain must be tired. Anyways, it works now thank you very much!
-
Hello everyone, I know there are a lot of articles about inserting into joined tables, but they all seem to do with auto incrementing both Keys at the same time. Mine is different and I'm hoping someone can help. I have two tables with a PK/FK relationship Emp_tbl ---------- ID (PK, int, not null, autoinc) Depart_ID (FK, int not null) Depart_tbl ---------- Depart_ID(PK, int, not null, autoinc) On my form I have a drop down that pulls the data from B to a drop-down that creates the value of the dropdown the integer of Depart_ID as follows: $sql_depart="SELECT Depart_Name, Depart_ID, Depart_Facility FROM dbo.Depart_tbl WHERE Disabled = '0' ORDER BY Depart_Name ASC"; $departResult=odbc_exec($dept_conn, $sql_depart); $departOptions=""; while($departRows=odbc_fetch_array($departResult)){ $departId=$departRows["Depart_ID"]; $Departments=$departRows['Depart_Name']; $departOptions.="<OPTION VALUE=\"$departId\">".$Departments.'</option>'; } odbc_close($dept_conn); So what I want to happen is to insert the data data into the Emp_tbl along with the proper Depart_ID for Depart_tbl (Keep in mind I don't want to change the Depart_tbl at all, just grab the PK value of and put that into the Emp_tbl for the join). Then this is my insert page: $_POST['Depart_ID'] = (int)$Depart_ID; ///Define our insert $sql="INSERT INTO dbo.Emp_tbl (Emp_First, Emp_Last, Emp_Title, Emp_Phone, Emp_Cell, Emp_Pager, Emp_Fax, Depart_ID) VALUES ('$_POST[Emp_First]','$_POST[Emp_Last]','$_POST[Emp_Title]','$_POST[Emp_Phone]','$_POST[Emp_Cell]','$_POST[Emp_Pager]','$_POST[Depart_Fax]','$Depart_ID')"; ///Make the insert $result=odbc_exec($emp_conn, $sql); The error I get is: Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver] The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Emp_Info_Emp_Department". The conflict occurred in database "PhoneDir", table "dbo.Depart_tbl", column 'Depart_ID'., SQL state 23000 in SQLExecDirect in Does this make sense? Can anyone help me? Thank you!
-
Thank you, I guess I got a little semi-colon happy That did not fix the issue however.
-
Hello everyone. I have a page with 3 separate drop down choices. Search SHEC Departments Search SJCF Departments Search SHEC Employees I'd like to show the results of the search on the same page. I'm trying to determine what SQL query to run based on what SELECT button they push. I'm having a issue trying to use a switch with $_GET. Here is an example of what I have. Sorry if the code is sloppy, I've been trying a bunch of things and have not organized it yet. <?php require"../includes/dept_mssql.php"; //Connect to the Department database require"../includes/emp_mssql.php"; //Conect to the Employee database //show all errors error_reporting(E_ALL); ini_set('display_errors', '3') ?> <html> <head> </head> <body> <div align="center"> <h1> Hospital Phone Directory </h1> <hr /> </div> <div align=center> <h2> SHEC Department Search </h2> <form name=shec_depart action="<?php echo $_SERVER['PHP_SELF']; ?>" method="get"> <?php $sql_depart_shec="SELECT Name, Depart_ID, Facility FROM dbo.Depart_tbl WHERE Facility = 'SHEC' OR Facility = 'BOTH' ORDER BY Name ASC"; $shecResult=odbc_exec($dept_conn, $sql_depart_shec); $shecOptions=""; while($shecRows=odbc_fetch_array($shecResult)){ $shecId=$shecRows["Depart_ID"]; $shecDepartments=$shecRows['Name']; $shecOptions.="<OPTION VAULE=\"$shecId\">".$shecDepartments; } ?> <select name="shec-depart"> <OPTION VALUE=>SHEC Departments<?php echo $shecOptions ?> </SELECT> <input type="submit" name="Submit" value="Search" /> <input type="hidden" name="submitted" id="submitted" value="true" /> </form> </div> <div align=center> <h2>SJCF Department Search</h2> <form name=sjcf_depart action="<?php echo $_SERVER['PHP_SELF']; ?>" method="get"> <?php $sql_depart_sjcf="SELECT Name, Depart_ID, Facility FROM dbo.Depart_tbl WHERE Facility = 'SJCF' OR Facility = 'BOTH' ORDER BY Name ASC"; $sjcfResult=odbc_exec($dept_conn, $sql_depart_sjcf); $sjcfOptions=""; while($sjcfRows=odbc_fetch_array($sjcfResult)){ $sjcfId=$sjcfRows["Depart_ID"]; $sjcfDepartments=$sjcfRows['Name']; $sjcfOptions.="<OPTION VAULE=\"$sjcfId\">".$sjcfDepartments; } ?> <select name="sjcf-dept" STYLE="width: 275px"> <OPTION VALUE=>SJCF Departments<?php echo $sjcfOptions ?> </SELECT> <input type="submit" name="Submit" value="Search" /> <input type="hidden" name="submitted" id="submitted" value="true" /> </form> </div> <div align=center> <h2> SHEC Employee Search</h2> <form name=shec_emp action="<?php echo $_SERVER['PHP_SELF']; ?>" method="get"> <?php $sql_emp_shec="SELECT * FROM dbo.Emp_tbl WHERE Facility = 'SHEC' OR Facility = 'BOTH' ORDER BY FirstName ASC"; $result=odbc_exec($emp_conn, $sql_emp_shec); ?> <select name="shec-name" STYLE="width: 275px"> <OPTION VALUE=A>A</option> <OPTION VALUE=B>B</option> </SELECT> <input type="submit" name="Submit" value="Search" /> <input type="hidden" name="submitted" id="submitted" value="true" /> </form> <?php if($_GET['submitted'] == true) { switch ($_SERVER['QUERY_STRING']) { case "shec-dept"; echo "do some query"; break; case "sjcf-dept"; echo "Do another query"; break; case "shec-name"; echo "Do yet a different query"; break; defalut; echo "error"; } } else { echo 'Get is not set'; } odbc_close($dept_conn); odbc_close($emp_conn); ?> At the moment the page displays, however making a selection from the dropdowns and hitting the submit button does not display any of the switch echos. Any help would be wonderful!! Thank you!