How to pass php variable as value in store procedure call in sql query?

Question

I am not getting any results while passing the values intot the stores procuder I have the code below

<?php

     $a="26456";

     $result3=mysql_query('CALL getItemStock($a)');
     $row = mysql_fetch_array($result3);
?>

Akam · Accepted Answer · 2016-05-26 15:32:39Z

2

Try this:

    $result3=mysql_query('CALL getItemStock('.$a.')');

or

    $result3=mysql_query("CALL getItemStock($a)");

UPDATE:

If the parameter defined as string then you need to enclose it with quotes as well. For example:

    $a = 'I am String';
    $result3=mysql_query("CALL getItemStock('$a')");

However, if the parameter defined as number, then no quotation required.

answered May 26, 2016 at 15:07

Akam

1,05216 silver badges25 bronze badges

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

1 Answer 1