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_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); } $sql = "SELECT titre_nom, combo_value, cell_values FROM DB_planning ORDER BY id DESC LIMIT 1"; $result = $conn->query($sql); $data = []; if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $cell_values = explode(',', $row['cell_values']); $data[] = array_merge([$row['titre_nom'], $row['combo_value']], $cell_values); } } $conn->close(); echo json_encode($data); ?>