Executing .sql file with variable from PHP script

Question

I have very long SQL file which includes $variable in format like:

DELIMITER $$
DROP TRIGGER IF EXISTS `$variable` $$
    CREATE TRIGGER `TEMP` BEFORE INSERT ON `5_2012`
    FOR EACH ROW BEGIN
      set NEW.chour = timediff(NEW.exit, NEW.enter);
      set NEW.total = timediff(NEW.exit, NEW.enter);
...

I need a way to execute this script each time with different table names ($variable).

I am using MySQL.

What database server are you using? Is that MySQL syntax?

user212218
– user212218

2012-06-05 23:43:33 +00:00
Commented Jun 5, 2012 at 23:43 — user212218
– user212218, Commented Jun 5, 2012 at 23:43

Jared · Accepted Answer · 2012-06-05 23:51:45Z

1

Change your .sql file into a .php script Add a header to the top, and add the mime type. If i can remember correctly, it's application/x-sql. Echo out each variable.

<?php
header("Content-type: application/x-sql");
?>

DELIMITER $$ 
DROP TRIGGER IF EXISTS `<?= $variable; ?>` $$
CREATE TRIGGER `TEMP` BEFORE INSERT ON `5_2012` 
FOR EACH ROW BEGIN   
    set NEW.chour = timediff(NEW.exit, NEW.enter);
    set NEW.total = timediff(NEW.exit, NEW.enter);

answered Jun 5, 2012 at 23:51

Jared

4064 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Executing .sql file with variable from PHP script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related