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
:
charge_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 de la table $sql = "SELECT column_name, combo_value, toto, date_values FROM planning"; $result = $conn->query($sql); $data = []; if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $date_values = explode(',', $row['date_values']); $data[] = array_merge([$row['column_name'], $row['combo_value'], $row['toto']], $date_values); } } $conn->close(); echo json_encode($data); ?>