File "save_to_db_02.php"

Full Path: /home/analogde/www/Softs/New folder/save_to_db_02.php
File size: 1.37 KB
MIME-type: text/x-php
Charset: utf-8

<?php

    $host = "analogdepat.mysql.db";   
    $dbname = "analogdepat";
    $username = "analogdepat"; 	   
    $password = "Un92pac007";	

    // creation de la connexion
    $conn = new mysqli($host, $username, $password, $dbname);

    // Verifier la connexion
    if ($conn->connect_error) 
    {
        die("Connection failed: " . $conn->connect_error);
    }
    else
    {
        echo "DB connexion OK";
    }

    // Recuperer les données envoyées via php://input
    $input = file_get_contents('php://input');

    // echapper les caractères speciaux pour eviter les injections SQL
    $input = $conn->real_escape_string($input);

    $data = json_decode(file_get_contents('php://input'), true);
    // Convertir les donnees en format JSON pour les stocker
    $jsonData = json_encode($data);
  
    $query = "INSERT INTO table_DB_planning (column_name, created_at) VALUES ('$jsonData' , Now())";

    $statusMessage = "";

    // Executer la requte
    if ($conn->query($query) === TRUE) 
    {
        $statusMessage = "OK";
    } 
    else 
    {
        $statusMessage = "ERREUR";
    }

    // Générer une alerte JavaScript
    //echo "<script>alert('$statusMessage');</script>";

    echo $statusMessage;

    setcookie("nom_du_cookie", $statusMessage , time() + 3600, "/");

    // Fermer la connexion
    $conn->close();

?>