Pusat Autisme pengaman

Study Equipment

Beg Murid

RM 30

(30 stok tinggal)

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras vitae massa mauris. Sed venenatis sed enim non auctor. Sed a luctus dolor, ut condimentum libero. Curabitur vel ultrices metus. Sed vitae arcu vitae purus aliquam bibendum. Proin at facilisis neque, imperdiet tempus erat. Maecenas nec hendrerit dui. Nullam accumsan mattis magna bibendum volutpat. Ut et diam id diam pellentesque sodales id sed risus.

Log masuk untuk teruskan membeli produk ini

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 : 74
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();
}

Produk Kami

Beg Murid

RM 30

Something went wrong