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.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
