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

Ama-Depositphotos 16207113 s

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.

izwi

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.

7 Amazwana

  1. 1
  2. 2
  3. 3

    Ngibhala ngize ngithole iphuzu lami. Ngicabanga ukuthi kuyisiphukuphuku ukuthi abantu abathenga okuqukethwe basongwe kakhulu ngokubalwa kwamagama.

    • 4

      UCasey - Ngivumelana nawe ngokuphelele. Ngicabanga ukuthi kunamathuba okusebenzisa izithombe namaphoyinti ezinhlamvu ukuheha abantu ukuthi bafunde okuqukethwe, kepha ngibhala ngize ngicabange ukuthi iphuzu lenziwe… futhi angizami ukwenza okungaphezulu noma okuncane.

    • 5

      UCasey - Ngivumelana nawe ngokuphelele. Ngicabanga ukuthi kunamathuba okusebenzisa izithombe namaphoyinti ezinhlamvu ukuheha abantu ukuthi bafunde okuqukethwe, kepha ngibhala ngize ngicabange ukuthi iphuzu lenziwe… futhi angizami ukwenza okungaphezulu noma okuncane.

UCABANGANI?

Le sayithi isebenzisa i-Akismet ukunciphisa ugaxekile. Funda ukuthi idatha yakho yokuphawula isetshenziswa kanjani.