01.<!DOCTYPE html>
02.<html>
03. <head>
04. <meta charset="utf-8">
05. <meta name="viewport" content="width=device-width, initial-scale=1">
06. <title>jQuery Mobile: Theme Download</title>
07. <link rel="stylesheet" href="themes/thaiherb.min.css" />
08. <link rel="stylesheet" href="themes/jquery.mobile.icons.min.css" />
12. </head>
13. <body>
14. <div data-role="page" data-theme="a">
15. <div data-role="header" data-position="inline">
16. <h1><img src="myfile/new2.png" width="50" height="50">รายชื่อสมุนไพร<img src="myfile/new2.png" alt="" width="50" height="50"></h1>
17. </div>
18. <ul data-role="listview" data-inset="true" >
19. <?
20. $objConnect = mysql_connect("localhost","root","1234") or die("Error Connect to Database");
21. $objDB = mysql_select_db("mydatabase");
22. $strSQL = "SELECT * FROM files";
23. $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
24.?>
25.
26.<?
27. while($objResult = mysql_fetch_array($objQuery))
28.
29. {
30.
31.
32.?>
33.
34.<li><img src="myfile/<?=$objResult["FilesName2"];?>"><?=$objResult["NameTH"];?><a href="appviewdetail.php?id=<?=$objResult["FilesID"];?>"></li>
35.
36.<?
37. }
38.mysql_close($objConnect);
39.?>
40.
41. </ul>
42. </div>
43. </body>
44.</html>
