WordPress ndi MySQL: Kodi Mawu Anu Awerengedwa Chiyani?
Pakhala zokambidwa pamabulogu okhudza pafupifupi mawu ochuluka za positi ya WordPress. Kuwala kwina kwatsitsidwa kuti injini zosaka zidzangoyesa zoyambazo x chiwerengero cha zilembo, pomwe x sichikudziwika pakadali pano. Zotsatira zake, chilichonse pambuyo pake ndikungowononga mawu.
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'ane mozama.
Kodi ndingafunse bwanji WordPress ya Word Count?
MySQL ilibe cholemba mawu chokhazikika mu MySQL, koma monganso funso lina 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:
SELECT `ID`, `post_date`, `post_type`,
SUM( LENGTH(`post_content`) - LENGTH(REPLACE(`post_content`, ' ', ''))+1) AS 'Wordcount'
FROM `wp_posts`
GROUP BY `ID`
HAVING `post_type` = 'post' AND `post_status` = 'publish'
ORDER BY `post_date` DESC
LIMIT 0, 100
Pakadali pano sindilembetsa ku 'kukula kwabwino positi' popeza zomwe zimapatsa mphamvu ndi makina osakira sikuti ndi kuwerengera kwamawu kokha, koma chiwerengero cha maulalo ku zomwe zili. Ngati muli ndi mawu a 2,000 omwe amakopa chidwi chambiri, ndiye kukula koyenera kwa positi yanu kunali mawu 2,000.