Can I disable auto increment of WordPress Posts Database to utilize previously deleted records?
Can I disable auto increment of WordPress Posts Database to utilize previously deleted records?
phpmyadmin
What is recommended data type and encryption type for password in a database
What is recommended data type and encryption type for password in a database
update_post_meta not working in template_redirect action
update_post_meta not working in template_redirect action
SQL query to change custom field in WordPress database
Recommend a database backup before you do this. ** updated the statement to specify “Y”, empty string, or null ** global $wpdb; $wpdb->query( “update {$wpdb->postmeta} SET meta_value=”X” WHERE meta_key = ‘old_price’ AND ( meta_value=”Y” OR meta_value=”” OR meta_value IS NULL ) );” );
why not selecting multiple rows of same standard_id using SQL query from database?
why not selecting multiple rows of same standard_id using SQL query from database?
Update WooCommerce stock status with SQL query if stock value is greater than 0
Update WooCommerce stock status with SQL query if stock value is greater than 0
Unable to insert two value in two different columns (WordPress database)
Unable to insert two value in two different columns (WordPress database)
Find locations of all featured images of draft posts via SQL
Alright this worked for me: First run the bellow script to generate the file locations of all files used for draft posts. SELECT voybp_posts.guid FROM voybp_posts WHERE voybp_posts.ID IN (SELECT voybp_postmeta.meta_value FROM voybp_postmeta WHERE voybp_postmeta.post_id IN ( SELECT voybp_posts.ID FROM voybp_posts WHERE voybp_posts.post_status=”draft”) AND voybp_postmeta.meta_key=”_thumbnail_id”) Export this as a CSV file and save it to … Read more
Store GravityForm data in phpmyadmin (mysql)
You can use something like below. Basically after form submission we get the data $entry extract the values we want (in the example $val1, $val2, $val3) then insert that data into the custom table with $wpdb: add_action(‘gform_after_submission’, ‘save_to_my_custom_table’, 10, 2); function save_to_my_custom_table($entry, $form) { global $wpdb; // update for your tablename (this assumes the table … Read more
Migrating meta_key and meta_value from old theme to new one
You’d have to look more closely at how the old theme displays the postmeta. At this point, you have a few options: Create a child theme for your new theme, and in its PHP file to display single posts, set the child theme up to display the postmeta just like your old theme did. (You … Read more