Pusat Autisme pengaman

Petunjuk

Cuti Semester

Cuti Umum

Perjumpaan PPIK

Program Berkuda

Program Khas

Program Renang

Program Sensori

Program Sosial

Sharing Session

Sukaneka

Mengenai Kami
PUSAT AUTISME PENGAMAN
Aras G Bangunan Akademik, Pusat Latihan Polis (PULAPOL) KL
Jalan Sultan Yahya Petra, 54100 Kuala Lumpur, Malaysia
Telefon
+603-2602 9988
Emel
pusatautismepdrm2020@gmail.com

Something went wrong

Page ID : 106
Content ID : 68
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '67' for key 'dmg_visitor.PRIMARY' The SQL being executed was: INSERT INTO dmg_visitor (dtvisit,total) VALUES ('2025-12-08',1)
Content :

use yii\db\Query;

$today = date("Y-m-d");

$query2= new Query;
$query2 ->select(['*'])->from('dmg_visitor')->all();
$command2 = $query2->createCommand();
$models2 = $command2->queryAll();
foreach ($models2 as $model2) {
    echo '<script>console.log("'.$model2["dtvisit"].' - '.$model2["total"].'");</script>';
}

$queryhits = new Query;
$queryhits ->select(['*'])->from('dmg_visitor')->where(['dtvisit' => $today])->all();
$commandhits = $queryhits->createCommand();
$modelshits = $commandhits->queryAll();

$counthits = 0;
$valhits = 0;

foreach ($modelshits as $modelhits) {
    $valhits = (int)$modelhits["total"];
    $counthits++;
}

$db = Yii::$app->db;
$valhits++;

if ($counthits == 1) {   
    $sql = "UPDATE dmg_visitor SET total = ".$valhits." where dtvisit = '".$today."'";
    $db->createCommand($sql)->execute();
} else if ($counthits > 1) {   
    $sql = "DELETE FROM dmg_visitor where dtvisit = '".$today."'";
    $db->createCommand($sql)->execute();
    $sql = "INSERT INTO dmg_visitor (dtvisit,total) VALUES ('".$today."',".$valhits.")";
    $db->createCommand($sql)->execute();
} else {
    $sql = "INSERT INTO dmg_visitor (dtvisit,total) VALUES ('".$today."',".$valhits.")";
    $db->createCommand($sql)->execute();
}

Kalendar

Petunjuk

Something went wrong