Pusat Autisme pengaman

Pakaian

Uniform Murid Lelaki

RM 50

Selanjutnya

Pakaian

Uniform Murid Perempuan

RM 50

Selanjutnya

Pakaian

Set Pakaian Sukan

RM 30

Selanjutnya

Pakaian

Topi Murid Pusat Autisme Pengaman

RM 25

Selanjutnya

Study Equipment

Set Peralatan Belajar

RM 50

Selanjutnya

Study Equipment

Beg Murid

RM 30

Selanjutnya

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 : 73
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

Uniform Murid Lelaki

RM 50

Uniform Murid Perempuan

RM 50

Set Pakaian Sukan

RM 30

Topi Murid Pusat Autisme Pengaman

RM 25

Set Peralatan Belajar

RM 50

Beg Murid

RM 30

Something went wrong