php mysql刷新表格_自动刷新表没有刷新页面PHP MySQL

该技术称为AJAX,添加到项目中的最简单的库之一是

jQuery.我假设您的问题不是使用JavaScript,而是考虑重新加载整个页面.

UPDATE

因为我是一个很好的人;)这应该工作,或多或少,我没有尝试过,所以可能有一两个错字：

$host="****";

$user="****";

$password="****";

$cxn = mysql_pconnect ($host, $user, $password);

mysql_select_db("defaultdb", $cxn);

if (getenv(HTTP_X_FORWARDED_FOR)) {

$ipaddress = getenv(HTTP_X_FORWARDED_FOR);

} else {

$ipaddress = getenv(REMOTE_ADDR);

}

$message = nl2br(strip_tags(nl2br($_POST["message"])));

if (isset($_POST['submitButton'])) {

if ($message != "") {

mysql_query("INSERT INTO ChatTest (ID, TimeStamp, Message) VALUES ('$ipaddress', NOW(), '$message')");

}

header('Location: chat.php');

}

$message = "";

$data = mysql_query("SELECT * FROM ChatTest ORDER BY TimeStamp DESC") or die(mysql_error());

$tbl = '';

$tbl .= "

";

$tbl .= "

";

$tbl .= "

ID:TimeStamp:Message:";

while($info = mysql_fetch_array( $data )) {

$tbl .= "

";

$tbl .= "

".$info['ID'] . " ";

$tbl .= "

".$info['TimeStamp'] . " ";

$tbl .= "

".$info['Message'] . "

";

}

$tbl .= "

";

mysql_close($cxn);

if (isset ($_GET['update']))

{

echo $tbl;

die ();

}

?>

Message:

Refresh Chat

$(document).ready (function () {

var updater = setTimeout (function () {

$('div#messages').load ('chat.php', 'update=true');

}, 1000);

});

至于编码技术,您可能希望研究SQL注入并编写更清晰的HTML,但我相信您会到达那里:)