Don’t use SQL to retrieve values from the option table, use the options API. In addition to avoiding using wrong table names (as was pointed out in the comments) you will most likely get better performance.
You’re recreating the select element on every iteration through the loop, and you need to name your current loop assignment variable differently, as you’re overwriting your original. Lastly, you’re also not assigning a value to the options within the loop, so you’re not going to get anything on the form submission, and text isn’t a … Read more
WordPress Multisite has been designed to handle this kind of situation. That would be ideal choice as both the sites use the same domain. Checkout Multisite table overview. For multisite, the following tables are global to all sites meaning there will be only one table which will be shared among all sites. wp_blogs wp_blog_versions wp_registration_log … Read more
WP uses the GUID column of posts for links. You need to replace that, I use a script http://interconnectit.com/products/search-and-replace-for-wordpress-databases/ Just drop it in your root dir then follow the instructions. Hope this helps!
I think you are missing the relation key here. If you want the users to be picked up when both the above meta values are matched, then you should use this as below $users_sent_to_admin = new WP_User_Query( array( ‘meta_query’ => array( ‘relation’ => ‘AND’, array( ‘key’ => ‘pending_approval’, ‘value’ => ‘true’, ‘compare’ => ‘=’), array( … Read more
Use a new instance of wpdb to connect and read from the other database: $mydb = new wpdb(‘blah’,’blah’,’dkpldump’,’localhost’); $event_categories = $mydb->get_results(“SELECT * FROM calendar_cats”); foreach( $event_categories as $event_category ){ //create term! $term = wp_insert_term( $event_category->categoryId, ‘event_category’, array( ‘slug’ => $event_category->categoryName ) ); }
Here is what you need. <?php $date = new DateTime(‘NOW’); $date->sub(new DateInterval(‘P30D’)); //30 Days Interval echo $back30days= $date->format(‘Y-m-d H:i:s’) . “\n”; global $wpdp; $top_users = $wpdb->get_results(“select count(users.user_nicename) as posts, users.user_nicename as user_name from $wpdb->users as users join $wpdb->posts as posts where users.ID = posts.post_author AND posts.post_status=”publish” AND posts.post_date_gmt > ‘$back30days’ GROUP BY users.user_nicename ORDER BY … Read more
It’s not difficult. You need to transfer files to the new server. Create a blank database and keep it’s name, user_name (this user must have all privileges of this newly created database) and password. Edit config.php file on new server with the these new details. Read: WordPress Codex for transferring site
It wasn’t working because at public status draft/publish were written without a capitol so it has to be ‘post_status’ => ‘Draft’ or ‘post_status’ => ‘Publish’
Yes 90-100ms round trip + time to prepare SQL statement + time to execute statement + time to send results back multiplied by the number of times you need to query the database. Sure the connection may stay open but it’s an inherently expensive thing to do. Considering that some setups can respond in full … Read more