{"id":39,"date":"2009-01-27T20:37:41","date_gmt":"2009-01-27T20:37:41","guid":{"rendered":"https:\/\/altrix.cz\/?p=39"},"modified":"2009-01-27T20:37:41","modified_gmt":"2009-01-27T20:37:41","slug":"chyba-ve-vyhledavani","status":"publish","type":"post","link":"https:\/\/altrix.cz\/?p=39","title":{"rendered":"Chyba ve vyhled\u00e1v\u00e1n\u00ed"},"content":{"rendered":"<figure id=\"attachment_85\" aria-describedby=\"caption-attachment-85\" style=\"width: 161px\" class=\"wp-caption alignleft\"><a href=\"http:\/\/www.opencart.com\/\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-85\" title=\"logo_opencart\" src=\"https:\/\/altrix.cz\/wp-content\/uploads\/2009\/01\/logo1-1-1.png\" alt=\"Logo Opencart\" width=\"161\" height=\"56\" \/><\/a><figcaption id=\"caption-attachment-85\" class=\"wp-caption-text\">Logo Opencart<\/figcaption><\/figure>\n<p>E-shop opencart obsahuje (obsahoval) drobnou chybu ve vyhled\u00e1v\u00e1n\u00ed. Jde o to \u017ee p\u0159i pokusu vyhledat produkt kter\u00fd nen\u00ed aktivn\u00ed dojde i tak k jeho nalezen\u00ed. Na\u0161t\u011bst\u00ed produkt nejde d\u00e1le zobrazit, tzn. ani objednat.<br \/>\n<!--more--><br \/>\nChyba je v modulu \/catalog\/controller\/search.php, \u0159\u00e1dek 48:<br \/>\n<code>select * from product p left join product_description pd on (p.product_id = pd.product_id) left join image i on (p.image_id = i.image_id) where pd.language_id = '?' and pd.name like '?' or pd.description like '?' and p.date_available &lt; now() and p.status = '1'<\/code>.<\/p>\n<p>Chyba nen\u00ed na prvn\u00ed pohled vid\u011bt, ale chyb\u00ed zde z\u00e1vorky okolo vyhled\u00e1vac\u00ed formulace, tedy:<br \/>\n<code>select * from product p left join product_description pd on (p.product_id = pd.product_id) left join image i on (p.image_id = i.image_id) where pd.language_id = '?' and (pd.name like '?' or pd.description like '?') and p.date_available &lt; now() and p.status = '1'<\/code>.<\/p>\n<p>Bez z\u00e1vorek SQL bere p\u0159\u00edkaz OR jako vyznam\u011bj\u0161\u00ed tak\u017ee dojde k vynech\u00e1n\u00ed \u010d\u00e1sti <code>and p.status = '1'<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>E-shop opencart obsahuje (obsahoval) drobnou chybu ve vyhled\u00e1v\u00e1n\u00ed. Jde o to \u017ee p\u0159i pokusu vyhledat produkt kter\u00fd nen\u00ed aktivn\u00ed dojde i tak k jeho nalezen\u00ed. Na\u0161t\u011bst\u00ed produkt nejde d\u00e1le zobrazit, tzn. ani objednat.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[15,37,39],"class_list":["post-39","post","type-post","status-publish","format-standard","hentry","category-opencart-navody","tag-chyba","tag-opencart","tag-oprava"],"_links":{"self":[{"href":"https:\/\/altrix.cz\/index.php?rest_route=\/wp\/v2\/posts\/39","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/altrix.cz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/altrix.cz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/altrix.cz\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/altrix.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=39"}],"version-history":[{"count":0,"href":"https:\/\/altrix.cz\/index.php?rest_route=\/wp\/v2\/posts\/39\/revisions"}],"wp:attachment":[{"href":"https:\/\/altrix.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=39"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/altrix.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=39"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/altrix.cz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=39"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}