Sometimes SQL knowledge is critical for WordPress developers to run mass updates on your posts. In this post, we are sharing an example SQL query to get posts using a category name. This requires database access and some basic SQL knowledge. To get all posts […]
To get a list of WordPress Posts using meta query in MySQL, you can use the following SQL query: SELECT p.ID, p.post_title, m.meta_id, m.meta_key, m.meta_value FROM `wp_posts` p LEFT JOIN `wp_postmeta` m ON p.ID = m.post_id WHERE m.meta_key = ‘wpcf-show-status’ AND m.meta_value ” ORDER BY […]
If you want to add a new user to WordPress database using MySQL using phpMyAdmin or a similar tool, you can use the following snippet: INSERT INTO `wp_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES (‘admin’, ‘$P$Bg/Ol6U.M07OGU7sKEZvIyl.mxuQQw.’, ‘admin’, ‘[email protected]’, ”, ‘2018-12-21 16:34:15’, […]
WordPress allows theme developers to define custom CSS styles for visual editor on the post edit screen. Although, this theme development stage is often skipped by developers, it is very critical for end users to feel home when they are composing amazing posts. To add […]
WordPress is a really powerful and secure CMS system, but if you are using it with the default installation, your site is always under risk. For example, if your login URL is yoursite.com/wp-admin hackers will always know where to start. In this post, I will […]
WordPress uses .htaccess file to handle all requests through the index.php file. This is a great feature because it enables us to use permalinks and all kinds of redirections. But it has one major pitfall. When a missing static file (404 error) is handled by WordPress […]
WordPress Countdown Widget supports count-up timers since version 2.5. It also has support for full shortcode functionality. In this post, I am going to show you how to easily add count-up timers to your WordPress posts using shortcodes. Count-up Shortcode Basic Syntax i That’s the […]
While developing WordPress themes, dividing your theme into multiple re-usable templates makes everything easier. WordPress already manages templates parts like header, footer, and sidebar using special functions like get_header, get_footer, and get_sidebar. For including all other template parts that are created by the designer we […]
Countdown Widget has the ability to suit your theme’s stylesheet and it can be customized easily using the Custom CSS field in WordPress Customizer. If you need to add semi-colons between digits of your countdown widget, you can easily do this using the code snippet below: […]
SQL is a great tool if you want to make changes to all your posts at once. Especially if you want to replace some old string with new ones it will be really helpful. In this post, I am going to show you how you […]
