Re: Function execution before page reload

Thanks Jerry for the reply. I made a mistake in the variable
"$_SERVER['HTTP_SELF']" in my previous posts, it should be
$_SERVER['PHP_SELF'].
I realize that the html page is static and that the browser does not
communicate with the PHP script.

When a user who updates a database the FORM in the PHP script will
have 'action' set to load a $_SERVER['PHP_SELF'];

Example of 'updatedb.php'
=======================================================================
========

<?php
// updatedb.php
$nu = new userFunction();

echo "<form action=\"$_SERVER['PHP_SELF']\" method='post'><input
type='text' name='name' /><input type='submit' name='update'
value='UPDATE DB' /></form>";

if (isset($_POST['update'])){
$nu->updateDBFunction($_POST['name']);
print "DB UPDATED<br />";

}

?>

End Example
=======================================================================
==================

In the short example above does the script execute the function BEFORE
it reloads the $_SERVER['PHP_SELF'] variable?

Schmidty




On Jan 26, 7:06 pm, Jerry Stuckle <jstuck...@xxxxxxxxxxxxx> wrote:
Schmidty wrote:
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!

SchmidtySchmidty,

Where are you updating the database? And where are you retrieving the
values?

PHP is server-side. ALL code is executed before the page is sent to the
browser. Interaction between PHP and the browser is one-way - the PHP
sends the page and terminates. There isn't any interaction between the
browser and the PHP code (other than to load a new page).

When they click on the submit button for the form, the browser requests
the page identified in your FORM statement. Since it is the same page,
all of the PHP code is executed again.

But you didn't show most of your code so there's no way to determine
what might be going on.

And no, you don't need AJAX or similar for this to work. Straight PHP
works great.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@xxxxxxxxxxxxx
==================- Hide quoted text -- Show quoted text -

.