mrguyhawkes
-
Posts
4 -
Joined
-
Last visited
Everything posted by mrguyhawkes
-
Can't execute php to delete multiple rows in database
mrguyhawkes replied to mrguyhawkes's topic in PHP Coding Help
your method actually works combined with AKADRUMMIN's method. But now i have a problem. as you can see in my code i have 8 rows with information. but some rows are not inserted because when i input data in db i have to choose which product description i need so others are left aas 0 ( null). https://docs.google.com/document/d/1wu2J2Jp4KAYEVyQ6B7KSGFp_7oeDttH7DwOPLMARfws/edit . This is how my data submition form looks like. But when i look at dvd for example, it shows only the size in mb, but the fields where it shows furniture dimensions are left as zeroes. how do i filter out zeroes and only show entries with data? it should look like this https://docs.google.com/document/d/1PzYObzyNIMBnzvkg22qTTmEk7H4jSsO4P6Bj9IABa2Y/edit -
Can't execute php to delete multiple rows in database
mrguyhawkes replied to mrguyhawkes's topic in PHP Coding Help
i tried all your suggestions but all i get is a black submit-copy.php page with no source. i moved my form out the while loop. also everytime i refresh page it asks for form resubmission. i think i screwed something up. -
Can't execute php to delete multiple rows in database
mrguyhawkes replied to mrguyhawkes's topic in PHP Coding Help
my submit button only is meant for deletion. i need to delete selected queries that are shown in form. i thought i needed to make new form for each record but i must be wrong. so i need to create all entries to show in one form? because i need checkbox by each record so that i select multiple and when i press mass delete button i can delete those data from database -
I'm trying to create a page where data is being displayed from database where data was inserted by other page. My data is displayed and i made checkboxes for it to select and a button to delete them. i can select them and when i press delete i made echo when it says that record deleted. Cant figure out why it doesnt actually delete from database. I want to delete by the row id. My index: <?php session_start(); require_once 'connection.php'; $sql = "SELECT * FROM test"; $all_product = $conn->query($sql); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="style.css"/> </head> <body> <div class="productList"> <div class="title"> <h1>Product List</h1> </div> <div class="button-container"> <a href="add-product.html"> <input type="button" class="addButton" value="ADD"> </a> <input type="submit" form="list-check-box" name="delete" id="#delete-product-btn" value="MASS DELETE" method="post"> </div> </div> <hr class="divLine"> <div class="show-list"> <?php while($row = mysqli_fetch_assoc($all_product)){ ?> <form class="grid-item" id="list-check-box" action="submit-copy.php" method="post"> <div class="list" > <p class="sku"> <input type="checkbox" id=".delete-checkbox" class="delete_checkbox" name="delete-product-btn[]" value="<?php $row['id'];?>"> <?php echo $row["sku"];?></p> <p class="name"><?php echo $row["name"];?></p> <p class="price"><?php echo $row["price"];?></p> </div> <div class="size"> <p class="size"><?php echo $row["size"];?></p> </div> <div class="weight"> <p class="weight"><?php echo $row["weight"];?></p> </div> <div class="furniture"> <p class="height"><?php echo $row["height"];?></p> <p class="width"><?php echo $row["width"];?></p> <p class="length"><?php echo $row["length"];?></p> </div> </form> <?php } ?> </div> <div class="footer"> <hr class="divLine"> <h4>Scandiweb Test assignment</h4> </div> </body> <?php include_once 'submit.php'; ?> </html> My PHP code: <?php session_start(); $id = $_POST["id"]; $host = "localhost"; $dbname = "productData"; $username = "root"; $password = "root"; $conn = mysqli_connect($host, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } // sql to delete a record $sql = "DELETE FROM test WHERE id IN($id)"; if(isset($_POST['delete'])){ $all_id = $_POST['delete-product-btn']; echo "Record deleted successfully"; } else { echo "Error deleting record: " . $conn->error; } $conn->close(); ?>