从php调用mysql存储过程时出错

Question

I have triggered the stored procedure from php. I have passed the input parameters also as shown.

$id = 1;
$nameDetail = 'raj';
$result = mysqli_query('CALL InsertDetails($id,$nameDetail)');

But getting below error.

mysqli_query() expects at least 2 parameters, 1 given ...

Please suggest a solution.

Answer 1

The issue is that you're not set the mysqli connection.please try this

$connection = mysqli_connect('localhost','username','password','db');
    $result = mysqli_query($connection,'CALL InsertDetails($id,$nameDetail)');