[FX.php List] testing connection to database

[Alex Gates]

Andrew-

Good call!  You're right - it just returns the FX_Error Object - 

Your code does exactly what I needed.

If the returned result is not an array, I check for "email sent" session
variable send myself an email and sms to my phone if "email sent" !=1.
After the emails are sent, I set "email sent" to 1.  That way, even if
they try over and over again, it will only send one email and sms.
(assuming they don't close their browser).

Of course, if a hundred people try it and have problems, I'll get a
hundred emails and sms messages - but by that time I hope to have the
problem resolved!  

Thanks for your help!

Alex 
 

-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Andrew Denman
Sent: Thursday, March 29, 2007 9:36 AM
To: 'FX.php Discussion List'
Subject: RE: [FX.php List] testing connection to database

As far as I can tell, when FX.php fails (ie: no connection to the
database)
it does not return an array; it returns an FX_Error object with debug
information.  This is what I use to check if a command has gone through
successfully:

if(!is_array($ReturnData) || $ReturnData['errorCode'] != 0) {
//error message
}

Andrew Denman

-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Alex Gates
Sent: Thursday, March 29, 2007 9:11 AM
To: 'FX.php Discussion List'
Subject: RE: [FX.php List] testing connection to database

Thanks, ggt - 
I changed it to

$testfindResult=$testfind->FMView();

but I still get the error: Cannot use object of type FX_Error as
array... error instead of an error code.

I can, however, see how using FMView() would lighten the load compared
to FMFindAny

Alex 


-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Gjermund
Gusland Thorsen
Sent: Thursday, March 29, 2007 9:00 AM
To: FX.php Discussion List
Subject: Re: [FX.php List] testing connection to database

FMView()

On 3/29/07, Alex Gates <alex at gandrpublishing.com> wrote:
> Hi everyone-
>
> What methods are you using to test the connection to the database?
>
>
> I'm trying this:
>
>
> include_once('FX/FX.php');
> include_once('FX/server_data.php');
> include_once('FX/FX_Error.php');
>
>
> $testfind=new FX($serverIP, $webCompanionPort, 'FMPro7');
> $testfind->SetDBData('filename.fp7','layoutname');
> $testfind->SetDBPassword('xxxxx','xxxxx');
> $testfindResult=$testfind->FMFindany();
> echo $testfindResult['errorCode'];
>
>
>
> We had our FileMaker server go down this morning and I realized that I
> didn't have any tests to the server.
>
> I'd ultimately like to say
> if($testfindResult['errorCode'] != 0) {
>
> Send email to my mobile phone because there is a critical problem with
> the server.
>
> }
>
>
> But instead of getting an error code, I get:
>
> Fatal error: Cannot use object of type FX_Error as array...
>
> Am I missing something simple?
>
> Alex
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
_______________________________________________
FX.php_List mailing list
FX.php_List at mail.iviking.org
http://www.iviking.org/mailman/listinfo/fx.php_list




_______________________________________________
FX.php_List mailing list
FX.php_List at mail.iviking.org
http://www.iviking.org/mailman/listinfo/fx.php_list

_______________________________________________
FX.php_List mailing list
FX.php_List at mail.iviking.org
http://www.iviking.org/mailman/listinfo/fx.php_list