$C=chr(34);
echo "
بحث - Powered by VBZooM";
?>
// الاتصال بقاعدة البيانات
include("admin/config.php");
$Connect =mysql_connect($DBHostName,$DBUserName,$DBPassword);
$Select =mysql_select_db($DBName,$Connect);
if ($REQUEST_METHOD=="POST" or $FindWord!="")
{
$TABLE= "";
$TD[1]="";
$TD[2]=" | ";
$STD=" | ";
$TR="";
$STABLE="
";
if ($SearchIn==1) {$PageNo=50;}
if ($SearchIn==2) {$PageNo=10;}
if ($SearchIn==3) {$PageNo=2;}
if ($SearchIn==4) {$PageNo=50;}
if ($SearchIn==5) {$PageNo=50;}
Echo $TABLE;
Echo "";
Echo "";
Echo "Germany";
Echo " | ";
Echo "";
Echo "";
Echo "English";
Echo " | ";
Echo "";
Echo "";
Echo "ابن كثير";
Echo " | ";
Echo "";
Echo "";
Echo "الجلالين";
Echo " | ";
Echo "";
Echo "";
Echo "القرآن الكريم";
Echo " | ";
Echo "";
Echo "";
Echo "الصفحة";
Echo " | ";
Echo "";
Echo "";
Echo "الآية";
Echo " | ";
Echo "";
Echo "";
Echo "السورة";
Echo " | ";
Echo "";
Echo "";
Echo "الجزءة";
Echo " | ";
if ($Page=="") {$Page=1;}
$FromRecord=($Page-1)*$PageNo;
if ($AloneWord==1) {$FindWord=" $FindWord ";}
if ($SearchIn==1) {$Sql = "select * from quran where BINARY Verse Like'%$FindWord%' and SuraNo>=$FromSuraNo and SuraNo<=$ToSuraNo order by QuranID ASC LIMIT $FromRecord,$PageNo";}
if ($SearchIn==2) {$Sql = "select * from quran where BINARY Meaning1 Like'%$FindWord%' and SuraNo>=$FromSuraNo and SuraNo<=$ToSuraNo order by QuranID ASC LIMIT $FromRecord,$PageNo";}
if ($SearchIn==3) {$Sql = "select * from quran where BINARY Meaning2 Like'%$FindWord%' and SuraNo>=$FromSuraNo and SuraNo<=$ToSuraNo order by QuranID ASC LIMIT $FromRecord,$PageNo";}
if ($SearchIn==4) {$Sql = "select * from quran where English Like'%$FindWord%' and SuraNo>=$FromSuraNo and SuraNo<=$ToSuraNo order by QuranID ASC LIMIT $FromRecord,$PageNo";}
if ($SearchIn==5) {$Sql = "select * from quran where Germany Like'%$FindWord%' and SuraNo>=$FromSuraNo and SuraNo<=$ToSuraNo order by QuranID ASC LIMIT $FromRecord,$PageNo";}
$Result = mysql_query($Sql);
while ($Row = mysql_fetch_array($Result))
{
Echo $TR;
$QuranID=$Row[$QuranID];
Echo "";
Echo "";
Echo "";
Echo $STD;
Echo " | ";
Echo "";
Echo "";
Echo $STD;
Echo " | ";
Echo "";
Echo "";
Echo $STD;
Echo " | ";
Echo "";
Echo "";
Echo $STD;
Echo " | ";
Echo "";
Echo "";
Echo $STD;
Echo $TD[1];
Echo "";
Echo $Row[PageNo];
Echo $STD;
Echo $TD[1];
Echo "";
Echo $Row[VerseNo];
Echo $STD;
Echo $TD[2];
Echo "";
Echo $Row[SuraName];
Echo $STD;
Echo $TD[1];
Echo "";
Echo $Row[PartNo];
Echo $STD;
Echo $TR;
if ($SearchIn==1) {$SearchText=$Row[Verse];}
if ($SearchIn==2) {$SearchText=$Row[Meaning1];}
if ($SearchIn==3) {$SearchText=$Row[Meaning2];}
if ($SearchIn==4) {$SearchText=$Row[English];}
if ($SearchIn==5) {$SearchText=$Row[Germany];}
$SearchText = str_replace("$FindWord", "$FindWord", $SearchText);
if ($SearchIn==1 or $SearchIn==2 or $SearchIn==3)
{
Echo " | ";
}
else
{
Echo " | ";
}
Echo "";
Echo $SearchText;
Echo " | ";
}
Echo $STABLE;
Echo "
";
Echo "";
// طباعة ارقام الصفحات
if ($SearchIn==1) {$RowsNo=mysql_num_rows(mysql_query("select * from quran where BINARY Verse Like'%$FindWord%' and SuraNo>=$FromSuraNo and SuraNo<=$ToSuraNo"));}
if ($SearchIn==2) {$RowsNo=mysql_num_rows(mysql_query("select * from quran where BINARY Meaning1 Like'%$FindWord%' and SuraNo>=$FromSuraNo and SuraNo<=$ToSuraNo"));}
if ($SearchIn==3) {$RowsNo=mysql_num_rows(mysql_query("select * from quran where BINARY Meaning2 Like'%$FindWord%' and SuraNo>=$FromSuraNo and SuraNo<=$ToSuraNo"));}
if ($SearchIn==4) {$RowsNo=mysql_num_rows(mysql_query("select * from quran where English Like'%$FindWord%' and SuraNo>=$FromSuraNo and SuraNo<=$ToSuraNo"));}
if ($SearchIn==5) {$RowsNo=mysql_num_rows(mysql_query("select * from quran where Germany Like'%$FindWord%' and SuraNo>=$FromSuraNo and SuraNo<=$ToSuraNo"));}
$MaxPage=(Int) ((($RowsNo-1)/$PageNo)+1);
Echo "";
Echo "
";
Echo "";
Echo "معلومات البحث";
Echo " | ";
Echo "";
Echo "";
Echo "";
Echo "$RowsNo";
Echo " | ";
Echo "";
Echo "";
Echo "عدد الآيات";
Echo " | ";
Echo "
";
Echo "";
Echo "";
Echo "الصفحات";
Echo " | ";
Echo "
";
Echo "";
for ($i=1 ;$i<=$MaxPage ; $i++)
{
If ($i==$Page)
{
Echo " | $i ";
}
Else
{
Echo " | $i";
}
}
Echo " |
";
Echo " | ";
Echo "
";
}
else
{
?>
$FONT[1]="";
$TABLE= "";
$TD[1]="";
$TD[2]=" | ";
$STD=" | ";
$TR="";
$STABLE="
";
Echo "