'; echo 'alert("'.$p.'")'; echo ''; } function ca($x) { global $a, $b; if ($x == "A"){ $a = '1'; $b = ''; }else { $a = '1'; $b = '1'; } } function cico($n1,$n2) { if(cek($n1,$n2) == '0') { return array('ueye22x.png', 'uok22.png'); } elseif(cek($n1,$n2) == '11') { return array('eye22.png', 'uok22.png'); } else { return array('eye22.png', 'ok22.png'); } } function cek($n1,$n2) { global $link; #$sqlnya="SELECT no,sum,dil,dis FROM tket WHERE no = '$n1' AND sum = '$n2' LIMIT 1"; $sqlnya='SELECT no,sum,dil,dis FROM tket WHERE no = '.$n1.' AND sum = "'.$n2.'" LIMIT 1'; $result = mysqli_query($link,$sqlnya); $row = mysqli_fetch_assoc($result); $num_rows = mysqli_num_rows($result); if($num_rows > 0) { //return($num_rows.' *** '.$row['dil'].' *** '.$row['dil']); return($num_rows.$row['dil'].$row['dis']); } else { return('0');} } //===INPUT FUNGSI LIHAT DAN BOOKMARK==== function ibook($n1,$n2,$x) { global $link; $tgl = strftime("%F#%T"); if (cek($n1,$n2) == '0') { global $a, $b; ca($x); $order = "INSERT INTO tket (no, sum, dil, dis, tgl) VALUES ('$n1','$n2','$a','$b','$tgl')"; $result = mysqli_query($link, $order); if($result){ echo pesan('Input data is succeed'); } else{ echo pesan('Input data is fail'); } } else { //if (cek($n1,$n2) == '11' & $x == 'A') if ($x == 'A') { echo pesan('Hadist yang sudah dilihat tidak dapat Diubah !'); } else { if ($x == 'B' & cek($n1,$n2) == '111') { ubook($n1,$n2,'A'); } else { ubook($n1,$n2,$x); } } } } function ubook($n1,$n2,$x) { konek(); global $a, $b; ca($x); $sql ="UPDATE tket SET dil = '$a', dis = '$b' WHERE no = '$n1' AND sum = '$n2'" ; $result = mysql_query($sql); if($result){ echo pesan('Input data is succeed'); } else{ echo pesan('Input data is fail'); } } function cc($cx){ return(''); } function cr_color($cr){ $cr = str_replace('%', ' ', $cr); $str_arr = explode(' ', $cr); $jm=count($str_arr); //echo 'Hasil 2 : '.$str_arr[1].', Jumlah :'.$jm.'
'; if ($jm == 2) { return array('', ''); } elseif ($jm == 3) { return array('', '', ''); } else { return array('', '', '', ''); } } //======================================================================= //===FUNCTION GET TABLE NAME===== function gtba($tb) { if ($tb == 'tbukhari1') { return("Bukhari");} if ($tb == 'tmuslim2') { return("Muslim");} if ($tb == 'tabudaud3') { return("Abu Daud");} if ($tb == 'ttirmidzi4') { return("Tirmidzi");} if ($tb == 'tnasai5') { return("Nasai");} if ($tb == 'tibnumajah6') { return("Ibnu Majah");} if ($tb == 'tahmad7') { return("Ahmad");} if ($tb == 'tmalik8') { return("Malik");} if ($tb == 'tdarimi9') { return("Ad Darimi");} if ($tb == 'quran_text') { return("Al-Quran");} } //--------------------------- function gtbb($tb) { if ($tb == "Bukhari") { return('tbukhari1');} if ($tb == "Muslim") { return('tmuslim2');} if ($tb == "Abu Daud") { return('tabudaud3');} if ($tb == "Tirmidzi") { return('ttirmidzi4');} if ($tb == "Nasai") { return('tnasai5');} if ($tb == "Ibnu Majah") { return('tibnumajah6');} if ($tb == "Ahmad") { return('tahmad7');} if ($tb == "Malik") { return('tmalik8');} if ($tb == "Ad Darimi") { return('tdarimi9');} if ($tb == "Al-Quran") { return("quran_text");} } //===ISI====GET-HADITS-in-BAB=========== function getisibab($tb,$kt,$bb) { global $link; $kt = str_replace('?', '"', $kt); $bb = str_replace('?', '', $bb); $bb = str_replace('!', '"', $bb); $bb=addslashes($bb); echo '
'; if ($tb != '') { #$sql = "SELECT no,sumber,bab, hindo, harab FROM $tb WHERE kitab = '$kt' AND bab LIKE '$bb%' ORDER BY no ASC "; $sql = "SELECT * FROM $tb WHERE kitab = '$kt' AND bab LIKE '$bb%' ORDER BY no ASC "; $buka=mysqli_query($link,$sql); $c=0; while($hasil=mysqli_fetch_row($buka)){ $c=$c+1; echo'
'; echo''; echo'
'.$c. '. [ '.$hasil[0].' ] --> '.$hasil[1].' --> '.$hasil[2].' --> '.$hasil[3].'
'.$hasil[4].'
'.$hasil[5].'
'; #
'; echo boknote($tb,$hasil[0],$hasil[8],$hasil[7],$hasil[8]).'
'; } } echo ""; } //===ISI====GET-ISI-HADITS-in-TABLE=========== function getisikitab($tb,$kt) { global $link; $kt = str_replace('?', '"', $kt); echo '
'; if ($tb != '') { #$sql = "SELECT no, sumber, kitab, hindo, harab, bok, note FROM $tb WHERE kitab = '$kt' ORDER BY no ASC "; $sql = "SELECT * FROM $tb WHERE kitab = '$kt' ORDER BY no ASC "; $buka=mysqli_query($link,$sql); $c=0; while($hasil=mysqli_fetch_row($buka)) { $c=$c+1; echo'
'; echo'
'.$c. '. [ '.$hasil[0].' ] --> '.$hasil[1].' --> '.$hasil[2].'
'.$hasil[4].'
'.$hasil[5].'
'; echo boknote($tb,$hasil[0],$hasil[8],$hasil[7],$hasil[8]).'
'; } } echo "
"; } //===MENU====GET-BAB-in-TABLE=========== function getbab($tb,$kt,$nk) { global $link; $kt = $kt=addslashes($kt); echo '"; } //===MENU==GET-KITAB-IN-TABLE========== function getkitab($tb) { global $link; echo '"; } /* ===MENU==CARI-KITAB-IN-TABLE ============================= ==========================================================ON */ //==REMOVE-SAKAL-FROM-ARABFONT========== function delsakalquran($tb){ global $link; if ($tb != '') { $sql = "SELECT no, uarab FROM $tb"; $buka=mysqli_query($link,$sql); $c=0; while($hasil=mysqli_fetch_row($buka)) { $c=$c+1; $huarab=json_encode($hasil[1]); //Remove honorific sign $hf1 ="\u0610"; //ARABIC SIGN SALLALLAHOU ALAYHE WA SALLAM $hf2 ="\u0611"; //ARABIC SIGN ALAYHE ASSALLAM $hf3 ="\u0612"; //ARABIC SIGN RAHMATULLAH ALAYHE $hf4 ="\u0613"; //ARABIC SIGN RADI ALLAHOU ANHU $hf5 ="\u0614"; //ARABIC SIGN TAKHALLUS //Remove koranic anotation $hf6 ="\u0615"; //ARABIC SMALL HIGH TAH $hf7 ="\u0616"; //ARABIC SMALL HIGH LIGATURE ALEF WITH LAM WITH YEH $hf8 ="\u0617"; //ARABIC SMALL HIGH ZAIN $hf9 ="\u0618"; //ARABIC SMALL FATHA $hf10 ="\u0619"; //ARABIC SMALL DAMMA $hf11 ="\u061A"; //ARABIC SMALL KASRA $hf12 ="\u06D6"; //ARABIC SMALL HIGH LIGATURE SAD WITH LAM WITH ALEF MAKSURA $hf13 ="\u06D7"; //ARABIC SMALL HIGH LIGATURE QAF WITH LAM WITH ALEF MAKSURA $hf14 ="\u06D8"; //ARABIC SMALL HIGH MEEM INITIAL FORM $hf15 ="\u06D9"; //ARABIC SMALL HIGH LAM ALEF $hf16 ="\u06DA"; //ARABIC SMALL HIGH JEEM $hf17 ="\u06DB"; //ARABIC SMALL HIGH THREE DOTS $hf18 ="\u06DC"; //ARABIC SMALL HIGH SEEN $hf19 ="\u06DD"; //ARABIC END OF AYAH $hf20 ="\u06DE"; //ARABIC START OF RUB EL HIZB $hf21 ="\u06DF"; //ARABIC SMALL HIGH ROUNDED ZERO $hf22 ="\u06E0"; //ARABIC SMALL HIGH UPRIGHT RECTANGULAR ZERO $hf23 ="\u06E1"; //ARABIC SMALL HIGH DOTLESS HEAD OF KHAH $hf24 ="\u06E2"; //ARABIC SMALL HIGH MEEM ISOLATED FORM $hf25 ="\u06E3"; //ARABIC SMALL LOW SEEN $hf26 ="\u06E4"; //ARABIC SMALL HIGH MADDA $hf27 ="\u06E5"; //ARABIC SMALL WAW $hf28 ="\u06E6"; //ARABIC SMALL YEH $hf29 ="\u06E7"; //ARABIC SMALL HIGH YEH $hf30 ="\u06E8"; //ARABIC SMALL HIGH NOON $hf31 ="\u06E9"; //ARABIC PLACE OF SAJDAH $hf32 ="\u06EA"; //ARABIC EMPTY CENTRE LOW STOP $hf33 ="\u06EB"; //ARABIC EMPTY CENTRE HIGH STOP $hf34 ="\u06EC"; //ARABIC ROUNDED HIGH STOP WITH FILLED CENTRE $hf35 ="\u06ED"; //ARABIC SMALL LOW MEEM //Remove tatweel $hf36 ="\u0640"; #-------------------- $hf37="\u0656";//ARABIC SUBSCRIPT ALEF $hf38="\u0657";//ARABIC INVERTED DAMMA $hf39="\u0658";//ARABIC MARK NOON GHUNNA $hf40="\u0659";//ARABIC ZWARAKAY $hf41="\u065A";//ARABIC VOWEL SIGN SMALL V ABOVE $hf42="\u065B";//ARABIC VOWEL SIGN INVERTED SMALL V ABOVE $hf43="\u065C";//ARABIC VOWEL SIGN DOT BELOW $hf44="\u065D";//ARABIC REVERSED DAMMA $hf45="\u065E";//ARABIC FATHA WITH TWO DOTS $hf46="\u065F";//ARABIC WAVY HAMZA BELOW $hf47="\u0670";//ARABIC LETTER SUPERSCRIPT ALEF #------------------------ $hf48="\u064e"; //Fathah $hf49="\u0650"; //Kasrah $hf50="\u064f"; //Dummah $hf51="\u064C"; //dummatain $hf52="\u064D"; //Kasratain $hf53="\u064B"; //Fathahtain $hf54="\u0651"; //Tasdid $hf55="\u0652"; //Sukun $hf56="\u0653";//ARABIC MADDAH ABOVE $hf57="\u0654";//ARABIC HAMZA ABOVE $hf58="\u0655";//ARABIC HAMZA BELOW $hf59="\u08F0";//FATHATAIN $hf60="\u08F1";//DOMMATAIN $hf61="\u08F2";//KASRATAIN #------------------------- $huarab = str_replace("\u0622", '\u0627', $huarab); #$huarab = str_replace("\u0623", '\u0627', $huarab); #$huarab = str_replace("\u0625", '\u0627', $huarab); for ($i = 1; $i <= 61; $i++) { $hfx= ${'hf'.$i}; $huarab = str_replace($hfx, '', $huarab); } $huarab=json_decode($huarab); delsakal2($tb,$hasil[0],$huarab); } echo "

