|
|
Posted by Schmidty on 01/26/07 17:42
Okay...I have another 'newbie' question;
I have a function that loads a page and the action is
$_SERVER['HTTP_SELF'];
In the form that is in a function(method?) within a class a variable
is passed back to a mysqli connection and database and updates the
database.
The problem is that when the page is reloaded it does not show the
updated information in the database with the $_SERVER['HTTP_SELF']. Why
is the page loaded with the same information? Is it cached from the
browser? Is there a way to have the functions execute before the
$_SERVER['HTTP_SELF'] action executes?
Example code ======================================
// Show info of users not updated
echo "<form action='".$_SERVER['PHP_SELF']."' method='post'><table
style=\"font: 14px solid #000000; border: 2px solid #CCC000;\">";
echo "<tr><td colspan='2' style=\"background: #C0C0C5; text-align:
center; font: 18px solid #000000;\">Credit Card
Applications</td></tr>";
echo "<tr><td colspan='2' style=\"background: #FFFFE0; text-align:
left; font: 12px solid #000000;\">New Applications In Database Needing
Approval:</td></tr>";
echo "<tr><tr><td colspan='2' style=\"border: 2px solid #000000;
width: 100%;\">";
if ($result->num_rows == 0) {echo "NO NEW APPLICATIONS<br />";}
while($row = $result->fetch_assoc()){
echo "<input type='checkbox' name='perinfo[]'
value='".$row['userID']."' >".$row['userID']." : ".$row['username']." -
".$row['recdate']."<br />";
} // end while
echo "</td></tr><tr>";
echo "<td align=\"center\"><input style=\"font: 10px solid
#000000;\" type=\"submit\" value=\"UPDATE INFO\" name='updatedb'
/></td><td style=\"text-align: center;\"><input type=\"reset\"
style=\"font: 10px solid #000000;\" value=\"RESET CHOICES\"
/></td></tr></form></table>";
$result->free();
} // end function
public function dbConnect(){
include('dbconn.php');
$mysqli = new mysqli($dbnet, $dbuser, $dbpass, $dbname);
if (mysqli_connect_errno()){ printf("Can't connect to MySQL Server.
Errorcode: %s\n", mysqli_connect_error());
exit;
} // end if
return $this->mysqli=$mysqli;
} // end function
End Example Code ===================================================
Thanks for the help!
Schmidty
Navigation:
[Reply to this message]
|