CORE MANAGER PRO

Editor: foxOptions.php

<?php
// Get the JSON data from the POST request
$json_data = $_POST['data'];
echo gettype($json_data);
echo $json_data."Here :)";
return "Hello";
// Decode the JSON string into a PHP array
$data = json_decode($json_data, true);

$ut = time();

$servername = "localhost";
$username = "dataeczp_ana";
$password = "dT1grv4ftCo_a7bBUM";
$dbname = "dataeczp_vasuki";

// Create a PDO instance
try {
    $pdo = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

echo "Connected to the database successfully!<br>";
} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage()."<br>";

}
//$jsonString = json_encode($data);
$errorStatus = "nathi";
// Assuming you have a table named 'my_table' with columns 'name' and 'age'
foreach ($data as $row) {
    $name = "Fox";
    $data1 = $json_data;
    
    
    
    
    // $name = $row['name'];
    // $age = $row['age'];
    // $sql = "INSERT INTO my_table (name, age) VALUES ('$name', '$age')";

// if ($conn->query($sql) === TRUE) {
        // echo "New record created successfully";
    // } else {
        // echo "Error: " . $sql . "<br>" . $conn->error;
    // }
    
    
    
    
    $sql = "INSERT INTO timepass (name,data) VALUES (?,?)";

// Bind the parameters and execute the statement
    $stmt = $pdo->prepare($sql);
    $stmt->bindParam(1, $name);
    $stmt->bindParam(2, $data1);
    
    
    if($errorStatus == "nathi"){
        try {
            $stmt->execute();
            // echo "Data inserted in database successfully!";
            $insertAlert = "Success";
        } catch (PDOException $e) {
            echo "Error: " . $e->getMessage();
            $insertAlert = "Fail";
            $errorStatus = "chhe";
        }
        
    }
}

Cancel