01.<html>
02.<head>
03.<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
04.<title>ลูกค้า</title>
05.</head>
06. <form id="form2" name="form2" method="post" action="">
07. <tr>
08. <?
09.
10.$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
11.
12.$objDB = mysql_select_db("CEM");
13.
14.$strSQL = "SELECT * FROM Customer";
15.
16.$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
17.
18.$num_rows = mysql_num_rows($objQuery);
19.echo "แถวทั้งหมด ".$num_rows."";
20.?>
21.
22. <tr>
23. <td align="right"><div align="left">
24. <p class="style10"><span class="style8"> <span class="style15">ข้อมูลลูกค้า</span></span> </p>
25. </div>
26.
27. <td align="right"><div align="center" class="style8">
28. <div align="left"><strong><span class="style10"> <span class="style8"> รหัสลูกค้า </span>:</span> </span>
29.
30. <input type="text" name="txtIDCus" id="txtIDEMP" size="20"/value="<?=$objResult["ID_CUST"];?>">
31. </strong> <strong>
32. <label>ประเภทอุตสาหกรรม</label>
33.: </strong>
34. <label>
35. <select name="Deparment" size="1" id="Deparment" value="<?=$objResult["CUST_INDUS"];?>">
36. <option value="1">อาหารและเครื่องดื่ม</option>
37. <option value="2">ยานยนต์</option>
38. <option value="3">พลาสติก</option>
39. <option value="4">อลูมิเนียม</option>
40. <option value="5">เครื่องใช้ไฟฟ้า</option>
41. <option value="6">อื่นๆ</option>
42. </select>
43. </label>
44. <br />
45. <br />
46. </div>
47. </div></td>
48. <td align="right"><div align="center" class="style8">
49. <div align="left"><strong><span class="style10"> <span class="style8"> <strong>ชื่อหน่วยงาน </strong></span><strong>:</strong></span> </span>
50. <input type="text" name="txtnameEMP" id="txtnameEMP" size="50" value="<?=$objResult["CUST_NAME"];?>">
51. </label>
52. <br />
53. <br />
54. </div>
55. </div></td>
56. <td align="right"><div align="center" class="style8">
57. <div align="left"><strong><span class="style10"> </span></div>
58. </div></td>
59.
60. <label><strong> ที่อยู่ :</strong>
61. <textarea name="address" id="address" cols="45" rows="5"value="<?=$objResult["CUST_ADDR"];?>"></textarea>
62. <br />
63. </label>
64. <br />
65.
66. <label></label>
67. <strong> เบอร์โทรศัพท์ : </strong>
68. <label>
69. <input name="TElEMP" type="text" id="TElEMP" size="35" value="<?=$objResult["CUST_PHON"];?>">
70. </label>
71. <strong>FAX :</strong>
72. <input name="FAXCus" type="text" id="FAXCus" size="30" value="<?=$objResult["CUST_FAX"];?>">
73. <p><strong> E-Mail :
74. </strong>
75. <input name="Email" type="text" id="Email" size="50" value="<?=$objResult["CUST_MAIL"];?>">
76. <br />
77. </p>
78.
79.<input type="submit" name="button2" id="button2" value="Submit" />
80.
81. <input type="submit" name="button2" id="button2" value="edit" />
82. <br />
83.
84.</form>
85.<label></label>
86.</body>
87.</html>
[b][/b]
