';
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 "";
}
//===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'
";
}
//===MENU====GET-BAB-in-TABLE===========
function getbab($tb,$kt,$nk) {
global $link;
$kt = $kt=addslashes($kt);
echo '
';
if ($tb != '')
{
$sql = "SELECT DISTINCT bab FROM $tb WHERE kitab = '$kt' ORDER BY bab ASC ";
$buka=mysqli_query($link,$sql);
$c=0;
while($hasil=mysqli_fetch_row($buka))
{
$c=$c+1;
$kt = str_replace('"', '?', $kt);
$bb = str_replace('"', '!', $hasil[0]);
$bb = str_replace('+G703', '', $bb);
#echo '';
echo'
'.$hasil[0].'
'.$c.'
';
}
}
echo "
";
}
//===MENU==GET-KITAB-IN-TABLE==========
function getkitab($tb) {
global $link;
echo '
';
if ($tb != '')
{
$sql = "SELECT DISTINCT kitab FROM $tb ORDER BY kitab ASC ";
$buka=mysqli_query($link,$sql);
$c=0;
while($hasil=mysqli_fetch_row($buka)){
$c=$c+1;
$kt = str_replace('"', '?', $hasil[0]);
$kt = $kt=addslashes($kt);
#echo $fl3.'';
echo '
'.$c. '.
'.$hasil[0].'
';
echo'
';
echo getbab($tb,$hasil[0],$c);
echo'
';
}
}
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 "
";
}
}
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 "
'.$imgn.','.$imgb.','.$dat.','.$no.','.$tb.': Terakhir dilihat
';
echo '
';
#-----DIV FOR SET CATATAN dan SHOW CATATAN-------
#------- DIV UNTUK BOOKMARK--------
echo '
'.$dat.'
';
#------ 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 "";
}
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 '
';
}
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."
';
}
//===========================================================
//=======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 '
Imam.
'.gn($tb).'
';
echo '
No.
'.$fl1.'
';
echo '
Kitab
'.$fl2.'
';
echo '
Bab
'.$fl3.'
';
echo '
Arab
'.$fl5.'
';
echo '
Indo
'.$fl4.'
';
echo '
';
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'];
}
}
}
?>