web 2.0

How to use PHP & SQL Server (mssql) Add/Insert/Edit/Delete On Same Form

Author: admin | Posted: 21-03-2010 | Category: PHP & SQL Server

How to use PHP & SQL Server (mssql) Add/Insert/Edit/Delete On Same Form Learn / tutorial php programming how to using PHP delete multiple record from SQL Server database.

ShotDev Focus:
- PHP & SQL Server add/insert/update/delete on same form.

Example 1

php_sqlserver_command.php

view plaincopy to clipboardprint?
  1. <html>  
  2. <head>  
  3. <title>ShotDev.Com Tutorial</title>  
  4. </head>  
  5. <body>  
  6. <?  
  7. $objConnect = mssql_connect("localhost","sa","");  
  8. $objDB = mssql_select_db("mydatabase");  
  9.   
  10. //*** Add Condition ***//  
  11. if($_POST["hdnCmd"] == "Add")  
  12. {  
  13. $strSQL = "INSERT INTO customer ";  
  14. $strSQL .="(CustomerID,Name,Email,CountryCode,Budget,Used) ";  
  15. $strSQL .="VALUES ";  
  16. $strSQL .="('".$_POST["txtAddCustomerID"]."','".$_POST["txtAddName"]."' ";  
  17. $strSQL .=",'".$_POST["txtAddEmail"]."' ";  
  18. $strSQL .=",'".$_POST["txtAddCountryCode"]."','".$_POST["txtAddBudget"]."' ";  
  19. $strSQL .=",'".$_POST["txtAddUsed"]."') ";  
  20. $objQuery = mssql_query($strSQL);  
  21. if(!$objQuery)  
  22. {  
  23. echo "Error Save [".mssql_error()."]";  
  24. }  
  25. //header("location:$_SERVER[PHP_SELF]");  
  26. //exit();  
  27. }  
  28.   
  29. //*** Update Condition ***//  
  30. if($_POST["hdnCmd"] == "Update")  
  31. {  
  32. $strSQL = "UPDATE customer SET ";  
  33. $strSQL .="CustomerID = '".$_POST["txtEditCustomerID"]."' ";  
  34. $strSQL .=",Name = '".$_POST["txtEditName"]."' ";  
  35. $strSQL .=",Email = '".$_POST["txtEditEmail"]."' ";  
  36. $strSQL .=",CountryCode = '".$_POST["txtEditCountryCode"]."' ";  
  37. $strSQL .=",Budget = '".$_POST["txtEditBudget"]."' ";  
  38. $strSQL .=",Used = '".$_POST["txtEditUsed"]."' ";  
  39. $strSQL .="WHERE CustomerID = '".$_POST["hdnEditCustomerID"]."' ";  
  40. $objQuery = mssql_query($strSQL);  
  41. if(!$objQuery)  
  42. {  
  43. echo "Error Update [".mssql_error()."]";  
  44. }  
  45. //header("location:$_SERVER[PHP_SELF]");  
  46. //exit();  
  47. }  
  48.   
  49. //*** Delete Condition ***//  
  50. if($_GET["Action"] == "Del")  
  51. {  
  52. $strSQL = "DELETE FROM customer ";  
  53. $strSQL .="WHERE CustomerID = '".$_GET["CusID"]."' ";  
  54. $objQuery = mssql_query($strSQL);  
  55. if(!$objQuery)  
  56. {  
  57. echo "Error Delete [".mssql_error()."]";  
  58. }  
  59. //header("location:$_SERVER[PHP_SELF]");  
  60. //exit();  
  61. }  
  62.   
  63. $strSQL = "SELECT * FROM customer";  
  64. $objQuery = mssql_query($strSQL) or die ("Error Query [".$strSQL."]");  
  65. ?>  
  66. <form name="frmMain" method="post" action="<?=$_SERVER["PHP_SELF"];?>">  
  67. <input type="hidden" name="hdnCmd" value="">  
  68. <table width="600" border="1">  
  69. <tr>  
  70. <th width="91"> <div align="center">CustomerID </div></th>  
  71. <th width="98"> <div align="center">Name </div></th>  
  72. <th width="198"> <div align="center">Email </div></th>  
  73. <th width="97"> <div align="center">CountryCode </div></th>  
  74. <th width="59"> <div align="center">Budget </div></th>  
  75. <th width="71"> <div align="center">Used </div></th>  
  76. <th width="30"> <div align="center">Edit </div></th>  
  77. <th width="30"> <div align="center">Delete </div></th>  
  78. </tr>  
  79. <?  
  80. while($objResult = mssql_fetch_array($objQuery))  
  81. {  
  82. ?>  
  83.   
  84. <?  
  85. if($objResult["CustomerID"] == $_GET["CusID"] and $_GET["Action"] == "Edit")  
  86. {  
  87. ?>  
  88. <tr>  
  89. <td><div align="center">  
  90. <input type="text" name="txtEditCustomerID" size="5" value="<?=$objResult["CustomerID"];?>">  
  91. <input type="hidden" name="hdnEditCustomerID" size="5" value="<?=$objResult["CustomerID"];?>">  
  92. </div></td>  
  93. <td><input type="text" name="txtEditName" size="20" value="<?=$objResult["Name"];?>"></td>  
  94. <td><input type="text" name="txtEditEmail" size="20" value="<?=$objResult["Email"];?>"></td>  
  95. <td><div align="center"><input type="text" name="txtEditCountryCode" size="2" value="<?=$objResult["CountryCode"];?>"></div></td>  
  96. <td align="right"><input type="text" name="txtEditBudget" size="5" value="<?=$objResult["Budget"];?>"></td>  
  97. <td align="right"><input type="text" name="txtEditUsed" size="5" value="<?=$objResult["Used"];?>"></td>  
  98. <td colspan="2" align="right"><div align="center">  
  99. <input name="btnAdd" type="button" id="btnUpdate" value="Update" OnClick="frmMain.hdnCmd.value='Update';frmMain.submit();">  
  100. <input name="btnAdd" type="button" id="btnCancel" value="Cancel" OnClick="window.location='<?=$_SERVER["PHP_SELF"];?>';">  
  101. </div></td>  
  102. </tr>  
  103. <?  
  104. }  
  105. else  
  106. {  
  107. ?>  
  108. <tr>  
  109. <td><div align="center"><?=$objResult["CustomerID"];?></div></td>  
  110. <td><?=$objResult["Name"];?></td>  
  111. <td><?=$objResult["Email"];?></td>  
  112. <td><div align="center"><?=$objResult["CountryCode"];?></div></td>  
  113. <td align="right"><?=$objResult["Budget"];?></td>  
  114. <td align="right"><?=$objResult["Used"];?></td>  
  115. <td align="center"><a href="<?=$_SERVER["PHP_SELF"];?>?Action=Edit&CusID=<?=$objResult["CustomerID"];?>">Edit</a></td>  
  116. <td align="center"><a href="JavaScript:if(confirm('Confirm Delete?')==true){window.location='<?=$_SERVER["PHP_SELF"];?>?Action=Del&CusID=<?=$objResult["CustomerID"];?>';}">Delete</a></td>  
  117. </tr>  
  118. <?  
  119. }  
  120. ?>  
  121. <?  
  122. }  
  123. ?>  
  124. <tr>  
  125. <td><div align="center"><input type="text" name="txtAddCustomerID" size="5"></div></td>  
  126. <td><input type="text" name="txtAddName" size="20"></td>  
  127. <td><input type="text" name="txtAddEmail" size="20"></td>  
  128. <td><div align="center"><input type="text" name="txtAddCountryCode" size="2"></div></td>  
  129. <td align="right"><input type="text" name="txtAddBudget" size="5"></td>  
  130. <td align="right"><input type="text" name="txtAddUsed" size="5"></td>  
  131. <td colspan="2" align="right"><div align="center">  
  132. <input name="btnAdd" type="button" id="btnAdd" value="Add" OnClick="frmMain.hdnCmd.value='Add';frmMain.submit();">  
  133. </div></td>  
  134. </tr>  
  135. </table>  
  136. </form>  
  137. <?  
  138. mssql_close($objConnect);  
  139. ?>  
  140. </body>  
  141. </html>  

Create a php file and save to path root-path/myphp/

Run
http://localhost/myphp/php_sqlserver_command.php

Screenshot

PHP & SQL Server (mssql) Add/Insert/Edit/Delete On Same Form

.
.
.
Download this script.
Download

Category: PHP & SQL Server by admin

1 Star2 Stars3 Stars4 Stars5 Stars6 Stars7 Stars8 Stars9 Stars10 Stars (1 votes, average: 1.00 out of 10)
Loading ... Loading ...

One Response to “How to use PHP & SQL Server (mssql) Add/Insert/Edit/Delete On Same Form”

  1. 1doublet, on January 13th, 2022 at 06:06 Said:

    2neptune…

    …

Leave a Reply

You must be logged in to post a comment.