Getting error when call mysql stored procedure from php

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.

yes i connected database . SP has two parametes, i have passed two parameters also. But the error shows 1 given — Gopal
– Gopal, Commented Mar 7, 2017 at 13:00
$mysqli = mysqli_connect('localhost','username','password','dbname'); $mysqli->query("call InsertDetails($id,'$nameDetails')") try this — praveena
– praveena, Commented Mar 7, 2017 at 13:03
Thanks for your reply. issue resolved. But the values not inserted in corresponding table. — Gopal
– Gopal, Commented Mar 7, 2017 at 13:13

Shanu k k · Accepted Answer · 2017-03-07 13:03:58Z

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)');

edited Mar 7, 2017 at 13:03

answered Mar 7, 2017 at 12:58

Shanu k k

1,2853 gold badges22 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

12 Comments

Gopal Over a year ago

Thanks for your reply. I have $id = 1; $nameDetail= 'test' ; $result = mysqli_query($connection,'CALL InsertDetails($id,$nameDetail)');. But the values not inserted in table.

Gopal Over a year ago

Yes it working. SP triggered. But values not stored in table. this is my SP CREATE PROCEDURE InsertDetails (id int, name varchar(100)) BEGIN Declare newvalue varchar(50) insert into student(id,Name) values(id,name); set newvalue = 'success'; select newvalue; END $$

Shanu k k Over a year ago

wait let me check

praveena Over a year ago

change this, insert into student (id, Name) values (sid, sname);

praveena Over a year ago

run your store procedure to check,

|

Niraj Shah · Accepted Answer · 2017-03-07 12:59:41Z

0

You need to pass in the connection as the first parameter:

// connect to DB
$connect = mysqli_connect("127.0.0.1", "my_user", "my_password", "my_db");

// run procedure
$result = mysqli_query($connect, 'CALL InsertDetails($id,$nameDetail)');

answered Mar 7, 2017 at 12:59

Niraj Shah

15.5k4 gold badges44 silver badges61 bronze badges

Collectives™ on Stack Overflow

Getting error when call mysql stored procedure from php

2 Answers 2

12 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

12 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related