Deleting database records MVC

ruuux93

I've built a MVC 'framework' for learning purposes, and I'm struggling with this problem:

I am working on a CRUD application and I don't know how I should delete the records from my database. Right now I'am doing it through URL.

example.com/controller/delete/id that is how I delete a record from the database. I don't really like this way, because anyone could unintentionally or intentionally delete database records.

So my question is: How should I implement this feature?

Basic

You've got a number of issues here:

First of all, you need to know who is performing the operation, then you need to decide if they're allowed to do it.

For the first, you need a login system which issues a session id to the client (usually via cookie). You then use the session id on the server to look up who the user is and check if they're allowed to do the delete. This is usually handled through granting roles to users and then allowing roles to perform certain actions

Incidentally, GET requests are used for requests that do not modify the server state and can be repeated with no side-effects. POST, (or PUT/DELETE) should be used for any action that makes changes. Browsers will not send a POST twice without prompting the user explicitly.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

Adding to a table using MVC 5, and reset Id after deleting records

From Dev

Uninitialized constant error while deleting multiple connected records from database

From Dev

Deleting all table records from core data database using relationship

From Dev

Uninitialized constant error while deleting multiple connected records from database

From Dev

Deleting a Database

From Dev

DocExpirationUpdateProcessorFactory not deleting records

From Dev

CKModifyRecordsOperation not deleting records

From Dev

Hibernate merge deleting records

From Dev

what precautions need to be taken before deleting records from a table in the production database

From Dev

what precautions need to be taken before deleting records from a table in the production database

From Dev

How to display database records in asp.net mvc view

From Dev

Filter records in database according to the selected checkboxes using MVC

From Dev

How to set controls visibility dynamically in MVC depending on database records

From Dev

Deleting large records in oracle sql

From Dev

Yii2 deleting records

From Dev

Yii2 deleting records

From Dev

ElasticSearch errors in deleting records by query

From Dev

Deleting comments in MVC view

From Dev

Deleting comments in MVC view

From Dev

"Cannot attach the file" error when deleting a database from the App_Data folder with LocalDb in MVC?

From Dev

Deleting a stored procedure in the database

From Dev

Deleting MongoDB database and collections

From Dev

Deleting row in database

From Dev

Deleting nodes in a database tree

From Dev

Deleting mysql database row

From Dev

Deleting a tuple from Database

From Dev

Deleting MySQL database with a "-" in the name

From Dev

Deleting row in database

From Dev

Database created but records no records inserting

Related Related

  1. 1

    Adding to a table using MVC 5, and reset Id after deleting records

  2. 2

    Uninitialized constant error while deleting multiple connected records from database

  3. 3

    Deleting all table records from core data database using relationship

  4. 4

    Uninitialized constant error while deleting multiple connected records from database

  5. 5

    Deleting a Database

  6. 6

    DocExpirationUpdateProcessorFactory not deleting records

  7. 7

    CKModifyRecordsOperation not deleting records

  8. 8

    Hibernate merge deleting records

  9. 9

    what precautions need to be taken before deleting records from a table in the production database

  10. 10

    what precautions need to be taken before deleting records from a table in the production database

  11. 11

    How to display database records in asp.net mvc view

  12. 12

    Filter records in database according to the selected checkboxes using MVC

  13. 13

    How to set controls visibility dynamically in MVC depending on database records

  14. 14

    Deleting large records in oracle sql

  15. 15

    Yii2 deleting records

  16. 16

    Yii2 deleting records

  17. 17

    ElasticSearch errors in deleting records by query

  18. 18

    Deleting comments in MVC view

  19. 19

    Deleting comments in MVC view

  20. 20

    "Cannot attach the file" error when deleting a database from the App_Data folder with LocalDb in MVC?

  21. 21

    Deleting a stored procedure in the database

  22. 22

    Deleting MongoDB database and collections

  23. 23

    Deleting row in database

  24. 24

    Deleting nodes in a database tree

  25. 25

    Deleting mysql database row

  26. 26

    Deleting a tuple from Database

  27. 27

    Deleting MySQL database with a "-" in the name

  28. 28

    Deleting row in database

  29. 29

    Database created but records no records inserting

HotTag

Archive