{"id":233282,"date":"2023-02-10T16:21:00","date_gmt":"2023-02-10T13:21:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=233282"},"modified":"2022-11-10T20:16:29","modified_gmt":"2022-11-10T17:16:29","slug":"lisage-sql-i-abil-wordpressi-lehemalli-jaergmine-juhuslik-postitus","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/et\/lisage-sql-i-abil-wordpressi-lehemalli-jaergmine-juhuslik-postitus\/","title":{"rendered":"Lisage SQL-i abil WordPressi lehemalli j\u00e4rgmine juhuslik postitus"},"content":{"rendered":"\n

V\u00f5ite sageli saada n\u00f5uandeid SEO (otsingumootori optimeerimise) parandamiseks, kui lisate uue postituse avaldamisel oma eelmistele postitustele linke. See aitab suurendada liiklust ja see toimib sarnaselt pistikprogrammidele nagu "Suhtelised postitused", kuid ainult lihtsam.<\/p>\n

K\u00f5ik WordPressi postitused on salvestatud tabelisse nt wp_posts<\/strong> ja selle tabeli seest leiate post_title<\/strong>, post_name<\/strong> ja need veerud on \u00fcsna lihtsad. S\u00f5ltuvalt teie postituste URL-ide konfiguratsioonist v\u00f5ib teil olla erineva vorminguga p\u00fcsilinke, mida saate konfigureerida jaotises Seaded \u2013 p\u00fcsilink.<\/p>\n

J\u00e4rgmise PHP koodi saab sisestada oma lehe malli, tavaliselt single.php<\/strong>, mis on \u00fche postituse mall v\u00f5i page.php<\/strong> lehe malli jaoks.<\/p>\n

\u00a0 global $wpdb; \/\/ include the $wpdb\n\u00a0 $query = \"select `post_title` as `title`, `post_name` as `name` from `wp_posts` where `post_type`='post' and `post_status`='publish' order by rand() limit 1\";\n\u00a0 $results = $wpdb->get_results($query); \/\/ run the query on the database\n\u00a0 if ($results) { \n\u00a0 \u00a0 $domain = $_SERVER['SERVER_NAME'];\n\u00a0 \u00a0 foreach ($results as $toppost) {\n\u00a0 \u00a0 \u00a0 \u00a0 echo \"<a href=\"<a class=\"vglnk\" target=\"_blank\" href=\"http:\/\/$domain\/\".$toppost-\" rel=\"nofollow\"><span>http<\/span><span>:\/\/$<\/span><span>domain<\/span><span>\/\".$<\/span><span>toppost<\/span><span>-<\/span><\/a>>name.\"\/\"><img title=\"Next Post: \".$toppost->title.\"\" src=\"<a class=\"vglnk\" target=\"_blank\" href=\"https:\/\/helloacm.com\/static\/nextpost2.png\" rel=\"nofollow\"><span>https<\/span><span>:\/\/<\/span><span>helloacm<\/span><span>.<\/span><span>com<\/span><span>\/<\/span><span>static<\/span><span>\/<\/span><span>nextpost2<\/span><span>.<\/span><span>png<\/span><\/a>\" alt=\"Next Post: \".$toppost->title.\"\" \/><\/a>\";\n\u00a0 \u00a0 }\n\u00a0 }<\/code><\/pre>\n
Muutke vastavalt wp_posts<\/strong>, kuna see v\u00f5ib veidi erineda. SQL-p\u00e4ring tagastab juhusliku postituse, kus see v\u00e4listab lehed v\u00f5i men\u00fc\u00fc_elemendid, lingid jne. Ja postituse olek tuleks avaldada, mis v\u00e4listab mustandi. Limiit 1<\/strong> tagastab ainult 1 postituse. Nii et kui soovite eelmist postitust, v\u00f5iksite kaaluda selle muutmist piiranguks 2<\/strong>.<\/p>\n
Minu saidi p\u00fcsilink p\u00f5hineb atribuudil post_name<\/strong>, mis on SEO-s\u00f5bralikum. Saate seda h\u00e4sti kohandada. SQL-p\u00e4ringut saab ka kohandada. N\u00e4iteks v\u00f5ite soovida juhuslike postituste asemel tagastada asjakohased postitused, sobitades title<\/code>v\u00e4\u00e4rtuse praeguse postituse pealkirja j\u00e4rgi. V\u00f5i soovite t\u00f5esti tagastada selle eelmise v\u00f5i j\u00e4rgmise postituse, mis on sorteeritud avaldamiskuup\u00e4eva j\u00e4rgi, v\u00f5iksite kasutada v\u00e4lja \u201epost_id".<\/p>\n
Kommentaarid<\/h3>\n
Yu \u2013 "Lahe, juhuslik on t\u00f5esti tore. Samuti veenduge, et juhuslik oleks praeguse postitusega seotud. Kuid see pole tavaliselt suur probleem, kui ajaveebi on m\u00f5eldud \u00fchele \u017eanrile.<\/p>\n
Ka RAND() j\u00e4rjekord t\u00f6\u00f6tab tuhandete kirjete puhul h\u00e4sti. (tavaliselt tavalise blogi puhul). Kuid see p\u00f5letab teie andmebaasi, kui teil on samas tabelis miljoneid kirjeid, mis vastavad otsingukriteeriumidele."<\/p>\n
Jah, SQL-i j\u00e4rjestus rand() j\u00e4rgi<\/strong> on natuke keeruline ja aeglane. See peab hankima k\u00f5ik kirjed ja sorteerima juhuslikult. Seda peetakse madalaks, kui laua suurus on keskmine v\u00f5i suur. V\u00f5imalik, et soovite kasutada j\u00e4rgmist nippi juhusliku kirje kiiremaks hankimiseks, kasutades PHP-s funktsiooni rand() .<\/strong><\/p>\n
\/\/ get total number of records\n$query = \"select count(1) from `table`\";\n$result = mysql_query($query) or die(mysql_error());\n$total = mysql_result($result, 0, 0);\n\n\/\/ get a random\n$r = rand(0, $total - 1);\n\/\/ return a number between 0 and $total - 1 inclusive using PHP\n$query = \"select * from `table` limit $r, 1\";\n$result = mysql_query($query) or die(mysql_error());<\/code><\/pre>\n
SQL-i piirangu<\/strong> p\u00f5hjused m\u00e4\u00e4rab nihke ja teine \u200b\u200bparameeter m\u00e4\u00e4rab tootavate kirjete arvu.<\/p>\n
Parem juhuslik salvestus<\/h3>\n
\u00dclaltoodu kohaselt on j\u00e4rjestus rand() j\u00e4rgi<\/strong> \u00e4\u00e4rmiselt ebaefektiivne, kui teil on v\u00e4ga suur tabel, sest sortimiseks (isegi kui soovite ainult \u00fchte \u00fcksust) k\u00e4ivitatakse funktsioon rand()<\/strong> ja see on see, mida me ei tee. tahan. Saame eeltoodut t\u00e4iustada kahe p\u00e4ringu abil, millest esimene tagastab postituste koguarvu ja meil on PHP juhuslik funktsioon ja juhusliku kirje saame limiitlause abil<\/strong>.<\/p>\n
global $wpdb; \/\/ include the $wpdb\n$query= \"select count(1) from `wp_posts` where `post_type`='post' and `post_status`='publish'\";\n$cnt = $wpdb->get_var($query); \/\/ run the query on the database and return single variable\n$rand = mt_rand(0, $cnt - 1);\n$query= \"select `post_title` as `title`, `post_name` as `name` from `wp_posts` where `post_type`='post' and `post_status`='publish' limit $rand,1\";\n$results = $wpdb->get_results($query); \/\/ run the query on the database\n\/\/ the rest are the same<\/code><\/pre>\n
:  helloacm.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"
Lisage j\u00e4rgmine juhuslik postitus WordPressi lehemalli<\/p>\n","protected":false},"author":1,"featured_media":224094,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[718,894,718,833,894,1110,842,802,802,833,842,863,863],"tags":[1165],"class_list":["post-233282","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-arendaja","category-kood","category-juhend-algajatele","category-n-a","category-opetused","category-php-4","category-wordpress-4","tag-affiai-et"],"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/posts\/233282","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/comments?post=233282"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/posts\/233282\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/media\/224094"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/media?parent=233282"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/categories?post=233282"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/tags?post=233282"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}