MySQL Forums
Forum List  »  PHP

Re: Cannot display mysqli_error($con) ???
Posted by: Peter Brawley
Date: January 26, 2019 01:29PM

The script has an error ...

...
DELIMITER //
DROP PROCEDURE IF EXISTS sp_tableTest;
CREATE PROCEDURE `sp_tableTest`(...
...

The delimiter directive needs to be moved to between the drop and create proc... cmds.

With that fixed the SIGNAL error message is produced both in the mysql client program and in a MySQL db query tool, theUsual (I use WB only when it can't be avoided, and that's rare).

PHP doesn't see the SIGNAL message with a single mysqli_query() call. It's due to the internal architecture of that API. You need to use mysqli's multi-query, for an example see "Call a stored procedure from PHP" at https://www.artfulsoftware.com/infotree/mysqltips.php.

Options: ReplyQuote


Subject
Written By
Posted
Re: Cannot display mysqli_error($con) ???
January 26, 2019 01:29PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.