01.<?php
02. function DateThai($strDate)
03. {
04. $strYear = date("Y",strtotime($strDate))+543;
05. $strMonth= date("n",strtotime($strDate));
06. $strDay= date("j",strtotime($strDate));
07.
08. $strMonthCut = Array("","ม.ค.","ก.พ.","มี.ค.","เม.ย.","พ.ค.","มิ.ย.","ก.ค.","ส.ค.","ก.ย.","ต.ค.","พ.ย.","ธ.ค.");
09. $strMonthThai=$strMonthCut[$strMonth];
10. return "$strDay $strMonthThai $strYear";
11. }
12.
13. $strDate = "2008-08-14 ";
14.
15.?>
16.
17.<?
18. include ("ConnectGeneral.php");
19. mysql_query ("SET NAMES utf8") or die (mysql_errno());
20. $id_knowledge=$_GET['id_knowledge'];
21.
22. $sql = "SELECT * FROM `knowledge`";
23. $result = mysql_query($sql);
24.
25.
26.while($row=mysql_fetch_array($result)){
27. $id_knowledge= $row["id_knowledge"];
28. $date_knowledge = DateThai($row["date_knowledge"]);
29. $head_knowledge= $row["head_knowledge"];
30.
31. $pic_knowledge= $row["pic_knowledge"];
32.
33. echo "<tr align='left'>";
34.echo "<td><img width=70 height=56 src='$pic_knowledge'></td>";
35.
36. echo "<td class='hactivity'><a href=\"ShowKnowledge1.php?id_knowledge=$id_knowledge\"<base target=_blank ' />$head_knowledge</td>";
37.
38.echo "<td>$date_knowledge</td>";
39.}
40.?>
