xuxu.fr

Log WordPress MySQL queries in csv file (and log file). Useful when you need to improve the performance or debug something.
You can contact me :
<ul>
<li>My blog: https://xuxu.fr/contact</li>
<li>My website : https://www.xuan-nguyen.fr</li>
<li>My Twitter account: https://twitter.com/xuxu</li>
</ul>

SQLog

Log WordPress MySQL queries in csv file (and log file). Useful when you need to improve the performance or debug something.

I guess I’m just curious by nature. After installing Anders Holte Nielsens Counterize plug-in, I noticed quite a few google query hits. I wanted to know which keywords led people to my site. I did a quick search but couldn’t find somethink like I had in mind (Update: A reader pointed out, that there is a plugin called Search Phrases, which has a slightly more minimalistic aim). 
Since Counterize keeps track of the referer, it was just a matter of applying some regular expressions and preparing a tag-like keyword heat cloud, which we’ve all gotten used to.
<h3>Usage</h3>
This is quite a simple filter. There’s two ways to use it:
function call [for use in templates]
<ul>
<li><code><?php if(function_exists(cloogooq)) cloogooq(keywords); ?></code></li>
<li><code><?php if(function_exists(cloogooq)) cloogooq(phrases); ?></code></li>
</ul>
token filter [for use in posts]
<ul>
<li><code>[CloOGooQ_KEYWORDS]</code></li>
<li><code>[CloOGooQ_PHRASES]</code></li>
</ul>
Either way will generate one of these two keyword clouds <a href="https://wordpress.org/extend/plugins/cloogooq/screenshots/" rel="ugc">below</a>. The first one disassembles the search string and counts each word for it’s one. The second phrase cloud leaves search strings intact – just like they got entered by the user.
<h3>License</h3>
This WordPress plug is released under the <a href="http://www.gnu.org/licenses/gpl.html" rel="nofollow ugc">GPL</a> and is provided with absolutely no warranty (as if?). For support leave a comment and we’ll see what the community has to say.

Cloud-O-Google Queries

Cloud-O-Google Queries is a filter to display keyword clouds based on search engine queries.

SQLog vs Cloud-O-Google Queries