max_visit.php

<?php
    session_start();
    $session_id = session_id();
    $current_date = date('Y-m-d', strtotime('now'));

    $db = new SQLite3('attendance.sqlite3');    
    $db->exec("CREATE TABLE IF NOT EXISTS attendance (
                    user_session varchar(50),
                    user_datetime varchar(100),
                    visit INT
                    )");

    $sql = 'SELECT * FROM attendance WHERE user_session = :session AND user_datetime = :current_date;';
    $stmt = $db->prepare($sql);
    $stmt->bindValue(':session', $session_id, SQLITE3_TEXT);
    $stmt->bindValue(':current_date', $current_date, SQLITE3_TEXT);
    $res = $stmt->execute();
    $result = $res->fetchArray();
    
    if ($result) 
    {
        if($result['visit'] >= 2)
        {
            echo 'habis'; exit;
        }
        
        echo 'boleh lagi ni';
        $visit = $result['visit'] + 1;
        // Update
        $sql = 'UPDATE attendance SET visit = :visit WHERE user_session = :session AND user_datetime = :current_date';
        $stmt = $db->prepare($sql);
        $stmt->bindValue(':visit', $visit, SQLITE3_TEXT);
        $stmt->bindValue(':session', $session_id, SQLITE3_TEXT);
        $stmt->bindValue(':current_date', $current_date, SQLITE3_TEXT);
        $res = $stmt->execute();
    }
    else
    {
        echo 'boleh lagi ni';
        $sql = 'INSERT INTO attendance (user_session, user_datetime, visit) VALUES (:session, :current_date, 1)';
        $stmt = $db->prepare($sql);
        $stmt->bindValue(':session', $session_id, SQLITE3_TEXT);
        $stmt->bindValue(':current_date', $current_date, SQLITE3_TEXT);
        $res = $stmt->execute();
    }