SUKSES UPDATE $c DATA dari TABEL $tb

"; } } function delsakalstr($tb) { global $link; if ($tb != '') { $huarab=json_encode($tb); #-------------------- $hf1="\u0656";//ARABIC SUBSCRIPT ALEF $hf2="\u0657";//ARABIC INVERTED DAMMA $hf3="\u0658";//ARABIC MARK NOON GHUNNA $hf4="\u0659";//ARABIC ZWARAKAY $hf5="\u065A";//ARABIC VOWEL SIGN SMALL V ABOVE $hf6="\u065B";//ARABIC VOWEL SIGN INVERTED SMALL V ABOVE $hf7="\u065C";//ARABIC VOWEL SIGN DOT BELOW $hf8="\u065D";//ARABIC REVERSED DAMMA $hf9="\u065E";//ARABIC FATHA WITH TWO DOTS $hf10="\u065F";//ARABIC WAVY HAMZA BELOW $hf11="\u0670";//ARABIC LETTER SUPERSCRIPT ALEF #------------------------ $hf12="\u064e"; //Fathah $hf13="\u0650"; //Kasrah $hf14="\u064f"; //Dummah $hf15="\u064C"; //dummatain $hf16="\u064D"; //Kasratain $hf17="\u064B"; //Fathahtain $hf18="\u0651"; //Tasdid $hf19="\u0652"; //Sukun $hf20="\u0653";//ARABIC MADDAH ABOVE $hf21="\u0654";//ARABIC HAMZA ABOVE $hf22="\u0655";//ARABIC HAMZA BELOW $hf23="\u08F0";//FATHATAIN $hf24="\u08F1";//DOMMATAIN $hf25="\u08F2";//KASRATAIN #------------------------- $huarab = str_replace("\u0622", '\u0627', $huarab); //ALIF TANDA TO ALIF POLOS #$huarab = str_replace("\u0623", '\u0627', $huarab); //ALIF HAMZA DIATAS TO ALIF POLOS #$huarab = str_replace("\u0625", '\u0627', $huarab); //ALIF HAMZA DIBAWAH TO ALIF POLOS for ($i = 1; $i <= 25; $i++) { $hfx= ${'hf'.$i}; #echo $hfx; $huarab = str_replace($hfx, '', $huarab); } $huarab=json_decode($huarab); echo '====================================='; echo "

