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:

Expand|Select|Wrap|Line Numbers

 
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

Expand|Select|Wrap|Line Numbers

 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!!!!

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

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

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

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

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

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about