The first thing you want to do will be find the post you want to modify. To find the post named “beddu” which post_type is post, you can excute this query: SELECT * FROM wp_posts WHERE post_type=”post” AND post_title=”beddu”; After you test and find the condition is correct. Move to update part. UPDATE wp_posts SET … Read more
You shouldn’t use a SQL query. You can do this programatically. $price = get_post_meta( $product_id, ‘_price’); $price += 100; // use -= 100 to subtract update_post_meta($product_id, ‘_price’, $price); update_post_meta($product_id, ‘_regular_price’, $price);
In my opinion and from what i’ve seen on testing. Using any WordPress function will slow things down dramatically. The fastest way i found to do this is by querying MySQL directly and grabbing only the things needed. For example: $products = $wpdb->get_results( “SELECT post_title, post_name FROM `wp_posts` WHERE post_type=”products””, ARRAY_A ); echo ‘<ol>’; foreach … Read more
You need to identify the tables for each of the columns that have the same name. You should also be using an IN statement and not = for the department. I can’t test this since I don’t have your DB but you can try this: $sql = $wpdb->get_results(“SELECT * FROM ” . $wpdb->prefix . “dir_personnel … Read more
I found out that my settings where filtered by validation function registered by register_setting. Somehow I thought that it would only affect settings that where going through wordpress’s own settings fields and not a custom AJAX function (the way I have it setup). To the point of the question: I used php exit to debug … Read more
What’s the easiest way to connect external database and display data on wordpress?
$wpdb has an insert method, so you can try the following: $table=”wp_email_subscribers”; $data = array( ‘first_name’ => $firstname, ‘last_name’ => $lastname, ’email’=> $email , ‘gdpr_consent’=>$gdprconsent ); $format = array(‘%s’,’%s’, ‘%s’, ‘%s’); $wpdb->insert($table,$data,$format); var_dump($wpdb->insert_id);
Using a meta_value or postdate to to query and orderby
Can I replace the “Upgrade Network” with SQL query?
If you’re looking for raw SQL query, then this should help: UPDATE <PREFIX>postmeta SET meta_value=”temp4″ WHERE meta_value=”temp1″ AND meta_key = ‘post_template’ If you want to run this query from WP, then you can use this: global $wpdb; $wpdb->update( “{$wpdb->prefix}postmeta”, array( ‘meta_value’ => ‘temp4’ ), array( ‘meta_key’ => ‘post_template’, ‘meta_value’ => ‘temp1’ ) );