Data Before : $tb"; echo "
Data After : $huarab

"; echo '====================================='; #echo "

SUKSES UPDATE DATA dari TABEL $tb

"; } } function delsakal1($tb) { global $link; if ($tb != '') { $sql = "SELECT no, uarab FROM $tb"; $buka=mysqli_query($link,$sql); $c=0; while($hasil=mysqli_fetch_row($buka)) { $c=$c+1; $huarab=json_encode($hasil[1]); #-------------------- $hf1="\u0656";//ARABIC SUBSCRIPT ALEF $hf2="\u0657";//ARABIC INVERTED DAMMA $hf3="\u0658";//ARABIC MARK NOON GHUNNA $hf4="\u0659";//ARABIC ZWARAKAY $hf5="\u065A";//ARABIC VOWEL SIGN SMALL V ABOVE $hf6="\u065B";//ARABIC VOWEL SIGN INVERTED SMALL V ABOVE $hf7="\u065C";//ARABIC VOWEL SIGN DOT BELOW $hf8="\u065D";//ARABIC REVERSED DAMMA $hf9="\u065E";//ARABIC FATHA WITH TWO DOTS $hf10="\u065F";//ARABIC WAVY HAMZA BELOW $hf11="\u0670";//ARABIC LETTER SUPERSCRIPT ALEF #------------------------ $hf12="\u064e"; //Fathah $hf13="\u0650"; //Kasrah $hf14="\u064f"; //Dummah $hf15="\u064C"; //dummatain $hf16="\u064D"; //Kasratain $hf17="\u064B"; //Fathahtain $hf18="\u0651"; //Tasdid $hf19="\u0652"; //Sukun $hf20="\u0653";//ARABIC MADDAH ABOVE $hf21="\u0654";//ARABIC HAMZA ABOVE $hf22="\u0655";//ARABIC HAMZA BELOW $hf23="\u08F0";//FATHATAIN $hf24="\u08F1";//DOMMATAIN $hf25="\u08F2";//KASRATAIN #------------------------- $huarab = str_replace("\u0622", '\u0627', $huarab); #$huarab = str_replace("\u0623", '\u0627', $huarab); #$huarab = str_replace("\u0625", '\u0627', $huarab); for ($i = 1; $i <= 25; $i++) { $hfx= ${'hf'.$i}; $huarab = str_replace($hfx, '', $huarab); } $huarab=json_decode($huarab); delsakal2($tb,$hasil[0],$huarab); } echo "

SUKSES UPDATE $c DATA dari TABEL $tb

"; } } #====================== function delsakal2($tb,$ino,$hu) { global $link; $sql ="UPDATE $tb SET uarab = '$hu' WHERE no = '$ino'" ; $result = mysqli_query($link, $sql); } function delsakalall(){ delsakal1("tbukhari1"); delsakal1("tmuslim2"); delsakal1("tabudaud3"); delsakal1("ttirmidzi4"); delsakal1("tnasai5"); delsakal1("tibnumajah6"); delsakal1("tahmad7"); delsakal1("tmalik8"); delsakal1("tdarimi9"); echo "

HAPUS tanda Sakal di SEMUA TABEL SUKSESSS....!

"; } #========PERBAIKI-TEXT-ARAB-YG-SALAH=============== function repairtext($t,$f,$a,$b){ global $link; $sql="UPDATE $t SET $f = REPLACE($f, '$a', '$b')"; $buka=mysqli_query($link,$sql); if ($buka){ echo "

Suksess REPLACE --$a-- with --$b-- !

"; }else { echo "

FAIL REPLACE !

"; } } function repairtextall($f,$a,$b){ global $link; $tb1 ="tbukhari1"; $tb2 ="tmuslim2"; $tb3 ="tabudaud3"; $tb4 ="ttirmidzi4"; $tb5 ="tnasai5"; $tb6 ="tibnumajah6"; $tb7 ="tahmad7"; $tb8 ="tmalik8"; $tb9 ="tdarimi9"; for ($i = 1; $i <= 9; $i++) { $tbx= ${'tb'.$i}; $sql="UPDATE $tbx SET $f = REPLACE($f, '$a', '$b')"; $buka=mysqli_query($link,$sql); } echo "

Suksess REPLACE --$a-- with --$b-- ALL Table !

