<?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'		);
		foreach($array_db as $k => $v){
			$this->dbx = $this->load->database($v, true);

$sql = "INSERT INTO `s_menu` (`S_MenuName`, `S_MenuUrl`, `S_MenuIcon`, `S_MenuParentS_MenuID`, `S_MenuLevel`, `S_MenuIsParent`, `S_MenuOrder`, `S_MenuIsActive`, `S_MenuCreated`, `S_MenuLastUpdated`)
VALUES ('Bank', 'test/vuex/one-md-bank/', NULL, '68', '2', 'N', '40', 'Y', now(), now());";
$query = $this->dbx->query($sql);

			if ($query) {
				//$rows = $query->row()->xcount;
				echo $v."-OK ";
			}
			else{
				echo $v."-ERROR ";
			}
			
			
		}
	}

}
?>