note 101323 added to ref.pdo-dblib
| From: | xwisdom at gmail dot com | Date: | Thu, 09 Dec 2010 23:42:21 +0000 |
| Subject: | note 101323 added to ref.pdo-dblib | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-174759@lists.php.net to get a copy of this message | ||
Here's how to call a stored procedure from MS SQL Server:
$return = null;
$param1 = 'value1';
$param2 = 'value2';
$ds = $db->prepare('{? = call ?,?}');
$ds->bindParam(1, $return, PDO::PARAM_INT | PDO::PARAM_INPUT_OUTPUT,4);
$ds->bindParam(2, $param1, PDO::PARAM_INT | PDO::PARAM_INPUT_OUTPUT,4);
$ds->bindParam(3, $param2, PDO::PARAM_INT | PDO::PARAM_INPUT_OUTPUT,4);
$ds->execute();
I've created a class to handle this kind of request. You can see it here - http://raxanpdi.com/sdk/docs/database.html
----
Server IP: 190.15.66.25
Probable Submitter: 65.183.14.102
----
Manual Page -- http://www.php.net/manual/en/ref.pdo-dblib.php
Edit -- https://master.php.net/note/edit/101323
Del: integrated -- https://master.php.net/note/delete/101323/integrated
Del: useless -- https://master.php.net/note/delete/101323/useless
Del: bad code -- https://master.php.net/note/delete/101323/bad+code
Del: spam -- https://master.php.net/note/delete/101323/spam
Del: non-english -- https://master.php.net/note/delete/101323/non-english
Del: in docs -- https://master.php.net/note/delete/101323/in+docs
Del: other reasons-- https://master.php.net/note/delete/101323
Reject -- https://master.php.net/note/reject/101323
Search -- https://master.php.net/manage/user-notes.php