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_db.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); 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"; ?>