php ดึงข้อมูลจาก db ของphpbb
Tuesday, May 26th, 2009ลองดูน่ะครับ <html><body><?php$dbhost = ‘localhost’;$dbuser = ‘********;$dbpass = ‘********’; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die (‘Error connecting to mysql’);mysql_query(“SET NAMES UTF8”); // เพื่อให้ดึงข้อมูลให้แสดงภาษาไทยครับ $dbname = ‘xxxxxxxi’;mysql_select_db($dbname);$query = "SELECT topic_id, topic_title FROM phpbb3_topics ORDER BY topic_time";$result = mysql_query($query); while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {echo "<a href=http://www.mooaoun/phpBB3/viewtopic.php?t=$topic_id\" >{$row[‘topic_title’]} </a><br>" ;}mysql_close($conn); ?> </body></html>
