IWordPress kunye neMySQL: Lithini iLizwi lakho kwiLizwi?

Iidipozithi iifoto 16207113 s

Kukho intetho kwiiblogi malunga nobungakanani obuqhelekileyo besithuba seWordPress. Olunye ukhanyiso luye lwakhanyiswa ukuba ii-Injini zokuKhangela ziya kuthi zilinganise ifuthe lokuqala x inani labalinganiswa, apho u-x okwangoku engaziwa. Ngenxa yoko, nantoni na emva koko yinkcitha yamagama.

igama

Umfanekiso ukusuka Amazwi!

Ndingcono ukuba ndonwabe ngeposi zam zebhlog ukuze ndenze uhlalutyo olongezelelekileyo kwaye ndibone ukuba ukuthandwa kwesithuba kwiziphumo zophando kunalo naluphi na unxibelelwano isibalo samagama. Andizukufumana isayensi kakhulu, kodwa ndifuna ukujonga nzulu.

Ndingabuza njani i-WordPress kubalo lwamagama?

I-MySQL ayinayo eyakhelwe-ngaphakathi eyokubala amagama ye-MySQL, kodwa njengayo yonke eminye imibuzo engaphendulwanga, umntu othile okrelekrele kwi-blogosphere sele ephendulile ukuba uyisebenzisa njani i-MySQL ukufumana ubalo lwamagama.

Nanku umbuzo wombhali wokubala uguqulwe kwiziko ledatha leWordPress:

KHETHA`ID`, `post_date`,` post_type`,
SUM (LENGTH (`post_content`) - LENGTH (REPLACE (` post_content`, '', '')) + 1) AS 'Wordcount'
UKUSUSA `wp_post`
IQELA NGU `ID`
UKUBA `post_type` = 'post' NO` post_status` = 'publish'
UKUYALELWA NGU `post_date` DESC
UMDA KUNYE, 0

Okwangoku andibhalisi 'kubungakanani beposi ogqibeleleyo' kuba eyona nto ibonelela ngesisindo ngenjini yokukhangela ayisiyo nje ukubala kwamagama, kodwa inani lamakhonkco kuloo mxholo. Ukuba unamagama angama-2,000 XNUMX athumela umtsalane kunxibelelwano oluninzi, emva koko ubungakanani obufanelekileyo beposi yakho yayingama-2,000 amagama.

7 Comments

  1. 1
  2. 2
  3. 3
    • 4

      Casey - Ndivumelana nawe ngokupheleleyo. Ndicinga ukuba kukho amathuba okusebenzisa imifanekiso kunye namanqaku eebhulethi ukutsala abantu ukuba bafunde umxholo, kodwa ndibhala ndide ndicinge ukuba inqaku lenziwe… kwaye ndizama ukungaphindi okanye hayi ngaphantsi.

    • 5

      Casey - Ndivumelana nawe ngokupheleleyo. Ndicinga ukuba kukho amathuba okusebenzisa imifanekiso kunye namanqaku eebhulethi ukutsala abantu ukuba bafunde umxholo, kodwa ndibhala ndide ndicinge ukuba inqaku lenziwe… kwaye ndizama ukungaphindi okanye hayi ngaphantsi.

Ingaba ucinga ntoni?

Le sayithi isebenzisa i-Akismet ukunciphisa ugaxekile. Funda indlela idatha yakho yokubhaliweyo isetyenziswe ngayo.