<?php
//import.php

$requete = file_get_contents("bdd.sql");
$mysqli = mysqli_connect("sql.toile-libre.org", "votre_identifiant", "votre_mdp", "votre_bdd");

if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

mysqli_report(MYSQLI_REPORT_ALL);


//$mysqli->multi_query($requete)) ne marche pas a cause de la taille de la requete


//Pas sur que cette solution marchera dans tout les cas
preg_match_all("/(.*?;)[\n\r]/s", $requete, $queries);

$i = 0;
foreach($queries[0] as $query) {
    $i++;
    echo $i;
    
    if($query == "") {
        continue;
    }
    if(!$mysqli->query($query))
    {
        echo "query: " . $query . " failed</br>";
        break;
    }
}

$mysqli->close();
echo "fin du chargement";