Re: [PHP] Calling a stored procedure

I tried a different approach with the code below:

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 = ifx_query($connect_id, $call_procedure);
}

And I get the error: PHP Warning: ifx_query(): supplied argument is not a
valid Informix link resource

I don't know if this is a step in the right direction or not.


On 11/30/07, 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.



Relevant Pages

  • RE: Executing Informix dbaccess in a Windows background environment
    ... The first question that comes to mind is why do this from a stored procedure? ... I'm going to assume that the PC has the Informix engine local to it. ... If the Informix engine is not on the windows environment, ... If you're going to use any of these languages, you would best build some sort of framework that you can re-use for your scripts. ...
    (comp.databases.informix)
  • AW: Error -710 from stored procedure
    ... The problem originally comes from a fact, that Informix doesn't ... when the query plan for a stored procedure should ... Each table in the database has it's version stored in 'systables'. ... low' in a session execution the SQL sometimes ...
    (comp.databases.informix)
  • Re: Possible Feature
    ... What does the Query Plan look like? ... recreate the Stored Procedure or Function with the changed ... Paul Watson escreveu: ... > GET THERE FASTER with Informix. ...
    (comp.databases.informix)
  • Re: Stored Procedure Problem
    ... This trigger then calls a stored procedure. ... below but this still gives the 668 informix error. ... User root should not be involved in the ... user informix should be used to administer ...
    (comp.databases.informix)
  • Re: korn shell executed using stored procedure....problem :(
    ... a stored procedure always runs inside the server. ... You cannot run a stored procedure in an sql editor ... IBM Informix Development Munich, Germany ... 2006 at the IBM Forum Frankfurt ...
    (comp.databases.informix)