refresh web page with new values

[colforbin05]

Hello....

I've written a php script embedded in html that calls upon a sql db to output results from an ldap server. This script was written to find the failed login attempts of windows users. I have two fields that asks for the hours, which the default searches the db 2 hours prior, and the failure count of the user login, which the default searches users that failed to login 5 times or more. I wanted to auto-refresh the web page so in order to accomplish this I entered the following into the html header:

<Meta HTTP-EQUIV="refresh" CONTENT="100; URL=/~charlie/helloworld.php">

This works well, but unfortunately the auto-update is refreshing to the home page and not keeping the altered values requested by the user. For example, if I switch the hours to 1 and the failures to 2, the auto refresh will bring me back to a default of 2 hours and 5 failures and not update my results of the first query. Does anyone know how to refresh the results of the query???? Any information will be greatly appreciated. Thank you. --Colforbin5

[barand]

Pass values in query string eg:

<Meta HTTP-EQUIV="refresh" CONTENT="100; URL=/~charlie/helloworld.php?hours=3&refresh=4">

hth

[Threehearts]

Hi!
The easiest solution to this seems to be to do the reload via javascript - if theres a good chance javascript on the viewing browser is activated.

example:
<img src="..." onClick="document.forms[0].elements[x1].value ='<?=$variable_a ?>'; document.forms[0].elements[x2].value ='<?=$variable_b ?>'; document.forms[0].submit();">

if you havent got a form you'd have to create one of course, via script or directly in html.

if you cant use clientsided script put a form into html and echo the values directly - hard option so to say.

the other way i see is - apart from putting the data back into the db - to open a session and registering the variables.

if you can use it the script thing should be fastest solution.

hope this helps...
greetings, jakob

[colforbin05]

barand:

This isn't working for some reason. I've entered the rest of the tag "?hours=3&refresh=4" but I'm getting a default of 3 hours. When the user opens the page, the default is 2 hours and the failure count is 5---the refresh works fine here when I don't alter the values. However, if I change these values to look up the login failures from 1 hour ago and having 2+ failures, the auto refresh doesnt update the results of the new page; it only goes back to the default. Any more suggestions? TX. --Colforbin.

[colforbin05]

Hi:

I made some progress on how to refresh the page after the user has submitted new hours and failures parameters. I simply put "http://enterprise/~benzino/final.php?$hours=hours

However, as I'm told this should work. I receive a Illegal hours parameter after the page refreshes. What is the dilly? I just need the page to refresh under the new altered values!! someone help me please!! -Colforbin

$hours = $_REQUEST["hours"];

// If it wasn't specified, we default it.

// Check the syntax.

if (! $hours) $hours = 2;

// Check the syntax.
ereg('^{[1-9][0-9]*$',} $hours) or die("Illegal HOURS parameter.");

// Also see how many failures must exist before we flag as "red".

$failures = $_REQUEST["failures"];
if (! $failures) $failures = 5;
ereg('^{[1-9][0-9]*$',} $failures) or die("Illegal FAILURES parameter.");

// When refreshing, make sure we pass non-default values back to the
// script, else we lose the changes.
$urlappend = ($hours != 2) ? "&hours={$hours}" : "";
if ($failures != 5) $urlappend .= "&failures={$failures}";

// OK, let's query the database.
// These variables are defined in ./authenticate.inc

if (!($db = mysql_connect($db_host, $db_user, $db_pass)))
die("SQL Server unavailable; try again later.");
if (!mysql_select_db("ntsyslog", $db))
die("No NTSysLog SQL database???");

$eid="SELECT primary_uname, COUNT(*) AS uname_count, MIN(stamp), MAX(stamp) " .
"FROM nteventlog WHERE stamp > NOW() - INTERVAL {$hours} HOUR " .
"AND event IN (529, 535, 539) GROUP BY primary_uname " .
"HAVING uname_count > {$failures} ORDER BY uname_count DESC";

if (!($eid = mysql_query($eid, $db)))
die("Can't run SQL query?");

// Fetch all the data and put it in an array called "rows".

while(($x = mysql_fetch_row($eid))) $rows[] = $x;

// Finish up by freeing the data structure and closing the DB connection.
mysql_free_result($eid);
mysql_close($db);

// OK, we have all our data now in "rows[]" and the database is closed down.
// Now generate the HTML.
// Each of the rows is itself an array, where the four values are
// (from the SQL query): uname, count, min_stamp and max_stamp.

?>

<HTML>

<Head>
<Title>Failed Login attempts</Title>
<Meta NAME= "Author" CONTENT= "Benjamin J. Paradis">
<Meta NAME= "Robots" CONTENT= "NoIndex, NoFollow">
<Meta HTTP-EQUIV="refresh" CONTENT="10; URL='http://enterprise/~benzino/final.php?hours=$hours'">
<LINK REL="stylesheet" TYPE="text/css" HREF="final.css">
</Head>

[barand]

I made some progress on how to refresh the page after the user has submitted new hours and failures parameters. I simply put "http://enterprise/~benzino/final.php?$hours=hours

Should be

"http://enterprise/~benzino/final.php?hours=$hours "

Note subtle repositioning of the $

[colforbin05]

Thanks! Worked like a charm. 😃