How to Add or Change Post Title

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

WordPress credentials not matched

If your database connection is wrong you will get an error says Error establishing database connection so if you seeing login form your connection is fine and wp-config has nothing to do in your issue. If you don’t remeber what’s your credentials are, go to your database manager like phpMyAdmin and look for _users table … Read more

Fastest way to display 5000 post titles?

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

HELP $q=mysql_query($sel) or die(mysql_error()) HELP

This is more like a server problem, it seems like your server is very old. WordPress requirements change over time to stay up to date and provide a fast and stable experience and also more features. As of this post, the WordPress server (minimum) requirements are the following: PHP 5.2.4+ MySQL 5.0+ Recommended is: PHP … Read more

get_option() does unserialize and don’t remove \

The get_option function is necessary for you using maybe_unserialize. update_option() function maybe_serialize passed. // store data time use maybe_unserialize. $data = maybe_serialize( $data ); // get/display time user maybe_unserialize $data = maybe_unserialize( $data ); Please check it with above example code

Restore Old Database Over Newer WP & Plugin Files

Remember that the database contains content. And the wp-options table usually contains all of the settings of themes and plugins (although there might be other tables that a theme/plugin might use). So the database contains content and settings that are used to display the page. The theme options contain the settings for the ‘look’ of … Read more