mysql:
create procedure sp_demo() begin select 111; end;php:
$conn=mysql_connect('127.0.0.1');
$query=mysql_query('call test.sp_demo(@test)',$conn);
var_dump($query);//true$conn=mysqli_connect('127.0.0.1');
$query=mysqli_query($conn,'call test.sp_demo(@test)');
var_dump($query);//false
create procedure sp_demo() begin select 111; end;php:
$conn=mysql_connect('127.0.0.1');
$query=mysql_query('call test.sp_demo(@test)',$conn);
var_dump($query);//true$conn=mysqli_connect('127.0.0.1');
$query=mysqli_query($conn,'call test.sp_demo(@test)');
var_dump($query);//false
if($conn){mysql_select_db('database',$conn);}
......
create procedure sp_demo() begin select 111; end;php:
$conn=mysql_connect('127.0.0.1');
$query=mysql_query('call test.sp_demo()',$conn);
var_dump($query);//true$conn=mysqli_connect('127.0.0.1');
$query=mysqli_query($conn,'call test.sp_demo()');
var_dump($query);//false
//$query=mysqli_query($conn,'select 111');
//var_dump($query);//true