Tag Archives: SQL

How To Delete Pingbacks, Spam Comments and Unused Tags in WordPress

WordPress is a great CMS, but it can get cluttered over time, and there’s no better way to remove all the unnecessary junk than to go clean it up in MySQL. Here are 3 quick SQL queries you can run to clean up your MySQL database. SQL command to delete all spam comments in WordPress: [...]

Continue reading...

How To Use SQL To Delete All Posts In A WordPress Category

How To Use SQL To Delete All Posts In A WordPress Category

This handy script allows you to delete all posts and all their related content from your WordPress installation…PERMANENTLY. Please use it with CAUTION and always perform backups! Use this script only at your own risk. Step 1: First you need to log into your phpMyAdmin and select your WordPress database. Step 2: From the horizontal [...]

Continue reading...

How To Protect Your Websites Against SQL Injection Attacks

How To Protect Your Websites Against SQL Injection Attacks

If not protected properly, websites can be vulnerable to SQL injection attacks. A layered approach to thwart SQL injection attacks provides a good defense. The following provide just some ways that you can adopt to start protecting your websites. 1. Sanitize the input The first thing you need to do is to make sure that [...]

Continue reading...

How To Process Multiple SQL Statements

How To Process Multiple SQL Statements

Sometimes you’ll find yourself needing to execute multiple statements at once. The normal mysql() class only allows for single statements, but the recent mysqli() offers this functionality. To use it, follow this code example:

Continue reading...

How To Solve Joomla Admin Login Problem

how to solve joomla admin login problem

If you’re using Joomla, and facing an admin login problem, you’re not alone. The Joomla admin login problem is a huge problem faced by many people, and because there are many causes, here are just some of the more common solutions that you can try. Joomla allows Super Administrators to add, edit, and delete users [...]

Continue reading...