58 lines
986 B
PHP
58 lines
986 B
PHP
<?php
|
|
|
|
class Updatequeryregional_fitri extends MY_Controller
|
|
{
|
|
|
|
function donow(){
|
|
$array_db = array(
|
|
'reg_bandung',
|
|
'reg_surabaya',
|
|
'reg_tegal',
|
|
'reg_manado',
|
|
'reg_pontianak',
|
|
'reg_yogya',
|
|
'reg_jakarta',
|
|
'reg_cirebon',
|
|
'reg_palembang',
|
|
'reg_medan',
|
|
'reg_padang',
|
|
'reg_pekanbaru',
|
|
'reg_magelang',
|
|
'reg_salatiga',
|
|
'reg_semarang',
|
|
'reg_balikpapan',
|
|
'reg_madiun',
|
|
'reg_makasar',
|
|
'reg_denpasar',
|
|
'reg_tasik',
|
|
'reg_prospek',
|
|
'reg_sima_malang',
|
|
'reg_sima_kediri',
|
|
'reg_sima_jember',
|
|
'reg_tulungagung'
|
|
//'reg_bekasi'
|
|
);
|
|
foreach($array_db as $k => $v){
|
|
$this->dbx = $this->load->database($v, true);
|
|
|
|
|
|
|
|
|
|
$sql="UPDATE `s_menu` SET `S_MenuUrl` = 'nasional/one-mou-accept-v2/' WHERE `S_MenuUrl` LIKE '%nasional/one-mou-accept%';";
|
|
|
|
$query = $this->dbx->query($sql);
|
|
if ($query) {
|
|
//$rows = $query->row()->xcount;
|
|
echo $v."-OK ";
|
|
}
|
|
else{
|
|
echo $v."-ERROR ";
|
|
}
|
|
|
|
|
|
}
|
|
}
|
|
|
|
}
|
|
?>
|