I-WordPress ne-MySQL: Lithini I-Word Lakho?

Kube nokukhulunywa okuthile kumabhulogi mayelana nosayizi omaphakathi wokuthunyelwe kwe-WordPress. Kukhanyisiwe okunye ukuthi ama-Search Engines azolinganisa umthelela wokuqala x inani lezinhlamvu, lapho u-x okwamanje engaziwa. Ngenxa yalokho, noma yini ngemuva kwalokho kumane nje kuwukuchitha amagama.

Isithombe kusuka I-Wordle!

Ngikhathazekile kakhulu ngokuthunyelwe kwami ​​kubhulogi ngakho-ke ngizokwenza okunye ukuhlaziywa futhi ngibone ukuthi ukuthandwa kokuthunyelwe kusuka emiphumeleni yosesho akunakho ukuxhumana igama lokubala. Ngeke ngibe nesayensi kakhulu, kepha ngifuna ukubheka ngokujulile.

Ngingabuza kanjani i-WordPress ye-Word Count?

I-MySQL ayinayo umsebenzi owakhelwe ngaphakathi wokubala amagama we-MySQL, kepha njengayo yonke eminye imibuzo engaphenduliwe, omunye umuntu ohlakaniphile ku-blogosphere usevele uphendule ukuthi ungayisebenzisa kanjani i-MySQL ukuthola i-Word Count.

Nawu umbuzo wombhali wegama eliguqulwe ku-database ye-WordPress:

KHETHA ʻID`, `post_date`,` post_type`,
I-SUM (LENGTH (`post_content`) - LENGTH (REPLACE (` post_content`, '', '')) + 1) NJENGOBA 'Wordcount'
KUSUKA `kumikhawulo wp_` 
IQEMBU NGU- `ID` 
UKUBA `post_type` = 'post' NO` post_status` = 'publish'
ODA NGOKUTHI `post_date` DESC 
I-LIMIT 0, 100

Okwamanje angibhaliseli 'kusayizi weposi ophelele' ngoba lokho okunikeza isisindo ngenjini yokusesha akuyona nje isibalo samagama, kepha inani lezixhumanisi zalokho okuqukethwe. Uma uneposi lamagama elingu-2,000 XNUMX eliheha ukunakwa kwezixhumanisi eziningi, khona-ke usayizi ofanele wokuthunyelwe kwakho kwakungamazwi angama-2,000.