0) { $num_rows= mysqli_num_rows($result); echo '
This word has appeared '.$num_rows.' times
'; echo ''; $cols=16; while($row = mysqli_fetch_row($result)) { for($i = 0; $i<= $cols; $i++) { if($i==0){ if($row[2]<=9)$sn='00'.$row[2]; if($row[2]>9 and $row[2]<=99)$sn='0'.$row[2]; if($row[2]>99)$sn=$row[2]; if($row[1]<=9)$an='00'.$row[1]; if($row[1]>9 and $row[1]<=99)$an='0'.$row[1]; if($row[1]>99)$an=$row[1]; $a_idnext=$row[0]+1; echo ''; if ($row[1]=="0" && $row[2]>1){ $snan='001001';}else{ $snan=$sn.$an;} echo ''; echo ''; echo ''; echo ''; echo ''; } } echo "\n"; } } //----------------- function RESULT7($link,$query,$vol_no, $book_no,$sb_no,$narrator){ $result = mysqli_query($link,$query) or die ("Error in query: $query. ".mysqli_error()); if (mysqli_num_rows($result) > 0) { echo '
|Surah| '.$row[2].' |Juz| '.$row[3].' |Ruku| '.$row[4].' '.$row[16].' |Hizb|'.$row[5].' |Ayat| '.$row[1].' |Next
snan= '.$snan.'
|s_arabic| '.$row[9].' |Listen|

|Transliteration| '.$row[13].'

|English| '.$row[7].'

|Urdu1| '.$row[8].'

'; $cols=16; while($row = mysql_fetch_row($result)) { for($i = 0; $i<= $cols; $i++) { if($i==0){ if($row[6]<=9)$bn='00'.$row[6]; if($row[6]>9 and $row[6]<=99)$bn='0'.$row[4]; if($row[6]>99)$bn=$row[6]; echo '

| Vol | '.$row[2].' | Book | '.$row[3].' '.$row[4].' | Number | '.$row[1].' |

| Narrated by '.$row[5].'

| Text |: '.$row[6]; echo '

'; } } echo "\n"; } } echo '

';} $BOOK_TITLE=array('Select a Book','1. Revelation','2. Belief','3. Knowledge','4. Ablution','5. Bathing','6. Menstrual Period','7. Ablution with dust','8. Prayer (Salat)','9. Prayer Hall (Sutra)','10. Times of the Prayer','11. Call to Prayer','12. Characteristics of the Prayer','13. Friday Prayer','14. Fear Prayer','15. The Two Festivals (Eids)','16. Witr Prayer','17. Dua\' for the Rain (Istisqaa','18. Eclipses','19. Prostration','20. Shortening Prayers','21. Night Prayer (Tahajjud)','22. Action while Praying','23. Funeral (Al-Janaa\'iz)','24. Tax (Zakat)','25. Tax (Zakat ul Fitr)','26. Pilgrimaage (Hajj)','27. Minor Pilgrimage (Umrah)','28. Pilgrimage Prevented','29. Pilgrims Hunting Penalty','30. Virtues of Madinah','31. Fasting','32. Ramadan Prayer','33. Stay in Mosque (I\'tikaf)','34. Sales and Trade','35. Paid in Advance','36. Hiring','37. Debt Transfer','38. Business by Proxy','39. Agriculture','40. Distributing Water','41. Loans , Bankruptcy','42. Lost and Found','43. Opressions','44. Partnership','45. Mortgaging','46. Freeing Slaves','47. Gifts','48. Witnesses','49. Peacemaking','50. Conditions','51. Wills','52. Jihaad','53. One-fifth of Booty','54. Beginning of Creation','55. Prophets','56. Merits of Sunnah','57. The Companions','58. Merits of Al-Ansaar','59. Expeditions','60. Prophetic Commentary','61. Virtues of the Qur\'an','62. Marriage','63. Divorce','64. Supporting Family','65. Food, Meals','66. Sacrifice on Birth','67. Hunting, Slaughter','68. Al-Adha Sacrifice','69. Drinks','70. Patients','71. Medicine','72. Dress','73. Good Manners','74. Asking Permission','75. Invocations','76. Softening the Heart','77. Divine Will (Qadar)','78. Oaths and Vows','79. Unfulfilled Oaths','80. Inheritance Laws','81. Punishment Laws','82. Disbelievers (war)','83. Blood Money','84. Dealing with Apostates','85. Under Duress','86. Tricks','87. Interpretations of Dreams','88. End of the World','89. Judgments','90. Wishes','91. Truthful WWord','92. Holding Steadfast','93. Oneness of Allah'); //echo '
'; echo ''; echo '
'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '
'; //--------------------------------------- function RESULT13($link,$query,$dt,$t_no){ global $SURAH_NAME, $t_name, $t_por,$t_background, $t_theme,$t_subject,$t_topics,$t_title, $t_tfn; $result = mysqli_query($link,$query) or die ("Error in query: $query. ".mysqli_error()); if (mysqli_num_rows($result) > 0) { $num_rows= mysqli_num_rows($result); //echo '
This word has appeared '.$num_rows.' times
'; echo ''; $cols=16; while($row = mysqli_fetch_row($result)) { for($i = 0; $i<= $cols; $i++) { if($i==0){ if($row[0]<=9)$sn='00'.$row[0]; if($row[0]>9 and $row[0]<=99)$sn='0'.$row[0]; if($row[0]>99)$sn=$row[0]; if(!empty($row[0]))echo ''; if($t_name=="yes")if(!empty($row[1]))echo ''; if($t_por=="yes")if(!empty($row[2]))echo ''; if($t_background=="yes")if(!empty($row[16]))echo ''; if($t_theme=="yes")if(!empty($row[3]))echo ''; if($t_subject=="yes")if(!empty($row[4]))echo ''; if($t_topics=="yes"){ if(!empty($row[5]))echo ''; if(!empty($row[6]))echo ''; if(!empty($row[7]))echo ''; if(!empty($row[8]))echo ''; if(!empty($row[9]))echo ''; if(!empty($row[10]))echo ''; if(!empty($row[11]))echo ''; if(!empty($row[12]))echo ''; if(!empty($row[13]))echo ''; if(!empty($row[14]))echo ''; if(!empty($row[15]))echo ''; }//end of topics if($t_topics=="yes"){ if(!empty($row[17]))echo ''; if(!empty($row[18]))echo ''; if(!empty($row[19]))echo ''; if(!empty($row[20]))echo ''; if(!empty($row[21]))echo ''; if(!empty($row[22]))echo ''; if(!empty($row[23]))echo ''; if(!empty($row[24]))echo ''; if(!empty($row[25]))echo ''; if(!empty($row[26]))echo ''; }//end of topics if($t_tfn=="yes"){ if(!empty($row[27]))echo ''; if(!empty($row[28]))echo ''; if(!empty($row[29]))echo ''; if(!empty($row[30]))echo ''; if(!empty($row[31]))echo ''; if(!empty($row[32]))echo '';} }//end of tfn }//end of i==0 echo "\n"; }//end of for loop }//end of while echo '

