Re: PHP mysqli is NOT trapping some errors when calling stored procedure

--0000000000000930c40581b4f64b
Content-Type: text/plain; charset="UTF-8"

Yes, I do have all reqd privs.

In fact, as long as a duplicate key situation isnt encountered, I am able
to invoke the stored proc from PHP alright and the record gets saved in the
database.

But when I try to re-do it using the same value (thereby I am expecting
that 1062-DUPLICATE KEY error will be thrown and caught by PHP), I dont get
any error from PHP!

In mysql client or MySQL Workbench, I do see the error. when I invoke the
stored proc.

Thanks,
Venkat


On Tue, Feb 12, 2019 at 9:56 PM Aziz Saleh <[email protected]> wrote:

> Do you have sufficient privileges to execute stored procedures
> (procs_priv) on PHP's end?
>
> On Tue, Feb 12, 2019 at 11:07 AM Venkat Hariharan <[email protected]>
> wrote:
>
>> Can you take a look at the issue that I've described at
>>
>> https://stackoverflow.com/questions/54643704/php-mysqli-is-not-trapping-some-errors-when-calling-stored-procedure
>> and tell me what I am missing in my PHP code ?
>>
>> To summarize: I am calling a MySQL stored procedure from PHP that does
>> some
>> DMLs (using mysqli). But the problem is that PHP is not able to get
>> intimated of some database error conditions raised by the stored proc
>> (which I know are raised, bcoz they do get flagged when invoked from a
>> mysql client)
>>
>> I've listed the relevant code fragments there. Am I not using mysqli
>> correctly?
>>
>> Thanks,
>> Venkat
>>
>

--0000000000000930c40581b4f64b--