Registering a new user – database Adding a post or comment – database Changing to a new theme – database(yes) Changing a theme’s settings – database Installing or removing a plugin – file system,database Activating, or deactivating a plugin – file system,database Updating a plugin – file system and database (DB structure may change if … Read more
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
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’ ) );
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
Not 100% sure how your DB could get that big. Have you gone through and cleaned out post revisions, old rows in the wp_options table from old plugins, etc?
you do not have to specify the $wpdb again in your query, but be sure that your table uses the prefix, if it has one. if it doesn’t, skip the part with the prefix. also, you should always prepare a manually added query first. this should do it: global $wpdb; $query = $wpdb->prepare( “SELECT * … Read more
This is a PHP variable scope issue, there is no $wpdb defined in your function. Add global $wpdb; before trying to use the $wpdb object.
Backticks and regular quotes (both single and double) have distinct meanings in SQL. Quotes indicate a literal string, whereas backticks are quoted identifiers. This isn’t specific to WordPress, but rather a general way in SQL of quoting columns or tables. For example, imagine you’re running a query comparing two columns: SELECT * FROM wp_posts WHERE … Read more
From PHP to WordPress If you are experienced in programming and in PHP, you know that saving data coming from a form basically involves these steps: validation sanitization connection to database store value in database even if “plain” PHP would work for all of them, WordPress has helpers and specific best practices for them. Validation … Read more
Here is a list of points that will help you in order to make an iOS app for your WordPress blog: You can either parse XML in the RSS feed, JSON by installing a JSON plugin in your WordPress or you can also parse HTML directly. 1) I would suggest using NSXMLParser and parse the … Read more