01.<?php
02.$ts=$_POST['ts'];
03.$con = mysql_connect("localhost","root","") or die("Error Connect to Database");
04.$condb = mysql_select_db("wptr");
05.mysql_query("SET NAMES UTF8");
06.$consql = "SELECT * FROM sys_teacher where name_t like '%$ts%'; ";
07.$conquery = mysql_query($consql) or die ("Error Query [".$consql."]");
08.?>
09.<?php
10.while($cols = mysql_fetch_array($conquery))
11.{
12.?>
13. <table width="600" border="1" bordercolor="#000000">
14. <tr>
15. <td colspan="4"><div align="center"><font size="+1"><strong>ข้อมูลส่วนตัวและผู้ใช้งาน</strong></font></div></td>
16. </tr>
17. <tr>
18. <td colspan="2" rowspan="7"><div align="center"><img src="myfilez/<?php echo $cols["pic_t"] ;?>" width="170" height="170" /> </div></td>
19. <td colspan="2"><div align="center">ข้อมูลเบื้องต้น</div></td>
20. </tr>
21. <tr>
22. <td width="117"><div align="left"><strong>หมายเลขครู : </strong></div></td>
23. <td width="186"><?php echo $cols[0] ?></td>
24. </tr>
25.</table>
26.<?php
27.}
28.?>
29.<?php
30.mysql_free_result($conquery);
31.mysql_close($con);
32.?>
