��ҹ��Ǣ�͡�͹˹�� :: ��ҹ��Ǣ�ͶѴ� |
����� |
��ͤ��� |
ryuozero Site Admin
�������: 13 Jul 2005 �ͺ: 1145
|
�ͺ�����: Thu Aug 02, 2007 7:45 am ����ͧ: phpbb topic anyway |
|
|
��ҧ�ԧ�ҡ: |
<?
$dbhost = 'localhost'; // ��÷Ѵ����֤�����¡�ҹ�����Ũҡ����ͧ�˹
$dbname = 'database'; //��÷Ѵ��������Ͱҹ�����ŷ��ŧ phpbb
$dbuser = 'root'; // ��÷Ѵ������ username
$dbpasswd = 'password'; // ��÷Ѵ������ password
$db=mysql_connect ($dbhost,$dbuser,$dbpasswd) or die ("Error!");
mysql_select_db("$dbname");
$qboard='select T.topic_id, T.topic_title, U.username, T.topic_time, T.topic_replies, T.topic_poster, P.post_username, T.topic_views, T.topic_replies
from phpbb_topics as T
left join phpbb_posts as P on T.topic_first_post_id=P.post_id
left join phpbb_users as U on U.user_id=T.topic_poster
order by T.topic_last_post_id desc limit 10';
$rboard=mysql_query($qboard, $db) or die("Error".mysql_error());
?>
<table width="470" align="center">
<tr>
<td align="center">Topic</td>
<td align="center">Post</td>
<td align="center">Rd/Rply</td>
<td align="center">Reply</td>
<td align="center">Date</td>
</tr>
<?
while ($rowb=mysql_fetch_array($rboard)) {
echo '<tr>';
//echo '<td>'.$rowb[0].'</td>';
echo '<td><a href="board/viewtopic.php?t='.$rowb[0].'" target="_blank">'.substr($rowb[1], 0, 100).'</a></td>';
if($rowb[5]==-1) echo '<td><strong>'.$rowb[6].'</strong></td>';
else echo '<td><strong>'.$rowb[2].'</strong></td>';
echo '<td>'.$rowb[7].'/'.$rowb[8].'</td>';
if ($rowb[4]!=0) {
$qboard2='select U.username, P.post_time, P.poster_id, P.post_username
from phpbb_posts as P
left join phpbb_users as U on U.user_id=P.poster_id
where P.topic_id='.$rowb[0].' order by P.post_time desc limit 1';
$rboard2=mysql_query($qboard2, $db);
$rowb2=mysql_fetch_array($rboard2);
if($rowb2[2]==-1) echo '<td><strong>'.$rowb2[3].'</strong></td>';
else echo '<td><strong>'.$rowb2[0].'</strong></td>';
echo '<td>'.date("d.m.y", $rowb2[1]).' </td>';
}
else {
echo '<td>N/A</td>';
echo '<td>'.date("d.m.y", $rowb[3]).'</td>';
}
echo '</tr>';
}
?>
</table> |
|
|
���仢�ҧ�� |
|
|
ryuozero Site Admin
�������: 13 Jul 2005 �ͺ: 1145
|
�ͺ�����: Thu Aug 02, 2007 7:50 am ����ͧ: |
|
|
���Ẻ������ ���¡����á�ҡ config.php �ͧ phpbb
��� path ��� include ���١�Сѹ
Code:
<?
include("phpbb/config.php"); // ��� path �ç������١
$db=mysql_connect ($dbhost,$dbuser,$dbpasswd) or die ("Error!");
mysql_select_db("$dbname");
$qboard='select T.topic_id, T.topic_title, U.username, T.topic_time, T.topic_replies, T.topic_poster, P.post_username, T.topic_views, T.topic_replies
from '.$table_prefix.'topics as T
left join '.$table_prefix.'posts as P on T.topic_first_post_id=P.post_id
left join '.$table_prefix.'users as U on U.user_id=T.topic_poster
order by T.topic_last_post_id desc limit 10';
$rboard=mysql_query($qboard, $db) or die("Error".mysql_error());
?>
<table width="470" align="center">
<tr>
<td align="center">Topic</td>
<td align="center">Post</td>
<td align="center">Rd/Rply</td>
<td align="center">Reply</td>
<td align="center">Date</td>
</tr>
<?
while ($rowb=mysql_fetch_array($rboard)) {
echo '<tr>';
//echo '<td>'.$rowb[0].'</td>';
echo '<td><a href="board/viewtopic.php?t='.$rowb[0].'" target="_blank">'.substr($rowb[1], 0, 100).'</a></td>';
if($rowb[5]==-1) echo '<td><strong>'.$rowb[6].'</strong></td>';
else echo '<td><strong>'.$rowb[2].'</strong></td>';
echo '<td>'.$rowb[7].'/'.$rowb[8].'</td>';
if ($rowb[4]!=0) {
$qboard2='select U.username, P.post_time, P.poster_id, P.post_username
from '.$table_prefix.'posts as P
left join '.$table_prefix.'users as U on U.user_id=P.poster_id
where P.topic_id='.$rowb[0].' order by P.post_time desc limit 1';
$rboard2=mysql_query($qboard2, $db);
$rowb2=mysql_fetch_array($rboard2);
if($rowb2[2]==-1) echo '<td><strong>'.$rowb2[3].'</strong></td>';
else echo '<td><strong>'.$rowb2[0].'</strong></td>';
echo '<td>'.date("d.m.y", $rowb2[1]).' </td>';
}
else {
echo '<td>N/A</td>';
echo '<td>'.date("d.m.y", $rowb[3]).'</td>';
}
echo '</tr>';
}
?>
</table> |
|
���仢�ҧ�� |
|
|
ryuozero Site Admin
�������: 13 Jul 2005 �ͺ: 1145
|
�ͺ�����: Thu Aug 02, 2007 4:05 pm ����ͧ: |
|
|
connect.php
��ҧ�ԧ�ҡ: |
<?
$host="localhost";
$user="root";
$pw=" ";
$dbname="db_webboard";
$c = mysql_connect ($host,$user,$pw);
if (!$c)
{
echo "<h3>ERROR : �������ö�Դ��Ͱҹ��������</h3>";
exit();
}
?> |
|
|
���仢�ҧ�� |
|
|
ryuozero Site Admin
�������: 13 Jul 2005 �ͺ: 1145
|
�ͺ�����: Thu Aug 02, 2007 4:12 pm ����ͧ: |
|
|
��ҧ�ԧ�ҡ: |
�����㹡�õԴ��Ͱҹ������ MySQL ���� Code PHP ���¹Դ���Ǥ�Ѻ |
����Ѻ����觤��駹�� ���ʹ��Ըա�õԴ��Ͱҹ����������Ѻ�����ҹ������ MySQL ��觼����й��Ըա�õԴ��������㹤��駡�͹ ��Ҩ�����ö���ҧ�ҹ������ MySQL ����������ͧ����ͧ ������ ��鹵͹���������Ѻ������蹵����ҧ�ҹ������ ���� MySQL Front �ҨѴ������ҧ�ҹ������ �������˹� User ����Ѻ Login ������ҹ������ ��ʹբͧ MySQL Front ����ҧ�ҡ MySQL Admin(����Ѻ����� MySQL Admin �����չФ�Ѻ) ���� MySQL Front ����ö�٢�������дѺ Table , Field, ��� Data �� �֧�дǡ㹡������ ź ��䢢����� ��������ö�٢�����㹵��ҧ����͹�Ѻ�� MS Access �ѧ����ѧ��� ���÷��д֧���������ʴ���˹�� Webpage ��� ����ö�� Code php �Ҫ���㹡�����ҧ��õԴ��͡Ѻ�ҹ�����ūС�͹ �ٻẺ��õԴ��� ��鹵͹�ѧ���仹��
1. ���ҧ text file ����� �ҡ Notepad ��駪��� config.php
2. ����� Code �ѧ���
��ҧ�ԧ�ҡ: |
//variable for mysql connect
$myHost = "127.0.0.1";
$myUser = "testdatabase"; -----> ���� User ,Password ������ҧ������͵Դ��Ͱҹ������
$myPassword = "1234";
?> |
3.save ������駪��� config.php (�ѹ�֡���� Sub Directory ���ǡѺ������� Website)
4. �Դ˹�� Website ����ͧ��ô֧�����Ũҡ My SQL ���ʴ��� ���͡ Code View
5. ����÷Ѵ�á ���������
include "config.php"
��ҧ�ԧ�ҡ: |
//connect mysql server
$link = mysql_connect($myHost, $myUser, $myPassword);
if (!$link) {
die('Could not connect: ' . mysql_error());
}
// make for the current db
$db_selected = mysql_select_db('testdatabase', $link);
//echo 'Connected successfully';
$query = 'SELECT * FROM Tablename
$result= mysql_query($query);
$row = mysql_fetch_array($result, MYSQL_NUM);
?> |
6. ����������ö�Դ��͡Ѻ�ҹ������ ������֧������㹵��ҧ���ʴ����Ѻ
����Ѻ������������ ����֡���Ըա����¹ Code ���� PHP �ա�Դ��Ѻ
Ref: |
|
���仢�ҧ�� |
|
|
|