SQL delete query
ZiNgA BuRgA Offline
Fag
*******
Posts: 3,357
Joined: Jan 2008
Post: #4
RE: SQL delete query
You want to pass along as little information as possible in parameters.
Why do you need to pass the table name, for example?
Your table should have an ID (and this should be set as the primary key) - you should need to pass all that other crap along, only the ID of the row should be required.

As for protecting against people directly visiting the URL, it depends on how you're actually authenticating users.  Ideally the delete script should check whether the current user has permissions to perform the action.

My Blog
10-22-2012 09:14 AM
Find all posts by this user Quote this message in a reply

« Next Oldest | Next Newest »

Messages In This Thread
SQL delete query - mdb - 10-21-2012, 05:30 PM
RE: SQL delete query - ZiNgA BuRgA - 10-21-2012, 10:01 PM
RE: SQL delete query - mdb - 10-22-2012, 03:00 AM
RE: SQL delete query - ZiNgA BuRgA - 10-22-2012 09:14 AM
RE: SQL delete query - mdb - 10-23-2012, 09:40 AM
RE: SQL delete query - ZiNgA BuRgA - 10-24-2012, 08:19 AM
RE: SQL delete query - devid456 - 07-06-2013, 12:45 AM

 Standard Tools
Forum Jump: