skania

So I have a tedious status selection bar that is on every page, so I simply used an include on the pages, the actual navigation bar separated. The navigation is ~/public_html/courseListMenu.php When the user is on a certain page, it will simply refresh the page to the current page, which the updated status (courseID), and the information about that course. However, if the user is looking at a participant, and clicks on the navigation (ie, change the courseID, thus changing the catalog of people in it), I want to redirect to the index.php. So here is the problem: I have a URL, www.example.com/atn/index.php *A class is selected* New URL with updated page, www.example.com/atn/index.php?CRN=999999999 Select editparticipant, www.example.com/atn/editparty.php?CRN=999999999&PARTY=111111111 *A new class is selected* I need to extract "editparty.php" so I can compare the string and if they match, then revert the user back to index.php. I need to compare strings, because since this is an include, there will be other pages that will redirect the user to index.php The exact problem I have is that I can get the script that is running, but it is the INCLUDED script filename, not the file name it is INCLUDED on, which is the filename I need. I hope this is clear; if it isn't, I can try to explain a little better. If anyone has any idea on how I can get this, it would be very much appreciated!

Php/sql novice here. :/ I've got a table that has id(auto-incrementing), student_id(primary key), student_name(varchar), swipe_in(date_time), swipe_out(date_time). I'm working on a web database that'll streamline attendance tracking for professors at a university. One of the reports requested is "By student". The professor would like headers across the top, and under each - the date if the student attended, and blank if the student failed to attend. Here are the problems I'm coming into: I have the headers with: $sql = "SELECT DISTINCT DATE(swipe_in) AS swipe_date from attendance"; $list = mysqli_query($dbcon, $sql); while($record = mysqli_fetch_assoc($list)){ echo "<th>" . $record['swipe_date'] . "</th>"; } I need to then print out the students that attended on that date. So that each student will either have "yes" or "no" (or something of that nature, or 0 or 1). But this brings me into a secondary problem: Students appear to enjoy double swiping their student identification cards "just in case" I suppose. There are multiple records in the database that have the same date but differ by ~10 seconds. I need to make sure I only check on one of those dates, I don't want each record to print. :S If possible, I would like to find a solution that does not deal with a hands on approach in the database - as this will all be automated in the end. So if I can accomplish the record problem without having to do something in the database each time I want a report would be best. The table in the database can be changed, but the input file is from a script that inserts into the database, essentially looks the same. Any ideas? Thanks in advance!

I have 4 studies that I need to display on a page. I was printing them in order, but I would like to make a partition that clearly distinguishes each section, studyID and studyName. Here is the code thus far: $sql = 'SELECT * FROM tbl_studies'; $list = mysqli_query($dbcon, $sql); $numRecords = mysqli_num_rows($list); for ($i = 1; $i < $numRecords ; $i++){ $sql1 = 'SELECT * FROM tbl_studies JOIN tbl_childinformation ON tbl_studies.studyID = tbl_childinformation.studyID JOIN tbl_parentinformation ON tbl_childinformation.parentID = tbl_parentinformation.parentID'; $list1 = mysqli_query($dbcon, $sql1); $record1 = mysqli_fetch_assoc($list1); echo "<center>----------------------------------------------------------------------<br>"; echo "<center>" . $record1['studyID'] . ' ' . $record1['studyName'] . "</center>"; echo "----------------------------------------------------------------------</center><br />"; $sql = "SELECT * from tbl_studies JOIN tbl_childinformation ON tbl_studies.studyID = tbl_childinformation.studyID JOIN tbl_parentinformation ON tbl_childinformation.parentID = tbl_parentinformation.parentID WHERE tbl_childinformation.studyID = '$record1[studyID]'"; $list = mysqli_query($dbcon, $sql); while($record = mysqli_fetch_assoc($list)){ $newbirthdate = date('m/d/Y', strtotime($record['dateOfBirth'])); $newstudydate = date('m/d/Y', strtotime($record['dateOfStudy'])); echo $record['studyID'] . ' ' . $record['studyName'] . '<br>'; echo "<p class = \"smallerfont\"><em>ID:</em> " . $record['childID'] . "<p class = \"smallerfont\"><em>Name:</em> " . $record['childFirstName'] . ' ' . $record['childLastName'] . "<p class = \"smallerfont\"><em>Date of Birth:</em> " . $newbirthdate . "<p class=\"smallerfont\"><em>Twin?:</em> " . ($record['twin'] == 1 ? 'Yes' : 'No') . "<p class = \"smallerfont\"><em>Medical Conditions:</em> " . $record['medicalConditions'] . "<p class = \"smallerfont\"><em>StudyID:</em> " . $record['studyID'] . "<p class=\"smallerfont\"><em>Date of Study:</em> " . $newstudydate . '<br /><br />'; echo "<div id=\"parentblock\">"; echo "<a id= \"parentlink\" href=\"parentinformationlink.php?pid=" . $record['parentID'] . "\"> Link to " . $record['parentOneFirstName'] . ' ' . $record['parentOneLastName'] . (empty($record['parentTwoFirstName']) ? '</a>':' and ' . $record['parentTwoFirstName'] . ' ' . $record['parentTwoLastName']) . "</a>"; echo "</div>"; } } So basically, I figured I could count the number of studies there are after querying the tbl_studies, and then for a for loop, and only print the children that have matching studyID's. Works great for the first loop, but I need to reference the 2nd record, and so on. Is there a way to achieve this in php? Any advice is greatly appreciated!

