001.<? include "chksession.php";?>
002.<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
003.<html>
004.<head>
005.<title>ร้านจำหน่ายปลาสวยงามและอุปกรณ์ทุกชนิด</title>
006.<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
007.<link href="../style.css" rel="stylesheet" type="text/css">
008.<script type="text/javascript" src="FCKeditor/fckeditor.js"></script>
009.</head>
010.<script>
011.function check_number() {
012.e_k=event.keyCode
013.
014.if (e_k != 13 && (e_k < 48) || (e_k > 57)) {
015.event.returnValue = false;
016.alert("กรอกเป็นตัวเลขเท่านั้น!");
017.}
018.}
019.
020.function check(){
021.if(f1.product_name.value == ""){
022.alert("โปรดกรอกชื่อสินค้าครับ");
023.stop();
024.}
025.if(f1.ref_type_id.value == "0"){
026.alert("โปรดกรอกประเภทสินค้าครับ");
027.stop();
028.}
029.if(f1.product_detail.value == ""){
030.alert("โปรดกรอกรายละเอียดสินค้าครับ");
031.stop();
032.}
033.if(f1. product_price .value == ""){
034.alert("โปรดกรอกราคาสินค้าครับ");
035.stop();
036.}
037.if(f1.stock.value == ""){
038.alert("โปรดระบุจำนวนสินค้าครับ");
039.stop();
040.}
041.{
042.f1.submit();
043.}
044.}
045.</script>
046.<body leftmargin=0 topmargin=0>
047.<table width="780" border="0" align="center" cellpadding="0" cellspacing="0">
048.<tr>
049.<td width="17" background="images/bg_left.gif"><img src="images/bg_left.gif" width="17" height="16"></td>
050.<td width="780" align=lift valign=top><table width="780" border="0" cellspacing="0" cellpadding="0">
051.<tr>
052.<td align=lift valign=top>
053.<? include "menu.php"; ?>
054.</td>
055.</tr>
056.<tr>
057.<td height="20" align=lift valign=top><table width="780" border="0" cellspacing="0" cellpadding="0">
058.<tr>
059.<td width="200" height="20" align=lift valign=top>
060.<? include "menu_left.php"; ?>
061.</td>
062.<td width="580" align=lift valign=top><table width="550" border="0" align="center" cellpadding="0" cellspacing="0">
063.<tr>
064.<td><div align="center">
065.<table width="550" border="0" cellpadding="0" cellspacing="0">
066.<tr>
067.<td><p align="left" class="p"><strong>เพิ่มสินค้าใหม่</strong></p></td>
068.</tr>
069.<tr>
070.<td><form name="form1" method="post" action="prd_add2.php" enctype="multipart/form-data" id="f1">
071.<table width="550" border="0" cellpadding="1" cellspacing="0" bordercolor="#eff2f3">
072.<tr>
073.<td width="115"><p align="right" class="p">ชื่อสินค้า
074.:</p></td>
075.<td width="431"> <input name="product_name" type="text" id="product_name" size="50" maxlength="150" >
076.<font color="#FF0000">*</font> </td>
077.</tr>
078.<tr>
079.<td ><p align="right" class="p">ประเภทสินค้า
080.:</p></td>
081.<td > <select name ="ref_type_id" id"ref_type_id">
082.<option value = "0" > เลือกประเภทสินค้า</option>
083.<?
084.$price=$_POST[price];
085.$t="สนใจติดต่อ";
086.include("../connect.php");
087.$sql2 = "select * from type order by type_id asc" ;
088.$result2 = mysql_db_query ($db,$sql2) ;
089.while ($rs2 = mysql_fetch_array ($result2)) {
090.$type_id = $rs2[type_id] ;
091.$type_name = $rs2[type_name];
092.echo "<option value = '$type_id'> $type_name </option>" ;
093.}
094.?>
095.</select>
096.<font color="#FF0000">*</font></td>
097.</tr>
098.<tr>
099.<td align=lift valign=top><p align="right" class="p">รายละเอียดสินค้า
100.:</p></td>
101.<td > <textarea name="product_detail" rows="4" cols="40" id="product_detail"></textarea>
102.<font color="#FF0000">*</font></td>
103.</tr>
104.<tr>
105.<td ><p align="right" class="p">ราคาสินค้า
106.:</p></td>
107.<td ><p align="left" class="p">
108.
109.<input type = "text" name="product_price" id="product_price" onkeypress= "check_number();" size = "20" maxlength="7">
110.<font color="#FF0000">* ไม่มี ให้ใส่ 0</font></p> </td>
111.</tr>
112.
113.<tr>
114.<td ><p align="right" class="p">จำนวนสินค้า
115.:</p></td>
116.<td > <input name = "stock" type = "text" id="stock" onkeypress= "check_number();" size = "20" maxlength="2">
117.<font color="#FF0000">*</font></td>
118.</tr>
119.<tr>
120.<td width="115"><p align="right" class="p">รูปภาพสินค้า
121.:</p></td>
122.<td align="left" valign="top"><input type="file" name="filUpload"><br>
123.<?
124.if($hidAction == "Add") {
125.$date = date("U");
126.if($file != "") {
127.$type = getimagesize($file);
128.if($type[3] == 1) {
129.$picture= $date."_img.gif";
130.} else if($type[3] == 2) {
131.$picture = $date."_img.jpg";
132.} else if($type[3] == 3) {
133.$picture = $date."_img.bmp";
134.}
135.copy($file, "picture/$picture");
136.chmod("picture/$picture", 0664);
137.}
138.
139.$host="localhost";
140.$db_username="root";
141.$db_password="1234";
142.$dbname="db_web";
143.$connect = mysql_connect($host,$db_username,$db_password);
144.if(!$connect){
145.echo "ไม่สามารถติดต่อฐานข้อมูลได้"; exit();
146.}
147.
148.$sql = "insert into picture (id, picture) values ('', '$picture') ";
149.$dbquery = mysql_db_query($dbname, $sql);
150.}
151.?>
152.<input name="hidAction" id="hidAction" type="hidden" value="Add">
153.
154.</tr>
155.<tr>
156.<td ><p align="right" class="p">สถานะ :</p></td>
157.<td ><p align="left" class="p">
158.<input type="radio" name="status" value="y">
159.แสดงหน้าแรก
160.<input type="radio" name="status" value="n" checked>
161.ไม่แสดงหน้าแรก </p></td>
162.</tr>
163.<tr>
164.<td><div align="center">
165.</div></td>
166.<td> <input type="button" name="Button" value=" ตกลง " onClick="check()">
167.<input type="reset" name="Reset" value="ยกเลิก"> </td>
168.</tr>
169.</table>
170.</form></td>
171.</tr>
172.</table>
173.</div></td>
174.</tr>
175.<tr>
176.<td><p align="right" class="p"> <font color="#FF0000">
177.* โปรดกรอกข้อมูลที่มีเครื่องหมายให้ครบ</font></p></td>
178.</tr>
179.</table></td>
180.</tr>
181.</table></td>
182.</tr>
183.<tr>
184.<td align=lift valign=top>
185.<? include "button.php"; ?>
186.</td>
187.</tr>
188.</table></td>
189.<td width="17" background="images/bg_right.gif"><img src="images/bg_right.gif" width="17" height="16"></td>
190.</tr>
191.</table>
192.</body>
193.</html>
