delete query (Mysql, Php)

Question

i tried to delete a mysql table record by a columname (ID).

if(isset($_GET['del_termin_del'])){
        $del_del_del = $_GET['del_termin_del'];
        $del_query = "DELETE FROM termine WHERE TerminID = '.$del_del_del.'";
        if ($conni->query($del_query) === TRUE) {
            echo "erfolgreich";
        } else {
            echo "Fehler beim Löschen" . $conn->error;
        }
}

If i run this, i get the success message, but the record is still there.

Can anybody help me?

Thank you!

You really need to look at how to use bound parameters here. This is wide open to SQL injection, and your code makes it possible for someone to empty your entire table in one go! — andrewsi
– andrewsi, Commented Oct 18, 2015 at 13:02

Ajeet Kumar · Accepted Answer · 2015-10-18 12:23:59Z

1

Replace your query

> "DELETE FROM termine WHERE TerminID = '.$del_del_del.'";

with

"DELETE FROM termine WHERE TerminID = '$del_del_del'";

answered Oct 18, 2015 at 12:23

Ajeet Kumar

8151 gold badge7 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

dfdsf Over a year ago

oh that's it :) Thank you for the quick and right answer

dfdsf Over a year ago

i have to wait 9 minutes

marc_s · Accepted Answer · 2016-02-12 19:26:19Z

0

You have to remove the dots in your query.

"DELETE FROM termine WHERE TerminID = '.$del_del_del.'"

to

"DELETE FROM termine WHERE TerminID = '$del_del_del'";

then everything should work!

edited Feb 12, 2016 at 19:26

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Oct 18, 2015 at 12:33

Marion Piloo

6310 bronze badges

Collectives™ on Stack Overflow

delete query (Mysql, Php)

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related