Deleting a row from a database table

In this recipe, we will be learning how to remove a row from a database table. We assume that a database called ECommerce already exists and a table called Users also exists in the ECommerce database. The Users table consists of two columns, EmailAddress and Password. Also, we assume that the User table contains a few rows in it. The user will be prompted to enter their email address and password in the form. The Users table is searched for the specified email address and password. If any row is found with the specified email address and password in the Users table, you will be prompted to confirm whether you are sure that you want to delete the row. If you click on the Yes button, the row will be deleted.

How to do it…

...