can’t delete a row from post_meta table
This is because the value of meta key is inside the if clause and is not set for the else. try else { $key = ‘save-author-to-book’; delete_post_meta( $post_id, $key, $meta_value=””); // break; }
mysql
Resetting AUTO_INCREMENT primary key
ALTER TABLE tablename AUTO_INCREMENT = 1 Change 1 to your desired value. for that case prior to execution of this you can sort your table with the primary field and get the highest value.
Migration of wordpress database from mariadb 10.0.20 to 5.5.50
This looks like a Foreign Key issue. When you use PHPMyAdmin to create the sql dump, try using the custom settings to disable Foreign Key checks.
How to extract some part of WordPress full source code
Let’s say what you have for post_content in database is $raw_content. Then what end result displayed by theme (simplified and varies a bit) would roughly be apply_filters( ‘the_content’, $raw_content ). Which filters? Essentially who knows. Quite a few are added by core to handle things like markup and typography adjustments, shortcode processing, and so on. … Read more
Performance of wp_get_attachment_image_srcset() and wp_get_attachment_image_url()
Performance of wp_get_attachment_image_srcset() and wp_get_attachment_image_url()
$wpdb Mysql trigger problem
No idea yes, use $wpdb seems like it should be. OTOH if this is something you want to do in a plugin, I am not sure if normal wordpress users (as defined in the DB) have trigger creation privilege. just be careful with what you are trying to do, as if you have object caching … Read more
How can I display a query in a page?
You can use the $wpdb object // Print last SQL query string $wpdb->last_query or: <?php if (current_user_can(‘administrator’)){ global $wpdb; echo “<pre>”; print_r($wpdb->queries); echo “</pre>”; }//Lists all the queries executed on your page ?> You might have to set define(‘SAVEQUERIES’, true); in wp-config.php
CONCAT_WS in custom sql query
‘CONCAT_WS(‘,’, wp_postmeta.meta_key, wp_postmeta.meta_value)’ was the name of the column. Everything is working as it should. To change the name of the column, add AS name after the CONCAT_WS statement, like this: ‘CONCAT_WS(‘,’, wp_postmeta.meta_key, wp_postmeta.meta_value)’ AS name (I didn’t test this specifically). Now the new column will be called name.
sql query not working in wp plugin
silly mistake, forgot $wpdb, it should be $school_count_last_month = $wpdb->get_var(“SELECT COUNT(*) from $wpdb->posts where post_date >= DATE_ADD(LAST_DAY(DATE_SUB(NOW(),INTERVAL 2 MONTH)),INTERVAL 1 DAY) and post_date <= DATE_SUB(NOW(),INTERVAL 1 MONTH)”);
Error while submitting form using AJAX and php
I believe it is because you are trying to set object properties that are undefined. Your javascript should look like this var measrumentData = { profile_name:null, value_one:null, value_two:null }; // Grab our post meta value measrumentData.profile_name = $( ‘#savem #profile_name’ ).val(); measrumentData.value_one = $(‘ #savem #value1’).val(); measrumentData.value_two = $(‘ #savem #value2’).val(); or var measrumentData = … Read more