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

follow up question for

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...
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.
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:
and store each "key=value" part of the url in a dedicate row, so you could then search of the "id" value correctly.
rgb192Author Commented:
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.