"; } function tambahkolom(){ global $link; $sqlt1 ="ALTER TABLE tbukhari1 ADD uarab longtext NOT NULL"; $sqlt2 ="ALTER TABLE tmuslim2 ADD uarab longtext NOT NULL"; $sqlt3 ="ALTER TABLE tabudaud3 ADD uarab longtext NOT NULL"; $sqlt4 ="ALTER TABLE ttirmidzi4 ADD uarab longtext NOT NULL"; $sqlt5 ="ALTER TABLE tnasai5 ADD uarab longtext NOT NULL"; $sqlt6 ="ALTER TABLE tibnumajah6 ADD uarab longtext NOT NULL"; $sqlt7 ="ALTER TABLE tahmad7 ADD uarab longtext NOT NULL"; $sqlt8 ="ALTER TABLE tmalik8 ADD uarab longtext NOT NULL"; $sqlt9 ="ALTER TABLE tdarimi9 ADD uarab longtext NOT NULL"; for ($i = 1; $i <= 9; $i++) { $sqlx= ${'sqlt'.$i}; mysqli_query($link, $sqlx); } } //--SET BOOKMARK------ function setbookmarknote($kod,$tb,$no,$dat){ global $link; if ($kod == "B"){ if (is_numeric($tb)) { $tbx = "quran_text"; $sr = $tb; #sura $ay = $no; #aya $sql="UPDATE $tbx SET bok = '$kod' WHERE sura = '$sr' AND aya = '$ay'"; }else { $sql="UPDATE $tb SET bok = '$kod' WHERE no = '$no'"; } }else { if (is_numeric($tb)) { $tbx = "quran_text"; $sr = $tb; #sura $ay = $no; #aya $sql="UPDATE $tbx SET note = '$dat' WHERE sura = '$sr' AND aya = '$ay'"; }else { $sql="UPDATE $tb SET note = '$dat' WHERE no = '$no'"; } } #echo "

Hasil : kode='$kod', $sql

"; $buka=mysqli_query($link,$sql); if ($buka){ echo "

Suksess SAVED = $sql !

"; }else { echo "

FAIL REPLACE !

"; } } function savelog($im,$noa,$nob,$dat){ global $link; #INSERT INTO `h9log`(`no`, `imam`, `ket`) VALUES ("222","muslim","browsing") $sql = "INSERT INTO `h9log` (`sumber`,`noa`,`nob`,`ket`) VALUES ('$im','$noa','$nob','$dat')"; #echo "

Hasil : kode='$kod', $sql

"; $buka=mysqli_query($link,$sql); if ($buka){ echo "

Suksess SAVED LOG !

"; }else { echo "

FAIL REPLACE !

"; } } //---LATIHAN TAMBAH 2 KOLOM PADA SEMUA TABLE---- #--Fungsi ini berhasil dan sukses tampa ERROR-- #--Jangan diaktifkan atau di-Call, #--karena akan menhapus daftar BOOKMARK dan CATATAN ANDA !--- function tambahkolomdua(){ global $link; //---TAMBAH-KOLOM-BOOKMARK---- $sqlt1 ="ALTER TABLE tbukhari1 ADD bok varchar(1)"; $sqlt2 ="ALTER TABLE tmuslim2 ADD bok varchar(1)"; $sqlt3 ="ALTER TABLE tabudaud3 ADD bok varchar(1)"; $sqlt4 ="ALTER TABLE ttirmidzi4 ADD bok varchar(1)"; $sqlt5 ="ALTER TABLE tnasai5 ADD bok varchar(1)"; $sqlt6 ="ALTER TABLE tibnumajah6 ADD bok varchar(1)"; $sqlt7 ="ALTER TABLE tahmad7 ADD bok varchar(1)"; $sqlt8 ="ALTER TABLE tmalik8 ADD bok varchar(1)"; $sqlt9 ="ALTER TABLE tdarimi9 ADD bok varchar(1)"; $sqlt10 ="ALTER TABLE quran_text ADD bok varchar(1)"; //---TAMBAH-KOLOM-NOTAKU-CATATAN $sqlt11 ="ALTER TABLE tbukhari1 ADD note TEXT"; $sqlt12 ="ALTER TABLE tmuslim2 ADD note TEXT"; $sqlt13 ="ALTER TABLE tabudaud3 ADD note TEXT"; $sqlt14 ="ALTER TABLE ttirmidzi4 ADD note TEXT"; $sqlt15 ="ALTER TABLE tnasai5 ADD note TEXT"; $sqlt16 ="ALTER TABLE tibnumajah6 ADD note TEXT"; $sqlt17 ="ALTER TABLE tahmad7 ADD note TEXT"; $sqlt18 ="ALTER TABLE tmalik8 ADD note TEXT"; $sqlt19 ="ALTER TABLE tdarimi9 ADD note TEXT"; $sqlt20 ="ALTER TABLE quran_text ADD note TEXT"; for ($i = 1; $i <= 20; $i++) { $sqlx= ${'sqlt'.$i}; mysqli_query($link, $sqlx); } echo "

SUKSES TAMBAH KOLOM --BOK-- dan --NOTE-- !

"; } //---END LATIHAN TAMBAH 2 KOLOM TABEL function kopikolomall(){ global $link; #$sql1 ="UPDATE tbukhari1 SET uarab = harab"; $sql1 ="UPDATE tbukhari1 SET uarab = harab"; $sql2 ="UPDATE tmuslim2 SET uarab = harab"; $sql3 ="UPDATE tabudaud3 SET uarab = harab"; $sql4 ="UPDATE ttirmidzi4 SET uarab = harab"; $sql5 ="UPDATE tnasai5 SET uarab = harab"; $sql6 ="UPDATE tibnumajah6 SET uarab = harab"; $sql7 ="UPDATE tahmad7 SET uarab = harab"; $sql8 ="UPDATE tmalik8 SET uarab = harab"; $sql9 ="UPDATE tdarimi9 SET uarab = harab"; # OK for ($i = 1; $i <= 9; $i++) { $sqlx= ${'sql'.$i}; mysqli_query($link, $sqlx); } #mysqli_query($link,$sql1); } function kopikolom($t){ global $link; $sql ="UPDATE $t SET uarab = harab"; $buka=mysqli_query($link,$sql); if ($buka){ echo "

