Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Refresh page to update table contents(from MySQL) 1
- Thread starter nataly333
- Start date
-
1
- #2
sleipnir214
Programmer
There's no PHP mechanism for doing this. Once the page is produced, the PHP script stops running.
You might try a "Refresh" META tag in your HTML code.
Want the best answers? Ask the best questions: TANSTAAFL!!
You might try a "Refresh" META tag in your HTML code.
Want the best answers? Ask the best questions: TANSTAAFL!!
- Thread starter
- #3
Thank You very much!
I tried something like:
<META HTTP-EQUIV="Refresh" CONTENT="3;URL=http://www.some.org/some.html">
but it didn't work.
Even if it work, it work only one time,is in't it?
And i need refresh my page each 60 sec, all the time...
Do you have any idea?
Sorry for my English, and thank you again for help
I tried something like:
<META HTTP-EQUIV="Refresh" CONTENT="3;URL=http://www.some.org/some.html">
but it didn't work.
Even if it work, it work only one time,is in't it?
And i need refresh my page each 60 sec, all the time...
Do you have any idea?
Sorry for my English, and thank you again for help
sleipnir214
Programmer
Send the meta tag each time the page refreshes. This should keep the page perpetually updating.
Want the best answers? Ask the best questions: TANSTAAFL!!
Want the best answers? Ask the best questions: TANSTAAFL!!
- Thread starter
- #5
I've tried your sudgections
<meta http-equiv="refresh" content="60;url=<?php echo $PHP_SELF; ?>">
<meta http-equiv="refresh" content="60;url=<? echo $_SERVER['PHP_SELF'] ?>">
Unfortunately it doesn't work.
Thank you for your help
<meta http-equiv="refresh" content="60;url=<?php echo $PHP_SELF; ?>">
<meta http-equiv="refresh" content="60;url=<? echo $_SERVER['PHP_SELF'] ?>">
Unfortunately it doesn't work.
Thank you for your help
sleipnir214
Programmer
That's odd. This script:
Works for me. Every 10 seconds the page refreshes and the session variable is updated. I'm getting a count of a new number every 10 seconds.
Want the best answers? Ask the best questions: TANSTAAFL!!
Code:
<?php
session_start();
if (!array_key_exists('foo', $_SESSION))
{
$_SESSION['foo'] = 1;
}
else
{
$_SESSION['foo'] ++;
}
print '<html>
<head>
<meta http-equiv="refresh" content="10; test_refresh.php">
</head>
<body>
';
print $_SESSION['foo'];
print '
</body>
</html>';
?>Works for me. Every 10 seconds the page refreshes and the session variable is updated. I'm getting a count of a new number every 10 seconds.
Want the best answers? Ask the best questions: TANSTAAFL!!
- Thread starter
- #7
sleipnir214
Programmer
It's possible that browser settings could change the behavior of the META tag.
Want the best answers? Ask the best questions: TANSTAAFL!!
Want the best answers? Ask the best questions: TANSTAAFL!!
- Thread starter
- #9
This is my code:
<?
include("shared.inc.php"
;
global $PHP_SELF;
?>
<html>
<head><title>My Site</title>
<meta http-equil="refresh" content="30;url=<? echo $_SERVER['PHP_SELF'] ?>">
</head>
<body bgcolor=#dfdfdf>
<?
$hostname="delta";
$username="root";
$password="nataly789";
$dbName="delta";
$db = mysql_connect($hostname,$username,$password) or die ("Can't connect to database "
mysql_select_db("$dbName",$db) or die("Can't select database"
$usertable="product";
$result = mysql_query("SELECT * FROM $usertable"
$num_rows = mysql_num_rows($result);
while ($myrow = mysql_fetch_array($result))
{
echo "<table width=500 border=0 cellspacing=0 cellpadding=0><tr>
<td>".$myrow[0]."</td>
<td width=120>".$myrow[1]."</td>
<td width=120>".$myrow[2]."</td>
</tr></table>";
}
mysql_close($db);
?>
</body>
</html>
<?
include("shared.inc.php"
;global $PHP_SELF;
?>
<html>
<head><title>My Site</title>
<meta http-equil="refresh" content="30;url=<? echo $_SERVER['PHP_SELF'] ?>">
</head>
<body bgcolor=#dfdfdf>
<?
$hostname="delta";
$username="root";
$password="nataly789";
$dbName="delta";
$db = mysql_connect($hostname,$username,$password) or die ("Can't connect to database "
; mysql_select_db("$dbName",$db) or die("Can't select database"
;$usertable="product";
$result = mysql_query("SELECT * FROM $usertable"
;$num_rows = mysql_num_rows($result);
while ($myrow = mysql_fetch_array($result))
{
echo "<table width=500 border=0 cellspacing=0 cellpadding=0><tr>
<td>".$myrow[0]."</td>
<td width=120>".$myrow[1]."</td>
<td width=120>".$myrow[2]."</td>
</tr></table>";
}
mysql_close($db);
?>
</body>
</html>
sleipnir214
Programmer
Try changing:
<meta http-equil=
to
<meta http-equiv=
Want the best answers? Ask the best questions: TANSTAAFL!!
<meta http-equil=
to
<meta http-equiv=
Want the best answers? Ask the best questions: TANSTAAFL!!
- Thread starter
- #11
- Status
Similar threads