Get content from a table and refresh div content every 5 seconds

You've got a lot of questions here!  

First, you will want a jQuery timer.
http://code.google.com/p/jquery-timer/

Then you will want to make some kind of communication with the background PHP script.  This is usually done with jQuery AJAX.  A "hello world" example is available in this article:
https://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Jquery/A_10712-The-Hello-World-Exercise-with-jQuery-and-PHP.html

You will need to write some kind of MySQLi or PDO query to get information from the SQL data base.  These functions are documented on the PHP.net web site.
http://www.php.net/manual/en/mysqli.query.php

You can use CSS to style the div.  Your background script can send the CSS styling when it sends the content.  The return value would look something like this...

<span style="color:green;">yes</span>

hello again :0)

add this function to your mysql.php file:

function get_data_from_db(){

$con = mysql_connect("localhost","username","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("database", $con);
$result = mysql_query("SELECT * FROM YourTable");
$array =  mysql_fetch_array($result);

echo json_encode($array);

mysql_close($con);
}

Select allOpen in new window

add this code to javascript section, to run the php function every 5 seconds, and upon success color the div with text = Yes

setInterval(function(){
$.ajax({
			url: 'mysql.php',
			type: 'post',
			data: 'action=get_data_from_db',
			success: function(data) 
			{
                  $.each(data, function(i,record){    
                      var id = record.IDcheck;
                      var val = record.Value;
$("#id").text(val);
$('#id').css('background-color',val == "yes"?'green':'white');
                  });
			}, error: function()
			{
			alert('error');
			}
		});

}, 5000);

Select allOpen in new window

Hi sedgwick!

When I insert the JQuery code in my page and run it I get an alert with error!

Thank you!

change the php function to this:

function get_data_from_db(){

$con = mysql_connect("localhost","username","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("database", $con);
$result = mysql_query("SELECT * FROM YourTable");
$array =  mysql_fetch_array($result);
mysql_close($con);

echo json_encode($array);

}

Select allOpen in new window

make sure to change to table name in the select query

Hi sedgwick,

I change the function but it still dosen't work!
Can you please take a look at the attached files!

Thank you very much!
testme.zip

try first without the interval code just to make sure the whole flow is working properly.
upon success i loop the records from DB, extract the id of each div and apply color according to the value.
i might got this loop wrong cause i don't know how the json will return from the mysq.php.
so paste here the data returned in he success handler in case it's not working.

I get an error: IDcheck is null or not an object (var id = record.IDcheck;)

Thank you!

ok, so please put break point on this line:
$.each(data, function(i,record){  

and post the properties of record, i might got the name wrong.

The "print json_encode($array)" is printing:
{"0":"IP216","IDcheck":"IP216","1":"yes","Value":"yes"}

I do not know how to put break point but i tryed to use alert for i and record. For i i got the value 0 and for record i got "undefined"!

Thank you!