|Surah: |'.$SURAH_NAME[$row[0]].'

|Name '.$row[0].':| '.$row[1].'

|Period of Revelation '.$row[0].':| '.$row[2].'

|Background '.$row[0].':| '.$row[16].'

|Theme '.$row[0].':| '.$row[3].'

|Subject '.$row[0].':| '.$row[4].'

|Topics| '.$row[5].'

|Topic '.$row[0].'.1:| '.$row[6].'

|Topic '.$row[0].'.2:| '.$row[7].'

|Topic '.$row[0].'.3:| '.$row[8].'

|Topic '.$row[0].'.4: | '.$row[9].'

|Topic '.$row[0].'.5| '.$row[10].'

|Topic '.$row[0].'.6| '.$row[11].'

|Topic '.$row[0].'.7| '.$row[12].'

|Topic '.$row[0].'.8| '.$row[13].'

|Topic '.$row[0].'.9| '.$row[14].'

|Topic '.$row[0].'.10| '.$row[15].'

|Title '.$row[0].'.1:|'.$row[17].'

|Title '.$row[0].'.2:|'.$row[18].'

|Title '.$row[0].'.3:|'.$row[19].'

|Title '.$row[0].'.4:|'.$row[20].'

|Title '.$row[0].'.5:|'.$row[21].'

|Title '.$row[0].'.6:|'.$row[22].'

|Title '.$row[0].'.7:|'.$row[23].'

|Title '.$row[0].'.8:|'.$row[24].'

|Title '.$row[0].'.9:|'.$row[25].'

|Title '.$row[0].'.10:|'.$row[26].'

'.$row[27].'

'.$row[28].'

'.$row[29].'

'.$row[30].'

'.$row[31].'

'.$row[32].'
';//end of number of rows }} function RESULT_SB($link,$query,$vol_no, $book_no,$sb_no,$narrator){ $result = mysqli_query($link,$query) or die ("Error in query: $query. ".mysqli_error()); if (mysqli_num_rows($result) > 0) { echo ''; $cols=16; while($row = mysqli_fetch_row($result)) { for($i = 0; $i<= $cols; $i++) { if($i==0){ if($row[6]<=9)$bn='00'.$row[6]; if($row[6]>9 and $row[6]<=99)$bn='0'.$row[4]; if($row[6]>99)$bn=$row[6]; echo '
'; echo ''; echo ''; } } echo "\n"; } } echo '
| Vol | '.$row[2].' | Book | '.$row[3].' '.$row[4].' | Number | '.$row[1].' |'; echo 'Narrated by '.$row[5].'
Text |: '.$row[6].'
';} //--------------------------------------- ?>