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

Posted on 2012-08-21
Last Modified: 2012-08-21
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...
Question by:rgb192
    LVL 107

    Accepted Solution

    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.
    LVL 142

    Assisted Solution

    by:Guy Hengel [angelIII / a3]
    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.

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this.Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it is …
    Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
    This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
    The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now