How To Achieve Checking Multiple Selections And Batch Deletions In Web Report?
2010-01-26 at 09:26 am hugegeSometimes I have to do some simple operation time and again in a web report.For example, there are a lot of data on a web page when making a row input report. I may want to delete the data of 28 rows. If they have to click the “Delete” button every time when they delete a row, the page will be refreshed 28 times. That’s very inefficiency.
Then, how to achieve checking multiple selections and batch deletions in web report?
Hi!
RAQ Report is a pure Web-based Java reporting tool. As it is a professional Web reporting tool, RAQ Report can help users to achieve batch selection and deletion in a row input easily.
Operation
With RAQ Report, you only need 4 steps.
Step 1: Design the web report in RAQ Report’s real Excel-like design interface.
Step 2: In the jsp file, add batch deletion javascript.
Step 3: In the jsp file, add checkbox javascript.
Step 4: In the jsp file, add operating button javascript.
For more details and graphic illustration, you can refer to my blog at http://freezea.blogspot.com/.
Good luck.
You don’t specify the platform you are using and thus the technology you want to use.
1 2 3In PHP, you can simply use a foreach loop, which will take the array of checkboxes, to repeat the same basic query each time. Assume you have a checkbox array like this:
This PHP code could be used:
< ?php
foreach($item in $_POST['item_id']) {
$rs = mysql_query("DELETE FROM table WHERE id = $item");
}
?>