Creating Tables with filtered data

  • mdrabble

    (@mdrabble)


    9 years, 5 months ago

    Apologies if posted in the wrong area….

    I’m looking for either a plugin or some other way of displaying some data into a filtered table.

    I have profile fields which contain Years e.g.. 1998, 1999,2000,2002

    I want to be able to create a dynamic table to show the years and the number of users with those years.

    Eg. 1998 (2) | 1999 (10) | 2000 (1)

    From the displayed data, I want to be able to click on the year and then only show members who have those years.

    To give you a better idea of what I am looking for – see links –

    Displaying Years – http://vichigh.com/alumni/search-by-year.php

    Display users filtered by year – http://vichigh.com/alumni/showyear.php?gradYear=1932&sortBy=last

    I have tried contacting the site owners to ask which wordpress plugin they have used but they haven’t replied.

    Cheers in advance.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    9 years, 5 months ago

    I’m pretty sure you can do this with Tablepress, but you may need the pro version and/or some of the extending plugins for it.

    https://ww.wp.xz.cn/plugins/tablepress/

    The site your referenced uses easy table creator, which is no longer available in the WordPress library.

    Thread Starter mdrabble

    (@mdrabble)

    9 years, 5 months ago

    @sterndata many thanks for the reply and the pointer i’ll take a look the plugin you mentioned 🙂

    Moderator Jan Dembowski

    (@jdembowski)

    Forum Moderator and Brute Squad

    9 years, 4 months ago

    @mdrabble Please do not create multiple topics for the same thing. Those get deleted when found and I’ve removed your new topic.

    How far did you get with Steve’s advice? Have you created a test site and played with the Tablepress plugin? I’ve not used that plugin but I do know that the author provides top notch support.

    Thread Starter mdrabble

    (@mdrabble)

    9 years, 4 months ago

    hi @jdembowski

    Thanks for the reply and no problem about removing the posts – wasn’t too sure about posting similar posts which is why I mentioned about deleting if needed.

    I have the basic site up and running and populated with BuddyPress Default Data so I have some data to play with.

    I’ve installed the plugin but I cannot see any way of getting it to look at the wp_bp_xprofile_data table.

    I’ll contact the author and see what he can advise.

    Thanks

    Thread Starter mdrabble

    (@mdrabble)

    9 years, 4 months ago

    I contacted the author of TablePress and unfortunately the plugin cannot query sql directly but he did suggest some alternatives with Tablepress extensions.

    After spending some time looking at this I am still struggling to achieve.

    I’ll keep plodding on in the hope of finding something or until someone can offer any other suggestions/plugins.

    Thread Starter mdrabble

    (@mdrabble)

    9 years, 4 months ago

    Ok, slight change of plan…..

    If I make a copy page.php from my selected theme and change it to display the data I need using the following example, would this be the correct way to connect and pull data from the database or would I be better off avoiding the method below?

    <?php
global $wpdb;
$alumniyear = $wpdb->get_results("sql query;");

** php code to display data **

?>
Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Creating Tables with filtered data’ is closed to new replies.