�����������֡��
A little text to describe your forum 
¤ÍÁ¾ÔÇàµÍÃìÈÖ¡ÉÒ  
 ÊÁѤÃÊÁÒªÔ¡(Register)��Ѥ���Ҫԡ(Register) 
 ªèÇÂàËÅ×Í���������   ¤é¹ËÒ����   ÃÒª×èÍÊÁҪԡ��ª�����Ҫԡ   ¡ÅØèÁ¼Ùéãªé���������� 
 ¢éÍÁÙÅÊèǹµÑÇ(Profile)��������ǹ���(Profile)   à¢éÒÊÙèÃкºà¾×èÍàªç¤¢éͤÇÒÁÊèǹµÑÇ�������к������礢�ͤ�����ǹ���   à¢éÒÊÙèÃкº(Log in)�������к�(Log in) 
phpbb topic anyway

 
Forum ¹Õé¶Ù¡ÅçÍ¡ ¤Ø³äÁèÊÒÁÒöµÍº ËÃ×Íá¡éä¢ä´é   ËÑÇ¢é͹Õé¶Ù¡ÅçÍ¡ ¤Ø³äÁèÊÒÁÒöá¡éä¢ ËÃ×͵ͺä´é    ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½Ö¡ï¿½ï¿½ -> +�+WEB+�+
��ҹ��Ǣ�͡�͹˹�� :: ��ҹ��Ǣ�ͶѴ�  
����� ��ͤ���
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]).'&nbsp;</td>';
}
else {
echo '<td>N/A</td>';
echo '<td>'.date("d.m.y", $rowb[3]).'</td>';
}
echo '</tr>';
}
?>
</table>
���仢�ҧ��
´Ù¢éÍÁÙÅÊèǹµÑÇ Ê觢éͤÇÒÁÊèǹµÑÇ Êè§ Email
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]).'&nbsp;</td>';
}
else {
echo '<td>N/A</td>';
echo '<td>'.date("d.m.y", $rowb[3]).'</td>';
}
echo '</tr>';
}
?>
</table>
���仢�ҧ��
´Ù¢éÍÁÙÅÊèǹµÑÇ Ê觢éͤÇÒÁÊèǹµÑÇ Êè§ Email
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();
}
?>
���仢�ҧ��
´Ù¢éÍÁÙÅÊèǹµÑÇ Ê觢éͤÇÒÁÊèǹµÑÇ Êè§ Email
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:
���仢�ҧ��
´Ù¢éÍÁÙÅÊèǹµÑÇ Ê觢éͤÇÒÁÊèǹµÑÇ Êè§ Email
���§�ӴѺ��ͤ����ͺ�ҡ��͹˹��:   
Forum ¹Õé¶Ù¡ÅçÍ¡ ¤Ø³äÁèÊÒÁÒöµÍº ËÃ×Íá¡éä¢ä´é   ËÑÇ¢é͹Õé¶Ù¡ÅçÍ¡ ¤Ø³äÁèÊÒÁÒöá¡éä¢ ËÃ×͵ͺä´é    ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½Ö¡ï¿½ï¿½ -> +�+WEB+�+ ��Ѻ���� GMT
˹�� 1 �ҡ 1

 
价��:  
�س�������ö���ҧ��Ǣ������
�س�������ö�����ͺ
�س�������ö��䢢�ͤ����ͧ�س
�س�������öź��ͤ����ͧ�س
�س�������öŧ��ṹ


Powered by phpBB © 2001 phpBB Group
-- Template created by dav.bo=> PurpleStylus --


For Support - http://forums.BizHat.com

Free Web Hosting | Free Forum Hosting | FlashWebHost.com | Image Hosting | Photo Gallery | FreeMarriage.com

Powered by PhpBBweb.com, setup your forum now!