database

Change all http to https in mysql databse?

I should think that you can use phpAdmin Find and Replace where you find “http://www.example.com” and replace with “https://www.example.com“. This should handle all internal linking (if blog, then internal linking as well as images, etc.). It would not cover relative addressing like “//www.example.com”. In the case of WordPress, this would be done on the wp_posts … Read more

Updating all rows of table with $wpdb

It will not work as the update statement requires a selector to narrow down what to update. You should use a general query. For your needs use this: $wpdb->query( $wpdb->prepare( “UPDATE $wpdb->comments SET `comment_karma` = %s”, ‘123’ ) );

Why WordPress uses 4 tables to manage terms

Well, it uses 3 tables. The fourth one (wp_termmeta) is just a way of allowing you to store some meta values for terms (icons, additional descriptions and so on). Citing from Codex: wp_terms – The categories for both posts and links and the tags for posts are found within the wp_terms table. wp_termmeta – Each … Read more

Extend the wp_users table

There are far better ways of doing this. Instead of modifying the user table, make use of User Meta. It has a dedicated table, and works the same way as post meta, but for users. add_user_meta get_user_meta update_user_meta There are many tutorials explaining how to add additional fields to the user profile using User meta … Read more

How to count number of records found in a database table?

Why don’t you directly echo the $num as it will contain the count of rows already…Here’s the edited part.. //To show number of rows in table function DB_Tables_Rows() { global $wpdb; $table_name = $wpdb->prefix . ‘mydata’; $count_query = “select count(*) from $table_name”; $num = $wpdb->get_var($count_query); echo $num . ‘Rows Found’; }

+ More