Question

thinkphp3.2 怎么调用mysql存储过程并返回所有结果集

Answer 1

$model = M("");
$sql = "call 存储过程名称('{$参数1}','{$参数2}',@result)";
//echo $sql;
$ref = $model -> query($sql);
//var_dump($ref);
// 结果集视具体情况而定
$status= $ref[0]['result'];