Solved it. Turns out you have to surround it with " "

I have a table of studies that I get based on studyID. $studyID = $_GET['sid']; $sql = "SELECT * FROM tbl_studies WHERE studyID = $studyID"; $list = mysqli_query($dbcon, $sql); $record = mysqli_fetch_assoc($list); print_r ($record); echo $record['studyName']; print_r ($record) and echo $record['studyName'] both show that there are 2 words for a study name, however, only 1 shows up when I use this: <input type="text" name="studyName" value = <?php echo $record['studyName']; ?>/> Will show "Olfactory" when echo $record['studyName'] shows "Olfactory Study". I'm assuming there is a fix that is relatively simple, but I haven't found one online, any advice is greatly appreciated!

Thank you for that, I had used && first, but when it wasn't working I switched to 'and'. And I'll have to read up on the " and ', thank you!

I need a list for a form that will be used to register children to their legal guardian. The list is a drop down menu, which will eventually be sorted alphabetically, if php can do that . However, the current problem is that there are single parents out there, way current way the code is set up works, but it looks off when there is a random '&' with no second parent name. When I try to do a ternary operation, it completely stops all options from appearing from the drop down. Here is the code that WORKS: echo "<option value=" . $row_list["parentID"] . ">" . $row_list["parentOneFirstName"] . " " . $row_list["parentOneLastName"] . " & " . $row_list["parentTwoFirstName"] . " " . $row_list["parentTwoLastName"] . "</option>"; Here is the code with the ternary operation: echo "<option value=" . $row_list["parentID"] . ">" . $row_list["parentOneFirstName"] . " " . $row_list["parentOneLastName"] . ((!empty($row_list["parentTwoFirstName"])) and (!empty($row_list["parentTwoLastName"]))) ? " & " . $row_list["parentTwoFirstName"] . " " . $row_list["parentTwoLastName"] . "</option>" : "</option>"; Anyone know what the problem is, or even better, how to fix it? I appreciate any and all input, thank you.

I've got a form that lets the user submit, or update a record, matching the update to the previously entered E-Mail. However, there is a "Do Not Contact" option that I need to be able to update as well. Here is how I have it structured: elseif (isset($_POST['Update'])){ $parentOneFirstName = mysqli_real_escape_string($dbcon, $_POST["parentOneFirstName"]); $parentOneLastName = mysqli_real_escape_string($dbcon, $_POST["parentOneLastName"]); $parentTwoFirstName = mysqli_real_escape_string($dbcon, $_POST["parentTwoFirstName"]); $parentTwoLastName = mysqli_real_escape_string($dbcon, $_POST["parentTwoLastName"]); $homePhone = mysqli_real_escape_string($dbcon, $_POST["homeNumber"]); $cellPhone = mysqli_real_escape_string($dbcon, $_POST["cellNumber"]); $city = mysqli_real_escape_string($dbcon, $_POST["city"]); $state = mysqli_real_escape_string($dbcon, $_POST["state"]); $zipPostal = mysqli_real_escape_string($dbcon, $_POST["zipPostal"]); $emailAddress = mysqli_real_escape_string($dbcon, $_POST["emailAddress"]); $referringFacility = mysqli_real_escape_string($dbcon, $_POST["referringFacility"]); $preferredContact = mysqli_real_escape_string($dbcon, $_POST["preferredContact"]); // $doNotContact = mysqli_real_escape_string($dbcon, $_POST["doNotContact"]); $sql = "UPDATE tbl_parentinformation SET emailAddress = '$emailAddress'"; if(!empty($parentOneFirstName)) $sql = $sql . ",parentOneFirstName = '$parentOneFirstName'"; if(!empty($parentOneLastName)) $sql = $sql . ",parentOneLastName = '$parentOneLastName'"; if(!empty($parentTwoFirstName)) $sql = $sql . ",parentTwoFirstName = '$parentTwoFirstName'"; if(!empty($parentTwoLastName)) $sql = $sql . ",parentTwoLastName = '$parentTwoLastName'"; if(!empty($homeNumber)) $sql = $sql . ",homePhone = '$homePhone'"; if(!empty($cellNumber)) $sql = $sql . ",cellPhone = '$cellPhone'"; if(!empty($city)) $sql = $sql . ",city = '$city'"; if(!empty($state)) $sql = $sql . ",state = '$state'"; if(!empty($zipPostal)) $sql = $sql . ",zipPostal = '$zipPostal'"; if(!empty($referringFacility)) $sql = $sql . ",referringFacility = '$referringFacility'"; if(!empty($preferredContact)) $sql = $sql . ",preferredContact = 'preferredContact'"; $sql = $sql . "WHERE emailAddress = '$emailAddress'"; This allows the user to update only fields they need to update, and doesn't empty out the data already there. The boolean value is received from a checkbox (check = true, nocheck = false), but I can't get it to check to see if it needs to update or not. Anyone have this problem in the past? I want them to have the OPTION to update it, but not require them to check each time a record is updated. Thanks in advance to anyone that responds

I'm a little new to PHP, a little more familiar to SQL but I haven't been able to figure out how to send a boolean value from an html form to the SQL server. I've got the doNotContact in the database as a boolean value, and have a checkbox for the selection: <td>Do Not Contact: </td><td><input type="checkbox" name="doNotContact" value= "True"/></td><br /> But when I write the SQL statement, it fails to get a value. All other values (text/number) work perfectly, except for this, so if anyone has any suggestions - I would appreicate it.