File "sauve_to_db02.php"

Full Path: /home/analogde/www/New folder/sauve_to_db02.php
File size: 1.01 KB
MIME-type: text/x-php
Charset: utf-8

<?php
$host = "analogdepat.mysql.db";
$dbname = "analogdepat";
$username = "analogdepat";
$password = "Un92pac007";

$conn = new mysqli($host, $username, $password, $dbname);

// Vérification de la connexion
if ($conn->connect_error) {
    die("Erreur de connexion : " . $conn->connect_error);
}

// Récupérer les données envoyées par la requête POST
$data = json_decode(file_get_contents('php://input'), true);

// Vider la table avant de sauvegarder les nouvelles données
//$conn->query("TRUNCATE TABLE table_DB_planning");

// Préparer la requête d'insertion
$stmt = $conn->prepare("INSERT INTO planning (column_name, combo_value, toto, date_values) VALUES (?, ?, ?, ?)");

foreach ($data as $row) {
    $column_name = $row[0];
    $combo_value = $row[1];
    $toto = $row[2];
    $date_values = implode(',', array_slice($row, 3));

    $stmt->bind_param("ssis", $column_name, $combo_value, $toto, $date_values);
    $stmt->execute();
}

$stmt->close();
$conn->close();

echo "OK";
?>