{"id":49577,"date":"2015-04-08T06:33:20","date_gmt":"2015-04-08T05:33:20","guid":{"rendered":"https:\/\/pl.wordpress.org\/support\/topic\/query-wpdb-prepare-problem-ze-znakami-typu-o-z\/"},"modified":"2016-08-05T22:12:00","modified_gmt":"2016-08-05T22:12:00","slug":"query-wpdb-prepare-problem-ze-znakami-typu-o-z","status":"closed","type":"topic","link":"https:\/\/pl.wordpress.org\/support\/topic\/query-wpdb-prepare-problem-ze-znakami-typu-o-z\/","title":{"rendered":"query wpdb-&gt; prepare problem ze znakami typu \u00f3 \u017c?"},"content":{"rendered":"<p>Wykonuj\u0119 zapytanie, poprzez wpdb-&gt;prepare zapytanie ze sk\u0142adni\u0105 LIKE, wszystko dzia\u0142a bardzo dobrze, dostaj\u0119 wyniki ( prawid\u0142owe ) jednak problem pojawia si\u0119 w przypadku gdy u\u017cyj\u0119 polskich znak\u00f3w konkretnie chodzi o literk\u0119 &#8222;\u00f3&#8221;<\/p>\n<pre><code>$link = $wpdb-&gt;esc_like( $link );\n    $link = $city.&#039;%&#039;;\n    $sql= &quot;SELECT DISTINCT SQL_CACHE woj FROM city WHERE woj = &#039;$woj&#039;&quot;;\n    $sqlz = $wpdb-&gt;prepare( $sql, $link, $link );\n    $query_db = $wpdb-&gt;get_results( $sqlz );<\/code><\/pre>\n<p>Dodam \u017ce kodowanie jest w porz\u0105dku.<\/p>\n","protected":false},"template":"","class_list":["post-49577","topic","type-topic","status-closed","hentry","topic-tag-polskie-litery","topic-tag-prepare","topic-tag-sign-o","topic-tag-wpdb"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pl.wordpress.org\/support\/wp-json\/wp\/v2\/topic\/49577","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pl.wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/pl.wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/pl.wordpress.org\/support\/wp-json\/wp\/v2\/topic\/49577\/revisions"}],"wp:attachment":[{"href":"https:\/\/pl.wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=49577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}