Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <td><button type="button" class="delete" onclick="deleteRow(this)">Delete</button></td>
- function deleteRow(r) {
- if (confirm('Are you sure you want to delete this entry?')) {
- var i = r.parentNode.parentNode.rowIndex;
- document.getElementById("skuTable").deleteRow(i);
- }
- request = $.ajax({
- type: "POST",
- url: "delete.php",
- data: "Group_ID="+i
- });
- request.done(function (response, textStatus, jqXHR){
- if(JSON.parse(response) == true){
- console.log("row deleted");
- } else {
- console.log("row failed to delete");
- }
- });
- // Callback handler that will be called on failure
- request.fail(function (jqXHR, textStatus, errorThrown){
- // Log the error to the console
- console.error(
- "The following error occurred: "+
- textStatus, errorThrown
- );
- });
- // Callback handler that will be called regardless
- // if the request failed or succeeded
- request.always(function () {
- });
- }
- <?php
- $SKU_Group = $_POST['SKU Group'];
- $Group_ID = $_POST['Group_ID'];
- $host="xxxxxxxxxx";
- $dbName="xxxxxx";
- $dbUser="xxxxxxxxxxxx";
- $dbPass="xxxxx";
- $pdo = new PDO("sqlsrv:server=".$host.";Database=".$dbName, $dbUser, $dbPass);
- $delete = "DELETE FROM SKU_Group_Dim WHERE Group_ID = '$Group_ID'";
- $stmt = $pdo->prepare($delete);
- $result = $stmt->execute();
- echo json_encode($result);
- if(!$result) {
- echo sqlsrv_errors();
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement