如何在数据库中插入新值时获得通知 - How to get notification when insert new value in db?

How to get notification when insert new value in db?

嗨，我在php的数据库中插入值，我希望当我在数据库中插入数值时，我的div颜色应该更改

insert.php

include('conn.php');
if(! $conn )
{
  die('Could not connect: ' . mysql_error());
}
$id=2;
//$sql="insert into messages (message,number,service) values ('dd',".$urlstring.",'ds')";
$sql = 'INSERT INTO messages '.
       '(message,number,service) '.
       'VALUES ( "'.$message.'", "'.$urlstring.'", "'.$service.'" )';
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
  die('Could not enter data: ' . mysql_error());
}
echo ("Records  affcted: ". mysql_affected_rows());
//echo "Entered data successfully'n";
mysql_close($conn);

index.php

<div id="div1" style="height=200px;width=300px;">
</div>

这里我想当insert.php执行时，div部分应该在另一个文件中更改颜色

我怎样才能实现这个

如有任何帮助，将不胜感激

您可以在javascript上使用定时器，并创建一个ajax函数来检索数据库中所有插入的数据。

试试这个：

include('conn.php');
if(! $conn )
{
  die('Could not connect: ' . mysql_error());
}
$id=2;
//$sql="insert into messages (message,number,service) values ('dd',".$urlstring.",'ds')";
$sql = 'INSERT INTO messages '.
       '(message,number,service) '.
       'VALUES ( "'.$message.'", "'.$urlstring.'", "'.$service.'" )';
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
  die('Could not enter data: ' . mysql_error());
}
echo ("Records  affcted: ". mysql_affected_rows());
//echo "Entered data successfully'n";
?>
<style>
#div1{
backgroud-color="yourcolor";
}
</style>
<?php
mysql_close($conn);

啊，我明白了。

也许这可以帮助你：http://www.barelyfitz.com/projects/csscolor/?