using php and mysql, how to store values as url decoded

follow up question for
http://www.experts-exchange.com/Database/MySQL/Q_27836893.html


well, still I would tell you that the url values should be stored in the db as url_decoded ...

anyhow, this should do, technically, except performance will be like a dog with big tables...
LVL 1
rgb192Asked:
Who is Participating?
 
Ray PaseurConnect With a Mentor Commented:
Why would you store URL values as url_encode() strings?  Why not url_encode() when there is a need for URL_encode()?  It doesn't make sense to me in a data base.
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
what I meant is that all the field in the url, decoded, are stored in distinct rows/columns.
so, using php (which is presumably used originally to store the url in the db), you could split up the url:
http://php.net/manual/en/function.urldecode.php
and store each "key=value" part of the url in a dedicate row, so you could then search of the "id" value correctly.
0
 
rgb192Author Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.