<html> <head> <title>ThaiCreate.Com PHP & SQL Server Tutorial</title> </head> <body> <form action="phpSQLServerCheckExistRecordAddSave.php" name="frmAdd" method="post"> <table width="600" border="1"> <tr> <th width="91"> <div align="center">CustomerID </div></th> <th width="160"> <div align="center">Name </div></th> <th width="198"> <div align="center">Email </div></th> <th width="97"> <div align="center">CountryCode </div></th> <th width="70"> <div align="center">Budget </div></th> <th width="70"> <div align="center">Used </div></th> </tr> <tr> <td><div align="center"><input type="text" name="txtCustomerID" size="5"></div></td> <td><input type="text" name="txtName" size="20"></td> <td><input type="text" name="txtEmail" size="20"></td> <td><div align="center"><input type="text" name="txtCountryCode" size="2"></div></td> <td align="right"><input type="text" name="txtBudget" size="5"></td> <td align="right"><input type="text" name="txtUsed" size="5"></td> </tr> </table> <input type="submit" name="submit" value="submit"> </form> </body> </html>
<html> <head> <title>ThaiCreate.Com PHP & SQL Server Tutorial</title> </head> <body> <?php $objConnect = mssql_connect("localhost","sa","") or die("Error Connect to Database"); $objDB = mssql_select_db("mydatabase"); $strSQL = "SELECT * FROM customer WHERE CustomerID = '".$_POST["txtCustomerID"]."' "; $objQuery = mssql_query($strSQL); $objResult = mssql_fetch_array($objQuery); if($objResult) { echo "CustomerID already exist."; } else { $strSQL = ""; $strSQL = "INSERT INTO customer "; $strSQL .="(CustomerID,Name,Email,CountryCode,Budget,Used) "; $strSQL .="VALUES "; $strSQL .="('".$_POST["txtCustomerID"]."','".$_POST["txtName"]."','".$_POST["txtEmail"]."' "; $strSQL .=",'".$_POST["txtCountryCode"]."','".$_POST["txtBudget"]."','".$_POST["txtUsed"]."') "; $objQuery = mssql_query($strSQL); if($objQuery) { echo "Save Done."; } else { echo "Error Save [".$strSQL."]"; } } mssql_close($objConnect); ?> </body> </html>
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน Source Code 2.0 ของทีมงานไทยครีเอท