Ukukhangisa Okuqukethwe

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.

izwi

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.

Douglas Karr

Douglas Karr i-CMO ye VulaINSIGHTS kanye nomsunguli we Martech Zone. UDouglas usize inqwaba yeziqalo eziphumelelayo ze-MarTech, uye wasiza ekukhuthaleni okungaphezu kuka-$5 bil ekuthengeni nasekutshalweni kwe-Martech, futhi uyaqhubeka nokusiza izinkampani ekusebenziseni nasekuzenzeleni amasu azo okuthengisa nokumaketha. UDouglas uyingcweti yokuguqula idijithali eyaziwa emhlabeni wonke kanye nesikhulumi se-MarTech. UDouglas futhi ungumbhali oshicilelwe wencwadi kaDummie kanye nencwadi yobuholi bebhizinisi.

Izihloko ezihlobene Nalesi

Buyela emuva kunkinobho phezulu
Close

I-Adblock itholiwe

Martech Zone iyakwazi ukukunikeza lokhu okuqukethwe ngaphandle kwenkokhiso ngoba senza imali ngesayithi yethu ngemali engenayo yezikhangiso, izixhumanisi ezingaphansi, noxhaso. Singajabula uma ungasusa i-ad blocker yakho njengoba ubuka isayithi lethu.