WordPress absolutely does need “DELETE“, otherwise it has no way to delete posts or tags or options rows or anything else. The “DROP” command is sometimes used during upgrades, although it’s been a long time. The last time I think it was used was during the WordPress 2.3 update, which removed the assorted categories tables … Read more
The second one is revision. It means the changes that you made, but didn’t save. WordPress saves that as revision post. There might be more than one revision post if you make more changes without updating the post. You don’t need to worry about that. It’s all in background and won’t affect you in any … Read more
Don’t change the Post ID. WordPress uses serialized data, and id’s have deep linking within the database.
Why do your own database queries? Use the WP functions to do it for you. $empid = (int) $_REQUEST[’empid’]; $name = get_user_meta($empid, ‘first_name’, true) . ‘ ‘ . get_user_meta($empid, ‘last_name’, true);
slow queries need to be cached, and the cache probably should be primed when the post is being saved to keep high level of responsiveness for all users (except for the one submitting the post at the time of submitting).
Bulk of WP’s native data structures aren’t meant for direct MySQL access. They are typically accessed via PHP APIs which take care of MySQL generation/execution and many more things, such as allowing to filter data, caching it for performance, and so on. Your issue here is that from MySQL point of view meta values aren’t … Read more
Use WP CLI! First grab the posts you want, we’ll use the wp post list command, and we need to run the command in our WordPress directory on the server. Here I’m grabbing all posts in October 2014 on my blog: wp post list –year=2014 –monthnum=10 This gives me ( oh noes my secret draft … Read more
Use stripslashes to remove the slashes. For example: echo stripslashes( $field );
You’re including the table prefix, but $wpdb takes care of that. Change: $query = $wpdb->prepare( “SELECT * FROM $wpdb->wp_terms INNER JOIN $wpdb->wp_term_taxonomy ON ($wpdb->wp_terms.term_id = $wpdb->wp_term_taxonomy.term_id) WHERE $wpdb->wp_terms.name LIKE %s AND $wpdb->wp_terms.count > 0”, $wpdb->esc_like($keyword) . ‘%’); To: $query = $wpdb->prepare( “SELECT * FROM $wpdb->terms INNER JOIN $wpdb->term_taxonomy ON ($wpdb->terms.term_id = $wpdb->term_taxonomy.term_id) WHERE $wpdb->terms.name LIKE … Read more
When getting user input to be stored on database, a good way to proceed is: Data validation: validate the data according whith the data you expect. For example: HTML string, number, email, URL, any text with no HTML, ect. Never trust on user input or client-side validation. You can make here also some sanitization, but … Read more