Database search facilities 
Author: Nigel M.
Visited 1286,
Followers 1,
Shared 0
Hi Im not too sure where to start.
Im looking to create a website with a large selection of wedding cars for hire based all over the country
I want people to be able to search using lots of criteria
So as an example they might want to search for a convertible in nottinghamshire that is red.
Once they have found the vehicle that interests them they can tick a box or select it to make an enquiry.
I have looked at the shopping cart but not sure the search criteria would be able to drill down.
Is there an add on or any suggestions how to do this
Thanks
Posted on the
Hello Nigel
X5 is not the tool, for such things.
You should use a database tool instead. The result could be integrated in your X5 project.
Like this example: http://eksempelsite.dk/side-4.html
The example is about firms - but could as well be cars.
You specify the fields to be used, and all fields is/can be searchable - also in combination. And a free text search can be made,
If a record is a car, and you are not the owner of the car, then you can set ownership for each record, so the owner of the car can maintain the information of the car him/herself.
He could then log in and then have access to only his Q"own" cars and maintain them. He will not be able to edit other cars than his own.
You can have a parent record with all the searc criterias and then a detail record where there is specifications of the car - text and eventual images, PDF¨s, links and so.
The example is made with AppGini: https://bigprof.com/appgini/
Hope you get inspired by this.
Hello Guys,
Take care, because all products are not registered into the database.
So this solution could not be used.
Into the database, just only ordered products are registered into the databse (products table). Any product with no orders does not exists into the db. Check your products table.
It's a main issue of WSX5 .. E-Commerce part is not based on only a database. There is some informations into the database, and also into files on the website.
Not the best structure, but it is
May be I do a mistake, but give me the proof of !!!
Enjoy!
Axel
Just to make it clear: What I suggest is not based on on the products.
It is a new table(or more tables) that should be specially designed for the purpose. To make it easy to use I suggest to use a database-tool.
A very simple solution could be to use a CSV-file and a good CSV viewer.
An example here: https://bramminginfo.dk/bramny03/firmaer.html
In the search field can be specified more search/selection criterias separated by a space.
The search happens immediately.
Each column can be sorted, ascending/descending.
This method however ( a CSV file), is only suitable for not much over 1000 records.
Forgot: In the database solution a record could contain a link to the "car" - but also the CSV file could have a field that contains a link.