{"id":1961,"date":"2014-08-29T08:03:47","date_gmt":"2014-08-29T08:03:47","guid":{"rendered":"http:\/\/musilda.cz\/?p=1961"},"modified":"2014-08-29T08:03:47","modified_gmt":"2014-08-29T08:03:47","slug":"lepsi-razeni-vysledku-pomoci-wp_query-ve-wordpress-4-0","status":"publish","type":"post","link":"https:\/\/affinite.io\/cs\/lepsi-razeni-vysledku-pomoci-wp_query-ve-wordpress-4-0\/","title":{"rendered":"Lep\u0161\u00ed \u0159azen\u00ed v\u00fdsledk\u016f pomoc\u00ed WP_Query ve WordPress 4.0"},"content":{"rendered":"\n

Tak jak se bl\u00ed\u017e\u00ed datum vyd\u00e1n\u00ed nov\u00e9 verze WordPressu 4.0, za\u010d\u00ednaj\u00ed se objevovat informace zaj\u00edmav\u00e9 pro v\u00fdvoj\u00e1\u0159e. Pokud vytv\u00e1\u0159\u00edte \u0161ablony pro WordPress, ur\u010dit\u011b jste se setkali s WP_Query. Pomoc\u00ed t\u00e9to t\u0159\u00eddy, m\u016f\u017eete vytv\u00e1\u0159et vlastn\u00ed v\u00fdpis obsahu a jej\u00ed mo\u017enosti jsou pom\u011brn\u011b velk\u00e9.<\/p>\n\n\n\n

Nyn\u00ed k orderby.<\/p>\n\n\n\n

Pokud jej v poli argument\u016f neuvedete, je z\u00e1kladn\u00ed \u0159azen\u00ed nastaveno dle data publikace a to sestupn\u011b. To znamen\u00e1, \u017ee se \u0159ad\u00ed podle post_date z tabulky wp_posts.<\/p>\n\n\n\n

Z\u00e1rove\u0148 m\u016f\u017eete pomoc\u00ed order nastavit, zda se bude \u0159adit sestupn\u011b, nebo vzestupn\u011b – DESC, nebo ASC.  V p\u0159\u00edpad\u011b, \u017ee budete cht\u00edt v\u00fdpis \u0159adit podle jin\u00e9ho sloupce, orderby akceptuje \u0159et\u011bzec s n\u00e1zvem sloupce. M\u016f\u017eete \u0159adit podle post_title, nebo author, p\u0159\u00edpadn\u011b pou\u017e\u00edt alias title.<\/p>\n\n\n\n

K\u00f3d:<\/p>\n\n\n\n

$q = new WP_Query( array( 'orderby' => 'post_title' ) );\n<\/pre>\n\n\n\n

bude proveden jako<\/p>\n\n\n\n

ORDER BY post_title DESC<\/pre>\n\n\n\n

Orderby um\u00ed nav\u00edc parsovat zadan\u00fd \u0159et\u011bzec, tak\u017ee, kdy\u017e zad\u00e1te n\u00e1zevy sloupc\u016f odd\u011blen\u00e9 mezerami, budou pou\u017eity takto:<\/p>\n\n\n\n

$q = new WP_Query( array( 'orderby' => 'title author' ) );<\/pre>\n\n\n\n

bude provedeno jako<\/p>\n\n\n\n

ORDER BY post_title, post_author DESC<\/pre>\n\n\n\n

Proto\u017ee defaultn\u00ed \u0159aen\u00ed v MySQL je ASC a \u0159ad\u00ed se podle sloupce, m\u016f\u017ee tento k\u00f3d vracet neo\u010dek\u00e1van\u00e9 v\u00fdsledky, kdy post_title bude ASC a post_author DESC.<\/p>\n\n\n\n

Zm\u011bny ve WordPress 4.0<\/h2>\n\n\n\n

V nov\u00e9 verzi WordPressu je u argumentu orderby mo\u017enost zadat polo\u017eky ne jako \u0159et\u011bzec, ale v hodnot\u00e1ch pole, tak\u017ee budete m\u00edt kontrolu nad t\u00edm, jak se budou v\u00fdsledky \u0159adit.<\/p>\n\n\n\n

$q = new WP_Query(\n   array(\n       'orderby' => array(\n                      'title' => 'DESC',\n                      'menu_order' => 'ASC'\n                    )\n   )\n);\n<\/pre>\n\n\n\n

bude provedeno jako<\/p>\n\n\n\n

ORDER BY post_title DESC, menu_order ASC<\/pre>\n\n\n\n

P\u0159e\u010dteno a ops\u00e1no z WordPress.org<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

Tak jak se bl\u00ed\u017e\u00ed datum vyd\u00e1n\u00ed nov\u00e9 verze WordPressu 4.0, za\u010d\u00ednaj\u00ed se objevovat informace zaj\u00edmav\u00e9 pro v\u00fdvoj\u00e1\u0159e. Pokud vytv\u00e1\u0159\u00edte \u0161ablony pro WordPress, ur\u010dit\u011b jste se setkali s WP_Query. Pomoc\u00ed t\u00e9to t\u0159\u00eddy, m\u016f\u017eete vytv\u00e1\u0159et vlastn\u00ed v\u00fdpis obsahu a jej\u00ed mo\u017enosti jsou pom\u011brn\u011b velk\u00e9. Nyn\u00ed k orderby. Pokud jej v poli argument\u016f neuvedete, je z\u00e1kladn\u00ed \u0159azen\u00ed nastaveno<\/p>\n","protected":false},"author":1,"featured_media":8644,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_uag_custom_page_level_css":"","footnotes":""},"categories":[30],"tags":[],"class_list":["post-1961","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-wordpress"],"acf":[],"uagb_featured_image_src":{"full":["https:\/\/affinite.io\/cs\/wp-content\/uploads\/sites\/2\/2014\/08\/wordpress-by-musilda.png",1200,800,false],"thumbnail":["https:\/\/affinite.io\/cs\/wp-content\/uploads\/sites\/2\/2014\/08\/wordpress-by-musilda-150x150.png",150,150,true],"medium":["https:\/\/affinite.io\/cs\/wp-content\/uploads\/sites\/2\/2014\/08\/wordpress-by-musilda-300x200.png",300,200,true],"medium_large":["https:\/\/affinite.io\/cs\/wp-content\/uploads\/sites\/2\/2014\/08\/wordpress-by-musilda-768x512.png",640,427,true],"large":["https:\/\/affinite.io\/cs\/wp-content\/uploads\/sites\/2\/2014\/08\/wordpress-by-musilda-1024x683.png",640,427,true],"1536x1536":["https:\/\/affinite.io\/cs\/wp-content\/uploads\/sites\/2\/2014\/08\/wordpress-by-musilda.png",1200,800,false],"2048x2048":["https:\/\/affinite.io\/cs\/wp-content\/uploads\/sites\/2\/2014\/08\/wordpress-by-musilda.png",1200,800,false],"archive-list":["https:\/\/affinite.io\/cs\/wp-content\/uploads\/sites\/2\/2014\/08\/wordpress-by-musilda-400x265.png",400,265,true]},"uagb_author_info":{"display_name":"Affinite","author_link":"https:\/\/affinite.io\/cs\/author\/affinite\/"},"uagb_comment_info":1,"uagb_excerpt":"Tak jak se bl\u00ed\u017e\u00ed datum vyd\u00e1n\u00ed nov\u00e9 verze WordPressu 4.0, za\u010d\u00ednaj\u00ed se objevovat informace zaj\u00edmav\u00e9 pro v\u00fdvoj\u00e1\u0159e. Pokud vytv\u00e1\u0159\u00edte \u0161ablony pro WordPress, ur\u010dit\u011b jste se setkali s WP_Query. Pomoc\u00ed t\u00e9to t\u0159\u00eddy, m\u016f\u017eete vytv\u00e1\u0159et vlastn\u00ed v\u00fdpis obsahu a jej\u00ed mo\u017enosti jsou pom\u011brn\u011b velk\u00e9. Nyn\u00ed k orderby. Pokud jej v poli argument\u016f neuvedete, je z\u00e1kladn\u00ed \u0159azen\u00ed nastaveno","_links":{"self":[{"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/posts\/1961","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/comments?post=1961"}],"version-history":[{"count":0,"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/posts\/1961\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/media\/8644"}],"wp:attachment":[{"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/media?parent=1961"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/categories?post=1961"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/affinite.io\/cs\/wp-json\/wp\/v2\/tags?post=1961"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}