If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > encryption question

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-27-07, 21:13
hconnor hconnor is offline
Registered User
 
Join Date: Feb 2007
Posts: 34
encryption question

hi

i've got a database that uses the URL to pass a parameter, the record ID. This seems susceptible to hacking and I'd like to encrypt that parameter so that its not usefully displayed.

starting URL: www.abc.com/results_details.php?video_ID=2

desired URL: http://www.abc.com/results_details.p...48r9wreofasohf

or something like it, however its saved encrypted.

would one way to do this would be to take the current ID and encrypt it and store it in a new field? then i'd rewrite the results page to pass the new encrypted ID as the parameter, which would be of little value to a hacker. redoing the results page is no problem.

but since each starting ID will be different, it seems a difficult task to write mysql script to update each record with a record-specific encoded ID.

any suggestions would be greatly appreciated. thanks.

mike
Reply With Quote
  #2 (permalink)  
Old 03-28-07, 10:44
guelphdad guelphdad is offline
Registered User
 
Join Date: Mar 2004
Posts: 440
what you do is don't bother encrypting at all. you put a password system into place and unless the user is logged in they can't see any of the video pages.
Reply With Quote
  #3 (permalink)  
Old 03-28-07, 11:24
hconnor hconnor is offline
Registered User
 
Join Date: Feb 2007
Posts: 34
thanks for the reply.

but i want to keep the website 'open' so that it get maximal use.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On