How to Delete Data From Mysql Database
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');
?>
How to Fetch Data From Mysql Database using PHP
Good post. I learn something new and challenging on websites I stumbleupon everyday.
It will always be exciting to read through content from other
authors and use something from other websites.
This article will help the internet viewers for creating
new blog or even a blog from start to end.
This website was… how do I say it? Relevant!! Finally I have found something which
helped me. Thanks!
Good day! Do you use Twitter? I’d like to follow you if that would be okay.
I’m absolutely enjoying your blog and look forward to new posts.
Fantastic beat ! I would like to apprentice whilst you amend your website, how can i subscribe for a blog website?
The account aided me a applicable deal. I have been a little bit familiar of this your broadcast offered bright clear idea
I 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..
Wow, this piece of writing is fastidious, my sister is analyzing these kinds of things, therefore I am going to inform her.
My brother recommended I might like this website. He was entirely right.
This post actually made my day. You can not imagine just
how much time I had spent for this info! Thanks!
Spot on with this write-up, I seriously feel this website needs a great deal more attention. I’ll probably be
back again to read more, thanks for the info!
These are in fact great ideas in on the topic of blogging.
You have touched some nice points here. Any way keep up wrinting.
Great article! That is the type of info that should be shared across the internet.
Disgrace on the seek engines for not positioning this put up upper!
Come on over and discuss with my site . Thanks =)
Wonderful article! We will be linking to this
great post on our website. Keep up the great writing.
I go to see everyday a few web pages and websites to read articles or reviews, but this blog gives quality based articles.
It is not my first time to visit this web site, i am
browsing this web site dailly and get fastidious data from here all the time.
I seriously love your website.. Great colors & theme. Did you build
this web site yourself? Please reply back as I’m planning to create my very own blog and want to learn where you got this from or just what the theme is called.
Cheers!
Hello Situs Slot termurah,
Yes i designed this website. If you contact me please click on this Link
It’s amazing designed for me to have a site,
which is useful in favor of my experience. thanks admin
Does 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.
you can Contact Us by this link
It is the best time to make some plans for the future and it is time to be happy.
I’ve learn this put up and if I may just I desire to suggest you
some interesting things or tips. Perhaps you could write next articles regarding this article.
I want to learn even more issues approximately it!
Hello There. I found your blog using msn. This is a really well written article.
I will be sure to bookmark it and return to read more of your
useful information. Thanks for the post. I’ll certainly return.
Awesome website you have here but I was curious if you knew of any discussion boards that cover the same topics
talked about here? I’d really like to be a part of group
where I can get feedback from other knowledgeable individuals that share the same interest.
If you have any recommendations, please let me know. Thank you!
Hello, 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!!
Heya i am for the primary time here. I came across this board and I find
It truly useful & it helped me out much. I hope to offer something
back and aid others such as you aided me.
I used to be able to find good advice from your blog posts.
I think that what you said was actually very logical.
But, consider this, what if you added a little content?
I mean, I don’t want to tell you how to run your blog, but what if you added a title to possibly get folk’s attention?
I mean How to Delete Data From Mysql Database – Hub of Tutorials is a little vanilla.
You ought to glance at Yahoo’s home page and watch how they
write article titles to grab people to open the links.
You might add a video or a related picture or two to grab
readers excited about everything’ve got to say.
Just my opinion, it might make your posts a little livelier.
This is very fascinating, You are a very professional
blogger. I have joined your rss feed and stay up for in search of
more of your wonderful post. Also, I have shared your site in my social
networks
Why people still make use of to read news papers when in this
technological globe everything is existing on web?
When I initially commented I clicked the “Notify me when new comments are added” checkbox and now each time
a comment is added I get three e-mails with the same comment.
Is there any way you can remove people from that service?
Bless you!
Hey there! I could have sworn I’ve been to this website before but after browsing through some of the post I realized it’s
new to me. Anyhow, I’m definitely delighted I found it and I’ll be bookmarking and checking back frequently!
Wow, awesome blog layout! How long have you been blogging for?
you made blogging look easy. The overall look of your website is great,
as well as the content!