Case Study : Create function to delete multiple data on the database with checkbox component
Requirements : Webserver Packages, already installed.
Multi-delete Checkbox like in Gmail, we can choose to delete a message in our inbox smply by clicking the checkbox on the data that we want to remove. This tutorial will create a sample application to remove the data – specific data which is marked by checkbox (like in Gmail).
Ok, let’s get into the tutorial.
Step 1 : Prepare the Database
- Create database named db_tutorial
- Prepare a table named tb_kota, with structure like picture below,
- Insert some sample data like below,
- Done!
Step 2 : Prepare the work directory
- Create folder named tutorphp in your document root
- Save all file in this tutorial in this folder.
Step 3 : Create a connection to DB script
- Type the following script,
<?php $host = "localhost"; $user = "root";//adjust according to your mysql setting $pass = ""; //adjust according to your mysql setting, i use no password here $dbName = "db_tutorial"; mysql_connect($host, $user, $pass); mysql_select_db($dbName) or die ("Connect Failed !! : ".mysql_error()); ?> - Save with the name connect.php
Step 4 : Script to Show the Data
- Type the following script,
<html><head> <title>Itx.Web.Id</title> <script type="text/javascript" src="pilihan.js"></script> <script type="text/javascript" src="warning.js"></script> </head> <body> <h2> The Data <h2> <?php include 'connect.php'; $query = "SELECT * FROM tb_book"; //the query for get all data in tb_student $result = mysql_query($query); ?> <form name="myform" method="post" action="prosesdeletemulti.php"> <?php echo "<table border='0' cellpadding='2' cellspacing='2'>"; echo "<tr bgcolor='orange'> <td> <b> Title </b> </td> <td> <b> Author </b> </td> </tr>"; $i = 0; while ($data = mysql_fetch_array($result)) { //mysql_fetch_array = get the query data into array echo "<tr> <td>".$data['title']."</td> <td>".$data['author']."</td> "; ?> <td><input type="checkbox" name="id[<?php echo $i;?>]" value="<?php echo $data['id'];?>" /></td> <?php $i++; } echo "</table>"; ?> <td> <input type="submit" value="Delete" onClick="return warning();" name="submit"> <input type="reset" value="Cancel" name="reset"> </td> </form> </body> </html> - save with the name student_data1.php
Step 5 : Create javascript to show warning
- Type the following script,
function warning() { return confirm('Are You Sure to Delete This Data?'); } - save with the name warning.js
Step 6 : Javascript to get the checkbox ed component
- Type the following script,
function pilihan() { // read the component from 'myform' var jumKomponen = document.myform.length; // no check all if (document.myform[0].checked == false) { for (i=1; i<=jumKomponen; i++) { if (document.myform[i].type == "checkbox") document.myform[i].checked = false; } } } - save with the name pilihan.js
Step 7 : Script to process delete multiple data
- Type the following script,
<?php include 'connect.php'; $data = $_POST['id']; //get all the id book that will be deleted foreach($data as $data1) { //looping according to the total data that checked //echo $data1; $query = "DELETE FROM tb_book where id = $data1"; //the query to delete data according to id $result = mysql_query($query); } if ($result) { include "student_data1.php"; echo "Delete sucess"; } ?> - save with the name prosesdeletemulti.php
Step 8 : Testing Code
- Go to http://localhost/tutorphp/student_data1.php. Check the checkbox on the data where you will delete the data.
- Warning appear. Choose Ok.
- Success confirmation appear, and the data really has been deleted. Check your database also
For the script explanation.. see script comment. and feel free to comment
OK. Haaaaaaaapppy Coding!
Others that might interesting too:
Copyright
All scripts and techniques demonstrated on itx.web.id can be used in whatever manner you wish without attribution. You cannot copy whole tutorials, either in English or translated to another language.
This post is also available in: Indonesian
English 
Indonesia
It is very difficult to delete them but you tell it very simply
Wow, amazing blog layout! How long have you been blogging for? you made blogging look easy. The overall look of your web site is wonderful, as well as the content!. Thanks For Your article about Delete Multiple Data with PHP .
Hell, I never vote for anybody, I always vote against. ~W.C. Fields
An election is coming. Universal peace is declared, and the foxes have a sincere interest in prolonging the lives of the poultry. ~George Eliot, Felix Holt, Chapter 5 (Thanks Julie!)
Alege elegant si simplu, alege online! Rochii Online iti aduce cele mai noi colectii de rochii din Marea Britanie. Indiferent daca esti in cautare de: Rochii de Ocazie, Rochii Club, Rochii de Vara 2012 sau Rochii Office Rochii Online este locul potrivit. Preturi mici si calitate maxima, numai pe RochiiOnline.me. Reduceri la doar un click distanta. Alege eficient si elegant!
Very interesting subject , thanks for posting . “He who seizes the right moment is the right man.” by Johann Wolfgang von Goethe.
Whats Going down i am new to this, I stumbled upon this I’ve found It positively helpful and it has helped me out loads. I am hoping to give a contribution & help different users like its helped me. Great job.
Good site! I really love how it is easy on my eyes and the data are well written. I am wondering how I could be notified when a new post has been made. I have subscribed to your RSS which must do the trick! Have a great day!
I have viewed that smart real estate agents almost everywhere are starting to warm up to FSBO Promotion. They are seeing that it’s in addition to placing a poster in the front place. It’s really concerning building human relationships with these retailers who at some point will become buyers. So, if you give your time and energy to serving these retailers go it alone : the “Law connected with Reciprocity” kicks in. Interesting blog post.
We wish to thank you all over again for the stunning ideas you offered Jesse when preparing her own post-graduate research as well as, most importantly, for providing many of the ideas in one blog post. Provided that we had known of your blog a year ago, we may have been saved the unwanted measures we were selecting. Thanks to you.
We stumbled over here from a different website and thought I might check things out. I like what I see so now i’m following you. Look forward to looking at your web page yet again.
Rattling instructive and good anatomical structure of content material , now that’s user friendly (:.
I regard something genuinely interesting about your blog so I saved to bookmarks .
I am glad I discovered another blog with a common wine beverages theme!
I arrived predicting something different, but this was great anyway. Well constructed stuff.
I mastered more new stuff on this fat reduction issue. One particular issue is that good nutrition is very vital if dieting. A huge reduction in bad foods, sugary meals, fried foods, sugary foods, beef, and white flour products may be necessary. Possessing wastes bloodsuckers, and contaminants may prevent desired goals for fat loss. While selected drugs momentarily solve the condition, the awful side effects will not be worth it, and they also never provide more than a short-lived solution. It can be a known undeniable fact that 95% of dietary fads fail. Thanks for sharing your thinking on this blog.
Extraordinarily educative thanks, I believe your trusty readers may want even more information such as this carry on the terrific effort.
hello there and thank you for your information – I’ve definitely picked up something new from right here. I did however expertise a few technical points using this site, as I experienced to reload the website lots of times previous to I could get it to load properly. I had been wondering if your hosting is OK? Not that I’m complaining, but slow loading instances times will very frequently affect your placement in google and could damage your quality score if advertising and marketing with Adwords. Well I am adding this RSS to my email and could look out for a lot more of your respective intriguing content. Make sure you update this again very soon..
Heya! I just wanted to ask if you ever have any trouble with hackers? My last blog (wordpress) was hacked and I ended up losing a few months of hard work due to no data backup. Do you have any methods to stop hackers?
I love what you guys are usually up too. This kind of clever work and exposure! Keep up the good works guys I’ve included you guys to my blogroll.
Hola! I’ve been following your blog for some time now and finally got the bravery to go ahead and give you a shout out from Lubbock Texas! Just wanted to mention keep up the great work!
7.I truly like your post. It’s evident that you have a good deal understanding on this topic. Your points are effectively created and relatable. Thanks for writing engaging and intriguing material.
Thank you, I’ve just been looking for information about this subject for a long time and yours is the best I have came upon so far. But, what in regards to the conclusion? Are you sure concerning the source?
Attractive section of content. I just stumbled upon your blog and in accession capital to assert that I acquire in fact enjoyed account your blog posts. Any way I抣l be subscribing to your augment and even I achievement you access consistently rapidly.
Hey there this is kinda of off topic but I was wondering if blogs use WYSIWYG editors or if you have to manually code with HTML. I’m starting a blog soon but have no coding skills so I wanted to get guidance from someone with experience. Any help would be enormously appreciated!
What i do not understood is in fact how you are now not really a lot more well-preferred than you may be right now. You are so intelligent. You recognize therefore considerably with regards to this matter, produced me personally imagine it from so many various angles. Its like men and women are not involved except it¡¦s something to do with Lady gaga! Your individual stuffs nice. All the time take care of it up!
fantastic points altogether, you just gained a new reader. What would you recommend in regards to your publish that you made a few days ago? Any positive?
Hello there! I know this is kinda off topic but I was wondering if you knew where I could locate a captcha plugin for my comment form? I’m using the same blog platform as yours and I’m having trouble finding one? Thanks a lot!
Hey there! I know this is kinda off topic nevertheless I’d figured I’d ask. Would you be interested in trading links or maybe guest authoring a blog article or vice-versa? My blog discusses a lot of the same topics as yours and I think we could greatly benefit from each other. If you happen to be interested feel free to shoot me an e-mail. I look forward to hearing from you! Great blog by the way!
It’s just the thing calculate to achieve some diplomacy for the impending and it is calculate to ensue in high spirits. I’ve interpret this post and if I could I long for to evoke you few exciting possessions before advice. Maybe you could engrave next articles referring to this article. I desire to read equal further things about it!|
Hello, i read your blog from time to time and i own a similar one and i was just curious if you get a lot of spam feedback? If so how do you stop it, any plugin or anything you can advise? I get so much lately it’s driving me crazy so any support is very much appreciated.
Very interesting information!Perfect just what I was looking for! “Oh, I don’t blame Congress. If I had 600 billion at my disposal, I’d be irresponsible, too.” by Lichty and Wagner.
There’s definately a lot to find out about this topic. I really like all of the points you made.
Your style is unique compared to other folks I have read stuff from. Many thanks for posting when you have the opportunity, Guess I’ll just book mark this web site.
Great article! I loved it, I can not wait for the next one. I’m waiting for more!
You can definitely see your skills in the paintings you write. The arena hopes for even more passionate writers like you who are not afraid to mention how they believe. All the time follow your heart. “The most profound joy has more of gravity than of gaiety in it.” by Michel de Montaigne.
Hello there there, just became alert towards your web site by Google, and identified that it is really informative. I’m going to watch out for brussels. I’ll appreciate when you continue on this in future. Numerous folks will probably be benefited from your producing. Cheers!
I picture this could be a number of upon the written content material? nevertheless I nonetheless consider that it may be suitable for just about any type of subject subject matter, as a result of it will regularly be gratifying to resolve a warm and delightful face or perhaps pay attention a voice whilst initial landing.
You created some decent factors there. I looked on the internet for that issue and discovered a lot of people goes also as together with your web page.
I am curious to locate out what weblog platform you might be working with? I’m obtaining some little safety problems with my newest site and I’d like to come across something extra safeguarded. Do you have any ideas?
I’m sorry, that has interfered… I have an understanding of this query. It really is doable to go over.
Howdy just wanted to give you a quick heads up. The text in your article seem to be running off the screen in Firefox. I’m not sure if this is a format issue or something to do with browser compatibility but I thought I’d post to let you know. The design look great though! Hope you get the issue resolved soon. Kudos
Prince of Persia is definitely the best, i definitely just like the lead actor and also the princess, the princess is very pretty..
Wow. There’s so considerably information right here it hurts my head. Great job
Splendid post writing. I concur. Visit my blog for a free trial now! Enjoy secret enlargement tips. Get big and rich. Did I mention free trial? Visit now.
Hi, Neat post. There’s an issue together with your website in internet explorer, could check this IE still is the marketplace chief and a big component to people will leave out your great writing due to this problem.
Hi there! Someone in my Myspace group shared this site with us so I came to check it out. I’m definitely loving the information. I’m bookmarking and will be tweeting this to my followers! Fantastic blog and superb style and design.
This blog rocks! I love it!
You really make it appear really easy together with your presentation but I to find this topic to be really something which I feel I’d never understand. It kind of feels too complicated and extremely vast for me. I am taking a look ahead to your next post, I will try to get the hang of it!
Do you have a spam issue on this website; I also am a blogger, and I was wanting to know your situation; we have developed some nice practices and we are looking to exchange methods with other folks, be sure to shoot me an e-mail if interested.
Incredible! This blog looks just like my old one! It’s on a completely different topic but it has pretty much the same layout and design. Outstanding choice of colors!
Hello! I just wanted to ask if you ever have any issues with hackers? My last blog (wordpress) was hacked and I ended up losing months of hard work due to no back up. Do you have any solutions to protect against hackers?
Have you ever considered about including a little bit more than just your articles? I mean, what you say is fundamental and everything. Nevertheless think of if you added some great images or videos to give your posts more, “pop”! Your content is excellent but with images and video clips, this site could undeniably be one of the greatest in its field. Fantastic blog!
I really enjoy studying on this site, it holds superb articles. “One should die proudly when it is no longer possible to live proudly.” by Friedrich Wilhelm Nietzsche.
Does your website have a contact page? I’m having problems locating it but, I’d like to shoot you an e-mail. I’ve got some suggestions for your blog you might be interested in hearing. Either way, great site and I look forward to seeing it develop over time.
Just wish to say your article is as astonishing. The clearness in your post is just excellent and i could assume you’re an expert on this subject. Well with your permission allow me to grab your RSS feed to keep up to date with forthcoming post. Thanks a million and please continue the enjoyable work.
Fantastic post however I was wanting to know if you could write a litte more on this subject? I’d be very thankful if you could elaborate a little bit further. Bless you!
Hi i like your Blog! The information is great keep it up. It is very useful.
Like what i seen here, it was very interesting to see and visit all the great stuff on here, and would very much recommend this site to someone else also. Great Job…
Hey there would you mind stating which blog platform you’re using? I’m planning to start my own blog soon but I’m having a tough time selecting between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design seems different then most blogs and I’m looking for something unique. P.S Apologies for being off-topic but I had to ask!