tag:blogger.com,1999:blog-9171370399460373731.post990926611293128365..comments2024-03-08T04:09:53.684-08:00Comments on Mostlikers Programming Blog : Product Search Filtering Using PHP and AjaxUnknownnoreply@blogger.comBlogger93125tag:blogger.com,1999:blog-9171370399460373731.post-37202222514687194282019-05-20T09:08:40.354-07:002019-05-20T09:08:40.354-07:00sir please tell me how to make default viwe set or...sir please tell me how to make default viwe set order by id desc in the demo2Amit vermahttps://www.blogger.com/profile/03698558749694658167noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-29394391862649825602018-03-17T10:49:27.014-07:002018-03-17T10:49:27.014-07:00when is select checkbox value i am getting -Object...when is select checkbox value i am getting -Object not found<br />Anonymoushttps://www.blogger.com/profile/17844244801193973076noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-42109215120923658132017-12-19T08:10:00.903-08:002017-12-19T08:10:00.903-08:00sir your code work like
http://demos.mostlikers.co...sir your code work like<br />http://demos.mostlikers.com/php/sort-search-filter/index.php?sort_price=price-desc-rank&brand=fashion%27<br /> by i want fixt url cat/mobile/smartphone<br />$cat=$_GET[cat];<br />$subcat=$_GET[sub-cat];<br />SELECT * FROM products WHERE category =$cat AND subcategory=$subcat <br />http://demos.mostlikers.com/php/sort-search-filter/index.php?cat=mobile&subcat=smart-phone?sort_price=price-desc-rank&brand=fashion%27-phone<br /><br />cat/mobile/smartphone?sort_price=price-desc-rank&brand=fashion%27-phone<br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-33619825249851000002017-07-05T23:01:43.320-07:002017-07-05T23:01:43.320-07:00http://www.mostlikers.com/2016/10/brand-size-check...http://www.mostlikers.com/2016/10/brand-size-checkbox-search-filter-using-php-jquery.htmlMostikershttps://www.blogger.com/profile/12751758635595080729noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-57136031306160776422017-06-30T13:41:42.998-07:002017-06-30T13:41:42.998-07:00hey karthick can you please guide me how to take m...hey karthick can you please guide me how to take multiple checkbox values and display it actually i am trying it but i can't able to get results Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-86726554796840800072017-06-30T12:42:53.942-07:002017-06-30T12:42:53.942-07:00hey Karthick can you guide me how to get multiple ...hey Karthick can you guide me how to get multiple checkboxes and show there data accordingly i am trying but when i select the another checkbox no results are shown Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-77913922547519294202017-06-27T22:43:23.947-07:002017-06-27T22:43:23.947-07:00hey , mostlikers I send my codes zip file on your ...hey , mostlikers I send my codes zip file on your email, Before 1 week ago you don't reply me...... solve my errorhamidhttp://www.mostlikers.com/2015/08/product-search-filtering-using-php-and.htmlnoreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-22081070470681908082017-06-21T10:51:11.820-07:002017-06-21T10:51:11.820-07:00Your English good only bro. I will tel you some st...Your English good only bro. I will tel you some steps <br /><br />1) Create product table insert some product information<br />2) Front end Create UI auto complete search bar in header ex : https://jqueryui.com/autocomplete/<br />3) Fetch all the product name by using mysql query and load the fetch data to auto complete json data.<br />4) Search and filter the keyword http://www.mostlikers.com/2016/05/create-your-own-search-engine-using-php.htmlMostikershttps://www.blogger.com/profile/12751758635595080729noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-47736030110772751942017-06-21T00:26:49.216-07:002017-06-21T00:26:49.216-07:00Ok I send my code your email address , I update yo...Ok I send my code your email address , I update you.hamidhttp://www.mostlikers.com/2015/08/product-search-filtering-using-php-and.html?m=1noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-18414826941075341512017-06-19T22:31:43.358-07:002017-06-19T22:31:43.358-07:00Hey Ricky Yusuf,
For your reference http://www.mo...Hey Ricky Yusuf,<br /><br />For your reference http://www.mostlikers.com/2016/05/create-your-own-search-engine-using-php.html use this tutorial Mostikershttps://www.blogger.com/profile/12751758635595080729noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-89873689234725280342017-06-19T22:30:42.549-07:002017-06-19T22:30:42.549-07:00Hay hamid, sorry for my bad english.
If all e-co...Hay hamid, sorry for my bad english. <br /><br />If all e-commerce (eg. Tokopedia.com, alibaba.com) always option "seacrh product" in header. My qustion is : ho to make it ? Anonymoushttps://www.blogger.com/profile/05861183334336419768noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-37203294870662381772017-06-19T22:30:04.258-07:002017-06-19T22:30:04.258-07:00For an PDO need to change query bind. email your c...For an PDO need to change query bind. email your code to mostlikers@gmail.com Mostikershttps://www.blogger.com/profile/12751758635595080729noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-820014950774396542017-06-16T04:32:59.673-07:002017-06-16T04:32:59.673-07:00hey , I not clearly understand your logic please ...hey , I not clearly understand your logic please explain me easily.hamidhttp://www.mostlikers.com/2015/08/product-search-filtering-using-php-and.htmlnoreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-25133750470482781542017-06-14T22:46:20.923-07:002017-06-14T22:46:20.923-07:00I'm not understand what you explain me!
not c...I'm not understand what you explain me!<br /><br />not clearly understand your code<br /><br />I try another way ,look see this<br /><br />I implode IN() clause look at,<br /><br />$query=$db->prepare('SELECT * FROM products WHERE category_id =:cid AND brand IN('.implode("','",$type).');<br />$query->bindParam(':cid',$filter);<br />$query->execute();<br /><br />print_r($query);<br /><br /><br />Above my code I not bound, brand variable $type ,<br />I print query ,the Query is Properly execute no error<br /><br />but not record found display<br /><br />look query string..........<br /><br /><br />PDOStatement Object ( [queryString] => SELECT * from product WHERE category_id=:cid AND brand IN(puma,addidas) )<br /><br />hamidhttp://www.mostlikers.com/2015/08/product-search-filtering-using-php-and.htmlnoreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-65322549013756540512017-06-14T19:15:11.290-07:002017-06-14T19:15:11.290-07:00hallo Mr. mostliker, i hope you can be always heal...hallo Mr. mostliker, i hope you can be always healt.<br /><br />top tutorial. but i can ask. how to make PRODUCT SEARCH from HEADER form ? thank before ifAnonymoushttps://www.blogger.com/profile/05861183334336419768noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-33541254534948137722017-06-14T11:30:05.999-07:002017-06-14T11:30:05.999-07:00$query->bindParam(':brname','write ...$query->bindParam(':brname','write your brand id manually'); check first the value or follow below query<br />prepare(<br /> 'SELECT * FROM products WHERE category_id =:cid AND brand IN(' . $inQuery . ')'<br />);<br /><br />// bindvalue is 1-indexed, so $k+1<br />foreach ($ids as $k => $id)<br /> $stmt->bindValue(($k+1), $id);<br /><br />$stmt->execute();<br />?><br /> Mostikershttps://www.blogger.com/profile/12751758635595080729noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-23138799152306475682017-06-14T00:46:45.558-07:002017-06-14T00:46:45.558-07:00$query->bindParam(':brname',implode(&qu...$query->bindParam(':brname',implode(",",$type));<br /><br />I try above your code,But same proble Record Not Foundhamidhttp://www.mostlikers.com/2015/08/product-search-filtering-using-php-and.htmlnoreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-23153660953254693702017-06-12T23:39:14.391-07:002017-06-12T23:39:14.391-07:00$query->bindParam(':brname',implode(&qu...$query->bindParam(':brname',implode(",",$type));<br /><br />I try above your code, but same problem Record Not Found ?hamidhttp://www.mostlikers.com/2015/08/product-search-filtering-using-php-and.htmlnoreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-24890392280987864542017-06-12T23:06:23.772-07:002017-06-12T23:06:23.772-07:00$query->bindParam(':brname',implode(&qu...$query->bindParam(':brname',implode(",",$type)); Mostikershttps://www.blogger.com/profile/12751758635595080729noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-9831818913576651632017-06-11T03:27:30.659-07:002017-06-11T03:27:30.659-07:00Hey, Man Fast Reply Me Solved My error, I Wait hel...Hey, Man Fast Reply Me Solved My error, I Wait help me....<br />Above My Code Send Before 3 Days Ago hamidhttp://www.mostlikers.com/2015/08/product-search-filtering-using-php-and.htmlnoreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-90248717008492182332017-06-08T03:40:38.711-07:002017-06-08T03:40:38.711-07:00Hey,I'm use PDO prepare statement how do I bou...Hey,I'm use PDO prepare statement how do I bound variable IN() function I try your code , But Problem is only one Brand display not multiple Brand display.<br /><br />Below My code : -<br /><br />$query=$db->prepare('SELECT * FROM products WHERE category_id =:cid AND brand IN(:brname)');<br />$query->bindParam(':cid',$filter);<br />$query->bindParam(':brname',implode("','",$type)); <br />$query->execute();<br /><br />above my code i implode the brand in bindParam() but only one brand display I click second checkbox The result is Record Not Found.hamidhttp://www.mostlikers.com/2015/08/product-search-filtering-using-php-and.htmlnoreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-13055600400866372652017-05-29T01:13:20.690-07:002017-05-29T01:13:20.690-07:00Not this file ajax_search.php file you need add th...Not this file ajax_search.php file you need add this code.Mostikershttps://www.blogger.com/profile/12751758635595080729noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-63122712349241845612017-05-27T01:35:59.963-07:002017-05-27T01:35:59.963-07:00Thank you for your reply but it does not seem to w...Thank you for your reply but it does not seem to work. Where am i making mistake, please help:<br /><br />$sql= "SELECT distinct id FROM `products` WHERE category_id = '1'";<br /> if(isset($_GET['brand']) && $_GET['brand']!="") :<br /> $brand = $_GET['brand'];<br /> $sql.=" AND brand IN ('".implode("','",$brand)."')";<br /> else : echo 'No results'<br /> endif;<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-55131035655662647532017-05-26T05:42:43.571-07:002017-05-26T05:42:43.571-07:00Before the endif; php line add else condition. el...Before the endif; php line add else condition. else : echo 'No results' Mostikershttps://www.blogger.com/profile/12751758635595080729noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-43325996556909327092017-05-26T05:41:34.446-07:002017-05-26T05:41:34.446-07:00This comment has been removed by the author.Mostikershttps://www.blogger.com/profile/12751758635595080729noreply@blogger.com