Execute($sqlIns,array($nilai)) === false) { $error = "Error Insert Data"; die ($error); }else{ $error = ""; } return $error; } function updateDB($tbl,$select,$where,$nilai){ global $db; $sqlIns = "update {$tbl} SET $select $where"; //$db->debug = true; if($db->Execute($sqlIns,array($nilai)) === false) { $error = "Error Update Data"; die ($error); }else{ $error = ""; } return $error; } function deleteDB($tbl,$where){ global $db; $del = "DELETE from {$tbl} $where"; if($db->Execute($del) === false) { $error = "Error Delete Data"; die ($error); }else{ $error = ""; } return $error; } /* Fungsi select satu data (c) Rapelino 6 Feb 2011 */ function selectRowDB($select,$tbl,$where){ global $db; $sqlSel = "select $select from {$tbl} $where"; $rs = &$db->GetRow($sqlSel); return $rs; } /* Fungsi select banyak data (c) Rapelino 6 Feb 2011 */ function selectAllDB($select,$tbl,$where,$order='',$limit=''){ global $db; $sqlSel = "select $select from {$tbl} $where $order $limit"; $rs = &$db->GetAll($sqlSel); return $rs; } /* Fungsi untuk memasukan aktifitas user ke dalam log Fungsi ini dapat dilakukan untuk user yang login, dengan table member_log (v.1) */ function insertMemberLog($tblUse,$activity,$nilai){ global $db; $sqlIns = "insert into {member_log} (rand_id,session_id,date_action,info_action,info_table,info_primary_key,id_user) values($values)"; if($db->Execute($sqlIns,array($nilai)) === false) { $error = "Error Insert Log Data"; die ($error); }else{ $error = ""; } return $error; } /* Funsi untuk Generate No Contoh SQL lengkap : "SELECT max(SUBSTR(mem_no_register,5,5))As nomor FROM member WHERE SUBSTR(mem_no_register,1,4)='".$periode."' "; $select1 = mem_no_register $n1 = 5 $n2 = 5 $form = member $select2 = mem_no_register $n3 = 1 $n4 = 4 */ function generateNumberTahun($select1,$n1,$n2,$form,$select2,$n3,$n4){ $thn = date('Y'); $periode= $thn; $SQLNo = "SELECT max(SUBSTR($select1,$n1,$n2))As nomor FROM $form WHERE SUBSTR($select2,$n3,$n4)='".$periode."' "; $rsNo = $db->GetRow($SQLNo); $LastNumber = $rsNo['nomor']; $NewNumber = $LastNumber+1; $MuchChar = strlen($NewNumber); If ($MuchChar == 1) { $NewNumber = $periode.'0000'.$NewNumber; } Else If ($MuchChar == 2) { $NewNumber = $periode.'000'.$NewNumber; } Else If ($MuchChar == 3) { $NewNumber = $periode.'00'.$NewNumber; } Else If ($MuchChar == 4) { $NewNumber = $periode.'0'.$NewNumber; } Else If ($MuchChar == 5) { $NewNumber = $periode.$NewNumber; } Else { $NewNumber = $periode.$NewNumber; } return $NewNumber; } /* nextVal(namaDatabase,namaTable) 8 April 2011 --> FUngsi untuk mendapatkan auto increment id yang terakhir */ function nextVal($schema,$table){ global $db; $sqlNextVal = " SELECT AUTO_INCREMENT AS last_id FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = '$schema' AND TABLE_NAME='$table' "; $rsNextval = &$db->GetRow($sqlNextVal); $id_next = $rsNextval['last_id']; return $id_next; } ?> Discovery Hotels & Resort "; print_r($frontImg); echo ""; */ ?>
Central Reservation: 62-21-3835050
green globe tuv












Discover Fun
Experience the fun with your family at Discovery Hotel & Convention Ancol and bring their imagination to life with a holiday to remember at Dunia Fantasi!
Enchanting Festive Season
Be dazzled by sparkling lights and extravagant Christmas decorations while you enjoy your stay at Hotel Borobudur Jakarta
Romance Package 5 Days & 4 Nights
Enjoy a romantic holiday with the love one. Candle light dinner and traditional massage will complete the happiness together
NEWS & UPDATE
Type in your e-mail to stay up to date with our promotion