Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
File Manager
/
New folder
:
sauve_to_db02.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?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"; ?>