Use Of Buffer In This Code?

[phplearner]

Can anyone please explain the use of '$Buffer' in this following code and the use of 'global $tbl_ads;' ... and if this will work in a PHP4.2 'register_globals off' environment?

Thank you.

=====================
function update_ads ($data) {
global $tbl_ads;

$buffer=mysql_query("SELECT DATE_ADD(current_date(), INTERVAL ".$data[duration]." DAY)") or die("update_ads".mysql_error());
$enddate=mysql_result($buffer, 0);
$query ="UPDATE $tbl_ads SET ";
$query.="category=$data[category], name='$data[name]',
email='$data[email]', homepage='$data[homepage]', ";
$query.="phone='$data[phone]', showphone='$data[showphone]', city='$data[city]', ";
$query.="subject='$data[subject]', message='$data[message]',
enddate='$enddate', duration=$data[duration], modifydate=NOW('') ";
$query.="WHERE ads_id=$data[ads_id]";
$hasil=mysql_query($query) or die("gagal update");
return $data[ads_id];
}

[cahva]

That $buffer is used to get th end-date for something.

You can remove that 'global $tbl_ads;' because $tbl_ads is not even used in the function.

And yes, that function will work with globals turned off.

[ramsy]

Originally posted by cahva
That $buffer is used to get th end-date for something.

You can remove that 'global $tbl_ads;' because $tbl_ads is not even used in the function.

And yes, that function will work with globals turned off.

$tbl_ads is used in the next query. It's strange though that it is not given a value. :eek:

[phplearner]

Thank you, cavha & ramsy. I'll keep studying this stuff.

[cahva]

Originally posted by ramsy
$tbl_ads is used in the next query. It's strange though that it is not given a value. :eek:

I must have been blind. 🙂 Its there allright! It propably takes the value from a config file or something.