{"id":41170,"date":"2014-05-30T17:20:23","date_gmt":"2014-05-30T16:20:23","guid":{"rendered":"https:\/\/pl.wordpress.org\/support\/topic\/wyciaganie-ikony-wpisu-z-bazy-danych\/"},"modified":"2016-08-05T22:06:51","modified_gmt":"2016-08-05T22:06:51","slug":"wyciaganie-ikony-wpisu-z-bazy-danych","status":"closed","type":"topic","link":"https:\/\/pl.wordpress.org\/support\/topic\/wyciaganie-ikony-wpisu-z-bazy-danych\/","title":{"rendered":"Wyci\u0105ganie ikony wpisu z bazy danych"},"content":{"rendered":"<p>Witam!<\/p>\n<p>Prosz\u0119 o pomoc, potrzebuj\u0119 &#8222;wyci\u0105gn\u0105\u0107&#8221; 3 ostatnie wpisy na zewn\u0119trznej podstronie, kt\u00f3ra nie jest bezpo\u015brednio zwi\u0105zana z silnikiem WordPress. Wzi\u0105\u0142em wi\u0119c i znalaz\u0142em poni\u017cszy skrypt, kt\u00f3ry wyci\u0105ga dane bezpo\u015brednio z bazy . Wszystko pi\u0119knie dzia\u0142a, ale brakuje mi jeszcze \u015bcie\u017cki do zdj\u0119cia ikony wpisu. Czy mo\u017ce wiecie jak doda\u0107 odpowiednie zapytanie do bazy abym to uzyska\u0142? Nie wiem dok\u0142adnie w kt\u00f3rym miejscu w bazie WordPress przechowuje uploadowane zdj\u0119cia.<\/p>\n<pre><code>&lt;?php\n\n$db[&#039;host&#039;] = &#039;localhost&#039;;\n$db[&#039;user&#039;] = &#039;&#039;;\n$db[&#039;pass&#039;] = &#039;&#039;;\n$db[&#039;name&#039;] = &#039;&#039;;\n\n$num_posts  = &#039;3&#039;;\n\n@mysql_connect ($db[&#039;host&#039;], $db[&#039;user&#039;], $db[&#039;pass&#039;]) or die (&#039;Nie uda\u0142o si\u0119 po\u0142\u0105czy\u0107 z baz\u0105 danych&#039;);\n@mysql_select_db ($db[&#039;name&#039;]) or die(&#039;Nie uda\u0142o si\u0119 wybra\u0107 bazy danych.&#039;);\nmysql_query(&quot;SET CHARSET utf8&quot;);\nmysql_query(&quot;SET NAMES &lt;code&gt;utf8&lt;\/code&gt; COLLATE &lt;code&gt;utf8_polish_ci&lt;\/code&gt;&quot;); \n\n$query = mysql_query (&quot;SELECT &lt;code&gt;post_title&lt;\/code&gt;,&lt;code&gt;post_name&lt;\/code&gt;,&lt;code&gt;post_content&lt;\/code&gt; FROM &lt;code&gt;wp_posts&lt;\/code&gt; WHERE &lt;code&gt;post_status&lt;\/code&gt; = &#039;publish&#039; AND &lt;code&gt;post_type&lt;\/code&gt;=&#039;post&#039; ORDER BY &lt;code&gt;post_date&lt;\/code&gt;  DESC LIMIT $num_posts;&quot;) or die (&#039;Nie uda\u0142o si\u0119 pobra\u0107 najnowszego wpisu&#039;);\n\nwhile ($row = mysql_fetch_array ($query)) {\n\n   echo $row[&#039;post_title&#039;];\n   echo&quot;&lt;br \/&gt;&quot;;\n\t echo $row[&#039;post_name&#039;];\n   echo&quot;&lt;br \/&gt;&quot;;\n\t echo $row[&#039;post_content&#039;];\n\t echo&quot;&lt;br \/&gt;&lt;br \/&gt;&quot;;\n}\n\nmysql_close();\n\n?&gt;<\/code><\/pre>\n<p>Z g\u00f3ry dzi\u0119kuj\u0119 za pomoc.<br \/>\nPozdrawiam<br \/>\nTomasz<\/p>\n","protected":false},"template":"","class_list":["post-41170","topic","type-topic","status-closed","hentry","topic-tag-baza-danych","topic-tag-ikona-wpisu","topic-tag-mysql"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pl.wordpress.org\/support\/wp-json\/wp\/v2\/topic\/41170","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\/41170\/revisions"}],"wp:attachment":[{"href":"https:\/\/pl.wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=41170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}