+16468445717

Category: sql

  1. Home
  2. Archive by Category "sql"
29 Dec

Downsize your WordPress database by removing transients

Wordpress Expert
web developer at WPLAB
Website development like the art
Latest posts by Wordpress Expert (see all)

First of it all, login to your phpmyadmin and choose your WordPress database. Once done, click on the sql button to open the sql command window. Then, simply paste the following sql command and execute it. DELETE FROM `wp_options` WHERE `option_name` LIKE (‘%_transient_%’); Credit: Stack Overflow Want more super useful SQL queries? Check out this […]

Rating
29 Dec

Downsize your WordPress database by removing transients

Wordpress Expert
web developer at WPLAB
Website development like the art
Latest posts by Wordpress Expert (see all)

First of it all, login to your phpmyadmin and choose your WordPress database. Once done, click on the sql button to open the sql command window.Then, simply paste the following sql command and execute it. Rating

Rating
23 Dec

WordPress tip: move all JavaScript files to the footer automatically

Wordpress Expert
web developer at WPLAB
Website development like the art
Latest posts by Wordpress Expert (see all)

First, open your functions.php file and paste the following code in it: Rating

Rating
16 Dec

WordPress tip: How to display a disclaimer on posts older than one year

Wordpress Expert
web developer at WPLAB
Website development like the art
Latest posts by Wordpress Expert (see all)

Paste the following code in your single.php file, within the loop. Edited the text on line 7 as desired. Rating

Rating
8 Dec

How to pre-populate WordPress editor with default content

Wordpress Expert
web developer at WPLAB
Website development like the art
Latest posts by Wordpress Expert (see all)

This code has to be pasted into your theme’s functions.php file. It can be customized to deal with custom post types, as shown on line 16 and after. Rating

Rating
3 Dec

WordPress shortcode to display user registration date

Wordpress Expert
web developer at WPLAB
Website development like the art
Latest posts by Wordpress Expert (see all)

First, place the code below into your theme’s functions.php file and don’t forget to save. Rating

Rating
30 Nov

How to disable content editor for a specific page template

Wordpress Expert
web developer at WPLAB
Website development like the art
Latest posts by Wordpress Expert (see all)

Before pasting this code in your function.php file, edit line 11 and replace contact.php by the name of the page you want to disable the editor for. Rating

Rating
3 Aug

WordPress hack: Show all active plugins

Wordpress Expert
web developer at WPLAB
Website development like the art
Latest posts by Wordpress Expert (see all)

Simply paste this code where you want to display the active plugin list. Once saved, active plugins will be displayed. Rating

Rating
15 Sep

WordPress tip: Modify any role name to fit your needs

Wordpress Expert
web developer at WPLAB
Website development like the art
Latest posts by Wordpress Expert (see all)

Simply paste this code into your function.php file. Edit lines 5 and 6 at your convenience. Rating

Rating
3 Apr

How to remove login shake effect when error occurs

Wordpress Expert
web developer at WPLAB
Website development like the art
Latest posts by Wordpress Expert (see all)

Simply paste the following code into your functions.php file: Rating

Rating
14 Mar

WordPress tip: Bulk delete comments with a specific url

Wordpress Expert
web developer at WPLAB
Website development like the art
Latest posts by Wordpress Expert (see all)

Just run the following query on your WordPress database to delete comments with nastyspamurl as url. Don’t forget to replace the table prefix wp_ if your database is using another prefix.And of course, create a backup of your database before running the query! Rating

Rating
14 Mar

WordPress tip: Bulk delete comments with a specific url

Wordpress Expert
web developer at WPLAB
Website development like the art
Latest posts by Wordpress Expert (see all)

Just run the following query on your WordPress database to delete comments with nastyspamurl as url. Don’t forget to replace the table prefix wp_ if your database is using another prefix.And of course, create a backup of your database before running the query! DELETE from wp_comments WHERE comment_author_url LIKE “%nastyspamurl%” ; The post WordPress tip: […]

Rating