If you’re wanting to display post specific to the site they were created on, and not on the others, WordPress MU does this out of the box. There are multiple tables in the same database setup for each site’s posts. They all share the same user table, but data for each site is logically separated … Read more
Yes, but unless you have total understanding of your system and it is going to be frozen at that state, this can be dangerous. Can you be sure that you know all the places in the DB where the post is referenced? There is the post table, the metadata table, taxonomies, and plugins. If you … Read more
Why the downvotes for using user meta? That’s how I do it, I store all the extra profile stuff in wp_usermeta table by utilizing update_user_meta. <?php // first validate all $_POST data $validated = $this->validate_and_sanitize(); $username = $validated[‘uname’]; $password = $validated[‘pass’]; $email = $validated[’email’]; $new_user_id = wp_create_user($username, $password, $email); if ( is_wp_error($new_user_id) && array_key_exists(‘existing_user_login’, $new_user_id->errors)) … Read more
I think you’re going about it the wrong way. You can use get_posts to get the attachments of the current post: $args = array( ‘post_type’ => ‘attachment’, ‘numberposts’ => -1, ‘post_status’ =>’any’, ‘post_parent’ => $post->ID ); $attachments = get_posts($args); if ($attachments) { foreach ( $attachments as $attachment ) { echo apply_filters( ‘the_title’ , $attachment->post_title ); … Read more
You can store multiple pieces of data within a single field by passing an array rather than a string: $user_data = array( ‘favorite_color’ => ‘blue’, ‘favorite_animal’ => ‘cat’, ‘favorite_city’ => ‘paris’ ); update_user_meta( $user_id, ‘user_data’, $user_data ); WordPress will serialize this data for you on save, and unserialize back into an array when it is … Read more
It’s almost always superior to use the standard WP tables. All WP functionality and plugins ‘know’ about those tables, and have access to them. They are completely oblivious to custom-built tables.
You could simply try using this plugin. If you want to custom-code it, that plugin would be a good place to start and look at how they’re doing it…
How to add drop down sub menu from database fields in the particular menu slug
http://yoast.com/custom-wordpress-database-error-pages/ You can make your own Database Error page by adding a db-error.php to your wp-content folder (/wp-content/db-error.php). You can find a good example of such a page in the link above. Don’t forget adding header(“HTTP/1.0 500 Internal Server Error”); in that file so it get a proper header message.
MySQL Engine vs. Charset