Search the Community
Showing results for tags 'urls'.
-
I am having trouble with having my page remember a POST item. What I'm trying to do is to have the data updated message to include a link using a userid, a random number that's used to find things in the database. I've tried several ways but still having trouble. Below are 2 such ways (along with others). I keep getting a page where the userid doesn't show up. It doesn't make sense though because it gets inserted into the database. Could someone take a look? Instead of coming up with a link like this: http://www.mynewpage.com/visitdetails.php?userid=113555588701606e973.42256784 It looks like this and I get a page doesn't exist error. http://www.mynewpage.com/visitDetails.php?userid= connection info here..... $today = date("F j, Y, g:i a"); $careComments = htmlspecialchars("$_POST[careComments]", ENT_QUOTES); $feedComments = htmlspecialchars("$_POST[feedComments]", ENT_QUOTES); $waterComments = htmlspecialchars("$_POST[waterComments]", ENT_QUOTES); $ventilationComments = htmlspecialchars("$_POST[ventilationComments]", ENT_QUOTES); $recordsComments = htmlspecialchars("$_POST[recordsComments]", ENT_QUOTES); $invNotes = htmlspecialchars("$_POST[invNotes]", ENT_QUOTES); $facilityComments = htmlspecialchars("$_POST[facilityComments]", ENT_QUOTES); $summaryComments = htmlspecialchars("$_POST[summaryComments]", ENT_QUOTES); $deads = "$_POST[deads]"; $start = "$_POST[start]"; $mortality = $deads/$start*100; $userid = "$_POST[userid]"; $sql="INSERT INTO visitNotes (id,today,userid,date,site,name,groupID,caretaker,reason,careComments,cough,looseness,sorting,treating,walking,med1,med2,euthanasia,biosecurity,feed,feedComments,adjustments,tickets,water,waterComments,cleanwater,meter,temps,ventilationComments,humidity,fans,curtains,inlets,hilo,alarm,backup,pitLevel,recordsComments,medRecords,rodent,testAlarm,lp,lpLevels,genFuel,genFuelLevel,genHoursRecord,genHours,invRecords,invNotes,currentInv,start,deads,mortality,cleanOffice,facilityComments,mow,gates,chute,lights,deadDisp,summaryComments) VALUES ('$_POST[id]','$today','$_POST[userid]','$_POST[date]','$_POST[site]','$_POST[name]','$_POST[groupID]','$_POST[caretaker]','$_POST[reason]','$careComments','$_POST[cough]','$_POST[looseness]','$_POST[sorting]','$_POST[treating]','$_POST[walking]','$_POST[med1]','$_POST[med2]','$_POST[euthanasia]','$_POST[biosecurity]','$_POST[feed]','$feedComments','$_POST[adjustments]','$_POST[tickets]','$_POST[water]','$waterComments','$_POST[cleanwater]','$_POST[meter]','$_POST[temps]','$ventilationComments','$_POST[humidity]','$_POST[fans]','$_POST[curtains]','$_POST[inlets]','$_POST[hilo]','$_POST[alarm]','$_POST[backup]','$_POST[pitLevel]','$recordsComments','$_POST[medRecords]','$_POST[rodent]','$_POST[testAlarm]','$_POST[lp]','$_POST[lpLevels]','$_POST[genFuel]','$_POST[genFuelLevel]','$_POST[genHoursRecord]','$_POST[genHours]','$_POST[invRecords]','$invNotes','$_POST[currentInv]','$_POST[start]','$_POST[deads]','$mortality','$_POST[cleanOffice]','$facilityComments','$_POST[mow]','$_POST[gates]','$_POST[chute]','$_POST[lights]','$_POST[deadDisp]','$summaryComments')"; if (!mysqli_query($con,$sql)) { die('Error: ' . mysqli_error($con)); } echo "1 record added <br>"; echo "<a href='visitDetails.php?userid='$_POST[userid]'>Email Visit Results</a>"; echo "<br><br><a href='visitDetails.php?userid='" . $userid . "'>Visit Results</a>"; mysqli_close($con); ?>