Black Friday sale is now on! 50% off Laravel: The Modular Way. Learn more

PHP Import SQL from a .sql file

David Carr

Tools Development

    I've released a new package to easily import a .sql file into a database using PDO.

    To install the package import it using composer:

    composer require daveismyname/sql-import

    Or download and include import.php manually from https://github.com/daveismyname/sql-import

    Then to use the library, define your database file path and credentials, the last option dropTables when set to true will delete all the tables in the database before import the sql file.

    <?php
    require('vendor/autoload.php');
    
    use Daveismyname\SqlImport\Import;
    
    $filename = 'database.sql';
    $username = 'root';
    $password = '';
    $database = 'sampleproject';
    $host = 'localhost';
    $dropTables = true;
    new Import($filename, $username, $password, $database, $host, $dropTables);

     

    Laravel Modules Book by David Carr

    Help support the blog so that I can continue creating new content!

    Subscribe to my newsletter

    Subscribe and get my books and product announcements.

    © 2009 - 2022 DC Blog. All code MIT license. All rights reserved.