How to make a searchable product database in Modx

Hi,

The remaining echo is line 328 => echo $debugSQL;

The version you have is the only one I’ve released.
I’ve made a lot of changes to the code but have no time to finish it for a public release.


:-)

wow merci beaucoup - it’s working!

again, what a great modul!!!!!

regards, j

Hi all,

I got my forms working with the help of Bob.

But I have a new random question:
How do I get the form to open to a specific url?

I tried this
<form action= "[~[*id*]~]" method= "post" action="index.php?q=3.html" >

I also tried
<form action= "[~[*id*]~]" method= "post" action="index.php?q=3.html" target="_blank" >
And it all works except it ignores the action and just stays on the current page.

Hi,

change :

<form action= "[~[*id*]~]" method= "post" action="index.php?q=3.html" >

To:

<form action= "[~3~]" method= "post" >

The doc with ID 3 must contain the same snippet call as the refering page.

:-)

Thanks that worked great!

Hi heliotrope,

would it be possible to set the values for two dropdown-lists in the product search in relation to each other? for example, i choose a country in the first dropdown, and the second dropdown will then show me just the options for that specific country...?

best regards, j

I want to try something different,

instead of a form that the user chooses from drop down menus, I want to set tvExplorer to just display the results of a set value eg: display all of the pages with the feature TV set to yes as soon as the page loads instead of the user having to click search.

Something like:

I want to be able to create a search page, say with business name, city, state, and then do a search and show all the businesses that match that criteria.
I have 15 million businesses.

Is this something that tvExplorer would be able to handle??
Right now the businesses are stored in a table in mysql.

15 million?!? That's gotta be a huge database. My guess is that the performance of searches on a record set that large would not be very good when TVs are concerned... it might interesting to try, but if you've got 15 million records, then I would recommend you create a custom database table(s) to store your data and index it well. Then you can write your own search form to browse the data.owse the data.

I use SphinxSearch inside of MySQL, so I can do a normal mysql query and retrieve what I want very quickly.
I am brand new to Modx so I will continue and see if I can figure out how to make it work.
If you have any examples of writing my own search form and browsing the data, I will look at it.
Thanks
ASawyer