to delete 14 row by 1 click

by

You should have a hyperlink for delete action. 

<a href="https://stackoverflow.com/questions/50769173/delete.php?id=<?php echo $row->id;?>">
Delete Record
</a>

Here it appends record ID in url and it looks like delete.php?id=15

Now you want to delete previous 14 records. 

$currentId = $_GET['id'];//got from URL
$nextLimit = $currentId - 14; //in case of next 14 you need to add

Your SQL Query should be:

$query = "delete from table
          where id between '$currentId' and '$nextLimit'";

and execute the query.

More Related Contents:

  1. How to Update one column (point) in php sql [duplicate]
  2. SQL PHP Insert issue
  3. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE `id` [closed]
  4. how to get client’s IP address in sql database [closed]
  5. Combine multiple sql / mysql queries in one query
  6. How can create Database using url or other method [duplicate]
  7. Php foreach give 2 users random value
  8. Cleansing User Passwords
  9. Cannot simply use PostgreSQL table name (“relation does not exist”)
  10. SELECT COUNT(*) AS count – How to use this count
  11. selecting unique values from a column
  12. Simple PHP Pagination script [closed]
  13. I cannot get my login form to connect interact properly with mySQL database [closed]
  14. mysql_num_rows(): supplied argument is not a valid MySQL result resource [duplicate]
  15. Increment value in MySQL update query
  16. Do SQL connections opened with PDO in PHP have to be closed
  17. CodeIgniter MSSQL connection
  18. MySQLi prepared statements with IN operator [duplicate]
  19. Laravel Advanced Wheres how to pass variable into function?
  20. How to convert ISO8601 to Date format in php
  21. MySQL skipping first row
  22. How to reverse order output of a MySQL query
  23. How to execute my SQL query in CodeIgniter
  24. Fatal error: Call to a member function query() on null
  25. How would I implement a simple site search with php and mySQL?
  26. Log the actual SQL query using ActiveRecord with Yii2?
  27. How to check if a value already exists to avoid duplicates?
  28. MYSQL select a piece of a string and order by that piece
  29. PHP/MySQL Pagination
  30. Limit pagination page number

Leave a Comment