How to call a MS SQL Server stored-procedure from PHP?

[rinal86]

hi i'm rizki. can you all help me? please

i have a problem with script php to call procedure using sql server database this is the store procedure in sql server:

CREATE Procedure dbo.q_putaka
 (
  @key varchar(200),
  @scope varchar(4) = null
 
 )
As
 if @scope ='1' 
  execute ('select distinct author_name,book_id,remark,availability,title  from v_pustaka where  '+@key +' and DOC_TYPE IN (SELECT NM_TYPE FROM TAKA.R_TYPEDOC WHERE CONVERT(INT,KD_TYPE) <=3 AND CONVERT(INT,KD_TYPE)>=1) ')
 
 else
  if @scope='2'
   execute ('select distinct author_name,book_id,remark,availability,title  from v_pustaka where  '+@key +' and DOC_TYPE IN (SELECT NM_TYPE FROM TAKA.R_TYPEDOC WHERE CONVERT(INT,KD_TYPE) <=6 AND CONVERT(INT,KD_TYPE)>=4) ')
 else
 if @scope='12'
  execute ('select distinct author_name,book_id,remark,availability,title  from v_pustaka where  '+@key +' and DOC_TYPE IN (SELECT NM_TYPE FROM TAKA.R_TYPEDOC) ')
 
 else
  if @scope='123'
   execute ('select distinct author_name, book_id,remark,availability,title  from v_pustaka where  '+@key +' and DOC_TYPE IN (SELECT NM_TYPE FROM TAKA.R_TYPEDOC )  union select convert(varchar,0),book_id,remark,availability,title from v_magazine where '+@key)
   else
      select distinct author_name, book_id,remark,availability,title  from v_pustaka 
 
GO
 

n the problem is how to make the script php to call that store procedure?please help me n can you all tell me step by step cause i'm not familiar with script php using sql server database. thanks

[nathj]

Have a look at this:
http://dev.mysql.com/doc/refman/5.0/en/call.html

Personally I stay away from SP's as experience shows me that merging business layer and data layer causes problems further down the line. I would always keep code and data separate.

Have you thought about PHP objects?

nathj

[Atli]

Hi.

Take a look at the mssql_init and mssql_execute functions.

[crocodilu2008]

Try. mssql_bind() Example

[PHP]<?php

$cn = mssql_connect($DBSERVER, $DBUSER, $DBPASS);
mssql_select_db($DB, $cn);

$sp = mssql_init("WDumpAdd"); // stored proc name

mssql_bind($sp, "@productname", stripslashes($newproduct), SQLVARCHAR, false, false, 150);
mssql_bind($sp, "@quantity", stripslashes($newquantity), SQLVARCHAR, false, false, 50);

mssql_execute($sp);
mssql_close($cn);

?>
[/PHP]

See Also
mssql_bind() .....
mssql_execute()
mssql_free_statement()

[ccassel82]

Hi I have this SP to execute at php but I have no Idea how to do it

this is the way I execute it on MSSQL

DECLARE @TranID int 
BEGIN TRANSACTION 
EXEC sp_TransactionModify @TranID output, 1, 100.00, 0, 100.00, 123, 456, “2008-08-20”
COMMIT
SELECT @TranID as TransactionID

How can I do to make it work at php??

Thank you so much!!!!