How to execute a stored procedure in php using sqlsrv and “?” style parameters

by

The user contributions on the php.net have a write up on how to execute a stored procedure using the sqlsrv-prepare.

In case that is removed from the php.net user contributions in the future here is what it had(has) listed:

$procedure_params = array(
array(&$myparams['Item_ID'], SQLSRV_PARAM_OUT),
array(&$myparams['Item_Name'], SQLSRV_PARAM_OUT)
);
// EXEC the procedure, {call stp_Create_Item (@Item_ID = ?, @Item_Name = ?)} seems to fail with various errors in my experiments
$sql = "EXEC stp_Create_Item @Item_ID = ?, @Item_Name = ?";
$stmt = sqlsrv_prepare($conn, $sql, $procedure_params);

Here’s the manual’s page, http://php.net/manual/en/function.sqlsrv-prepare.php

More Related Contents:

  1. Get Return Value from SQL Stored Procedure using PHP
  2. to delete 14 row by 1 click
  3. Using PHP data in MySQL [closed]
  4. Checking the availability of rooms
  5. PHP Parse Error – Creating a PHP script to verify user and pass [duplicate]
  6. How to properly set up a PDO connection
  7. Commands out of sync; you can’t run this command now
  8. Best way to get result count before LIMIT was applied
  9. Get table column names in MySQL?
  10. How to resolve ambiguous column names when retrieving results?
  11. Loading .sql files from within PHP
  12. How to insert multiple rows from a single query using eloquent/fluent
  13. Best way to defend against mysql injection and cross site scripting
  14. Use bound parameter multiple times
  15. Retrieving Multiple Result sets with stored procedure in php/mysqli
  16. MySQL “NOT IN” query 3 tables
  17. PHP: multiple SQL queries in one mysql_query statement
  18. SQLSTATE[42S22]: Column not found: 1054 Unknown column – Laravel
  19. How to connect sql server with php using xampp?
  20. Calling stored procedure with Out parameter using PDO
  21. Laravel Eloquent, group by month/year
  22. Why does this return Resource id #2? [duplicate]
  23. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  24. How to generate unique id in MySQL?
  25. Pass array literal to PostgreSQL function
  26. How to SELECT DEFAULT value of a field
  27. SQL & PHP – Which is faster mysql_num_rows() or ‘select count()’?
  28. looping a SQL insert statement with dates
  29. Display an array in a readable/hierarchical format [duplicate]
  30. UNION syntax in Cakephp

Leave a Comment