$link = mysqli_connect("meharicltest.mysql.db", "meharicltest", "Pva131254", "meharicltest");
if (!$link) {
echo "Erreur : Impossible de se connecter à MySQL." . PHP_EOL;
echo "Errno de débogage : " . mysqli_connect_errno() . PHP_EOL;
echo "Erreur de débogage : " . mysqli_connect_error() . PHP_EOL;
exit;}
// Your code here
echo "
\n".
"HAPedit 3.1.11.111 (septembre 2021 15:54:28)****************";
//print_r($_FILES);echo('***
');
//print_r($_POST);
//$tempname=$_FILES['file']['tmp_name'];
//echo( $tempname);
move_uploaded_file($_FILES['file']['tmp_name'], "bdd.sql");
$handle = @fopen("bdd.sql", "r");
if ($handle) {
$link->query("DROP TABLE `activity`, `affectation`, `bill`, `card`, `channel`, `compte`, `exercice`, `fee`, `member`, `note`, `organisation`, `product`, `purchase`, `reference`, `view`, `wooLink`, `wooOrder`;");
while (($buffer = fgets($handle)) !== false) {
$sql=utf8_encode($buffer);
$link->query($sql);
//echo $sql."
";
}
if (!feof($handle)) {
echo "Erreur: fgets() a échoué\n";
}
fclose($handle);
unlink("bdd.sql");
//mise a jour exercice
$sql="UPDATE `encours` SET `id_exercice` = '".$_POST['exercice']."' WHERE `encours`.`id` = 1";
//echo($sql);
$link->query($sql);
$sql="UPDATE `encours` SET `id_exercice` = '".date("Y-m-d h:i ")."' WHERE `encours`.`id` = 2";
//echo($sql);
$link->query($sql);
// header('Location: index.php');
}
?>