Grab One Record based on URL string

  • dwaynebmw

    (@dwaynebmw)


    10 years, 1 month ago

    For those of you familiar with retrieving record based on URL string… I will give a easy example.

    In MS Access we used to create a simple URL to retrieve a record such as
    http://www.sampleweb.asp?Px=263&Xiikq&19pp21

    Well.. 263 would be the ID or Key field in the DB to retrieve the record and only one record.

    I have CFDB on my WP site. I would like to do the same thing. Simply retrieve one record from the CFDB based on a simple WP URL, the page & the ID Record number for example. Then I can simply create an html page inside of WP using HTML scripting to dress up the page the user is looking at using the field with the data from the CFDB.

    Since I’m a tad bit new to php and CFDB seems top have its own sort of scripting… could someone just show me the script that retrieves one record based on a field in the DB?

    I can create short codes from the wizard built in CFDB, but I do not see an option to retrieve only one record, based on some kind of URL that would directly link to a short code of some kind allowing me to grab that one record…and not all the records. If its there I don’t see it.

    End the end I am going to create an event ticket for the user, and send the user a direct link to their email to simply come to the designated page and see their e-ticket.

    I do not like any of the RSVP, or ticketing plugins on the WP plugins site… so I can easily design this part myself using html coding. But this one hurdle is in my way.

    Thanks everyone!!

    Dwayne

    https://ww.wp.xz.cn/plugins/contact-form-7-to-database-extension/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    10 years, 1 month ago

    The submit_time UNIX time stamp is the unique I’d for an entry. Given such a value, you can use it in the filter of shortcode and export links, for example:
    [cfdb-table form=”form name” submit_time=1318262984.3426″]

    To simply look at that value, you can do this
    cfdb-table form=”form name” show=”submit_time,/.*/”]

    I suspect you are interested in creating a master-detail view:
    http://cfdbplugin.com/?page_id=1389

    Thread Starter dwaynebmw

    (@dwaynebmw)

    10 years ago

    thanks Mike.

    Im using this plugin to generate a serial number for each form submission.
    https://ww.wp.xz.cn/plugins/contact-form-7-serial-numbers/

    Now I just have to be able to retrieve that record using this serial number, in some kind of URL.

    dw

    Plugin Author Michael Simpson

    (@msimpson)

    10 years ago

    It is the same thing in principle as using submit_time. You are just using a different field.

    Thread Starter dwaynebmw

    (@dwaynebmw)

    10 years ago

    hi Mike,

    Yeah you’re right.

    So on this page http://cfdbplugin.com/?page_id=1389 how do I adjust the code to only retrieve a single record? Use ID as the sample key field. Lets see what that looks like. You know how to script or adjust the code there?

    Thanks for your help Mike.

    dw

    Plugin Author Michael Simpson

    (@msimpson)

    10 years ago

    Everywhere you see submit_time, replace with your field name

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Grab One Record based on URL string’ is closed to new replies.