WordPress ndi MySQL: Kodi Mawu Anu Awerengedwa Chiyani?

Zithunzi za Depositph 16207113 s

Pakhala pali zokambirana pamabulogu za kukula kwaposachedwa kwa WordPress. Kuunika kwina kwatsimikizika kuti Ma Injini Osakira amangolemera zotsatira zoyambilira x chiwerengero cha zilembo, pomwe x sichikudziwika pakadali pano. Zotsatira zake, chilichonse pambuyo pake ndikungowononga mawu.

mawu

Chithunzi kuchokera Wordle!

Ndimakhudzidwa kwambiri ndi zolemba zanga pa blog kotero ndipanga zina zowunikira ndikuwona ngati kutchuka kwa positi kuchokera pazosaka kuli ndi mgwirizano uliwonse ndi mawu ochuluka. Sindikupeza zasayansi kwambiri, koma ndikufuna ndiyang'anenso.

Kodi ndingafunse bwanji WordPress ya Word Count?

MySQL ilibe cholemba mawu chokhazikika mu MySQL, koma monganso funso lililonse losayankhidwa, munthu wina wanzeru pa blogosphere wayankha kale momwe angagwiritsire ntchito MySQL kuti apeze Mawu Owerengera.

Nayi funso lowerengera mawu la wolemba lomwe lasinthidwa patsamba la WordPress:

SANKHANI `ID`,` post_date`, `post_type`,
SUM (LENGTH (`post_content`) - LENGTH (REPLACE (` post_content`, '', '')) + 1) AS 'Wordcount'
KUCHOKERA `wp_post`
GULU NDI `ID`
KUKHALA `post_type` = 'post' NDI` post_status` = 'publish'
DONGOSOLO NDI `post_date` DESC
MALIRE 0, 100

Pakadali pano sindilembetsa ku 'kukula kwabwino positi' popeza zomwe zimapatsa mphamvu ndi injini yosaka sikuti kungowerengera mawu, koma kuchuluka kwa maulalo azomwe zili. Ngati muli ndi mawu 2,000 omwe amakopa chidwi chamalumikizidwe ambiri, ndiye kukula koyenera kwa positi yanu kunali mawu 2,000.

7 Comments

  1. 1
  2. 2
  3. 3

    Ndikulemba mpaka nditapeza mfundo yanga. Ndikuganiza kuti ndichopusa kuti anthu ogula zinthu atakulungidwa ndi kuchuluka kwamawu.

    • 4

      Casey - Ndikuvomerezana nanu kwathunthu. Ndikuganiza kuti pali mwayi wogwiritsa ntchito zithunzi ndi zipolopolo kuti akope anthu kuti awerenge zomwe zalembedwa, koma ndimalemba mpaka ndikuganiza kuti mfundoyi yaperekedwa… ndipo sindiyesanso kuchita zocheperapo kapena zochepa.

    • 5

      Casey - Ndikuvomerezana nanu kwathunthu. Ndikuganiza kuti pali mwayi wogwiritsa ntchito zithunzi ndi zipolopolo kuti akope anthu kuti awerenge zomwe zalembedwa, koma ndimalemba mpaka ndikuganiza kuti mfundoyi yaperekedwa… ndipo sindiyesanso kuchita zocheperapo kapena zochepa.

Mukuganiza chiyani?

Tsambali likugwiritsa ntchito Akismet kuchepetsa spam. Phunzirani momwe deta yanu ikufotokozera.