�����������֡��
A little text to describe your forum 
¤ÍÁ¾ÔÇàµÍÃìÈÖ¡ÉÒ  
 ÊÁѤÃÊÁÒªÔ¡(Register)��Ѥ���Ҫԡ(Register) 
 ªèÇÂàËÅ×Í���������   ¤é¹ËÒ����   ÃÒª×èÍÊÁҪԡ��ª�����Ҫԡ   ¡ÅØèÁ¼Ùéãªé���������� 
 ¢éÍÁÙÅÊèǹµÑÇ(Profile)��������ǹ���(Profile)   à¢éÒÊÙèÃкºà¾×èÍàªç¤¢éͤÇÒÁÊèǹµÑÇ�������к������礢�ͤ�����ǹ���   à¢éÒÊÙèÃкº(Log in)�������к�(Log in) 
Important Notice: We regret to inform you that our free phpBB forum hosting service will be discontinued by the end of June 30, 2024. If you wish to migrate to our paid hosting service, please contact [email protected].
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!