Is it possible to display trigger error message to Webpage?

Question

I have trigger under certain condition, If condition: false Error occurs. I should display that error message which occurs in database trigger to HTML web page to notify user!

CREATE TRIGGER check_trigger BEFORE INSERT ON your_table
FOR EACH ROW
BEGIN        
    IF (NEW.name = NEW.firstname) THEN
        SIGNAL SQLSTATE '45000' 
            SET MESSAGE_TEXT = 'same names error. Insertion canceled';
    END IF;
END

How to display SET MESSAGE_TEXT="" to web page? If it's not possible any other ways

@YourCommonSense Any Idea Dude?? – Shukurillo Baykhanov Jul 04 '19 at 13:39 — Shukurillo Baykhanov, Jul 04 '19 at 13:39

score 5 · Answer 1 · edited Jun 20 '20 at 09:12

5

You can take a look at the documentation here.

It says:

The error values that are accessible after SIGNAL executes are the SQLSTATE value raised by the SIGNAL statement and the MESSAGE_TEXT and MYSQL_ERRNO items. These values are available from the C API:

mysql_sqlstate() returns the SQLSTATE value.

mysql_errno() returns the MYSQL_ERRNO value.

mysql_error() returns the MESSAGE_TEXT value.

Since I'm guessing you're using PHP you can try

if (!$mysqli->query("INSERT INTO your_table SET name='a', firstname='a'")) {
    printf("Error message: %s\n", $mysqli->error);
}

edited Jun 20 '20 at 09:12

Community

1
1

answered Jul 02 '19 at 12:48

Teneff

30,564
13
72
103

[Check my attempt Dude](https://stackoverflow.com/questions/56855299/how-to-use-mysqli-sqlstate-to-display-trigger-error-message) – Shukurillo Baykhanov Jul 02 '19 at 16:55

score 0 · Answer 2 · answered Jul 03 '19 at 04:35

0

You can look at some like Pusher which is an external rest service that can push messages to your web site.

answered Jul 03 '19 at 04:35

JakesIV

41
4

Is it possible to display trigger error message to Webpage?

2 Answers2