php执行mysql文件

<?php
// 数据库连接配置
$host = 'localhost';
$user = 'username';
$password = 'password';
$dbname = 'database_name';

// 连接数据库
$conn = mysqli_connect($host, $user, $password, $dbname);

if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

// 读取SQL文件
$sql_file_path = 'path_to_your_sql_file.sql';
$sql_content = file_get_contents($sql_file_path);

// 分割SQL文件为单独的语句
$sql_statements = explode(';', $sql_content);

foreach ($sql_statements as $statement) {
    if (!empty(trim($statement))) { // 确保语句不为空
        if (mysqli_multi_query($conn, $statement)) {
            do {
                if ($result = mysqli_store_result($conn)) {
                    // 处理结果集（如果有）
                    while ($row = mysqli_fetch_assoc($result)) {
                        // 处理每一行数据
                    }
                    mysqli_free_result($result);
                }
            } while (mysqli_next_result($conn));
        } else {
            echo "SQL Error: " . mysqli_error($conn) . "\n";
        }
    }
}

// 关闭数据库连接
mysqli_close($conn);
?>