76 lines
1.2 KiB
PHP
76 lines
1.2 KiB
PHP
<?php
|
|
|
|
class Updatequery_fitri extends MY_Controller
|
|
{
|
|
|
|
function donow()
|
|
{
|
|
$array_db = array(
|
|
'riau',
|
|
'pajajaran',
|
|
'toha',
|
|
'cimahi',
|
|
'ngagel',
|
|
'aditya',
|
|
'jemur',
|
|
'mulyo',
|
|
'parkus',
|
|
'hrm',
|
|
'cikditiro',
|
|
'sultan_agung',
|
|
'matraman',
|
|
'bonjer',
|
|
'samanhudi',
|
|
'ragunan',
|
|
'cirebon',
|
|
'veteran',
|
|
'dahlan',
|
|
'plaju',
|
|
'diponegoro',
|
|
'yamin',
|
|
'padang',
|
|
'tegal',
|
|
'manado',
|
|
'pontianak',
|
|
'sudirman',
|
|
'magelang',
|
|
'salatiga',
|
|
'semarang',
|
|
'balikpapan',
|
|
'madiun',
|
|
'makasar',
|
|
'denpasar',
|
|
'tasik',
|
|
//'dupang',
|
|
'wonokusumo',
|
|
'tangkuban_perahu',
|
|
'ciliwung',
|
|
'kediri',
|
|
'jember',
|
|
//'simokerto',
|
|
'hertasning',
|
|
'tulungagung',
|
|
'hasyim',
|
|
'sumarecon',
|
|
'kompolmaksum',
|
|
'mojokerto'
|
|
);
|
|
foreach ($array_db as $k => $v) {
|
|
$this->dbx = $this->load->database($v, true);
|
|
|
|
$sql = "UPDATE `s_menu` SET `S_MenuName` = 'Laporan Terbitnya Point' WHERE `S_MenuName` LIKE '%Laporan Pendapatan Point%';";
|
|
$query = $this->dbx->query($sql);
|
|
|
|
if ($query) {
|
|
//$rows = $query->row()->xcount;
|
|
echo $v . "-OK ";
|
|
} else {
|
|
echo $v . "-ERROR ";
|
|
}
|
|
|
|
|
|
}
|
|
}
|
|
|
|
}
|
|
?>
|