How Can I Dynamically Load SQL Files into MySQL Using PHP?

Efficiently Importing SQL Files into MySQL using PHP

Creating databases and populating them with data from SQL files is a common task, especially during application installation. Manually executing each query individually becomes cumbersome with complex database schemas. This article details a streamlined PHP approach to directly import SQL files into MySQL.

Method

This method uses PHP's file_get_contents() function to read the entire SQL file into a string. The PDO (PHP Data Objects) class then provides a robust and consistent way to interact with the MySQL database. Combining these simplifies the import process significantly.

Code Example

The following PHP code illustrates how to import a SQL file using a PDO connection:

<code class="language-php">$dsn = 'mysql:host=localhost;dbname=my_database';
$user = 'root';
$password = '';

try {
    $db = new PDO($dsn, $user, $password);
    $sql = file_get_contents('file.sql');
    $qr = $db->exec($sql);
    echo "SQL file imported successfully.";
} catch (PDOException $e) {
    echo "Error importing SQL file: " . $e->getMessage();
}</code>

This code connects to the MySQL database via PDO, reads the SQL file ('file.sql'), and executes all queries within the file using $db->exec(). The try...catch block handles potential errors during the process.

Summary

Using file_get_contents() and PDO offers a simple yet effective method for dynamically importing SQL files in PHP. This approach is ideal for automating database initialization during application deployments.

The above is the detailed content of How Can I Dynamically Load SQL Files into MySQL Using PHP?. For more information, please follow other related articles on the PHP Chinese website!