File "save_to_db_02.php"

Full Path: /home/analogde/www/New folder/save_to_db_02.php
File size: 1.43 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();



?>