إنشاء صفحة البداية مربوطة بقاعدة البيانات

[اليافعي]

???? ?????? ??? ??????? (?? ??? ???????) ??????? ????? ???? ???? ?????.

???? ??????? ??? ??? ??????

??? ????? ?? ??? ???? ????? ???? ??????? ???? ????? ?? ??? ????????? ?? ????? ???????? ?? ???? ???? ??????? ????? ?? PhpBB


????? ??????? ????? ?? ??? ?? ?? ???

??? ?? ???? ????????? ???? ???? ?? ?????? ?? ????? ????????? ???? ????? PhpBB ???? ?? ?? ????? ?? ????? ?????? ??? ????? ?? ????? ??????? ???? ?????? ??? ?? ???? ?? ???????? ????? ??? ???? ?? ???? ???? ????? ??? ?? ???? ??? php

???????
??? ????? ??? ??? ????? ???
::
????? ????? ??? ????? ??? ???? ??? php ??? ?? ???
:
????? ?????? ?????? ??? ??? ??? HTML ?????? ??????? ?? ?????? ????? ???? (????? ??? - ???????-???? ????) ???? ??????? ???? ???? .... ??? ????? ???? ?????? ??? ????? ?? ??? ?? ????? ??? php

ملفات

!!!! ????? --> ??? ????? ???? ???? ????? PhpBB ?? ??????? ???????? ??????? ???? ?????? ??? ???? ?? ???!!!!

::: ??? ??? PHP ::::::::::::::::::::

??? ????? ???? ?? ?????? ?????? ???????
????? ?? ???? main_page.php
???? ?? ????? ??? ????? ??? ??? PhpBB ??????? (??? ????? ??????) ?? ???? ??????? ??????? ??? ?? ?? ?????? ?????? ???

???? ????? ???? ??????? ?? ????? ???????? (????? ??? ???????? ??? ???? ??????) .... ?? ??? ?????? ??????? ???? ??? ???????? .... ???? ??? ??????? ???????

كود: تحديد الكل

$private_fourms ='20,21';
$title_limit ='10';
$sql = "SELECT topic_id,topic_title, topic_first_poster_name
FROM phpbb_topics
WHERE forum_id    NOT IN ($private_fourms)
AND topic_approved = 1 ORDER BY topic_id DESC LIMIT 0,$title_limit";
$result = $db->sql_query($sql);

???? ??? ???? ???? ???????? ???? ????? ????? ?? ????? ???? ????? PhpBB ?? ?????? ?? ??????? ??????

كود: تحديد الكل

while($row = $db->sql_fetchrow($result))
{
    $template->assign_block_vars('my_block', array(
        'TOPIC_ID'    => $row['topic_id'],
        'TOPIC_TITLE'    => $row['topic_title'],
        'TOPIC_POSTER'    => $row['topic_first_poster_name'],
    ));
}

???? ???? ????? (*????????*) ??????? ??? ??????? ?? ????? TOPIC_ID ????? ??????? ??? ??????? ????? ???????

????? ???? ?? ???? ?? ?? ??? ???????? ????????? ?? ?? ????? HTML ???? ????? ?? ??? ??????? ??? ???? ???? ?? ???? ????? ?? ??????? !!

??? ??? HTML
????? ?? ???? ??? ??????? ?? ???? ??????? ????????

كود: تحديد الكل

/phpBB3/styles/<style>/template/main_page.html

???? ??? ?? ?? ??? ??? ????

كود: تحديد الكل

<!-- INCLUDE overall_header.html -->

??? ??? ??? ????

كود: تحديد الكل

<!-- INCLUDE overall_footer.html -->

???? ??? ???? ????? ?? ??? ?? ???? .... ????? ??? ???? ?????? ?? ??? ?? ??????? ????? ??? ??? ???????? ????? ?? ??? ???????? ???? ?? main_page.php ?? ????? main_page.html

????? ??? ???? ?? ????? ??? ??? ???? (??? ?? ??? ???? ???? ?? ??? HTML ?????? ?????? ???? ???????)

كود: تحديد الكل

			<table border="1" width="100%" bgcolor="#F9F3DF" cellspacing="3" cellpadding="3" bordercolor="#FFC58A" style="border-collapse: collapse">
				<tr>
					<td colspan="2" bgcolor="#F5EBC5"><b>
					<font size="4" color="#B95627"> ? </font></b>
					<span lang="ar-ye"><font size="4" color="#B95627"><b>???? ????????</b></font></span></td>
				</tr>
				<tr>
					<td width="6%"> </td>
					<td width="88%"> </td>
				</tr>
			</table>

?? ???? ????? ???? ?? ????? ??? TR ?? ?? ????? ??? ??? ???? ?? ??? ??? ??????!!!! ??? ?? ???? ???? ?? ?? ????? ???? ?? ??? TR ????? ??????? ??? PhpBB

كود: تحديد الكل

<!-- BEGIN my_block -->

				<tr>
					<td width="6%">::::</td>
					<td width="88%"><a href="viewtopic.php?t={my_block.TOPIC_ID}">{my_block.TOPIC_TITLE}</a>:::????::: {my_block.TOPIC_POSTER}</td>
				</tr>
<!-- END my_block -->

????? ??????? ??? ??? ????? ??? ???????? ??? ??? ???? (?? ?? ??? ?????) ?? ??????.

?????? ????? ??? ????? ???? ??????? ???? ?? ????? ???????? ?????? ?? ??? ?????? ???? ????? ?? ????? ??? PHP


????? ???? ?? ???? ??? ???? ?? ????? ???? ????? ??? ???? ????? ??? PhpBB