The value is serialized, if you retrieve the meta data with the WordPress functions you’ll get that data back unserialized, and you’ll be able to iterate over it(looks like an array). $somevar = get_user_meta( ‘99999’, ‘your-key’, true ); As with options in WordPress, user meta is serialized when it’s an array or object, single values … Read more
Visit /wp-admin/upgrade.php on each site to manually upgrade the database e.g. http://www.example.com/wp-admin/upgrade.php This happens if you have a site on the WordPress network that doesn’t resolve or if you have spoofed DNS locally but not on the server – your computer knows that www.example.com points at 127.0.0.1 but your local server is still resolving www.example.com … Read more
If instead of modifying functions.php you can modify wp-config.php, you can use the following: define(‘WP_HOME’,’http://example.com’); define(‘WP_SITEURL’,’http://example.com’); Source: https://codex.wordpress.org/Changing_The_Site_URL#Edit_wp-config.php
in the export process from your server’s PhpMyAdmin select Custom options, then – be sure to tick under Object Creation Options the next option: Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement than try to re import the DB hope it helped
Should I be creating an interface for my new table? How do I go about that? Unfortunately, there is no interface to implement, you’re going to have to build everything from scratch. This includes: The admin pages The edit screens The saving and updating and deleting All the classes and functions will need building from … Read more
Just to clarify the get_var() method of $wpdb does work just fine in this context: global $wpdb; $helloworld_id = $wpdb->get_var(“SELECT ID FROM wp_posts WHERE post_name=”hello-world””); echo $helloworld_id; Actually it is more practical in this context, because a single variable is returned, which is what is actually wanted.
That table is from the redirection plugin, and isn’t a part of WordPress Core. Deleting it should have no ill effects as long as you disable the plugin too. If you wish to continue using that plugin though, I recommend using the plugin authors support at https://wordpress.org/support/plugin/redirection/
If you look a bit into the source, you’ll see that $wpdb->insert() will use ->query() under the hood. So should be the same, right? Not that simple. It doesn’t just use ->query() but also ->prepare(), which is considered best practice. Meanwhile with your code example you’ve probably just opened yourself to SQL injections. The takeaway … Read more
WordPress MU uses one database and each blog gets his own tables with the blog id in the prefix, so once you install a network installation your database should have these tables: wp_1_categories wp_1_comments wp_1_link2cat wp_1_links wp_1_options wp_1_post2cat wp_1_postmeta wp_1_posts wp_blogs wp_blog_versions wp_registration_log wp_signups wp_site wp_sitecategories wp_sitemeta wp_usermeta wp_users And every new site you set … Read more
Deleting the plugins’ files (as opposed to deleting via deactivate and delete) will not affect settings. The plugin’s deactivation/deletion code (if any, not all have that) might clear out the plugin’s options. But most plugins will keep the options in case you want to reinstall things. So, deleting via FTP, will not affect the plugins’ … Read more