mysql_fetch_array replacement?

Robert Williams

5 Jul 2015 5 Jul '15

2:51 p.m.

Hi,

After the SVN up on the 18th July the script we use for generating the Smokeping targets stopped producing any data (the list of slightly reformatted hostnames). The script itself was taken from this mailing list about 2 years ago and is as follows:

#!/usr/bin/env php <?php

include("/opt/observium/includes/defaults.inc.php"); include("/opt/observium/config.php"); include("/opt/observium/includes/definitions.inc.php"); include("/opt/observium/includes/functions.php");

echo "*** Targets ***\n\nprobe = FPing\n\nmenu = Top\ntitle = Network Latency Grapher\nremark = Welcome to SmokePing\n\n";

$query = mysql_query("SELECT hostname FROM `devices` WHERE `disabled`=0 ORDER BY hostname");

while ($data = mysql_fetch_array($query)) { $hostid = str_replace(".","_",$data['hostname']); $hostname = $data['hostname']; echo "+ $hostid\n\nhost = $hostname\n\n"; }

I can see that /includes/functions.php no longer exists but it’s replacement in functions.inc.php does not appear to have a function for mysql_fetch_array().

So my question is, can someone point me to the correct replacement function for this? I’ve had a look through it and can’t see what I’m looking for, but PHP is not my ‘thing’ so I’m missing it.

Any assistance appreciated!

Robert Williams Custodian Data Centre Email: Robert@CustodianDC.com http://www.CustodianDC.com

Attachments:

attachment.html (text/html — 6.5 KB)

Show replies by date

Adam Armstrong

5 Jul 5 Jul

7:40 p.m.

mysql_fetch_array is part of PHP :)

We did switch some functions related to database access, but those were our own. try using dbFetchRows() instead of mysql_fetch_array()!

adam.

