wolvelopez Posted January 23, 2017 Share Posted January 23, 2017 Hello friends.I am completely exhausted looking for information to be able to do a product search and that these are displayed in the main page, after some values selected by the client using jquery.The client will select a specialty and a board created by me and then with that value should be displayed all products that are assigned to that specialty. Can you give me some information on how to do this?Thanks in advance and sorry for my English, since I use a translator. Link to comment Share on other sites More sharing options...
NemoPS Posted January 23, 2017 Share Posted January 23, 2017 How are you assigning that specialty to products? What does it represent? Feature, attribute, something else? Link to comment Share on other sites More sharing options...
wolvelopez Posted January 23, 2017 Author Share Posted January 23, 2017 How are you assigning that specialty to products? What does it represent? Feature, attribute, something else? It is one more field that we have added and this works perfectly. The problem is that I do not know how to display the products. I am using the filter module to insert those 2 fields into jquery and I can get the values with no problem. What I do not do is how to pass the sql query to prestashop to bring me the products. I hope I have been more clear. Thank you Link to comment Share on other sites More sharing options...
NemoPS Posted January 27, 2017 Share Posted January 27, 2017 you can use Db::getInstance()->ExecuteS($yourQuery);You will have an array with productsMore info: http://nemops.com/prestashop-functions-2/#.WIsxbfnaeUk Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now