Call a SQL Server stored proc with parameters in PHP

Question

Based on this :

how to execute sql server stored procedure on php?

Tried the following :

$odbc = odbc_connect($DB1_ODBC,$DB1_USER,$DB1_PWD);  // proven to be fully functionnal
$result = odbc_exec($odbc,"CALL importClient( @name = 'hello',@number = 457)");

It does not call the stored procedure, i can't see any error code.

I replaced "CALL by "EXEC but it's not working in either cases.

Otherwise, the stored procedure can be run by using the same credentials to connect to the database, and using this SQL statement :

EXECUTE [dbo].[importClient] @name = 'hello',@number = 457

I couldn't find anything helpful, neither think of another way, and I definitely need the parameters.

Joshua Jones · Accepted Answer · 2017-07-04 18:51:34Z

1

$stmt = odbc_prepare($odbc, "call dbo.importClient(?, ?)");
odbc_execute($stmt, ["hello", 457]);

Using a prepared statement will protect your code from SQL injection attacks. Use this when you replace your literal values with variables containing user input.

edited Jul 4, 2017 at 18:51

answered Jul 4, 2017 at 16:17

Joshua Jones

1,4261 gold badge11 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Antoine Pelletier Over a year ago

Error code is the following : odbc_execute(): SQL error: [Microsoft][ODBC SQL Server Driver]Invalid parameter number

Antoine Pelletier · Accepted Answer · 2017-07-04 17:48:27Z

0

It finally worked with :

$result = odbc_exec($odbc,"EXECUTE importClient @name = 'hello', @number = 457");

But this isn't protected against SQL injections, so it might not be the best answer

answered Jul 4, 2017 at 17:48

Antoine Pelletier

3,3354 gold badges43 silver badges70 bronze badges

Collectives™ on Stack Overflow

Call a SQL Server stored proc with parameters in PHP

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related