Re: [PHP] Calling a stored procedure

On Nov 30, 2007 1:56 PM, Dan Shirah <mrsquash2@xxxxxxxxx> wrote:
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.




No, not at all. I just included that as dummy data to illustrate
the point. The thing to pay attention to is the instantiation. For
your case, it should probably look something like this:

<?
$connect_id = new Informix();
?>

Well, something of the like, anyway.

--
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

  • Error using money datatype parameter and DBNull.
    ... I am getting an error executing a SQL Server stored procedure with parameters of type ... .Parameters.AddWithValue(PRM_ActualCost, mActualCost) ... in the table is defined as a nullable column of type money. ... "Implicit conversion from datatype nvarchar to money is not allowed. ...
    (microsoft.public.dotnet.framework.adonet)
  • 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: 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)
  • Post to HTTP With paramerters
    ... In a SQL table, I have a field that when it drops to below 5, i want ... to automatically run a Stored Procedure that then connects to a URL ... there is a field called Money. ... Any help/guidence appriciated as i am really lost on where to start! ...
    (microsoft.public.sqlserver)
  • 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)