WordPress.org

Forums

Custom Tables
[Plugin: custom tables] Show Multiple table results in a sngle page (5 posts)

  1. BharathRam
    Member
    Posted 2 years ago #

    Hi,

    I am using Custom Tables plugin to create three tables based on a primary key. In the search page i have shown the single table results. but when we are directed to the view page after clicking on the results, i want to show the data from all three tables. How can i do that? Please help.

    http://wordpress.org/extend/plugins/custom-tables/

  2. BharathRam
    Member
    Posted 2 years ago #

    to be precise,
    i have three tables.

    table 1: has the user name and email
    table 2: has user address and phone number
    table 3: has other details.

    So what i want to do is, when we click on the search results, i want the view page to show the output from all three tables. that is,

    if the search result is,

    name: xyz email: xyz@xyz.com

    and when clicking on it, the output should be,

    name: xyz
    email: xyz2xyz.com
    phone: blah blah
    other details: blah blah

    please help me on this

  3. aprietoartwork
    Member
    Posted 2 years ago #

    You need to condense all that information into one table. Is there a specific reason why you would want that information separated?

    your table should look like so:

    usrname | email | address | phone# | details
    Joe | joe@blah.com | 123 joe street | 1234567 | jibberish

    You would conduct your search like so: If for example you were searching only the "usrname" field. Be sure to change the wctable id number to the # of your specific table. This should be in the content of a page or post.

    [wctsearch fields="usrname"]<?php
    if ($_GET['wcts'] != '' OR $_GET['s'] != '') {
    echo do_shortcode("[wctable id=\"5\"]");
    }
    ?>

    To display the results you would like, go to the plugin, click on your table then View Setup>Entry Setup.

    For example:
    Name: {name}
    Phone: {phone}
    Email: {email}

    Text you want before field result: {name of field/results}

    This should get you started, thanks!

  4. aprietoartwork
    Member
    Posted 2 years ago #

    Please install the plugin Exec-PHP so you can use PHP in pages/posts.

  5. BharathRam
    Member
    Posted 2 years ago #

    Thanks for your reply. It helped me a lot. But the reason for having separate tables is that I am building a membership directory. So i want to sort all data out.

    I want to get the data from table 2 and 3 with the primary key of table 1.
    Can you please help me out with this?

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Custom Tables
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic

Tags

No tags yet.