|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
MDB2 Stored Proc
Could someone please explain how to use executeStoredProc for mysql to get the OUT parameters of a stored procedure?
|
|
#2
|
||||
|
||||
|
RE: MDB2 Stored Proc
your OUT params should be going into a user variable (@var). then you can select that var to find out what it says.
|
|
#3
|
|||
|
|||
|
RE: MDB2 Stored Proc
But how can I select it?
Let's say I have a simple SP getNameByID (IN id INT, OUT Name TINYTEXT) I do like this: executeStoredProc ('getNameByID', array('1','@name')) But How can I get @name now using PHP? And the other question is whay is the difference between $result_class and $result_wrap_class (two other parameters in ExecuteStoredProc())? Thanks |
|
#4
|
||||
|
||||
|
RE: MDB2 Stored Proc
I don't know MDB - I know mysql stored procedures in which case you would do a simple select of @name.
SELECT @name |
|
#5
|
|||
|
|||
|
RE: MDB2 Stored Proc
Thanks. I know how to get it in MySQL, but I need to know how to do it in MDB2.
|
|
#6
|
|||
|
|||
|
RE: MDB2 Stored Proc
I m doing this:
$mysqli=mysqli_query($link, "call('1','@name')"); $name=mysql_query("select @name"); after display $name= resourceId#4 $name1=mysql_fetch_array($name); $name1 displays Array. Is this code correct? I need to get the value in @name in $name. how to do it? please help |
|
#7
|
||||
|
||||
|
RE: MDB2 Stored Proc
you are crossing you extensions - using mysqli and mysql
|
![]() |
| Viewing: Codewalkers Forums > PHP Related > PEAR Packages > MDB2 Stored Proc |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|