In this tutorial, we will explain how to Delete Data from Mysql database which is already inserted in the database using PHP.
table.php
<?php
include(db.php);
?>
<html>
<head>
<title>Table</title>
</head>
<body>
<div class="table">
<div class="tab1"><h1>Name</h1></div>
<div class="tab1"><h1>Father name</h1></div>
<div class="tab1"><h1>Mother name</h1></div>
<div class="tab1"><h1>E-mail</h1></div>
<div class="tab1"><h1>Address</h1></div>
<div class="tab1"><h1>DOB</h1></div>
<div class="tab1"><h1>Category</h1></div>
<div class="tab1"><h1>Image</h1></div>
<div class="tab1"><h1>Action</h1></div>
<div class="tab1"><h1>Delete</h1></div>
<?php $query1 = "select * from new order by id desc limit 0,30";
$query2 = mysql_query($query1);
while($row = mysql_fetch_array($query2)) { ?>
<div class="tab1"><h1><?php echo $row['name'];?></h1></div>
<div class="tab1"><h1><?php echo $row['father_name'];?></h1></div> <!--from database-->
<div class="tab1"><h1><?php echo $row['mother_name'];?></h1></div>
<div class="tab1"><h1><?php echo $row['e_mail'];?></h1></div>
<div class="tab1"><h1><?php echo $row['address'];?></h1></div>
<div class="tab1"><h1><?php echo $row['dob'];?></h1></div>
<div class="tab1"><h1><?php echo $row['category'];?></h1></div>
<div class="tab1"><h1><a href="delete.php?id=<?php //echo $row['id'];?>">Delete</a></h1></div>
<?php } ?>
</div>
</body>
</html>
style.css
.table{
height:400px;
width:100%;
float:left;
}
.tab1{
width:9.5%;
height:42px;
border:1px #000000 solid;
float:left;
}
.tab1 h1{
width:70px;
height:20px;
font-size:18px;
float:left;
margin:0px;
padding:0px 30px;
}
.tab1 h2{
width:89.5px;
height:20px;
font-size:18px;
float:left;
margin:0px;
padding:0px 15px;
}
delete.php
<?php include(db.php); $id = $_GET['id']; $querydel = "delete from new where id = '$id' "; mysql_query($querydel); ?>
db.php
<?php
mysql_connect('localhost', 'root', '');
mysql_select_db('db');
?>
63 Comments
web site
August 26, 2020 - 11:55 pmGreate article. Keep posting such kind of info on your page.
Im really impressed by your blog.
Hello there, You’ve performed a fantastic job. I will certainly digg it and in my view suggest to my friends.
I am confident they will be benefited from this web site.
how to unclog a kitchen sink
August 25, 2020 - 10:39 pmwhoah this blog is fantastic i really like reading your articles.
Keep up the great work! You know, a lot of individuals are searching round for
this info, you could help them greatly.
해외에이전시
August 24, 2020 - 10:01 pmHi, I do believe this is a great web site. I stumbled upon it 😉
I may revisit once again since I have bookmarked it.
website
August 24, 2020 - 5:27 pmYou made some really good points there. I checked on the
web for more info about the issue and found most individuals will go along with your views on this website.
dias festivos en el salvador segun codigo de trabajo
August 24, 2020 - 2:02 pmThis is the right website for anybody who wants to understand this
topic. You know so much its almost tough to argue with you (not that I personally will need to…HaHa).
You certainly put a fresh spin on a topic which has been written about
for years. Great stuff, just excellent!
http://heavylathemachinejobwork79011.bloginwi.com/20306700/top-heavy-machine-operator-secrets
August 24, 2020 - 4:16 amHey I am so excited I found your weblog, I really found
you by error, while I was browsing on Bing for something else, Anyways I am here now and
would just like to say thanks a lot for an incredible post and an all
round exciting blog (I also love the theme/design), I don’t have time to go through
it all at the moment but I have bookmarked
it and also added in your RSS feeds, so when I have time
I will be back to read a lot more, Please do keep up the fantastic job.
빚갚는방법
August 24, 2020 - 3:34 amI am regular visitor, how are you everybody? This post posted at this site
is actually nice.
apprendre la photo
August 23, 2020 - 8:24 pmI believe that is among the such a lot significant information for me.
And I am happy to read your article. However, want to
remark on few basic things, The web site taste is great, the articles are truly great : D.
Just right job, cheers
cool soccer moves that are easy to learn
August 23, 2020 - 7:17 pmHello, the whole thing is going well here and ofcourse every one is sharing facts, that’s
really excellent, keep up writing.
Fargo Elderly Apartments
August 23, 2020 - 1:14 pmI love your blog.. very nice colors & theme.
Did you make this website yourself or did you hire someone to do it for you?
Plz, reply as I’m looking to create my own blog and would like to know where u got this from.
kudos
công ty tư vấn định cư glfin
August 23, 2020 - 12:25 pmThank you, I have recently been searching for info approximately this subject for a long
time and yours is the greatest I have found out till now.
However, what in regards to the bottom line? Are you certain about the supply?
avertizori pescuit
August 23, 2020 - 11:34 amI was recommended this web site by means of
my cousin. I am not positive whether or not this post is written through him as nobody
else recognise such exact about my trouble. You are amazing!
Thanks!
XSHP
August 23, 2020 - 10:48 amWhen some one searches for his necessary thing,
therefore he/she wants to be available that in detail,
so that thing is maintained over here.
KQXSBN
August 23, 2020 - 9:35 amHello, i think that i saw you visited my website thus
i came to ?return the favor?.I’m trying to find things to enhance
my web site!I suppose its ok to use a few of your ideas!!
pet friendly apartments memphis tn
August 23, 2020 - 6:42 amHello. excellent job. I did not imagine this.
This is a remarkable story. Thanks!
led display
August 23, 2020 - 6:20 amI need to to thank you for this wonderful read!! I certainly enjoyed
every little bit of it. I’ve got you bookmarked to check out
new stuff you post…
Hai San Mr D 0938.452.752
August 23, 2020 - 5:51 amThanks for the marvelous posting! I actually enjoyed reading it, you happen to be a great author.I will make certain to
bookmark your blog and definitely will come back at some point.
I want to encourage that you continue your great writing, have a nice morning!
victims.wiki
August 23, 2020 - 3:43 amHello it’s me, I am also visiting this website on a regular basis,
this site is actually nice and the visitors
are truly sharing pleasant thoughts.
classinzoom.com
August 23, 2020 - 2:59 amThank you for the good writeup. It in fact was a amusement account it.
Look advanced to far added agreeable from you! However, how could we communicate?
3 inch Composite Deck
August 23, 2020 - 2:29 amHey there! This is kind of off topic but I need some advice from an established blog.
Is it hard to set up your own blog? I’m not very techincal but I can figure things out pretty fast.
I’m thinking about setting up my own but I’m not sure where to begin. Do you have any ideas or suggestions?
Many thanks https://keystarindustries.com/3-composite-deck-keystar-industries/
family fun in orlando
August 22, 2020 - 3:18 pmJust wish to say your article is as surprising. The clarity in your post is just spectacular and i can assume you
are an expert on this subject. Well with your permission let me to grab your RSS feed to keep up to date with forthcoming post.
Thanks a million and please carry on the rewarding work.
houston fun places
August 22, 2020 - 2:56 pmI absolutely love your website.. Great colors & theme.
Did you develop this site yourself? Please reply back as
I’m trying to create my very own blog and want to know where you got this from or
exactly what the theme is called. Many thanks!
Rahul Kumar
August 23, 2020 - 2:12 amHi houston,
We design this website. Do you want your own website?
Contact US
fun games for 9 year old boys
August 22, 2020 - 2:19 pmWow, this piece of writing is nice, my younger sister is analyzing these things, thus I am going to convey her.
golf balls
August 22, 2020 - 1:52 pmHello, i feel that i saw you visited my blog so i got
here to go back the choose?.I am trying to find things to improve my site!I suppose its ok to make use of a few
of your ideas!! https://mycustomgolfball.com/157-golf-balls
SXHP
August 22, 2020 - 12:23 pmKeep on working, great job!
adultfrinendfinder.com login
August 22, 2020 - 10:56 amMy relatives always say that I am killing my time here at net, however I know I am getting know-how everyday
by reading such good articles or reviews.
Vito
August 22, 2020 - 12:03 amThis website was… how do you say it? Relevant!! Finally I’ve found
something which helped me. Thanks a lot!
foundation repair
August 21, 2020 - 6:41 pmVery soon this site will be famous amid all blogging
viewers, due to it’s fastidious content
back
August 21, 2020 - 2:54 pmDo you mind if I quote a few of your articles
as long as I provide credit and sources back to your blog?
My blog is in the very same niche as yours and my users would definitely benefit from a lot of the
information you present here. Please let me know if this ok with you.
Many thanks!
money
August 21, 2020 - 2:38 pmPlease let me know if you’re looking for a article writer for your
blog. You have some really good articles and I feel I would be a good asset.
If you ever want to take some of the load off, I’d love to write some content for your blog in exchange for a
link back to mine. Please shoot me an e-mail if interested.
Cheers!
http://inpris.net
August 21, 2020 - 6:08 amAmazing! Its actually remarkable article, I have got much clear idea on the topic of from this article.
adlut friend finder
August 21, 2020 - 4:03 amI love your blog.. very nice colors & theme. Did you design this
website yourself or did you hire someone to do it for you?
Plz answer back as I’m looking to design my own blog
and would like to find out where u got this from.
thanks a lot
adultfriendsfinders
August 20, 2020 - 12:19 pmHello mates, how is everything, and what you
want to say about this post, in my view its truly awesome in support of me.
fun things to do in minneapolis this weekend
August 18, 2020 - 9:07 pmI absolutely love your blog and find many of your post’s to be just what
I’m looking for. Would you offer guest writers to write content for you?
I wouldn’t mind composing a post or elaborating on a number of
the subjects you write with regards to here. Again, awesome web site!
foundation repair
August 18, 2020 - 2:29 pmI love it when individuals come together and share ideas.
Great blog, continue the good work!
japanese mechanical watches
August 18, 2020 - 7:55 amI’m really loving the theme/design of your weblog.
Do you ever run into any web browser compatibility issues?
A small number of my blog readers have complained about my website not working correctly in Explorer
but looks great in Chrome. Do you have any suggestions to
help fix this problem?
Sandra
August 16, 2020 - 9:50 pmI got this site from my friend who shared with me about this site
and now this time I am browsing this web page and reading very informative articles at this place.
đánh giá nhà cái
August 16, 2020 - 4:45 pmWonderful, what a web site it is! This web site presents valuable data to us, keep it up.
https://www.google.com/maps/d/edit?mid=1HwR6AJrb1QOHrtZhqX5Z-If0G-c1_qvK&usp=sharing
August 16, 2020 - 2:31 pmHello would you mind letting me know which hosting company you’re using?
I’ve loaded your blog in 3 completely different internet browsers and
I must say this blog loads a lot faster then most. Can you recommend
a good internet hosting provider at a honest price?
Cheers, I appreciate it!
joker388
August 16, 2020 - 2:36 amwhoah this blog is wonderful i like studying your posts.
Stay up the great work! You know, lots of people are
looking round for this info, you could help them
greatly.
https://rb.gy/k2bsu4
August 15, 2020 - 2:28 pmLes stratégies de transformation digitale.
ask
August 14, 2020 - 10:25 pmWe are a group of volunteers and starting a new scheme in our community.
Your website provided us with valuable info to work on. You have done a formidable job
and our entire community will be grateful to you.
www.tantrictop.co.uk
August 14, 2020 - 5:00 amPretty section of content. I just stumbled upon your blog and in accession capital to assert that I get in fact enjoyed account your blog posts.
Any way I will be subscribing to your augment and even I achievement you access consistently rapidly.
http://www.authorstream.com/reiginnamedoza
August 12, 2020 - 10:47 amI simply could not leave your website before suggesting that I really
enjoyed the standard info an individual supply on your visitors?
Is going to be back frequently to investigate cross-check new posts
googl
August 12, 2020 - 8:09 amThanks for the marvelous posting! I actually enjoyed reading it, you happen to be a great
author.I will be sure to bookmark your blog and will often come back down the road.
I want to encourage continue your great posts, have a
nice morning!
Lynne
August 11, 2020 - 7:44 amYes! Finally someone writes about youtube vidos rosa
lopes de operacion triumfo unchained melody.
Central IT
August 9, 2020 - 7:59 pmAppreciating the commitment you put into your blog and in depth
information you provide. It’s nice to come across a blog every once in a while that isn’t
the same unwanted rehashed material. Excellent read!
I’ve bookmarked your site and I’m including your RSS feeds to
my Google account.
Situs Judi
August 9, 2020 - 4:00 pmThanks very nice blog!
일본서버호스팅
August 9, 2020 - 8:33 amThank you for the good writeup. It in reality used to be a leisure account it.
Glance complex to far delivered agreeable from you!
However, how can we keep in touch?
royalrahul007
August 10, 2020 - 1:23 amIf You want to contact us Click here
일본서버호스팅
August 8, 2020 - 7:40 pmGreetings from Carolina! I’m bored to tears at work so I decided to
browse your site on my iphone during lunch break. I love the info you present here and can’t
wait to take a look when I get home. I’m surprised at how quick your blog loaded on my
phone .. I’m not even using WIFI, just 3G ..
Anyhow, fantastic blog!
918kiss apk
August 8, 2020 - 9:14 amExcellent post! We will be linking to this particularly great article on our website. Keep up the great writing.
เล่นสล็อตฟรี
August 6, 2020 - 11:41 amThis paragraph offers clear idea for the new viewers of blogging, that really how to do blogging.
Situs slot habanero
August 1, 2020 - 9:49 amHello, i think that i saw you visited my web site thus i got
here to return the favor?.I am trying to in finding things to improve my website!I guess its good enough to make use of some of your
ideas!!
kroger feed
July 31, 2020 - 9:10 pmDoes your site have a contact page? I’m having a tough time locating it but, I’d like to send you an email.
I’ve got some ideas for your blog you might be interested in hearing.
Either way, great website and I look forward to seeing it develop over time.
royalrahul007
August 1, 2020 - 1:25 amyou can Contact Us by this link
다이어트 도시락
July 31, 2020 - 7:20 pmIt’s amazing designed for me to have a site,
which is useful in favor of my experience. thanks admin
883111.org
July 31, 2020 - 3:24 amI go to see everyday a few web pages and websites to read articles or reviews, but this blog gives quality based articles.
https://angel.co/company/get-success-in-cba-exams-with-latest-cba-pdf-dumps
July 31, 2020 - 3:05 amWonderful article! We will be linking to this
great post on our website. Keep up the great writing.
fun places to go near me for kids
July 30, 2020 - 9:32 pmThese are in fact great ideas in on the topic of blogging.
You have touched some nice points here. Any way keep up wrinting.
Perawatan Wajah
July 30, 2020 - 5:17 pmI am extremely impressed together with your writing skills as neatly as with the format to your blog.
Is that this a paid topic or did you modify it yourself?
Anyway keep up the excellent high quality writing, it is rare
to see a great weblog like this one these days..
Pembesar Payudara
July 30, 2020 - 3:02 pmThis article will help the internet viewers for creating
new blog or even a blog from start to end.