Need Help in SQLSRV_PARAM_OUT

Feb 21, 2011 at 6:51 AM
Edited May 26, 2011 at 7:52 AM

Hi,

Sample PHP code is

<!--?php	 $para	=	array(array($memberid,SQLSRV_PARAM_IN),	 array($start_date,SQLSRV_PARAM_IN),	 array($end_date,SQLSRV_PARAM_IN)	 );	 $stmt =  "{call MemberStatement(?, ?, ?)}";	 if(!($result= sqlsrv_query($conn,$stmt ,$para)))	 {	 echo "Database Error"; die;	 }	 $arr_main = array();$totalpoints =0;while($row = sqlsrv_fetch_array($result)){	 $arr_main[] =  $row;$totalpoints = $totalpoints + $row['member_points'];	 }?-->

 

<?php

$para = array(array($memberid,SQLSRV_PARAM_IN), array($start_date,SQLSRV_PARAM_IN), array($end_date,SQLSRV_PARAM_IN) );

$stmt =  "{call MemberStatement(?, ?, ?)}";

if(!($result= sqlsrv_query($conn,$stmt ,$para)))

{

echo "Database Error"; die;

}

$arr_main = array();

$totalpoints =0;

while($row = sqlsrv_fetch_array($result))

{

$arr_main[] =  $row;

$totalpoints = $totalpoints + $row['member_points'];

}

?>
When i execute the above i don't get any result. But if i run the above SP in management studio , i am able to see the result(8 rows are coming).
I don't know the reason , why i don't get any result?
Please any one give me the solution for this problem.

Thanks

Tamilmani Mohan

Oct 17, 2011 at 9:25 PM
Edited Oct 17, 2011 at 9:50 PM

Hi Tamilmani,

You do not appear to be initializing your variables before the following call:

$para = array(array($memberid,SQLSRV_PARAM_IN), array($start_date,SQLSRV_PARAM_IN), array($end_date,SQLSRV_PARAM_IN) );
Thanks,

Jonathan