I-WordPress ne-MySQL: Lithini I-Word Lakho?
Kube khona inkulumo kumabhulogi mayelana nesilinganiso igama lokubala kokuthunyelwe kwe-WordPress. Okunye ukukhanya kubonisiwe ukuthi izinjini zokusesha zizokala kuphela umthelela wokuqala x inani lezinhlamvu, lapho u-x okwamanje engaziwa. Ngenxa yalokho, noma yini ngemuva kwalokho kumane nje kuwukuchitha amagama.
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:
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
Okwamanje angibhaliseli 'kusayizi weposi ophelele' ngoba lokho okunikeza isisindo ngenjini yokusesha akuyona nje isibalo samagama, kodwa inani lezixhumanisi kulokho okuqukethwe. Uma unokuthunyelwe kwamagama angu-2,000 okuheha ukunakwa kwezixhumanisi eziningi, khona-ke usayizi ofanele wokuthunyelwe kwakho kwakungamazwi angama-2,000.