[PHP-DB] execut MS SQL stored proc

2004-07-15 Thread Damien Babilon 
Hi All,
To resolve my last prolem, I've switched of server, I'm now on a WIN2000 
ox with PHP 4.8 and Apache 1.3, thanks for your reply

Now
I try to execute a Stored procedure on a mssql box. The connection is 
ok, ut I can't get the results.
The stored procedure did'n return a recordset, it return simple text and 
I did'n find (since more than 5 hours now) how to set my vars in php !!!

Here is the code:
   $mssql_host=xxx.xxx.xxx.xxx;
   $mssql_username=USER;
   $mssql_password=PASSWD;
   $mssql_db=DBNAME;
   $conn=mssql_connect($mssql_host,$mssql_username,$mssql_password)
   or Die(Couldn't connect to MSSQL Server $mssql_host);
   mssql_select_db($mssql_db,$conn)
   or Die(Couldn't open database $mssql_db);
   $proc=mssql_init(sp_WebCustomerGet,$conn);
  
   $rc=0;
   $userid=damien;
   $lang=;
   $pin=;
   $fma=;
   $fmtn=;
   $res=;

   mssql_bind($proc,@RC,$rc,SQLINT1,TRUE,FALSE);
   mssql_bind($proc,@Id,$userid,SQLVARCHAR,FALSE,20); # = the param 
I give to the SP
   mssql_bind($proc,@Language,$lang,SQLCHAR,TRUE,FALSE,5);
   mssql_bind($proc,@Pin,$pin,SQLCHAR,TRUE,FALSE,4);
   mssql_bind($proc,@FollowMeActive,$fma,SQLBIT,TRUE,FALSE);
   
mssql_bind($proc,@FollowMeTelephoneNumber,$fmtn,SQLVARCHAR,TRUE,TRUE,25);
   mssql_bind($proc,@Result,$res,SQLVARCHAR,TRUE,TRUE,256);

   $rs=mssql_execute($proc);
   echo Return code:.$rc.br;
   echo Lang = .$lang.br;
   echo Pin = .$pin.br;
   echo FollowMeActive = .$fma.br;
   echo FollowMeTelephoneNumer = .$fmtn.br;
   echo Result = .$res;

Here is the result of the SP with Query analyser:
(1 row(s) affected)
Stored Procedure: EuroGSMTest.dbo.sp_WebCustomerGet
   Return Code = 0
   Output Parameter(s):
   @Language = fr-BE
   @Pin = 4321
   @FollowMeActive = 0
   @FollowMeTelephoneNumber = NULL
   @Result = Ok
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] execut MS SQL stored proc

2004-07-15 Thread Damien Babilon 
Hi All,
To resolve my last prolem, I've switched of server, I'm now on a WIN2000 
ox with PHP 4.8 and Apache 1.3, thanks for your reply

Now
I try to execute a Stored procedure on a mssql box. The connection is 
ok, ut I can't get the results.
The stored procedure did'n return a recordset, it return simple text and 
I did'n find (since more than 5 hours now) how to set my vars in php !!!

Here is the code:
  $mssql_host=xxx.xxx.xxx.xxx;
  $mssql_username=USER;
  $mssql_password=PASSWD;
  $mssql_db=DBNAME;
  $conn=mssql_connect($mssql_host,$mssql_username,$mssql_password)
  or Die(Couldn't connect to MSSQL Server $mssql_host);
  mssql_select_db($mssql_db,$conn)
  or Die(Couldn't open database $mssql_db);
  $proc=mssql_init(sp_WebCustomerGet,$conn);
 
  $rc=0;
  $userid=damien;
  $lang=;
  $pin=;
  $fma=;
  $fmtn=;
  $res=;

  mssql_bind($proc,@RC,$rc,SQLINT1,TRUE,FALSE);
  mssql_bind($proc,@Id,$userid,SQLVARCHAR,FALSE,20); # = the param 
I give to the SP
  mssql_bind($proc,@Language,$lang,SQLCHAR,TRUE,FALSE,5);
  mssql_bind($proc,@Pin,$pin,SQLCHAR,TRUE,FALSE,4);
  mssql_bind($proc,@FollowMeActive,$fma,SQLBIT,TRUE,FALSE);
  
mssql_bind($proc,@FollowMeTelephoneNumber,$fmtn,SQLVARCHAR,TRUE,TRUE,25);
  mssql_bind($proc,@Result,$res,SQLVARCHAR,TRUE,TRUE,256);

  $rs=mssql_execute($proc);
  echo Return code:.$rc.br;
  echo Lang = .$lang.br;
  echo Pin = .$pin.br;
  echo FollowMeActive = .$fma.br;
  echo FollowMeTelephoneNumer = .$fmtn.br;
  echo Result = .$res;

Here is the result of the SP with Query analyser:
(1 row(s) affected)
Stored Procedure: EuroGSMTest.dbo.sp_WebCustomerGet
  Return Code = 0
  Output Parameter(s):
  @Language = fr-BE
  @Pin = 4321
  @FollowMeActive = 0
  @FollowMeTelephoneNumber = NULL
  @Result = Ok
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php