File "sauve_to_db.php"

Full Path: /home/analogde/www/New folder/sauve_to_db.php
File size: 762 bytes
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);

if ($conn->connect_error) {
    die("Erreur de connexion : " . $conn->connect_error);
}

$data = json_decode(file_get_contents('php://input'), true);

foreach ($data as $row) {
    $titre_nom = $row[0];
    $combo_value = $row[1];
    $cell_values = implode(',', array_slice($row, 2));

    $sql = "INSERT INTO DB_planning (titre_nom, combo_value, cell_values) VALUES (?, ?, ?)";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("sss", $titre_nom, $combo_value, $cell_values);
    $stmt->execute();
}

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

echo "OK";
?>