Sent from Mailbird [http://www.getmailbird.com/?utm_source=Mailbird&utm_medium=email&utm...] On 05/07/2015 18:19:48, Robert Williams robert@custodiandc.com wrote: Hi, After the SVN up on the 18th July the script we use for generating the Smokeping targets stopped producing any data (the list of slightly reformatted hostnames). The script itself was taken from this mailing list about 2 years ago and is as follows: #!/usr/bin/env php <?php include("/opt/observium/includes/defaults.inc.php"); include("/opt/observium/config.php"); include("/opt/observium/includes/definitions.inc.php"); include("/opt/observium/includes/functions.php"); echo "*** Targets ***\n\nprobe = FPing\n\nmenu = Top\ntitle = Network Latency Grapher\nremark = Welcome to SmokePing\n\n"; $query = mysql_query("SELECT hostname FROM `devices` WHERE `disabled`=0 ORDER BY hostname"); while ($data = mysql_fetch_array($query)) { $hostid = str_replace(".","_",$data['hostname']); $hostname = $data['hostname']; echo "+ $hostid\n\nhost = $hostname\n\n"; } ?> I can see that /includes/functions.php no longer exists but it’s replacement in functions.inc.php does not appear to have a function for mysql_fetch_array(). So my question is, can someone point me to the correct replacement function for this? I’ve had a look through it and can’t see what I’m looking for, but PHP is not my ‘thing’ so I’m missing it. Any assistance appreciated! Robert Williams Custodian Data Centre Email: Robert@CustodianDC.com http://www.CustodianDC.com

Phillip Baker

7:41 p.m.

mysql_fetch_array is a built in function to php. However, if you’ve switched your Observium to using mysqli instead of the deprecated mysql library, you’ll probably want mysqli_fetch_array

From: observium [mailto:observium-bounces@observium.org] On Behalf Of Robert Williams Sent: 05 July 2015 13:51 To: Observium Network Observation System (observium@observium.org) Subject: [Observium] mysql_fetch_array replacement?

Hi,

#!/usr/bin/env php <?php

include("/opt/observium/includes/defaults.inc.php"); include("/opt/observium/config.php"); include("/opt/observium/includes/definitions.inc.php"); include("/opt/observium/includes/functions.php");

echo "*** Targets ***\n\nprobe = FPing\n\nmenu = Top\ntitle = Network Latency Grapher\nremark = Welcome to SmokePing\n\n";

$query = mysql_query("SELECT hostname FROM `devices` WHERE `disabled`=0 ORDER BY hostname");

while ($data = mysql_fetch_array($query)) { $hostid = str_replace(".","_",$data['hostname']); $hostname = $data['hostname']; echo "+ $hostid\n\nhost = $hostname\n\n"; }

I can see that /includes/functions.php no longer exists but it’s replacement in functions.inc.php does not appear to have a function for mysql_fetch_array().

Any assistance appreciated!

Robert Williams Custodian Data Centre Email: Robert@CustodianDC.com http://www.CustodianDC.com

Mike Stupalov

7:41 p.m.

If I correctly understand what you do, than:

foreach(dbFetchRows("SELECT hostname FROM `devices` WHERE `disabled`=0 ORDER BY hostname") as $data) {

$hostid = str_replace(".","_",$data['hostname']);

$hostname = $data['hostname']; echo "+ $hostid\n\nhost = $hostname\n\n"; }

On Sun, Jul 5, 2015 at 3:51 PM, Robert Williams Robert@custodiandc.com wrote:

...

Hi,

After the SVN up on the 18th July the script we use for generating the Smokeping targets stopped producing any data (the list of slightly reformatted hostnames). The script itself was taken from this mailing list about 2 years ago and is as follows:

#!/usr/bin/env php

<?php include("/opt/observium/includes/defaults.inc.php"); include("/opt/observium/config.php"); include("/opt/observium/includes/definitions.inc.php"); include("/opt/observium/includes/functions.php"); echo "*** Targets ***\n\nprobe = FPing\n\nmenu = Top\ntitle = Network Latency Grapher\nremark = Welcome to SmokePing\n\n"; $query = mysql_query("SELECT hostname FROM `devices` WHERE `disabled`=0 ORDER BY hostname"); while ($data = mysql_fetch_array($query)) { $hostid = str_replace(".","_",$data['hostname']); $hostname = $data['hostname']; echo "+ $hostid\n\nhost = $hostname\n\n"; } ?>

I can see that /includes/functions.php no longer exists but it’s replacement in functions.inc.php does not appear to have a function for mysql_fetch_array().

So my question is, can someone point me to the correct replacement function for this? I’ve had a look through it and can’t see what I’m looking for, but PHP is not my ‘thing’ so I’m missing it.

Any assistance appreciated!

Robert Williams Custodian Data Centre Email: Robert@CustodianDC.com http://www.CustodianDC.com

observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

-- Mike Stupalov http://observium.org/

Phillip Baker

7:42 p.m.

In fact, I’d be surprised if mysql_query is working if you’ve switched Observium to mysqli. What’s the actual error output of the script when you run it?

Phil

Hi,

#!/usr/bin/env php <?php

include("/opt/observium/includes/defaults.inc.php"); include("/opt/observium/config.php"); include("/opt/observium/includes/definitions.inc.php"); include("/opt/observium/includes/functions.php");

echo "*** Targets ***\n\nprobe = FPing\n\nmenu = Top\ntitle = Network Latency Grapher\nremark = Welcome to SmokePing\n\n";

$query = mysql_query("SELECT hostname FROM `devices` WHERE `disabled`=0 ORDER BY hostname");

while ($data = mysql_fetch_array($query)) { $hostid = str_replace(".","_",$data['hostname']); $hostname = $data['hostname']; echo "+ $hostid\n\nhost = $hostname\n\n"; }

I can see that /includes/functions.php no longer exists but it’s replacement in functions.inc.php does not appear to have a function for mysql_fetch_array().

Any assistance appreciated!

Robert Williams Custodian Data Centre Email: Robert@CustodianDC.commailto:Robert@CustodianDC.com http://www.CustodianDC.com

Adam Armstrong

7:53 p.m.

I expect he's now using mysqli_* via the config option, which means mysql_* is no longer connected to a database :)

adam.

Sent from Mailbird [http://www.getmailbird.com/?utm_source=Mailbird&utm_medium=email&utm...] On 05/07/2015 18:43:14, Phillip Baker phil@lchost.co.uk wrote: In fact, I’d be surprised if mysql_query is working if you’ve switched Observium to mysqli. What’s the actual error output of the script when you run it? Phil From: observium [mailto:observium-bounces@observium.org] On Behalf Of Robert Williams Sent: 05 July 2015 13:51 To: Observium Network Observation System (observium@observium.org) Subject: [Observium] mysql_fetch_array replacement? Hi, After the SVN up on the 18th July the script we use for generating the Smokeping targets stopped producing any data (the list of slightly reformatted hostnames). The script itself was taken from this mailing list about 2 years ago and is as follows: #!/usr/bin/env php <?php include("/opt/observium/includes/defaults.inc.php"); include("/opt/observium/config.php"); include("/opt/observium/includes/definitions.inc.php"); include("/opt/observium/includes/functions.php"); echo "*** Targets ***\n\nprobe = FPing\n\nmenu = Top\ntitle = Network Latency Grapher\nremark = Welcome to SmokePing\n\n"; $query = mysql_query("SELECT hostname FROM `devices` WHERE `disabled`=0 ORDER BY hostname"); while ($data = mysql_fetch_array($query)) { $hostid = str_replace(".","_",$data['hostname']); $hostname = $data['hostname']; echo "+ $hostid\n\nhost = $hostname\n\n"; } ?> I can see that /includes/functions.php no longer exists but it’s replacement in functions.inc.php does not appear to have a function for mysql_fetch_array(). So my question is, can someone point me to the correct replacement function for this? I’ve had a look through it and can’t see what I’m looking for, but PHP is not my ‘thing’ so I’m missing it. Any assistance appreciated! Robert Williams Custodian Data Centre Email: Robert@CustodianDC.com [mailto:Robert@CustodianDC.com] http://www.CustodianDC.com [http://www.CustodianDC.com]

Robert Williams

6 Jul 6 Jul

1:50 p.m.

Thanks guys, didn’t realise it was a php function ☺

Interestingly there were no errors at all, just a zero output from the function, which didn’t help!

Anyway, the solution was indeed from the example given on here:

foreach(dbFetchRows("SELECT hostname FROM `devices` WHERE `disabled`=0 ORDER BY hostname") as $data)

(Then the rest of the original code)

So cheers for that!

Robert Williams Custodian Data Centre Email: Robert@CustodianDC.com http://www.CustodianDC.com From: observium [mailto:observium-bounces@observium.org] On Behalf Of Adam Armstrong Sent: 05 July 2015 18:54 To: observium@observium.org Subject: Re: [Observium] mysql_fetch_array replacement?

I expect he's now using mysqli_* via the config option, which means mysql_* is no longer connected to a database :)

adam.

Sent from Mailbirdhttp://www.getmailbird.com/?utm_source=Mailbird&utm_medium=email&utm_campaign=sent-from-mailbird

On 05/07/2015 18:43:14, Phillip Baker phil@lchost.co.uk wrote: In fact, I’d be surprised if mysql_query is working if you’ve switched Observium to mysqli. What’s the actual error output of the script when you run it?

Phil

Hi,

#!/usr/bin/env php <?php

include("/opt/observium/includes/defaults.inc.php"); include("/opt/observium/config.php"); include("/opt/observium/includes/definitions.inc.php"); include("/opt/observium/includes/functions.php");

echo "*** Targets ***\n\nprobe = FPing\n\nmenu = Top\ntitle = Network Latency Grapher\nremark = Welcome to SmokePing\n\n";

$query = mysql_query("SELECT hostname FROM `devices` WHERE `disabled`=0 ORDER BY hostname");

while ($data = mysql_fetch_array($query)) { $hostid = str_replace(".","_",$data['hostname']); $hostname = $data['hostname']; echo "+ $hostid\n\nhost = $hostname\n\n"; }

I can see that /includes/functions.php no longer exists but it’s replacement in functions.inc.php does not appear to have a function for mysql_fetch_array().

Any assistance appreciated!

Robert Williams Custodian Data Centre Email: Robert@CustodianDC.commailto:Robert@CustodianDC.com http://www.CustodianDC.com

3503

Age (days ago)

3504

Last active (days ago)

List overview

Download

6 comments

4 participants

tags (0)

participants (4)

Adam Armstrong
Mike Stupalov
Phillip Baker
Robert Williams