Stored procedures

Anon

Somebody, somewhere must know how to call stored procedures from PHP - preferably using MSSQL, buy MySQL would do. I have searched every forum I can find, and there is a resounding silence on the subject. Please help!!

gio2k

http://www.php.net/manual/en/function.mssql-query.php

Check the posts at the end of the documentation. It's not much, but I hope it helps you.

-Gio-

djg_uk

Hi John,

MySQL does not support stored procedures.

This discussion was covered a year or so ago (see http://www.phpbuilder.com/forum/read.php3?num=5&id=5384&loc=0&thread=5384) so it might be an idea to contact either of the users involved to see if they've had any success.

Regards,

David

Anon

Surely your just talking about something like

function foo()
{ print "hello"; }

stored in a field in a database that you can then exec at will.

you can store the code in a mysql text field. probably the same for mssql i dont know.

just insert like you would any other data.
then when you want the function - get the col data just like normal - then use the php command eval().
ull have to check the syntax in the manual.

ive done this loads of times with functions, classes and just regular code.
eval -ing this foo function would mean that then from your code you can run "foo();"

djg_uk

Hi Dunk,

A stored procedure is a database term for a series of SQL commands executed when a certain event is triggered, such as a delete query.

Regards,

David

Anon

oops 🙂

Anon

execute a query ...

using ODBC :

$conn = odbc_connect(bla,ba,ba,2);

$query "exec stp_name'parameter','parameter')";

$values = odbc_exec($conn,$query);

simple

gio2k

No. That's a trigger.
A stored procedure is a sequence of logical SQL statements that are stored in the DBMS.
This way the user doesn't have to execute all the SQL statements one by one.
It also has some other advantages, such as server optimization (for speed).

-Gio-