10-04-20, 11:18 AM
السلام عليكم ورحمة الله
عندي كود كبيره شويه يعمل استعلام في قاعدة البيانات
بس عند الطلب يتاخر في البحث
هل هناك طريقة لتسريغ الكود
هذا الكود
[attachment=24398]
بارك اله فيكم وشكرا
عندي كود كبيره شويه يعمل استعلام في قاعدة البيانات
بس عند الطلب يتاخر في البحث
هل هناك طريقة لتسريغ الكود
هذا الكود
[attachment=24398]
PHP كود :
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='SSB' and band='160m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mSSB1 = $result->num_rows;
if ($mSSB1 == "0" ) {
$SSB1 = '<td><p align="center"> </td>';
} else{
$SSB1 = '<td><p align="center">' . $mSSB1 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='SSB' and band='80m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mSSB2 = $result->num_rows;
if ($mSSB2 == "0" ) {
$SSB2 = '<td><p align="center"> </td>';
} else{
$SSB2 = '<td><p align="center">' . $mSSB2 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='SSB' and band='60m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mSSB3 = $result->num_rows;
if ($mSSB3 == "0" ) {
$SSB3 = '<td><p align="center"> </td>';
} else{
$SSB3 = '<td><p align="center">' . $mSSB3 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='SSB' and band='40m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mSSB4 = $result->num_rows;
if ($mSSB4 == "0" ) {
$SSB4 = '<td><p align="center"> </td>';
} else{
$SSB4 = '<td><p align="center">' . $mSSB4 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='SSB' and band='30m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mSSB5 = $result->num_rows;
if ($mSSB5 == "0" ) {
$SSB5 = '<td><p align="center"> </td>';
} else{
$SSB5 = '<td><p align="center">' . $mSSB5 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='SSB' and band='20m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mSSB6 = $result->num_rows;
if ($mSSB6 == "0" ) {
$SSB6 = '<td><p align="center"> </td>';
} else{
$SSB6 = '<td><p align="center">' . $mSSB6 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='SSB' and band='17m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mSSB7 = $result->num_rows;
if ($mSSB7 == "0" ) {
$SSB7 = '<td><p align="center"> </td>';
} else{
$SSB7 = '<td><p align="center">' . $mSSB7 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='SSB' and band='15m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mSSB8 = $result->num_rows;
if ($mSSB8 == "0" ) {
$SSB8 = '<td><p align="center"> </td>';
} else{
$SSB8 = '<td><p align="center">' . $mSSB8 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='SSB' and band='12m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mSSB9 = $result->num_rows;
if ($mSSB9 == "0" ) {
$SSB9 = '<td><p align="center"> </td>';
} else{
$SSB9 = '<td><p align="center">' . $mSSB9 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='SSB' and band='10m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mSSB10 = $result->num_rows;
if ($mSSB10 == "0" ) {
$SSB10 = '<td><p align="center"> </td>';
} else{
$SSB10 = '<td><p align="center">' . $mSSB10 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='FT8' and band='160m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mFT81 = $result->num_rows;
if ($mFT81 == "0" ) {
$FT81 = '<td><p align="center"> </td>';
} else{
$FT81 = '<td><p align="center">' . $mFT81 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='FT8' and band='80m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mFT82 = $result->num_rows;
if ($mFT82 == "0" ) {
$FT82 = '<td><p align="center"> </td>';
} else{
$FT82 = '<td><p align="center">' . $mFT82 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='FT8' and band='60m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mFT83 = $result->num_rows;
if ($mFT83 == "0" ) {
$FT83 = '<td><p align="center"> </td>';
} else{
$FT83 = '<td><p align="center">' . $mFT83 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='FT8' and band='40m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mFT84 = $result->num_rows;
if ($mFT84 == "0" ) {
$FT84 = '<td><p align="center"> </td>';
} else{
$FT84 = '<td><p align="center">' . $mFT84 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='FT8' and band='30m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mFT85 = $result->num_rows;
if ($mFT85 == "0" ) {
$FT85 = '<td><p align="center"> </td>';
} else{
$FT85 = '<td><p align="center">' . $mFT85 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='FT8' and band='20m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mFT86 = $result->num_rows;
if ($mFT86 == "0" ) {
$FT86 = '<td><p align="center"> </td>';
} else{
$FT86 = '<td><p align="center">' . $mFT86 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='FT8' and band='17m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mFT87 = $result->num_rows;
if ($mFT87 == "0" ) {
$FT87 = '<td><p align="center"> </td>';
} else{
$FT87 = '<td><p align="center">' . $mFT87 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='FT8' and band='15m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mFT88 = $result->num_rows;
if ($mFT88 == "0" ) {
$FT88 = '<td><p align="center"> </td>';
} else{
$FT88 = '<td><p align="center">' . $mFT88 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='FT8' and band='12m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mFT89 = $result->num_rows;
if ($mFT89 == "0" ) {
$FT89 = '<td><p align="center"> </td>';
} else{
$FT89 = '<td><p align="center">' . $mFT89 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='FT8' and band='10m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mFT810 = $result->num_rows;
if ($mFT810 == "0" ) {
$FT810 = '<td><p align="center"> </td>';
} else{
$FT810 = '<td><p align="center">' . $mFT810 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='CW' and band='160m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mCW1 = $result->num_rows;
if ($mCW1 == "0" ) {
$CW1 = '<td><p align="center"> </td>';
} else{
$CW1 = '<td><p align="center">' . $mCW1 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='CW' and band='80m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mCW2 = $result->num_rows;
if ($mCW2 == "0" ) {
$CW2 = '<td><p align="center"> </td>';
} else{
$CW2 = '<td><p align="center">' . $mCW2 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='CW' and band='60m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mCW3 = $result->num_rows;
if ($mCW3 == "0" ) {
$CW3 = '<td><p align="center"> </td>';
} else{
$CW3 = '<td><p align="center">' . $mCW3 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='CW' and band='40m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mCW4 = $result->num_rows;
if ($mCW4 == "0" ) {
$CW4 = '<td><p align="center"> </td>';
} else{
$CW4 = '<td><p align="center">' . $mCW4 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='CW' and band='30m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mCW5 = $result->num_rows;
if ($mCW5 == "0" ) {
$CW5 = '<td><p align="center"> </td>';
} else{
$CW5 = '<td><p align="center">' . $mCW5 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='CW' and band='20m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mCW6 = $result->num_rows;
if ($mCW6 == "0" ) {
$CW6 = '<td><p align="center"> </td>';
} else{
$CW6 = '<td><p align="center">' . $mCW6 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='CW' and band='17m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mCW7 = $result->num_rows;
if ($mCW7 == "0" ) {
$CW7 = '<td><p align="center"> </td>';
} else{
$CW7 = '<td><p align="center">' . $mCW7 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='CW' and band='15m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mCW8 = $result->num_rows;
if ($mCW8 == "0" ) {
$CW8 = '<td><p align="center"> </td>';
} else{
$CW8 = '<td><p align="center">' . $mCW8 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='CW' and band='12m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mCW9 = $result->num_rows;
if ($mCW9 == "0" ) {
$CW9 = '<td><p align="center"> </td>';
} else{
$CW9 = '<td><p align="center">' . $mCW9 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='CW' and band='10m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mCW10 = $result->num_rows;
if ($mCW10 == "0" ) {
$CW10 = '<td><p align="center"> </td>';
} else{
$CW10 = '<td><p align="center">' . $mCW10 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='MFSK' and band='160m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mMFSK1 = $result->num_rows;
if ($mMFSK1 == "0" ) {
$MFSK1 = '<td><p align="center"> </td>';
} else{
$MFSK1 = '<td><p align="center">' . $mMFSK1 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='MFSK' and band='80m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mMFSK2 = $result->num_rows;
if ($mMFSK2 == "0" ) {
$MFSK2 = '<td><p align="center"> </td>';
} else{
$MFSK2 = '<td><p align="center">' . $mMFSK2 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='MFSK' and band='60m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mMFSK3 = $result->num_rows;
if ($mMFSK3 == "0" ) {
$MFSK3 = '<td><p align="center"> </td>';
} else{
$MFSK3 = '<td><p align="center">' . $mMFSK3 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='MFSK' and band='40m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mMFSK4 = $result->num_rows;
if ($mMFSK4 == "0" ) {
$MFSK4 = '<td><p align="center"> </td>';
} else{
$MFSK4 = '<td><p align="center">' . $mMFSK4 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='MFSK' and band='30m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mMFSK5 = $result->num_rows;
if ($mMFSK5 == "0" ) {
$MFSK5 = '<td><p align="center"> </td>';
} else{
$MFSK5 = '<td><p align="center">' . $mMFSK5 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='MFSK' and band='20m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mMFSK6 = $result->num_rows;
if ($mMFSK6 == "0" ) {
$MFSK6 = '<td><p align="center"> </td>';
} else{
$MFSK6 = '<td><p align="center">' . $mMFSK6 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='MFSK' and band='17m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mMFSK7 = $result->num_rows;
if ($mMFSK7 == "0" ) {
$MFSK7 = '<td><p align="center"> </td>';
} else{
$MFSK7 = '<td><p align="center">' . $mMFSK7 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='MFSK' and band='15m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mMFSK8 = $result->num_rows;
if ($mMFSK8 == "0" ) {
$MFSK8 = '<td><p align="center"> </td>';
} else{
$MFSK8 = '<td><p align="center">' . $mMFSK8 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='MFSK' and band='12m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mMFSK9 = $result->num_rows;
if ($mMFSK9 == "0" ) {
$MFSK9 = '<td><p align="center"> </td>';
} else{
$MFSK9 = '<td><p align="center">' . $mMFSK9 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='MFSK' and band='10m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mMFSK10 = $result->num_rows;
if ($mMFSK10 == "0" ) {
$MFSK10 = '<td><p align="center"> </td>';
} else{
$MFSK10 = '<td><p align="center">' . $mMFSK10 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='RTTY' and band='160m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mRTTY1 = $result->num_rows;
if ($mRTTY1 == "0" ) {
$RTTY1 = '<td><p align="center"> </td>';
} else{
$RTTY1 = '<td><p align="center">' . $mRTTY1 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='RTTY' and band='80m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mRTTY2 = $result->num_rows;
if ($mRTTY2 == "0" ) {
$RTTY2 = '<td><p align="center"> </td>';
} else{
$RTTY2 = '<td><p align="center">' . $mRTTY2 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='RTTY' and band='60m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mRTTY3 = $result->num_rows;
if ($mRTTY3 == "0" ) {
$RTTY3 = '<td><p align="center"> </td>';
} else{
$RTTY3 = '<td><p align="center">' . $mRTTY3 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='RTTY' and band='40m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mRTTY4 = $result->num_rows;
if ($mRTTY4 == "0" ) {
$RTTY4 = '<td><p align="center"> </td>';
} else{
$RTTY4 = '<td><p align="center">' . $mRTTY4 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='RTTY' and band='30m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mRTTY5 = $result->num_rows;
if ($mRTTY5 == "0" ) {
$RTTY5 = '<td><p align="center"> </td>';
} else{
$RTTY5 = '<td><p align="center">' . $mRTTY5 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='RTTY' and band='20m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mRTTY6 = $result->num_rows;
if ($mRTTY6 == "0" ) {
$RTTY6 = '<td><p align="center"> </td>';
} else{
$RTTY6 = '<td><p align="center">' . $mRTTY6 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='RTTY' and band='17m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mRTTY7 = $result->num_rows;
if ($mRTTY7 == "0" ) {
$RTTY7 = '<td><p align="center"> </td>';
} else{
$RTTY7 = '<td><p align="center">' . $mRTTY7 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='RTTY' and band='15m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mRTTY8 = $result->num_rows;
if ($mRTTY8 == "0" ) {
$RTTY8 = '<td><p align="center"> </td>';
} else{
$RTTY8 = '<td><p align="center">' . $mRTTY8 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='RTTY' and band='12m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mRTTY9 = $result->num_rows;
if ($mRTTY9 == "0" ) {
$RTTY9 = '<td><p align="center"> </td>';
} else{
$RTTY9 = '<td><p align="center">' . $mRTTY9 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='RTTY' and band='10m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mRTTY10 = $result->num_rows;
if ($mRTTY10 == "0" ) {
$RTTY10 = '<td><p align="center"> </td>';
} else{
$RTTY10 = '<td><p align="center">' . $mRTTY10 . '</td>';
}
$smarty->assign("SSB1",$SSB1);
$smarty->assign("SSB2",$SSB2);
$smarty->assign("SSB3",$SSB3);
$smarty->assign("SSB4",$SSB4);
$smarty->assign("SSB5",$SSB5);
$smarty->assign("SSB6",$SSB6);
$smarty->assign("SSB7",$SSB7);
$smarty->assign("SSB8",$SSB8);
$smarty->assign("SSB9",$SSB9);
$smarty->assign("SSB10",$SSB10);
$smarty->assign("FT81",$FT81);
$smarty->assign("FT82",$FT82);
$smarty->assign("FT83",$FT83);
$smarty->assign("FT84",$FT84);
$smarty->assign("FT85",$FT85);
$smarty->assign("FT86",$FT86);
$smarty->assign("FT87",$FT87);
$smarty->assign("FT88",$FT88);
$smarty->assign("FT89",$FT89);
$smarty->assign("FT810",$FT810);
$smarty->assign("RTTY1",$RTTY1);
$smarty->assign("RTTY2",$RTTY2);
$smarty->assign("RTTY3",$RTTY3);
$smarty->assign("RTTY4",$RTTY4);
$smarty->assign("RTTY5",$RTTY5);
$smarty->assign("RTTY6",$RTTY6);
$smarty->assign("RTTY7",$RTTY7);
$smarty->assign("RTTY8",$RTTY8);
$smarty->assign("RTTY9",$RTTY9);
$smarty->assign("RTTY10",$RTTY10);
$smarty->assign("CW1",$CW1);
$smarty->assign("CW2",$CW2);
$smarty->assign("CW3",$CW3);
$smarty->assign("CW4",$CW4);
$smarty->assign("CW5",$CW5);
$smarty->assign("CW6",$CW6);
$smarty->assign("CW7",$CW7);
$smarty->assign("CW8",$CW8);
$smarty->assign("CW9",$CW9);
$smarty->assign("CW10",$CW10);
$smarty->assign("MFSK1",$MFSK1);
$smarty->assign("MFSK2",$MFSK2);
$smarty->assign("MFSK3",$MFSK3);
$smarty->assign("MFSK4",$MFSK4);
$smarty->assign("MFSK5",$MFSK5);
$smarty->assign("MFSK6",$MFSK6);
$smarty->assign("MFSK7",$MFSK7);
$smarty->assign("MFSK8",$MFSK8);
$smarty->assign("MFSK9",$MFSK9);
$smarty->assign("MFSK10",$MFSK10);
$smarty->assign("ca",$ca);
$smarty->display("db:head.tpl");
$smarty->display("db:header.tpl");
$smarty->display("db:indexright.tpl");
$smarty->display("db:oqrs_sh3.tpl");
$smarty->display("db:footer.tpl");
بارك اله فيكم وشكرا