<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
$servername = "127.0.0.1";
$username = "autoph_db";
$password = "@4u70hu36r0up007#"; // Ensure this is correct for your setup
$dbname = "autoph_db";
$port = 3306; // Default MySQL port

try {
    $pdo = new PDO("mysql:host=$servername;port=$port;dbname=$dbname", $username, $password);
    // set the PDO error mode to exception
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
        // $data = [
        //     'filename' => 'testupload',
        //     'path' => 'uploads/',
        //     'extension' => 'png',
        //     'status' => 1,
        //     'active' => 1,
        //     'created_at' => date("Y-m-d h:i:s")
        // ];  
        // createData($pdo, 'files', $data);

} catch(PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}

function createData($pdo, $table, $data){
    try{
        $columns = implode(", ", array_keys($data));
        $placeholders = implode(", ", array_fill(0, count($data), '?'));

        $pdo->beginTransaction();
        $sql = "INSERT INTO customer_upload_ltms ($columns) VALUES ($placeholders) ";
        $stmt = $pdo->prepare($sql);
        $stmt->execute(array_values($data));

        $pdo->commit();
        echo'Record inserted successfully';

        // $conditions = ['active' => 1];
        // $results = readData($pdo, 'files', $conditions);
      
    }
    catch(PDOException $e){
        $pdo->rollback();
        echo 'Failed to insert data : '.$e->getMessage();
    }
}

function readData($pdo, $table, $conditions =[]){
    try{
        $sql = "SELECT * FROM $table";
        
        if (!empty($conditions)) {
            $sql .= " WHERE " . implode(" AND ", array_map(function ($key) {
                return "$key = ?";
            }, array_keys($conditions)));
        }

        // Prepare the statement
        $stmt = $pdo->prepare($sql);
        
        // Execute with condition values
        $stmt->execute(array_values($conditions));
        
        // Fetch all the results
        $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
        
        return $results;
    }
    catch(PDOException $e)
    {
        echo 'Read Failed: '. $e->getMessage();
        return [];
    }
    
}
?>