Re: [PHP] Calling a stored procedure

I'm not sure if we're on the same page.

I have a stored procedure on my Informix server. All I am trying to do is
create a simple form that when submitted will pass several parameters to the
stored procedure and execute it.

I shouldn't have to pass the head/body/content to the Informix server to
execute the procedure, right?


On 11/30/07, Daniel Brown <parasane@xxxxxxxxx> wrote:

On Nov 30, 2007 1:39 PM, Dan Shirah <mrsquash2@xxxxxxxxx> wrote:
Hello all,

I am having soem difficulty when trying to call an INFORMIX stored
procedure
with PHP.

I have verified that the if() condition is true and all of the
parameters I
am passing are valid. However, when I run the following:

if ($num_rows > 0 && $barcode_id == "") {
echo "The query found ".$num_rows." row(s)";
$call_procedure = "CALL informix.updt_brcd_id_req('$case',
'$event_date',
'$event_sequence', '$event_code')";
$call_result = $connect_id->query($call_procedure);
}

I get this error message: PHP Fatal error: Call to a member function
query()
on a non-object

I have never tried to call a stored procedure in PHP before so I'm not
even
sure if I am on the right track.

Any help is greatly appreciated.

Dan


You have to first instantiate the class.

For example:

<?
include_once("classes/layout.class.php");
$H = new Head();
$B = new Body();
$P = new Page($H, $B);
$H->title("A Sample PHP Page");
$H->css("sample.css");
$B->content("This is where Dan Shirah's content would go.");
$P->render();
?>

--
Daniel P. Brown
[office] (570-) 587-7080 Ext. 272
[mobile] (570-) 766-8107

If at first you don't succeed, stick to what you know best so that you
can make enough money to pay someone else to do it for you.

Relevant Pages

  • Re: [PHP] Calling a stored procedure
    ... I have a stored procedure on my Informix server. ... can make enough money to pay someone else to do it for you. ... The thing to pay attention to is the instantiation. ...
    (php.general)
  • Re: korn shell executed using stored procedure....problem :(
    ... I have a korn shell script which executed using the "system" command in ... Everything works fine when I ran the stored procedure inside the ... in a sql editor (connected to the informix server using ODBC ... connection). ...
    (comp.databases.informix)
  • Re: [PHP] Calling a stored procedure
    ... I have a stored procedure on my Informix server. ... I get this error message: PHP Fatal error: Call to a member function ... You have to first instantiate the class. ...
    (php.general)
  • Re: [PHP] Calling a stored procedure
    ... I am having soem difficulty when trying to call an INFORMIX stored procedure ... I get this error message: PHP Fatal error: Call to a member function query ... You have to first instantiate the class. ...
    (php.general)
  • Re: korn shell executed using stored procedure....problem :(
    ... I have a korn shell script which executed using the "system" command in ... Everything works fine when I ran the stored procedure inside the ... in a sql editor (connected to the informix server using ODBC ... connection). ...
    (comp.databases.informix)