database - Read For Learn

Can I connect WordPress website with an external database?

Website Developer has gone missing! How to gain full access of your code from a WordPress website?

Assuming you have admin access, the first thing to do is to downgrade his admin user to ‘contributor’ (lowest level). If you have been sharing the admin access, create a new admin account just for you, then log in as that account, and then downgrade that admin account. And don’t create an account called ‘admin’ … Read more

register_activation_hook not working

How can I delete the options from DB when the plugin is deleted?

WordPress, Error when trying to insert data >> Notice: wpdb::prepare was called incorrectly

I have fixed this, the issue was in the way I was creating the array. I was using a multi-dimensional and needed to call the correct level of the array in the post. By calling $_POST[‘customer’] which was the name of the array I could access the correct rows. Here is what the array looks … Read more

Best way to search and replace within serialized database strings?

It seems WP-CLI is indeed one of the easiest ways to search/replace serialized strings, e.g. for replacing any unwanted instances of staging links: wp search-replace https://staging.example.com https://example.com –all-tables The above command will search the entire WordPress database for the first string, and replace all instances with the second string provided. If you want to test … Read more

SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta

You can do something like Query the wp_posts table Left join the source_name from wp_posmeta table Left join the coverage_url from wp_posmeta table Then select the data you want to pull from post, source_name and coverage_url result Something like this should do SELECT post.ID, post.post_title, sn.meta_value as source_name, cu.meta_value as coverage_url FROM wp_posts as post … Read more

notify users when changed database

I don’t want Ajax request to be sent every 2 seconds. Is there a way to send me a notification only if the database changes in a certain meta? You can’t watch the database for changes like this. The most you could do is add filters on post meta changes on the PHP side to … Read more

Custom WP_query in Jnews theme returns thousands of posts

Running one-off cron jobs when WP_DISABLE_CRON is true: can I hit /wp-cron.php?

The WP_DISABLE_CRON constant only removes WP-Cron from loading on the page so it’s no longer triggered by site traffic. You can absolutely hit the wp-cron.php file directly to trigger it. I use https://cron-job.org to ping my private sites at https://dev.example.com/wp-cron.php?doing_wp_cron for example. This is actually recommended in the WordPress handbook: https://developer.wordpress.org/plugins/cron/hooking-wp-cron-into-the-system-task-scheduler/ Editing to add: if … Read more

+ More