While this is not really an error, extra data that is not used should not be included in any output as it will only add to the extra bytes.

When you look at your JSON output, you realized the column names and values also have extra index column numbers and the associated values included.

To remove this, simply add an option in the PDO when you instantiate a database connection in PHP like this:

That should fix the problem. When you use json_encode(), there will be no more duplicate values with the corresponding column index number as key.

After being hit with malware that took advantage of some holes in old WordPress versions, I finally was able to solve the iFrame malware problem that had dogged a few of my other blogs.

I wondered why Sucuri always displays those same malware error messages even though I already cleaned everything. I thought Sucuri was nuts. So yes, their plugin actually bases the results on cached results.

If you want to have the updated results of Sucuri’s scan of your blog, make sure you click the RE-SCAN button in their site so the cached result will be the latest one that the plugin will use its report on.

While browsing through some of my folders, I noticed that wp-includes and all its subfolders exposed the file listing. This is a bad thing. Nobody should ever know what it inside your site’s folders. The plugin Silence is Golden Guard helped free my blog sites totally of those malware iframe error messages.

This plugin basically adds an index.php file in every folder of your blog site. There is nothing more this PHP file can do except just idle itself and show a blank screen in the browser whenever someone attempts to browse folders in your blog.

I believe the developer should at least put another option to have index.html instead of index.php. One may never know if the blog may get infected again. At least those PHP code will be useless inside an HTML file.

Related Posts Plugin for WordPress, Blogger...