Malaysia Coastal, Oceanography and Hydraulic Marine Geospatial Data Management System

Contact Us

53 views

National Water Research Institute of Malaysia

Lot 5377, Jalan Putra Permai, 43300 Seri Kembangan, Selangor Darul Ehsan.
T: 0389476400
F: 0389483044

Disclaimer• Privacy Policy• Security Policy• Personal Data Protection

Best viewed using Mozilla Firefox dan Google Chrome with screen resolution 1366x768.

use yii\db\Query; $today = date("Y-m-d"); //Jumlah Keseluruhan Visitor $queryhitsoverall= new Query; $queryhitsoverall->select(['sum(total)'])->from('dmg_visitor')->all(); $commandhitsoverall = $queryhitsoverall->createCommand(); $valoverallhits = $commandhitsoverall->queryScalar(); //Jumlah Visitor Tahun Ini $queryhitsyear = new Query; $queryhitsyear->select(['sum(total)'])->from('dmg_visitor')->andWhere('YEAR(dtvisit) = YEAR(:substr)', [':substr' => $today])->all(); $commandhitsyear= $queryhitsyear->createCommand(); $valyearhits = $commandhitsyear->queryScalar(); //Jumlah Visitor Bulan Ini $queryhitsmonth = new Query; $queryhitsmonth->select(['sum(total)'])->from('dmg_visitor')->where('MONTH(dtvisit) = MONTH(:substr)', [':substr' => $today])->andWhere('YEAR(dmg_visitor.dtvisit) = YEAR(:substr)', [':substr' => $today])->all(); $commandhitsmonth = $queryhitsmonth->createCommand(); $valmonthhits = $commandhitsmonth->queryScalar(); //Jumlah Visitor Minggu Ini $queryhitsweek = new Query; $queryhitsweek->select(['sum(total)'])->from('dmg_visitor')->where('YEARWEEK(dtvisit) = YEARWEEK(:substr)', [':substr' => $today])->all(); $commandhitsweek = $queryhitsweek->createCommand(); $valweekhits = $commandhitsweek->queryScalar(); //Jumlah Visitor Hari Ini $queryhits = new Query; $queryhits ->select(['sum(total)'])->from('dmg_visitor')->where(['dtvisit' => $today])->all(); $commandhits = $queryhits->createCommand(); $valhits = $commandhits->queryScalar(); echo '

'.Yii::t('app', 'Disclaimer').'• '.Yii::t('app', 'Privacy Policy').'• '.Yii::t('app', 'Security Policy').'• '.Yii::t('app', 'Personal Data Protection').'

'.Yii::t('app', 'Best viewed using Mozilla Firefox dan Google Chrome with screen resolution 1366x768').'.

';use yii\db\Query; $today = date("Y-m-d"); //Jumlah Keseluruhan Visitor $queryhitsoverall= new Query; $queryhitsoverall->select(['sum(total)'])->from('dmg_visitor')->all(); $commandhitsoverall = $queryhitsoverall->createCommand(); $valoverallhits = $commandhitsoverall->queryScalar(); //Jumlah Visitor Tahun Ini $queryhitsyear = new Query; $queryhitsyear->select(['sum(total)'])->from('dmg_visitor')->andWhere('YEAR(dtvisit) = YEAR(:substr)', [':substr' => $today])->all(); $commandhitsyear= $queryhitsyear->createCommand(); $valyearhits = $commandhitsyear->queryScalar(); //Jumlah Visitor Bulan Ini $queryhitsmonth = new Query; $queryhitsmonth->select(['sum(total)'])->from('dmg_visitor')->where('MONTH(dtvisit) = MONTH(:substr)', [':substr' => $today])->andWhere('YEAR(dmg_visitor.dtvisit) = YEAR(:substr)', [':substr' => $today])->all(); $commandhitsmonth = $queryhitsmonth->createCommand(); $valmonthhits = $commandhitsmonth->queryScalar(); //Jumlah Visitor Minggu Ini $queryhitsweek = new Query; $queryhitsweek->select(['sum(total)'])->from('dmg_visitor')->where('YEARWEEK(dtvisit) = YEARWEEK(:substr)', [':substr' => $today])->all(); $commandhitsweek = $queryhitsweek->createCommand(); $valweekhits = $commandhitsweek->queryScalar(); //Jumlah Visitor Hari Ini $queryhits = new Query; $queryhits ->select(['sum(total)'])->from('dmg_visitor')->where(['dtvisit' => $today])->all(); $commandhits = $queryhits->createCommand(); $valhits = $commandhits->queryScalar(); echo '

'.Yii::t('app', 'Disclaimer').'• '.Yii::t('app', 'Privacy Policy').'• '.Yii::t('app', 'Security Policy').'• '.Yii::t('app', 'Personal Data Protection').'

'.Yii::t('app', 'Best viewed using Mozilla Firefox dan Google Chrome with screen resolution 1366x768').'.