Trying to change <td bgcolor> when ajax posts new data - Page 2

matthewst · 03-22-2010, 08:02 PM

Okay, I wasn't as close as I thought. Js is still just echoing whatever php is outputting.

Code:

function handleJoblog() {
  if(httpjob.readyState == 4) {
    var response = httpjob.responseText;
	if(response=="Update! ") {
    document.getElementById('bar').innerHTML = response;
	document.getElementById('bar').style.color = "red"
	}
	if(response!="Update! ") {
    document.getElementById('bar').innerHTML = response;
	document.getElementById('bar').style.color = "yellow"
	}
  }
}

The above code outputs in yellow whether there is new data or not.

Here is the php:

Code:

$total_job_log_entries = ceil(mysql_num_rows(mysql_query("SELECT id FROM job_log WHERE id > '1'")));
if ($total_job_log_entries != $jle_old){
$response = "Update! ";
echo $response;
echo "Total number of job log entries: " . $total_job_log_entries . "<br>";
}else{
echo "Total number of job log entries: " . $total_job_log_entries . "<br>";
}

matthewst · 03-22-2010, 08:14 PM

I couldn't get this to work either.

Code:

  if(httpjob.readyState == 4) {
    var response = httpjob.responseText;
	if(newdata == yes) {
    document.getElementById('bar').innerHTML = response;
	document.getElementById('bar').style.color = "red"
	}
	if(response!="Update! ") {
    document.getElementById('bar').innerHTML = response;
	document.getElementById('bar').style.color = "yellow"
	}

Code:

$total_job_log_entries = ceil(mysql_num_rows(mysql_query("SELECT id FROM job_log WHERE id > '1'")));
if ($total_job_log_entries != $jle_old){
?>
<script type="text/javascript">
var newdata=yes;
</script>
<?php
//$response = "Update! ";
//echo $response;
echo $response . "Total number of job log entries: " . $total_job_log_entries . "<br>";
}else{
echo "Total number of job log entries: " . $total_job_log_entries . "<br>";
}
$HTTP_SESSION_VARS["jle_old"] = $total_job_log_entries;

tfit · 03-22-2010, 09:46 PM

Matthew you're completely screwing your code. that javascript line doesn't doesn't help much and still trying clientside evualation

.
where comes this newdata from?
Assuming the server returns update or noupdate. we can than return to the switch statement
switch(response) {
case update:
document.getElementById('bar').innerHTML = response;
document.getElementById('bar').style.color = "red"
break;
default :
document.getElementById('bar').innerHTML = response;
document.getElementById('bar').style.color = "yellow"
}
when done that you can return your whole string and do a substring search for noupdate

matthewst · 03-23-2010, 01:13 AM

That's the problem. PHP will output either "blah 123" or "Update! blah 124". Js is simply echoing what php is outputing. I don't want to include the word "Update".

If it were all php I would do this:

Code:

session_start();

//job log entries
$total_job_log_entries = '0';
$total_job_log_entries = ceil(mysql_num_rows(mysql_query("SELECT id FROM job_log WHERE id > '1'")));
if ($total_job_log_entries != $jle_old){
//new data
echo "<font color='red'>Total number of job log entries: " . $total_job_log_entries . "</font><br>";
}else{
//same old data
echo "<font color='yellow'>Total number of job log entries: " . $total_job_log_entries . "</font><br>";
}
$HTTP_SESSION_VARS["jle_old"] = $total_job_log_entries;
mysql_close();

All I need is a way to tell Js I have new data so I can make the background for that table cell flash or briefly change color or something.

matthewst · 03-23-2010, 02:07 AM

GOT IT!!!!!!
Added this function on the client side:

Code:

function blinkIt() {
 if (!document.all) return;
 else {
   for(i=0;i<document.all.tags('blink').length;i++){
      s=document.all.tags('blink')[i];
      s.style.visibility=(s.style.visibility=='visible')?'hidden':'visible';
   }
 }
}

And this on the server side:

Code:

if ($total_job_log_entries != $jle_old){
$response = "Update! ";
echo "<blink>Total number of job log entries: " . $total_job_log_entries . "</blink><br>";
}else{
echo "Total number of job log entries: " . $total_job_log_entries . "<br>";
}

tfit · 03-23-2010, 07:52 AM

Quote:

Originally Posted by matthewst

GOT IT!!!!!!
Added this function on the client side:

Code:

function blinkIt() {
 if (!document.all) return;
 else {
   for(i=0;i<document.all.tags('blink').length;i++){
      s=document.all.tags('blink')[i];
      s.style.visibility=(s.style.visibility=='visible')?'hidden':'visible';
   }
 }
}

And this on the server side:

Code:

if ($total_job_log_entries != $jle_old){
$response = "Update! ";
echo "<blink>Total number of job log entries: " . $total_job_log_entries . "</blink><br>";
}else{
echo "Total number of job log entries: " . $total_job_log_entries . "<br>";
}

you're introducing different viewpoints at times

, but i'm glad you got it working

matthewst · 03-23-2010, 01:07 PM

Yeah, I'm still learning Js. Thanks for the help.

How do I mark this resolved?

tfit · 03-23-2010, 01:34 PM

I have to search for that from time to time too

Anyway go to your first post, edit, advanced, title and there you can change status