Notifikasi

[NOTIFIKASI JIKA DATA MASUK KE TABLE]
MYSQL (Buat Dulu DB ['counter'])
-----------------
DROP TABLE IF EXISTS `konter1`;
CREATE TABLE `konter1` (
  `member_id` varchar(20) DEFAULT NULL,
  `ip` varchar(20) DEFAULT NULL,
  `total_unik` varchar(20) DEFAULT NULL,
  `tanggal` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*---------------------------------*/
periksa-tabel.php
/*--------------------------------*/
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.0/jquery.min.js"></script>
<?php
function get_random_string($valid_chars, $length)
{
    $random_string = "";
    $num_valid_chars = strlen($valid_chars);
    for ($i = 0; $i < $length; $i++)
    {
        $random_pick = mt_rand(1, $num_valid_chars);
        $random_char = $valid_chars[$random_pick-1];
        $random_string .= $random_char;
    }
    return $random_string;
}
$original_string = 'abcdefghijklmnopqrstuvwxyz';
$random_string = get_random_string($original_string, 6);

$host = "localhost";
$user = "root";
$pass = "";
$db = "counter";

$ip  = $_SERVER['REMOTE_ADDR'];
$tanggal = date("Y-m-d");

$konek = mysql_connect ($host, $user, $pass);
if ($konek) {
    $isi = mysql_select_db ($db);
    if (!$isi) {
        die ("Teu aya Database-an");
    }
} else {
    die ("Teu Konak Mysql");
}

$cek_id=mysql_num_rows(mysql_query ("SELECT member_id FROM konter1 WHERE member_id='$random_string' "));
if ($cek_id > 0){
    echo "AYA NU SARUA!!!!";
}
else{
  $asup = "INSERT INTO konter1(member_id,  ip, total_unik,tanggal) VALUES ('$random_string','$ip', 1,'$tanggal')";
  $asupTOKEN=mysql_query($asup);
  ?>
 <script type="text/javascript">
$("#sound").remove();
var sound = $("<embed id='sound' type='audio/mpeg' />");
sound.attr('src', 'notify.mp3');
sound.attr('loop', false);
sound.attr('hidden', true);
sound.attr('autostart', true);
$('body').append(sound);
</script>
<?php
}
?>

/*---------------------*/
load.php
/*------------------------*/
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<style>
body{font-size:12px;background-color:#eee;font-family:Arial, Helvetica, sans-serif}
table.gridtable{color:#333;border-collapse:collapse;border-color:#666;border-width:1px}
table.gridtable th{background-color:#dedede;border-color:#666;border-style:solid;border-width:1px;padding:8px}
table.gridtable td{background-color:#fff;border-color:#666;border-style:solid;border-width:1px;padding:8px}
</style>
<!--<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.0/jquery.min.js"></script>-->
<script type="text/javascript" src="jquery.min.js"></script>
</head>
<script type="text/javascript">
        var auto_refresh = setInterval(
        function ()
        {
        $('#load_content').load('periksa-table.php').fadeIn("slow");
        }, 10000);
</script>
<body>

<div id="load_content"> </div>
<?php
$host = "localhost";
$user = "root";
$pass = "";
$db = "counter";
$ip  = $_SERVER['REMOTE_ADDR'];
$tanggal = date("Y-m-d");

$konek = mysql_connect ($host, $user, $pass);
if ($konek) {
    $isi = mysql_select_db ($db);
    if (!$isi) {
        die ("Teu aya Database-an");
    }
} else {
    die ("Teu Konak Mysql");
}
$result22 = mysql_query("SELECT member_id FROM konter1");
$num_rows2 = mysql_num_rows($result22);

$result = mysql_query("SELECT * FROM konter1")
or die(mysql_error());

echo "<table style='background: #fff;' border='0' cellpadding='0' cellspacing='1px' class='gridtable'>";
echo "<tr> <th>MEMBER ID</th> <th>IP ADDRESS</th> </tr>";
while($row = mysql_fetch_array( $result )) {
    echo "<tr><td>";
    echo $row['member_id'];
    echo "</td><td>";
    echo $row['ip'];
    echo "</td></tr>";
}
echo "</table>";
?>

</body>
</html>