How to Delete Record From Table Using PHP MySQL



Allowing users to deactivate/delete their account, to delete post/article and even friend and unfriend system however require the PHP MYSQL delete query if you’re dealing with PHP MYSQL database.








To delete post, user account all require this same delete query. So in this tutorial I’ll be showing you how to delete post from table using MySQL delete query.

php mysql delete query


some useful tutorials:

Building JavaScript WYSIWYG Text Editor From Scratch

How to Make Facebook Kind of Like Button Using PHP Programming Language

How to Get Value from URL Using PHP Programming Language

Reading on I hope you already have your database, table created and some pretty records inserted in it then next is for us to get our hands dirty with the coding process.
Everything is going to be put in same web page.

So I have a DATABASE name -> delete and a TABLE name -> record.

My table has three rows: post_id, post_title and post_content.
post_id          post_title      post_content
1                      coding           coding is important


Now below is the entire code for deleting record from table:

<!DOCTYPE html>
<htmL>
<head>
<title>mysql delete query</title>
</head>
<body>
<form action="" class="signup-form-class">
<input type="submit" name="delete-submit" value="delete" />
</form>
<?php
$mydb = new mysqli("localhost", "root", "", "delete");
if(isset($_POST['delete-submit']))
{
$post_id = 1;
$postid = $post_id;
$su = $mydb->prepare("DELETE FROM record WHERE post_id='{$postid}'");
$su->execute();
If($su)
{
Echo “post deleted!”;
}
}
?>
</body>
</html>

An html form with no input field, the form has one delete button.

Read all about html form






I put both the delete button and the delete MYSQL query in the same page. As you can see, there is no METHOD attribute in the form simply because I’m not posting anything into the database.

If the delete query is successful, then you’ll get “post deleted!” report message.

Remember I did Demo about the table, which has one record, post_id =1, post_title=coding and post_content=coding is important.

I did not fetch record from the table, so I assigned the post_id value which is 1 to a variable which I name ($post_id = 1;) and assigned the variable $post_id into $postid ($postid = $post_id;).

Subscribe, follow us more are on the way.

Comments

  1. KayalApril 20, 2019 at 11:17 PM

    Great blog! Your explanation style is too good, it is very impressed to me. I want more unique posts and Keeping the good work...

    Oracle DBA Training in Chennai
    Oracle DBA Course in Chennai
    Unix Training in Chennai
    Oracle Training in Chennai
    Pega Training in Chennai
    Primavera Training in Chennai
    Excel Training in Chennai
    Corporate Training in Chennai
    Tableau Training in Chennai

    ReplyDelete
  2. Being Morning StarMay 27, 2019 at 7:48 AM

    Valueable information

    ReplyDelete
    Replies
    1. JerryMay 27, 2019 at 8:50 AM

      Thanks! Please subscribe to the blog for more updates.

      Delete
  3. Anbarasan14June 17, 2019 at 5:06 AM

    Excellent idea! Kind sharing this blog. I am sure that reading your blog leaves the people with some good learning experience. Great job.
    IELTS Coaching in Anna Nagar
    IELTS Coaching in Chennai Anna Nagar
    IELTS Coaching in Adyar
    IELTS Coaching in Porur
    IELTS Coaching in Mumbai
    Best English Speaking Classes in Mumbai
    Spoken English Classes in Chennai
    IELTS Coaching Centre in Chennai

    ReplyDelete
  4. sandeep saxenaJune 17, 2019 at 6:02 AM


    Thanks for sharing this great blog. That is very interesting to read and I am always searching for informative blog like this.
    Html5 Training in Chennai
    DOT NET Training in Chennai
    Best DOT NET Training in Chennai
    dot net coaching centers in chennai
    best .net training institute in chennai
    dot net training center in chennai
    QTP Training in Chennai
    LoadRunner Training in Chennai

    ReplyDelete
  5. UnknownApril 29, 2020 at 5:07 AM

    This is great, I love it

    ReplyDelete
  6. AkapureMay 15, 2020 at 10:11 PM

    That's so cool

    ReplyDelete
  7. AnonymousMay 17, 2022 at 5:17 AM

    perde modelleri
    sms onay
    mobil ödeme bozdurma
    Nft Nasıl Alınır
    Ankara evden eve nakliyat
    Trafik Sigortası
    DEDEKTOR
    web sitesi kurma
    AŞK KİTAPLARI

    ReplyDelete
  8. AnonymousMay 25, 2022 at 9:47 PM

    SMM PANEL
    Smm Panel
    iş ilanları
    İNSTAGRAM TAKİPÇİ SATIN AL
    hirdavatciburada.com
    beyazesyateknikservisi.com.tr
    servis
    Tiktok para hilesi

    ReplyDelete
  9. AnonymousJune 28, 2022 at 4:05 AM

    uc satın al
    özel ambulans
    yurtdışı kargo
    en son çıkan perde modelleri
    en son çıkan perde modelleri
    minecraft premium
    lisans satın al
    nft nasıl alınır

    ReplyDelete
  10. mrbahisDecember 22, 2022 at 7:42 AM

    Good content. You write beautiful things.
    hacklink
    vbet
    sportsbet
    sportsbet
    taksi
    hacklink
    korsan taksi
    mrbahis
    vbet

    ReplyDelete
  11. ersinJuly 30, 2023 at 9:53 AM

    yalova
    artvin
    balıkesir
    tuzla
    kayseri

    8U5

    ReplyDelete
  12. fatmaAugust 22, 2023 at 6:27 PM

    salt likit
    salt likit
    0AGB1

    ReplyDelete

Post a Comment

Popular posts from this blog

Guide to add blog URL to Google search console

Image
 In one of my recent blog posts, I explained how to submit your blog for AdSense approval and things you should do first before applying. Now, in this post, I want to teach you how to add your blog url to Google search console. maybe, you might ask why this is important. Calm down, I will explain why you need to add you blog to Google search console. For you to get better traffic result in blogging, your blog need to rank high in search engines. And Google is the world's number #1 search engine. So making your blog to show on search engines will fetch you a lot organic traffic. Now you see why you should consider adding your blog url to Google search console? This is exactly what I'm going to teach you on this post. mind you, I'm making this post for Blogspot users. So first, go to your blogger dashboard and click to open the menu tab, scroll down a bit and click settings. When the settings menu come up, scroll down and click Google search console. Now when the Google searc...
Read more

Best steps to master JavaScript programming language

Image
To build web app, JavaScript is not exceptional because of its ability to manipulate the browser environment. Beyond client side scripting, JavaScript libraries enable us to interact with server side, exchanging data with php . This tutorial is not about JavaScript libraries, this tutorial is to give you steps that will enable you understand and master the language itself. Many are battling with JavaScript without knowing the real course, what would this course may be? This is what I am going to tell you here. Don’t say JavaScript is hard because of the way you start learning. If you start in the right direction you’ll get it right. To understand JavaScript we must know how the language works, then how can we know how the language work is another question on its own. For web app, after learning html and css they usually tell us to learn JavaScript before learning php, isn’t it? The pattern in which the language report error is another annoying thing, compared to tha...
Read more