01.<?
02. mysql_connect("localhost","root","1234");
03. mysql_select_db("uuuu");
04. mysql_query("SET character_set_results=tis620");
05.mysql_query("SET character_set_client=tis620");
06.mysql_query("SET character_set_connection=tis620");
07. $strSQL = "SELECT * FROM products WHERE pname = '".trim($_POST['pname'])."' ";
08. $objQuery = mysql_query($strSQL);
09. $objResult = mysql_fetch_array($objQuery);
10. if($objResult)
11. {
12. echo "แพ็คเกตซ้ำ";
13. }
14. else
15. {
16.
17. $strSQL = "INSERT INTO products (category,pname,detail,price) VALUES ('".$_POST["category"]."',
18. '".$_POST["pname"]."','".$_POST["detail"]."','".$_POST["price"]."')";
19. $objQuery = mysql_query($strSQL);
20.
21. echo "<center>อัพเดตแพ็คเกตเรียบร้อยแล้ว</center><br>";
22.
23. echo "<br> <center><input name='btnButton' type='button' value='Back'onClick='JavaScript:history.back();'></center></a>";
24.
25. }
26. mysql_close();
27.?>
