Problem calling MySQL stored procedure from php

Question

I have a stored MySQL procedure that takes a customer number and a currency as input. It outputs an array using a select statement. The output array is comprised of Balance and NetBalance,

If I call the procedure from MySQL as "call GetAccountBalanceByCurrency(500,'USD')" I get the correct results.

However, if I call it from PHP as $x= mysqli_multi_query("call GetAccountBalanceByCurrency(500,'USD');"), I get the following error message:

Warning: mysqli_multi_query() expects exactly 2 parameters, 1 given 
    in C:\...\...\call_proc_test4.php on line 4.

I assume it is something simple, but have been banging my head for hours. I have tried $x= mysqli_multi_query("call GetAccountBalanceByCurrency(500,'USD')"); among other things. Can anybody see the error?

Many thanks.

Pascal MARTIN · Accepted Answer · 2009-12-01 23:04:23Z

4

Quoting the manual, the mysqli_multi_query function requires two parameters, when you are using the procedural style API :

bool mysqli_multi_query  ( mysqli $link  , string $query  )

So, you at least must pass the link identifier as a first parameter.

BTW : that's exactly what the warning message is trying to indicate you ;-)
"mysqli_multi_query() expects exactly 2 parameters, 1 given"

Yes, the same manual page also gives an example with only one parameter -- but it's for the Object oriented style (mysqli being an extension that exposes both a procedural and an OO API).

answered Dec 1, 2009 at 23:04

Pascal MARTIN

402k82 gold badges665 silver badges666 bronze badges

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

Comments

Community · Accepted Answer · 2023-11-21 15:10:29Z

0

Check out the documentation for mysqli_multi_query. The way you're calling it needs two arguments instead of just the one:

https://www.php.net/mysqli_multi_query

edited Nov 21, 2023 at 15:10

CommunityBot

11 silver badge

answered Dec 1, 2009 at 23:03

leepowers

38.4k24 gold badges103 silver badges132 bronze badges

Comments

streetparade · Accepted Answer · 2009-12-01 23:11:05Z

0

First you have to set 2 querys or one recource and one query like this

$link = mysqli_connect("localhost", "my_user", "my_password", "world");

$query  = "CREATE TABLE....;...;... blah blah blah;...";

mysqli_multi_query($link,$query);

answered Dec 1, 2009 at 23:11

streetparade

33k39 gold badges106 silver badges123 bronze badges

Collectives™ on Stack Overflow

Problem calling MySQL stored procedure from php

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related