Skip to main content
MENU
Megamenu - Secondary
+603-2602 9988
pusatautismepdrm2020@gmail.com
Log Masuk
Daftar Baru
Megamenu - Main
Utama
Latar Belakang Pusat
Mengenai Kami
Kalendar
Acara
Hubungi Kami
Tutup
Tutup
Log Masuk
Daftar Baru
Utama
Latar Belakang Pusat
Mengenai Kami
Kalendar
Acara
Hubungi Kami
Utama
» Acara
Acara
Sukan Tahunan Pusat Autisme Pengaman
26.11.2022
PULAPOL
Selanjutnya
Majlis Sambutan Hari Kemerdekaan Pusat Autisme Pengaman
30.08.2022
Pusat Autisme Pengaman
Selanjutnya
Lawatan ke Aquaria KLCC
16.06.2022
Aquaria KLCC
Selanjutnya
Something went wrong
Page ID : 77
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(); }