Suksess KOPY COLUMN from TABLE --$t--!

"; }else { echo "

FAIL REPLACE !

"; } } function hapuskolom(){ global $link; $sqlt1 ="ALTER TABLE tbukhari1 DROP COLUMN uarab"; $sqlt2 ="ALTER TABLE tmuslim2 DROP COLUMN uarab"; $sqlt3 ="ALTER TABLE tabudaud3 DROP COLUMN uarab"; $sqlt4 ="ALTER TABLE ttirmidzi4 DROP COLUMN uarab"; $sqlt5 ="ALTER TABLE tnasai5 DROP COLUMN uarab"; $sqlt6 ="ALTER TABLE tibnumajah6 DROP COLUMN uarab"; $sqlt7 ="ALTER TABLE tahmad7 DROP COLUMN uarab"; $sqlt8 ="ALTER TABLE tmalik8 DROP COLUMN uarab"; $sqlt9 ="ALTER TABLE tdarimi9 DROP COLUMN uarab"; for ($i = 1; $i <= 9; $i++) { $sqlx= ${'sqlt'.$i}; mysqli_query($link, $sqlx); } } #ALTER TABLE tbl_Country DROP COLUMN IsDeleted; #====BELOW-IS-INI-FILE-READ-WRITE==== function put_ini_file($config, $file, $has_section = false, $write_to_file = true){ $fileContent = ''; if(!empty($config)){ foreach($config as $i=>$v){ if($has_section){ $fileContent .= "[".$i."]\n\r" . put_ini_file($v, $file, false, false); } else{ if(is_array($v)){ foreach($v as $t=>$m){ $fileContent .= $i."[".$t."] = ".(is_numeric($m) ? $m : '"'.$m.'"') . "\n\r"; } } else $fileContent .= $i . " = " . (is_numeric($v) ? $v : '"'.$v.'"') . "\n\r"; } } } if($write_to_file && strlen($fileContent)) return file_put_contents($file, $fileContent, LOCK_EX); else return $fileContent; } #====END-OF-INI-FILE-READ-WRITE==== #==HITUNG JUMLAH DATA YANG DICARI PER TABEL ======== function hitungdata($tb,$cr){ if (!empty($tb) && !empty($cr)){ global $link; $st = "`$tb` WHERE (no LIKE '$cr' OR kitab LIKE '%$cr%' OR bab LIKE '%$cr%' OR hindo LIKE '%$cr%' OR harab LIKE '%$cr%' OR uarab LIKE '%$cr%') ORDER BY no ASC "; $query = "SELECT COUNT(*) as `num` FROM {$st}"; $sql = mysqli_query($link,$query); $row = mysqli_fetch_array($sql); #if ((!empty($row['num'])) || ($row['num'] >= 1)) if ($row['num'] === NULL) { return 0; }else { return $row['num']; #return "Imam ".$tb.", Ditemukan ".$row['num']." Hadits"; } } } #---FUNGSI UNTUK CETAK DATA DALAM TAB PER TABLE- function boknote($tb,$no,$dat,$imgb,$imgn){ echo '
'; if ($imgb != "B"){ $imgb = "bintanga.png"; echo ''; }else { $imgb = "bintangb.png"; echo '
Bookmark
'; } if (($imgn != NULL) || ($imgn != "")){ $imgn = "noteb.png"; echo '
Catatan
'; } else{ $imgn = "notea.png"; echo '
Catatan
'; } #echo ''; #echo '
'.$imgn.','.$imgb.','.$dat.','.$no.','.$tb.': Terakhir dilihat
'; echo '
'; #-----DIV FOR SET CATATAN dan SHOW CATATAN------- #------- DIV UNTUK BOOKMARK-------- echo ''; #------ DIV UNTUK CATATAN----------- echo ' '; #-----END-DIV FOR SET CATATAN dan SHOW CATATAN------- echo '
'; } function cetakdatacari($tb,$cr){ global $link; $page = (int) (!isset($_GET["page"]) ? 1 : $_GET["page"]); $limit = 12; $startpoint = ($page * $limit) - $limit; $pn=basename($_SERVER['PHP_SELF']); #$cr = trim($_SESSION['q']); //get text to search from session... $cra = $cr; $cr = str_replace(' ', '%', $cr); #$cra = str_replace('%', ' ', $cr); $statement = "`$tb` WHERE (no LIKE '$cr' OR kitab LIKE '%$cr%' OR bab LIKE '%$cr%' OR hindo LIKE '%$cr%' OR harab LIKE '%$cr%' OR uarab LIKE '%$cr%') ORDER BY no ASC "; $total = hitungdata($tb,$cr); if (empty($total)) {$total="data kosong";exit;} echo "
Imam ".gtba($tb).", Ditemukan $total Hadits untuk kata ".$cra."
"; echo '
'.pagination($statement,$limit,$page).'
'; //show records $i = ($limit * $page) - $limit; $sql = "SELECT * FROM {$statement} LIMIT {$startpoint} , {$limit}"; $query = mysqli_query($link, $sql); while ($row = mysqli_fetch_assoc($query)) { //-------------------------- $i = $i+1; $cr = str_replace('%', ' ', $cr); $acr = explode(' ', $cr); $jm=count($acr); //----------------------------------------------------- $fl1 = $row['no']; $fl2 = $row['kitab']; $fl3 = $row['bab']; $fl4 = $row['hindo']; $fl5 = $row['harab']; #$fl6 = $row['uarab']; $fl7 = $row['bok']; $fl8 = $row['note']; # tesss-baris 149 //----------------------------------------------------- for ($x = 0; $x < $jm; $x++) { $fl1 = str_ireplace($acr[$x], cc($acr[$x]), $fl1); $fl2 = str_ireplace($acr[$x], cc($acr[$x]), $fl2); $fl3 = str_ireplace($acr[$x], cc($acr[$x]), $fl3); $fl4 = str_ireplace($acr[$x], cc($acr[$x]), $fl4); $fl5 = str_ireplace($acr[$x], cc($acr[$x]), $fl5); #$fl6 = str_ireplace($acr[$x], cc($acr[$x]), $fl6); } echo'
'.$i.' '.$row['sumber'].' No.'.$fl1.' '.$fl2.' '.$fl3.'
'; #echo '
'; # kontent langsung terbuka echo '
'; # kontent tersembunyi click untuk buka #echo ''; echo ''; //echo ''; echo ''; echo boknote($tb,$row['no'],$fl8,$fl7,$fl8).''; #echo boknote("$fl1").''; echo '
'.$fl4.''.$fl5.'
'.$fl5.'
'.$fl4.'
'.$fl4.''.$row['harab'].'
'; #echo boknote('1','`'.$fl2.'`').'
'; echo '
'; } echo '
Kembali
'; } #---DIBAWAH-FUNGSI2-UNTUK-PRINTOUT-ALQURAN---- #---==================================================== function nosurah($s){ for ($i=1; $i<=114; $i++){ $ns=namasurah($i); if ($s == $ns) { return $i; break; } } } function namasurah($i){ $nsurah = array ("No Surah", "Al-Faatihah", "Al-Baqarah", "Ali Imran", "An-Nisaa", "Al-Maaidah", "Al-Anam", "Al-Araaf", "Al-Anfaal", "At-Taubah", "Yunus", "Huud", "Yusuf", "Ar-Rad", "Ibrahim", "Al-Hijr", "An-Nahl", "Al-Israa", "Al-Kahfi", "Maryam", "Thaahaa", "Al-Anbiyaa", "Al-Hajj", "Al-Muminuun", "An-Nuur", "Al-Furqaan", "Asy-Syuaraa", "An-Naml", "Al-Qashash", "Al-Ankabuut", "Ar-Ruum", "Luqman", "As-Sajdah", "Al-Ahzab", "Saba", "Faathir", "Yaasiin", "Ash-Shaaffat", "Shaad", "Az-Zumar", "Al-Mumin", "Fushshilat", "Asy-Syuura", "Az-Zukhruf", "Ad-Dukhaan", "Al-Jaatsiyah", "Al-Ahqaaf", "Muhammad", "Al-Fath", "Al-Hujuraat", "Qaaf", "Adz-Dzariyaat", "Ath-Thuur", "An-Najm", "Al-Qamar", "Ar-Rahmaan", "Al-Waaqiah", "Al-Hadiid", "Al-Mujaadilah", "Al-Hasyr", "Al-Mumtahanah", "Ash-Shaff", "Al-Jumuah", "Al-Munaafiquun", "At-Taghaabun", "Ath-Thalaaq", "At-Tahriim", "Al-Mulk", "Al-Qalam", "Al-Haaqqah", "Al-Maaarij", "Nuh", "Al-Jin", "Al-Muzzammil", "Al-Muddatstsir", "Al-Qiyaamah", "Al-Insaan", "Al-Mursalaat", "An-Naba", "An-Naziat", "Abasa", "At-Takwiir", "Al-Infithaar", "Al-Muthaffifiin", "Al-Insyiqaaq", "Al-Buruuj", "Ath-Thaariq", "Al-Alaa", "Al-Ghaasyiyah", "Al-Fajr", "Al-Balad", "Asy-Syams", "Al-Lail", "Adh-Dhuhaa", "Alam Nasyrah", "At-Tiin", "Al-Alaq", "Al-Qadr", "Al-Bayyinah", "Al-Zalzalah", "Al-Aadiyaat", "Al-Qaariah", "At-Takaatsur", "Al-Ashr", "Al-Humazah", "Al-Fiil", "Quraisy", "Al-Maauun", "Al-Kautsar", "Al-Kaafiruun", "An-Nashr", "Al-Lahab", "Al-Ikhlash", "Al-Falaq", "An-Naas"); if (!empty($i)){ return $nsurah[$i];} } function cetaksurahlist(){ $sr1 =' 1Al-Faatihah 7Makkiyyah '; $sr2 =' 2Al-Baqarah 286Madaniyyah '; $sr3 =' 3Ali Imran 200Madaniyyah '; $sr4 =' 4An-Nisaa 176Madaniyyah '; $sr5 =' 5Al-Maa`idah 120Madaniyyah '; $sr6 =' 6Al-Anam 165Makkiyyah '; $sr7 =' 7Al-Araaf 206Makkiyyah '; $sr8 =' 8Al-Anfaal 75Madaniyyah '; $sr9 =' 9At-Taubah 129Madaniyyah '; $sr10 =' 10Yunus 109Makkiyyah '; $sr11 =' 11Huud 123Makkiyyah '; $sr12 =' 12Yusuf 111Makkiyyah '; $sr13 =' 13Ar-Rad 43Madaniyyah '; $sr14 =' 14Ibrahim 52Makkiyyah '; $sr15 =' 15Al-Hijr 99Makkiyyah '; $sr16 =' 16An-Nahl 128Makkiyyah '; $sr17 =' 17Al-Israa 111Makkiyyah '; $sr18 =' 18Al-Kahfi 110Makkiyyah '; $sr19 =' 19Maryam 98Makkiyyah '; $sr20 =' 20Thaahaa 135Makkiyyah '; $sr21 =' 21Al-Anbiyaa 112Makkiyyah '; $sr22 =' 22Al-Hajj 78Madaniyyah '; $sr23 =' 23Al-Muminuun 118Makkiyyah '; $sr24 =' 24An-Nuur 64Madaniyyah '; $sr25 =' 25Al-Furqaan 77Makkiyyah '; $sr26 =' 26Asy-Syuaraa 227Makkiyyah '; $sr27 =' 27An-Naml 93Makkiyyah '; $sr28 =' 28Al-Qashash 88Makkiyyah '; $sr29 =' 29Al-Ankabuut 69Makkiyyah '; $sr30 =' 30Ar-Ruum 60Makkiyyah '; $sr31 =' 31Luqman 34Makkiyyah '; $sr32 =' 32As-Sajdah 30Makkiyyah '; $sr33 =' 33Al-Ahzab 73Madaniyyah '; $sr34 =' 34Saba 54Makkiyyah '; $sr35 =' 35Faathir 45Makkiyyah '; $sr36 =' 36Yaasiin 83Makkiyyah '; $sr37 =' 37Ash-Shaaffat 182Makkiyyah '; $sr38 =' 38Shaad 88Makkiyyah '; $sr39 =' 39Az-Zumar 75Makkiyyah '; $sr40 =' 40Al-Mumin 85Makkiyyah '; $sr41 =' 41Fushshilat 54Makkiyyah '; $sr42 =' 42Asy-Syuura 53Makkiyyah '; $sr43 =' 43Az-Zukhruf 89Makkiyyah '; $sr44 =' 44Ad-Dukhaan 59Makkiyyah '; $sr45 =' 45Al-Jaatsiyah 37Makkiyyah '; $sr46 =' 46Al-Ahqaaf 35Makkiyyah '; $sr47 =' 47Muhammad 38Madaniyyah '; $sr48 =' 48Al-Fath 29Madaniyyah '; $sr49 =' 49Al-Hujuraat 18Madaniyyah '; $sr50 =' 50Qaaf 45Makkiyyah '; $sr51 =' 51Adz-Dzariyaat 60Makkiyyah '; $sr52 =' 52Ath-Thuur 49Makkiyyah '; $sr53 =' 53An-Najm 62Makkiyyah '; $sr54 =' 54Al-Qamar 55Makkiyyah '; $sr55 =' 55Ar-Rahmaan 78Madaniyyah '; $sr56 =' 56Al-Waaqiah 96Makkiyyah '; $sr57 =' 57Al-Hadiid 29Madaniyyah '; $sr58 =' 58Al-Mujaadilah 22Madaniyyah '; $sr59 =' 59Al-Hasyr 24Madaniyyah '; $sr60 =' 60Al-Mumtahanah 13Madaniyyah '; $sr61 =' 61Ash-Shaff 14Madaniyyah '; $sr62 =' 62Al-Jumuah 11Madaniyyah '; $sr63 =' 63Al-Munaafiquun 11Madaniyyah '; $sr64 =' 64At-Taghaabun 18Madaniyyah '; $sr65 =' 65Ath-Thalaaq 12Madaniyyah '; $sr66 =' 66At-Tahriim 12Madaniyyah '; $sr67 =' 67Al-Mulk 30Makkiyyah '; $sr68 =' 68Al-Qalam 52Makkiyyah '; $sr69 =' 69Al-Haaqqah 52Makkiyyah '; $sr70 =' 70Al-Maaarij 44Makkiyyah '; $sr71 =' 71Nuh 28Makkiyyah '; $sr72 =' 72Al-Jin 28Makkiyyah '; $sr73 =' 73Al-Muzzammil 20Makkiyyah '; $sr74 =' 74Al-Muddatstsir 56Makkiyyah '; $sr75 =' 75Al-Qiyaamah 40Makkiyyah '; $sr76 =' 76Al-Insaan 31Madaniyyah '; $sr77 =' 77Al-Mursalaat 50Makkiyyah '; $sr78 =' 78An-Naba 40Makkiyyah '; $sr79 =' 79An-Naziat 46Makkiyyah '; $sr80 =' 80Abasa 42Makkiyyah '; $sr81 =' 81At-Takwiir 29Makkiyyah '; $sr82 =' 82Al-Infithaar 19Makkiyyah '; $sr83 =' 83Al-Muthaffifiin 36Makkiyyah '; $sr84 =' 84Al-Insyiqaaq 25Makkiyyah '; $sr85 =' 85Al-Buruuj 22Makkiyyah '; $sr86 =' 86Ath-Thaariq 17Makkiyyah '; $sr87 =' 87Al-Alaa 19Makkiyyah '; $sr88 =' 88Al-Ghaasyiyah 26Makkiyyah '; $sr89 =' 89Al-Fajr 30Makkiyyah '; $sr90 =' 90Al-Balad 20Makkiyyah '; $sr91 =' 91Asy-Syams 15Makkiyyah '; $sr92 =' 92Al-Lail 21Makkiyyah '; $sr93 =' 93Adh-Dhuhaa 11Makkiyyah '; $sr94 =' 94Alam Nasyrah 8Makkiyyah '; $sr95 =' 95At-Tiin 8Makkiyyah '; $sr96 =' 96Al-Alaq 19Makkiyyah '; $sr97 =' 97Al-Qadr 5Makkiyyah '; $sr98 =' 98Al-Bayyinah 8Madaniyyah '; $sr99 =' 99Al-Zalzalah 8Madaniyyah '; $sr100 =' 100Al-Aadiyaat 11Makkiyyah '; $sr101 =' 101Al-Qaariah 11Makkiyyah '; $sr102 =' 102At-Takaatsur 8Makkiyyah '; $sr103 =' 103Al-Ashr 3Makkiyyah '; $sr104 =' 104Al-Humazah 9Makkiyyah '; $sr105 =' 105Al-Fiil 5Makkiyyah '; $sr106 =' 106Quraisy 4Makkiyyah '; $sr107 =' 107Al-Maauun 7Makkiyyah '; $sr108 =' 108Al-Kautsar 3Makkiyyah '; $sr109 =' 109Al-Kaafiruun 6Makkiyyah '; $sr110 =' 110An-Nashr 3Madaniyyah '; $sr111 =' 111Al-Lahab 5Makkiyyah '; $sr112 =' 112Al-Ikhlash 4Makkiyyah '; $sr113 =' 113Al-Falaq 5Makkiyyah '; $sr114 =' 114An-Naas 6Makkiyyah '; echo '"; } function hitungdataquran($tb,$cr){ global $link; $st = "`$tb` WHERE (sura LIKE '$cr' OR aya LIKE '%$cr%' OR text LIKE '%$cr%' OR indo LIKE '%$cr%' OR uarab LIKE '%$cr%') ORDER BY sura AND aya ASC "; $query = "SELECT COUNT(*) as `num` FROM {$st}"; $sql = mysqli_query($link,$query); $row = mysqli_fetch_array($sql); #is_null($result['column']) #$result['column'] === NULL if ($row['num'] === NULL) { return 0; } #if ((!empty($row['num'])) || ($row['num'] >= 1)) else{ return $row['num']; #return "Imam ".$tb.", Ditemukan ".$row['num']." Hadits"; } } function quranpersurat($tb,$surahno){ global $link; echo '
'; $page = (int) (!isset($_GET["page"]) ? 1 : $_GET["page"]); $limit = 30; $startpoint = ($page * $limit) - $limit; $statement = "`$tb` WHERE sura = '$surahno' ORDER BY sura AND aya ASC "; echo '
'.pagination($statement,$limit,$page).'
'; echo '
'; # kontent langsung terbuka echo '
'; $i = ($limit * $page) - $limit; $sql = "SELECT * FROM {$statement} LIMIT {$startpoint} , {$limit}"; $query = mysqli_query($link, $sql); while ($row = mysqli_fetch_assoc($query)) { //-------------------------- $i = $i+1; //----------------------------------------------------- $fl0 = $row['no']; $fl1 = $row['sura']; $fl2 = $row['aya']; $fl3 = $row['text']; $fl4 = $row['indo']; $fl5 = $row['bok']; $fl6 = $row['note']; $ket = "Ayat : Browsing"; $ap = ""; //----------------------------------------------------- #echo $fl3.' #echo $fl3.""; echo $fl3.''; echo '['.$fl2.'] '; echo ''; } echo '
'; echo '
'; echo '
Kembali
'; echo '
'; } function cetakdataqurancari($tb,$cr){ global $link; $page = (int) (!isset($_GET["page"]) ? 1 : $_GET["page"]); $limit = 12; $startpoint = ($page * $limit) - $limit; #$cr = trim($_SESSION['q']); //get text to search from session... $cra = $cr; $cr = str_replace(' ', '%', $cr); #$cra = str_replace('%', ' ', $cr); $statement = "`$tb` WHERE (sura LIKE '$cr' OR aya LIKE '%$cr%' OR text LIKE '%$cr%' OR indo LIKE '%$cr%' OR uarab LIKE '%$cr%') ORDER BY sura AND aya ASC "; $total = hitungdataquran($tb,$cr); if (empty($total)) {$total="data kosong";exit;} echo "
Al-Quran, Ditemukan $total Ayat untuk kata ".$cra."
"; echo '
'.pagination($statement,$limit,$page).'
'; //show records $i = ($limit * $page) - $limit; $sql = "SELECT * FROM {$statement} LIMIT {$startpoint} , {$limit}"; $query = mysqli_query($link, $sql); while ($row = mysqli_fetch_assoc($query)) { //-------------------------- $i = $i+1; $cr = str_replace('%', ' ', $cr); $acr = explode(' ', $cr); $jm=count($acr); //----------------------------------------------------- $fl0 = $row['no']; $fl1 = $row['sura']; $fl2 = $row['aya']; $fl3 = $row['text']; $fl4 = $row['indo']; $fl5 = $row['bok']; $fl6 = $row['note']; $ap = ""; //----------------------------------------------------- for ($x = 0; $x < $jm; $x++) { $fl0 = str_ireplace($acr[$x], cc($acr[$x]), $fl0); $fl1 = str_ireplace($acr[$x], cc($acr[$x]), $fl1); $fl2 = str_ireplace($acr[$x], cc($acr[$x]), $fl2); $fl3 = str_ireplace($acr[$x], cc($acr[$x]), $fl3); $fl4 = str_ireplace($acr[$x], cc($acr[$x]), $fl4); } echo'
'.$i.' '.$fl1.'. '.namasurah($fl1).' Ayat : '.$fl2.'
'; #echo '
'; # kontent langsung terbuka echo '
'; # kontent tersembunyi click untuk buka echo ''; //echo ''; echo ''; echo boknote($row['sura'],$row['aya'],$fl1,$fl5,$fl6).''; echo '
'.$fl3.'
'.$fl4.'
'.$fl4.''.$row['harab'].'
'; #echo boknote($tb,$row['no'],$fl8,$fl7,$fl8).'
'; echo '
'; } echo '
Kembali
'; } //=========================================================== //=======Fungsi dibawah untuk lcari.php=============== function langsungcari($tb,$cr){ if ($tb == "0"){ echo '
Pilih Imam...!
'; }else{ function gn($tb) { if ($tb == 'tbukhari1') { return("Bukhari");} if ($tb == 'tmuslim2') { return("Muslim");} if ($tb == 'tabudaud3') { return("Abu Daud");} if ($tb == 'ttirmidzi4') { return("Tirmidzi");} if ($tb == 'tnasai5') { return("Nasai");} if ($tb == 'tibnumajah6') { return("Ibnu Majah");} if ($tb == 'tahmad7') { return("Ahmad");} if ($tb == 'tmalik8') { return("Malik");} if ($tb == 'tdarimi9') { return("Ad Darimi");} } global $link; $cra = $cr; $cr = str_replace(' ', '%', $cr); $statement = "`$tb` WHERE (no LIKE '$cr') ORDER BY no ASC "; $sql = "SELECT * FROM {$statement} "; $query = mysqli_query($link, $sql); while ($row = mysqli_fetch_assoc($query)) { //-------------------------- $cr = str_replace('%', ' ', $cr); $acr = explode(' ', $cr); $jm=count($acr); //----------------------------------------------------- $fl1 = $row['no']; $fl2 = $row['kitab']; $fl3 = $row['bab']; $fl4 = $row['hindo']; $fl5 = $row['harab']; //----------------------------------------------------- //------DIV CLASS From Header langsungcari.php--------- echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '
Imam.
'.gn($tb).'
No.
'.$fl1.'
Kitab
'.$fl2.'
Bab
'.$fl3.'
Arab
'.$fl5.'
Indo
'.$fl4.'
'; echo'
'; } } } function ga($a) { if ($a == "1") { return('tbukhari1');} if ($a == "2") { return('tmuslim2');} if ($a == "3") { return('tabudaud3');} if ($a == "4") { return('ttirmidzi4');} if ($a == "5") { return('tnasai5');} if ($a == "6") { return('tibnumajah6');} if ($a == "7") { return('tahmad7');} if ($a == "8") { return('tmalik8');} if ($a == "9") { return('tdarimi9');} if ($a == "0") { return("0");} } #==HITUNG JUMLAH DATA YANG DICARI PER TABEL ======== function gtotal($tb){ if (!empty($tb)){ global $link; $tb = ga($tb); $query = "SELECT COUNT(*) as `num` FROM {$tb}"; $sql = mysqli_query($link,$query); $row = mysqli_fetch_array($sql); if ($row['num'] === NULL) { return 0; }else { return $row['num']; } } } ?>