Teach you to use PHP to call MSSQL stored procedures

Teach you to use PHP to call MSSQL stored procedures

//Execute stored procedure

for($i=0;$i<$ses_basket_items;$i++)
{
$query="exec add_ddxx
@p_account="$session_account",
@p_name="$name[$i]",
@p_num="$num[$i]",
@p_marketPRice="$marketprice[$i]",
@p_memberprice="$memberprice[$i]",
@p_priceoftax="$notaxprice[$i]",
@p_priceoflast="$lastprice[$i]",
@p_sumprice="$price[$i]",
@p_buy_date="$date",
@p_flag="$p_flag"";
$result=mssql_query($query,$connection) or die("Stored procedure execution error, unable to execute the SQL: $query");
}

The above introduces how to use PHP to call MSSQL stored procedures, including the relevant content. I hope it will be helpful to friends who are interested in PHP tutorials.