Basic Web Functionality - Security Question

From: Date: Mon, 11 Aug 2014 20:02:06 +0000
Subject: Basic Web Functionality - Security Question
Groups: php.general 
Request: Send a blank email to php-general+get-323728@lists.php.net to get a copy of this message
Hi all, Assuming the following: - in your database you are using serial numeric ID's - with php you do a search query to get a number of items - then you display the results in a loop on a web page list view. - then on each row you have an edit button for that item. Here, the link is something like: editpage.php?id=<?php echo $record->getField('item_id'); ?> - now when you click to the edit page - it will do another query to get all the item details and display an edit form - etc. Problem: In this case - anyone can simply change the url id=xxx to any other number and it will make the page search for another item record. Q: HOW can we lock this down so as to prevent the above scenario and it is a more secure system? BTW: One method that we can use is to have a second field such as a random number field in the table data - then search for both - which people will have a hard time guessing like this link: editpage.php?id=<?php echo $record->getField('item_id'); ?>&random=<?php echo $record->getField('randomnum); ?> ANY BETTER SUGGESTIONS to lock things down? -- Thanks, Dave - DealTek dealtek@gmail.com [db-14]

« previous php.general (#323728) next »