Use $wpdb or other PHP script method to find/replace in WP database
I’m hoping to push a bug fix for a custom WordPress plugin my sites use.
sql
WP_POSTMETA changes site crash
I try to update wp_postmeta from SQL script.
How to Update post_modified of all wordpress post
i want to update all my wordpress post modified date and time to a specific date and time,
i have a code to update it base on the id, but i want one to update all the row at once without putting the id of the posts .
CREATE TABLE with dbDelta does not create table
I based this code from the codex on the docs. I placed it in my main plugin file but it’s not creating the database table. Have I missed something?
Clear Terms from Taxonomy for Specific Post IDs?
Trying figure out how I can use some SQL/$wpdb->query to delete all the terms from a taxonomy that are related to specific post IDs. The following works beautifully to delete all the terms from a specific taxonomy, but I need to modify it to only remove ones associated with specific post IDs as mentioned.
WP_Query with “post_title LIKE ‘something%'”?
I need to do a WP_Query with a LIKE on the post_title.
Organizing WP Pages based on old website database
I’m moving existing data involving paintings from an old host that didn’t use WordPress to a new host that does.
How to display SQL query that ran in query?
I have come across a function before that displayed the exact SQL code that was used.
In a loop for example, but can’t remember.
Add special meta box to custom post type
I have managed to add a meta box to my custom post type (see code below)
Now I need to add another meta box. With this box I want to display / edit a value from another table called wp_project_bids_mitglied. This table contains a row with the post ids and a row with the values (0,1,2) that I would like to edit / display in my backend. How do I have to change the code to achieve this goal? Thanks!
Getting users who registered 360 days from current date
As per the title, what I want to do is run a custom query that (using WP-Cron) will run once a day to check for users who registered exactly 360 days before the current date (don’t need time, just date) and gather their ID. I have this: