Aug 25

PHP SQL Server Stored Procedure #16 

/* prepare the statement resource */
$stmt=mssql_init("your_stored_procedure", $conn);

/* now bind the parameters to it */
mssql_bind($stmt, "@id",    $id,    SQLINT4,    FALSE);
mssql_bind($stmt, "@name",  $name,  SQLVARCHAR, FALSE);
mssql_bind($stmt, "@email", $email, SQLVARCHAR, FALSE);   

/* now execute the procedure */
$result = mssql_execute($stmt);

Another Example

$conn = mssql_connect($db_host,$db_user,$db_password);if ($conn===false){	
    echo 'Cannot connect.';	
    exit;
} 

if (mssql_select_db("YourDatabase",$conn) === false) {	
   echo 'no database';	
   exit;
}

$proc = mssql_init('YourStoredProcedure',$conn);
mssql_bind($proc,'@ParameterOne',$ParameterOne,SQLVARCHAR);
mssql_bind($proc,'@ParameterTwo',$ParameterTwo,SQLVARCHAR);
mssql_bind($proc,'@ParameterThree',$ParameterThree,SQLVARCHAR);
if ($result = mssql_execute($proc)) {	
   if ($row = mssql_fetch_row($result)){		
      // process results	
   }
}
From: http://sitestree.com/?p=5256
Categories:16
Tags:
Post Data:2011-08-31 17:44:38
Shop Online: https://www.ShopForSoul.com/ (Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com In Bengali: http://Bangla.SaLearningSchool.com http://SitesTree.com 8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) Shop Online: https://www.ShopForSoul.com/ Medium: https://medium.com/@SayedAhmedCanada