File Manager

X7ROOT File Manager

Current Path: /home/u742491609/domains/apca.org.in/public_html/admin

home / u742491609 / domains / apca.org.in / public_html / admin /

?? ..
?? .htaccess(98 B)
?? add-blog.php(4.24 KB)
?? add-blog1.php(3.14 KB)
?? add-blog2.php(4.77 KB)
?? add-blog3.php(3.71 KB)
?? all-blog.php(5.62 KB)
?? all-blog1.php(2.07 KB)
?? all-subscriber.php(1.83 KB)
?? assets
?? connection.php(675 B)
?? connectivity
?? convocation
?? dashboard.php(1.57 KB)
?? delete-blog.php(332 B)
?? edit-add-blog.php(5.25 KB)
?? edit-add-blog1.php(9.63 KB)
?? edit-blog.php(5.12 KB)
?? error_log(4.92 KB)
?? footer.php(954 B)
?? header.php(2.21 KB)
?? inaugration
?? index.php(3.6 KB)
?? logout.php(80 B)
?? others
?? passing-out-parade
?? republic-independence
?? short-term
?? sidebar.php(4.43 KB)
?? track_visitors.php(1.29 KB)
?? uploads

Editing: track_visitors.php

<?php
// Database connection
$host = 'localhost';
$db = 'u742491609_apca';
$user = 'u742491609_apca';
$pass = 'L9r/cO14tt';

try {
    $pdo = new PDO("mysql:host=$host;dbname=$db", $user, $pass);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

// Check if a record exists for today's date
    $today = date('Y-m-d');
    $stmt = $pdo->prepare("SELECT * FROM visitors WHERE visit_date = :visit_date");
    $stmt->execute(['visit_date' => $today]);
    $record = $stmt->fetch(PDO::FETCH_ASSOC);

if ($record) {
        // Update the visit count for today
        $stmt = $pdo->prepare("UPDATE visitors SET visit_count = visit_count + 1 WHERE visit_date = :visit_date");
        $stmt->execute(['visit_date' => $today]);
    } else {
        // Insert a new record for today
        $stmt = $pdo->prepare("INSERT INTO visitors (visit_date, visit_count) VALUES (:visit_date, 1)");
        $stmt->execute(['visit_date' => $today]);
    }

// Get the total visit count (optional)
    $stmt = $pdo->query("SELECT SUM(visit_count) AS total_visits FROM visitors");
    $result = $stmt->fetch(PDO::FETCH_ASSOC);
    echo "Total number of visitors: " . $result['total_visits'];

} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}
?>

X7ROOT File Manager

Editing: track_visitors.php

Upload File

Create Folder