The Support Forums will be in read-only mode for a scheduled maintenance window on 01 September 2016 14:00 UTC - 20:00 UTC. More information.

[resolved] Mysql query Help (3 posts)

  1. dangerouslydead
    Posted 4 years ago #

    I created a new table "certificates" in the wordpress database and have stored data in it. Right now the data looks like this

    id company certificate_number validity
    1 dezinefine 12345 2012-09-09
    2 Simple Minds 9999 2012-09-09

    Now, I want to create a form on a page where visitors can input the Certificate Number and search. I have very little knowledge of PHP or mySQL. Can someone help me if ti not too complicated a process?

  2. Rachel Baker
    Posted 4 years ago #

    I suggest starting with a Google search of (something like) "PHP how to search MySQL table" to get yourself at least started.
    An example would be:

    The combine that with Custom Queries from the Codex:

    Perhaps another option would be the Search RegEx plugin:

  3. dangerouslydead
    Posted 4 years ago #

    Thank you Rachel.

    I found a plugin that did the work beautifully. The name of the plugin is DB-Toolkit. It is an easy plugin to use.

Topic Closed

This topic has been closed to new replies.

About this Topic