Display db Data on webpage? How to?

Has anyone got or know of a snippet/plugin that will allow site visitors to search and manipulate data on a webpage?

What I mean is I have a list of suppliers, and I want users to be able to search the list by location, species, product, name etc.

I already have the list displayed in full (see my previous post http://modxcms.com/forums/index.php/topic,25706.0.html )

This is what it looks like on my live dev server http://breakthroughecommerce.com/dev/hatcheries

I also already have phpmyedit installed in the backend as a module thanks to a fantastic tutorial by ganesh

http://modxcms.com/forums/index.php/topic,23176.msg159219.html#new

I guess what I’m after is some sort of cool search function that will work with db’s

Thanks in advance.

PS Perhaps we need a forum just on database stuff.

tvExplorer (http://modxcms.com/forums/index.php/topic,16456.0.html) combined with tvEditor (http://modxcms.com/forums/index.php/topic,16455.msg104821/topicseen.html#msg104821) will get the job done. It’s a little difficult to figure out how to make the calls, but once you do, it’s VERY customizable and really accurate. It’s what I used here to make the searches: http://www.apartmenthunterhouston.com/

Looks like exactly what I want.

Also, looks like I’m in for some serious woodshedding.

Thanks a lot.

ER

It’s a little difficult to figure out how to make the calls, but once you do, it’s VERY customizable and really accurate.

I got it installed, but I’ve no idea where to even start. All I have is a blank screen, which is apparently what I’m supposed to have.

Where does one go from there?

There’s tutorials on the 1st post on each of those, plus questions are answered throughout the rest of the threads. It doesn’t help the example site is in French, and I don’t have the time to write a tutorial, yet.

Sorry.

mark,

I’m interested in doing something similar and I’m just starting out (by reading about 50 threads). Did you have any success, if you don’t mind sharing, how did you proceed?

John

Here’s the other similar threads:

http://modxcms.com/forums/index.php?topic=26086.0
http://modxcms.com/forums/index.php?topic=25726.0

John,

I decided that I will probably end up offering to pay someone to do it for me.

The examples I’ve seen obviously show that it can be done very elegantly, however it does seem to be a little bit too complicated for non techs like me.

John,

Heliotrope who wrote the tvexplorer and tv editor snippets has told me that they only work with modx documents, not dbs, so despite previous ER’s suggestion, using these two snippets is not a solution.

Markg, is there any relationship between the custom table and the modx documents? Are they tied together somehow? You want to search just the content of the custom table or do you want to search this data together with modx document data?