MySQL stored procedure using multiple parameters

Question

I can use MySQL stored procedures with one parameter but when I try and use multiple parameters the stored procedure doesn't seam to be called. I will paste the php code I have then the SQL code. Can anyone give any indication why it's not working?

Thanks

<?php 

//DB Connection include
include '/connection/proccon.php';    

 $skill=1;
 $level=1;
 $user=1;

//SQL for identify user 
$sqlquestion = sprintf("call updatequestion('%s, %s, %s')", $skill, $user, $level);

echo $sqlquestion;
$resultquestion = mysqli_query($link, $sqlquestion);    

?>

SQL Below

--Procedure: updatequestion

--DROP PROCEDURE IF EXISTS updatequestion;

DELIMITER |

CREATE DEFINER = 'root'@'%' PROCEDURE updatequestion 
(
  IN  v_uid    int,
  IN  v_level  int,
  IN  v_qid    int
)
BEGIN
INSERT INTO answer (qid,uid,level) VALUES(v_qid,v_uid,v_level);
END|

DELIMITER ;

You put quotes around all the parameters, so it's just one string instead of 3 separate parameters. — Barmar
– Barmar, Commented Jul 9, 2014 at 8:56

user3793240 · Accepted Answer · 2014-07-09 08:59:13Z

1

Use the quotes better, you included 3 parameters into 2 quotes, that's wrong, i think.

Solution:

**

$sqlquestion = sprintf("call updatequestion(%s, %s, %s)", $skill, $user, $level);

**

Have a nice day

answered Jul 9, 2014 at 8:59

user3793240

441 silver badge10 bronze badges

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

Comments

Barmar · Accepted Answer · 2014-07-09 08:57:55Z

0

Change it to:

$sqlquestion = sprintf("call updatequestion(%s, %s, %s)", $skill, $user, $level);

The quotes were combining all the parameters into one string.

answered Jul 9, 2014 at 8:57

Barmar

789k57 gold badges554 silver badges669 bronze badges

2 Comments

Huntz Over a year ago

Thank you, spent ages on this there is very little online with this notation.

Barmar Over a year ago

There are examples of procedures with multiple parameters here: mysqltutorial.org/stored-procedures-parameters.aspx

Collectives™ on Stack Overflow

MySQL stored procedure using multiple parameters

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related