How to Delete Data From Mysql Database

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

63 Comments

  • web site

    August 26, 2020 - 11:55 pm

    Greate 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 pm

    whoah 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 pm

    Hi, 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 pm

    You 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 pm

    This 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 am

    Hey 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 am

    I am regular visitor, how are you everybody? This post posted at this site
    is actually nice.

  • apprendre la photo

    August 23, 2020 - 8:24 pm

    I 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 pm

    Hello, 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 pm

    I 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 pm

    Thank 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 am

    I 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 am

    When 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 am

    Hello, 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 am

    Hello. excellent job. I did not imagine this.
    This is a remarkable story. Thanks!

  • led display

    August 23, 2020 - 6:20 am

    I 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 am

    Thanks 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 am

    Hello 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 am

    Thank 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 am

    Hey 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 pm

    Just 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 pm

    I 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 am

      Hi 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 pm

    Wow, 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 pm

    Hello, 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 pm

    Keep on working, great job!

  • adultfrinendfinder.com login

    August 22, 2020 - 10:56 am

    My 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 am

    This 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 pm

    Very soon this site will be famous amid all blogging
    viewers, due to it’s fastidious content

  • back

    August 21, 2020 - 2:54 pm

    Do 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 pm

    Please 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 am

    Amazing! 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 am

    I 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 pm

    Hello 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 pm

    I 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 pm

    I love it when individuals come together and share ideas.

    Great blog, continue the good work!

  • japanese mechanical watches

    August 18, 2020 - 7:55 am

    I’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 pm

    I 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 pm

    Wonderful, 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 pm

    Hello 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 am

    whoah 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 pm

    Les stratégies de transformation digitale.

  • ask

    August 14, 2020 - 10:25 pm

    We 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 am

    Pretty 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 am

    I 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 am

    Thanks 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 am

    Yes! Finally someone writes about youtube vidos rosa
    lopes de operacion triumfo unchained melody.

  • Central IT

    August 9, 2020 - 7:59 pm

    Appreciating 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 pm

    Thanks very nice blog!

  • 일본서버호스팅

    August 9, 2020 - 8:33 am

    Thank 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 am

      If You want to contact us Click here

  • 일본서버호스팅

    August 8, 2020 - 7:40 pm

    Greetings 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 am

    Excellent post! We will be linking to this particularly great article on our website. Keep up the great writing.

  • เล่นสล็อตฟรี

    August 6, 2020 - 11:41 am

    This paragraph offers clear idea for the new viewers of blogging, that really how to do blogging.

  • Situs slot habanero

    August 1, 2020 - 9:49 am

    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!!

  • kroger feed

    July 31, 2020 - 9:10 pm

    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.

    • royalrahul007

      August 1, 2020 - 1:25 am

      you can Contact Us by this link

  • 다이어트 도시락

    July 31, 2020 - 7:20 pm

    It’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 am

    I 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 am

    Wonderful 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 pm

    These 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 pm

    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..

  • Pembesar Payudara

    July 30, 2020 - 3:02 pm

    This article will help the internet viewers for creating
    new blog or even a blog from start to end.

Leave A Reply