An attachment is a Post The posts table contains information on the attachment post. In WordPress every uploaded media has it’s own post entry, where post_type is ‘attachment’ and post_status is ‘inherit’. In fact, you can get attachment post types using functions used to get other post types, like post, page or any CPT. That … Read more
In general, storing PHP serialized data in database in a bad idea. It can be easily understood if you use multple key-value pairs of data in one field row, that is, you use an array or a object with one meta key. Imaging a car as the object. You can set multiple meta values to … Read more
Although I would advice you to avoid this and use a plugin for this work. Because only a dedicated plugin can help SEO. “WordPress SEO” from yoost is a great plugin for SEO. That being said, here is the code for adding meta description and keywords in header. Paste this in theme’s functions.php file. function … Read more
You do this: $item->content_multiple = get_post_meta($item->ID, ‘_menu_item_content_multiple’, true); Note how you set the third parameter of get_post_meta() to true, which means that only one value will be returned. If you read the docs, you will see that, if the third parameter is false, you will get an array with all the values for that meta … Read more
This would need a query. So building on your code: <?php $postTitle = $_POST[‘post_title’]; $submit = $_POST[‘submit’]; if(isset($submit)){ global $user_ID, $wpdb; $query = $wpdb->prepare( ‘SELECT ID FROM ‘ . $wpdb->posts . ‘ WHERE post_title = %s AND post_type = \’stuff\”, $postTitle ); $wpdb->query( $query ); if ( $wpdb->num_rows ) { $post_id = $wpdb->get_var( $query ); … Read more
get_the_ID() can (only) be used within the loop. This retrieves the ID of the current post handled by the loop. You can use it on it’s own if you need it only once: $dish_meta = get_post_meta( get_the_ID(), ‘dish_meta’, true ); You can also store it as a variable if you need it more than once: … Read more
Doesn’t look like there’s any way to avoid it. The update_metadata() function, which is ultimately responsible for saving the meta, explicitly runs a stripslashes_deep() on the meta value. This function will even strip slashes from array elements, if the value were an array. Theres a filter that’s run AFTER that called sanitize_meta, which you could … Read more
You don’t need to loop through the values. Just use update_post_meta($post_ID, {key}, {array of vals}), it should do! <?php $poddata = Array( ‘pod_id’ => $this->pod_id, ‘url’ => $this->url, ‘name’ => $this->name, ‘description’ => $this->description, ‘service’ => $this->service, ‘status’ =>$this->status, ‘price’ => $this->price ); //Update inserts a new entry if it doesn’t exist, updates otherwise update_post_meta($post_ID, … Read more
Use unserialize() to convert it into an array. $mydata=”a:5:{s:9:”engine_id”;a:1:{i:0;s:9:”300000225″;}s:15:”transmission_id”;a:1:{i:0;s:6:”257691″;}s:5:”plant”;a:1:{i:0;s:23:”Oshawa, Ontario, Canada”;}s:15:”Manufactured in”;a:1:{i:0;s:6:”CANADA”;}s:22:”Production Seq. Number”;a:1:{i:0;s:6:”151411″;}}”; $mydata = unserialize($mydata); echo $mydata[‘Manufactured in’][0]; Edit– Related thought- something to keep in mind when storing meta data serialized like this is that you limit your ability to use that data in queries, if that’s a concern for you. for instance, … Read more
Object cache everywhere WordPress tries to reduce the number of database queries as much as possible. For example, anytime you get a meta field or a taxonomy field, before querying the database, WordPress looks if that that was already queried and stored in cache, and returns it from there instead of querying the database. The … Read more