When you choose to import them into the new/merged website, you’ll have the option to import the author, or to assign a new one to the imported posts. You could assign different authors to each import and use that to separate the content. Do both use the same categories? If they don’t it should be … Read more
There isn’t an RSS of the names of the categories specifically otherwise I would have used the XML from the RSS feed with XSLT to display the category list that way. There is a handy function named add_feed(). You can create any feed or other output with it. Should be useful in your case. And … Read more
Querying in WordPress is done by using the the wpdb variable. Be sure to always prepare your sql so WP can make it database safe. Example: global $wpdb; $rows = $wpdb->get_results( $wpdb->prepare( “SELECT * FROM `{$wpdb->prefix}TABLE_NAME` WHERE `var` = %d”, 1) ); Then you can loop through the data and output it as for example … Read more
First of all i wouldn’t use phpmyadmin for a database that large. Use something like Sequel Pro its free and easy to use. Second if you dont want the tables that WPML Created and you have removed the plugin from your site you can remove the tables that it creates. Upload the sql to a … Read more
The WordPress APIs rely on the global $wpdb object, you can define any arbitrary object of type wpdb but that doesn’t mean WordPress will use it. Instead, something akin to the following might be better: global $wpdb; $tempDB = $wpdb; $wpdb = new wpdb(DB_USER2, DB_PASSWORD2, DB_NAME2, DB_HOST2); // do your remote SQL stuff // perhaps … Read more
Neither. Theme options should be stored as theme mods, using get_theme_mod and set_theme_mod. Internally these map on to options, but it is the official way to store theme specific options, that way when you change themes you don’t get clashes, and your settings are preserved for if you ever change back. It’s the classic adage … Read more
The WordPress wpdb class is a little different than the normal way of querying in that you run “vanilla” database queries. You can see documentation on the wpdb class on the WordPress docs: http://codex.wordpress.org/Class_Reference/wpdb#Run_Any_Query_on_the_Database Also, in regard to your code, you should be able to change the line here: $originaldb->query_posts( ‘posts_per_page=1’ ); To something like … Read more
There are multiple storage mechanisms in WP so it can be bit tricky to pick one and sometimes there is no single right choice. Let’s examine your criteria for storage: persistent (you don’t want data just evaporating) processable (you want to export it and probably navigate) simple to implement (you don’t want go building something … Read more
I would use an AJAX request to a PHP script that does the lookup, which might look something like this on the jQuery side after document ready: // jquery $(‘#email-input’).live(‘change’, function() { //ajax request $.ajax({ url: “email_check.php”, data: { ’email’ : $(‘#email-input’).val() }, dataType: ‘json’, success: function(data) { if(data.result) { alert(‘Email exists!’); } else { … Read more
I’ve found that I need to change the siteurl and home entries in wp_options when I move from local to a live server. Not sure that should affect a connection to the database though.