Unable to create trigger in PHP for mySQL

Question

I am trying to create a trigger into mySQL using PHP

mysqli_select_db($host, "game");
$sql = "CREATE TRIGGER test_seven BEFORE INSERT ON test FOR EACH ROW INSERT INTO test (name) VALUES ('test')";
$query = $host->prepare($sql);
$query->execute();

And it is not working even though I tried running it on phpMyAdmin and it worked.

EDIT: "This command is not supported in the prepared statement protocol yet" Is there a way of skipping the prepare statement then ?

I also faced the same issue , for procedures / tiggers, still dont know why it does not allow, but my guess is , its due to user rights, in phpmyadmin user has diffrent rights/ privelges and when you do some thing with code it has diffrent priveleges, even though the user are same. Not sure if its correct or not — Purushottam zende
– Purushottam zende, Commented Feb 5, 2018 at 12:29
"not working" means what? What error do you get? Are you even checking for mySQL errors in your PHP code? Does the user which PHP is logging in with have rights to do this? — ADyson
– ADyson, Commented Feb 5, 2018 at 13:04
@ADyson "This command is not supported in the prepared statement protocol yet" Is there a way of skipping the prepare statement then ? — Johny
– Johny, Commented Feb 5, 2018 at 13:11
Don't execute it as prepared statement. This is an admins job, not a programmers. But apart from that, I doubt that the statement worked, like you say. Your trigger would create an infinite loop and is therefore not allowed. Your insert statement would fire the trigger, which would fire the trigger, which would fire the trigger...and so on. — fancyPants
– fancyPants, Commented Feb 5, 2018 at 13:16

GolezTrol · Accepted Answer · 2018-02-05 13:23:14Z

1

Apparently the real problem was the fact that I was not supposed to use the PDO::prepare statement, if anyone else is having this issue use PDO::exec.

edited Feb 5, 2018 at 13:23

GolezTrol

116k19 gold badges186 silver badges215 bronze badges

answered Feb 5, 2018 at 13:18

Johny

213 bronze badges

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

Collectives™ on Stack Overflow

Unable to create trigger in PHP for mySQL

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related