PHP import sql from multiple directories [duplicate]

Question

I am trying to create a script where I can import .sql files from multiple directories into my database.

I am able to import one SQL by this code:

<?php
$sql = file_get_contents('mysqls/hey.sql');
$qr = $dbh->exec($sql);
?>

But when I move on to make it read more then one .sql file it dosnt work:

<?php
$sql = file_get_contents('mysqls/*.sql');
$qr = $dbh->exec($sql);
?>

I would also like for it to go into multiple folders that may be created in the future [folders would be in the same directory as the code].

My database connection has already been made in a PDO config connection.

you need to traverse through each file

arun
– arun

2013-11-18 06:50:29 +00:00
Commented Nov 18, 2013 at 6:50 — arun
– arun, Commented Nov 18, 2013 at 6:50

Bhadra · Accepted Answer · 2013-11-18 06:49:29Z

2

$dirf    = 'mysqls';
$dir = scandir($dirf);
foreach($dir as $file) {
   if(($file!='..') && ($file!='.')) {
       $sql = file_get_contents($file);
       $qr = $dbh->exec($sql);
   }
}

answered Nov 18, 2013 at 6:49

Bhadra

2,1041 gold badge13 silver badges19 bronze badges

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

7 Comments

user3001214 Over a year ago

How would I be able to show an success / error message?

Bhadra Over a year ago

success message for db query??

Bhadra Over a year ago

success/error depends on the db query only.so you can echo the success/error of db query in the if loop

user3001214 Over a year ago

Dont worry, relised how to do then removed as I no longer need the messages. Anyways the code you provided is not working correctly. Its reading the files, but for some reason its not running it through the database.

user3001214 Over a year ago

If it helps, in my .sql files I have similar codes of "INSERT INTO test (id, title) VALUES (1, 'hello');"

|

Collectives™ on Stack Overflow

PHP import sql from multiple directories [duplicate]

1 Answer 1

7 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Linked

Related