Post meta is a data set containing additional core as well as custom post information.
11
votes
3answers
3k views
what is the correct way to compare dates in a WP query_posts meta_query
I have a query_posts call in a WP template. Through the use of the More Fields Plugin I can give the site admin the ability to create an event (custom post type) and then enter a date which is ...
9
votes
4answers
3k views
Post meta vs Seperate database tables
When developing plugins that requires data storage, what's the pros and cons of using one method or another ?
The explication given in the codex is not detailed.
Before jumping in with a whole ...
8
votes
3answers
3k views
Passing error/warning messages from a meta box to “admin_notices”
I have a simple meta box that updates the post custom fields (using update_post_meta()).
How can I send a error or warning message to the next page after the user publishes/updates the post and ...
7
votes
4answers
8k views
How can I show posts only if meta_value is not empty
Three people have already tried to solve this, and we're coming up nil. I want to show only posts that have a value in the meta_key 'featured_image'.
So... if 'featured_image' is not empty, show the ...
7
votes
3answers
7k views
Order by meta value or date?
Got a custom field called startDate but its only on a few events. I was wondering if it isn't set for a post I could use post_date to generate the posts list?
// if meta_key _postmeta.startDate isn't ...
6
votes
4answers
13k views
WP insert post PHP function and Custom Fields
The wordpress function is used for submitting data programatically. Standard fields to submit to incude the content, excerpt, title, date and many more.
What there is no documentation for is how to ...
6
votes
1answer
178 views
Save other metadata on image upload?
I am trying to have Wordpress automatically save the "credit" metadata that is stored within images I am uploading. I know this would be entered as a custom post meta field using update_post_meta().
...
6
votes
1answer
1k views
Best way to programmatically remove a category/term from a post
I am working on a script to convert all posts in a given category to use a postmeta flag instead (testing of MySQL has shown me that on a site as large as mine this will lead to a meaningful decrease ...
5
votes
2answers
158 views
Lack of composite indexes for meta tables
Why wp_commentmeta table does not have a composite index (comment_id, meta_key) by default? I believe it's the only useful index for that table, am I wrong?
Instead, it has a strange set of indexes:
...
5
votes
2answers
300 views
Can the Next/Prev Post links be ordered by menu order or by a meta key?
I have a series of posts that are ordered by a meta_key value. They could also be arranged by menu order, if necessary.
The next/prev post links (generated by next_post_link, previous_post_link, or ...
4
votes
2answers
3k views
How to hook update_post_meta and delete_post_meta?
I'm still struggling to get my head around this whole hooking into things, so I'm really stuck on trying to do the following task:
If update_post_meta is fired then check to see if the meta_key is ...
4
votes
2answers
1k views
post formats - how to switch meta boxes when changing format?
Problem
After realizing that post formats are pretty popular, but only a extremly rough drawn concept, i see that users will run into possible traps.
Post format ...
uses post meta fields & ...
4
votes
1answer
170 views
What is the most secure way to store post meta data in WP?
Sony's recent security "holes" showed how unsafe it can be to store data unencrypted. As some of you may know, I 'm working on re-releasing the free CRM theme Driftwood.
What is the most secure way ...
4
votes
1answer
127 views
What is the advantage of the wp_options design pattern?
As we all know, a design pattern that is used frequently in Wordpress' DB code is the idea of persisting data for a particular object (blog/post/comment), indexed with a particular name or key.
We ...
4
votes
1answer
401 views
Export WordPress Posts and Meta Information in CSV format
I need to export all WordPress Posts and related Meta information using an SQL query. I've managed to export just the Posts but realised that the Meta information is in another table.
Could someone ...
4
votes
1answer
346 views
Update all posts automatically when using post_meta
I recently created a new site using wordpress but I'm a rookie - everything I know is trial and error with no formal training. So please, please, please keep your answers as simple as possible. Thanks ...
4
votes
1answer
94 views
Allow user to create instances of custom field
I have a custom field for a links page which takes a name and an URL and saves it in the post meta. However, I want the user to be able to click "Add new link" and a new custom box appears so they can ...
3
votes
3answers
4k views
Attaching taxonomy data to post with wp_insert_post
I am implementing (trying) a front end posting system which shows taxonomy data in several dropdown select fields, each of the dropdowns is named by using the "name" $arg in wp_dropdown_categories.
...
3
votes
2answers
765 views
How do I paginate search results for custom post types?
I have a Custom Post Type called "cars" that stores several custom fields along with the standard Title/Description fields. I need users to be able to search through the CPT based on the custom fields ...
3
votes
1answer
323 views
How to programmatically create a connection with [Plugin: Posts 2 Posts] on cpt publish?
How can I programmatically create a connection between one custom post type, cpt, (with post id known) to another on cpt on publish?
I am using VoodooPress's front-end posting method to publish a ...
3
votes
1answer
121 views
Adding an assisting editor box to Post page
I run a multiple author platform and to improve the moderation, I want to add a couple of assisting editors. I want to add a custom box to the Post page where the assisting editor can confirm which ...
3
votes
2answers
391 views
Custom Post Type with Input fields to seperate table on database.
At the moment I'm using a custom post type called 'locations' I would like to be able to put input fields into the custom post type that would store the information such as ( address, type, phone ...
3
votes
1answer
53 views
How to use multiple query with same meta key
I use these codes to print custom field query.
My custom field key is out_wiki
<?php if( get_post_meta($post->ID, "out_wiki", true) ): ?>
<div class="outlink">
...
3
votes
2answers
575 views
How to add category to: 'wp-admin/post-new.php'?
I want to have a link to create a new post that sets the category also.
I have tried wp-admin/post-new.php?post_category=12 and wp-admin/post-new.php?cat=12, but neither worked. I also tried using ...
3
votes
1answer
643 views
importing data from non-wordpress mysql db
I have created an import file to get the articles from a non-wordpress db and bring them in as posts in wordpress, I am not sure how to bring over the thumbnail image into my custom field I defined as ...
3
votes
2answers
180 views
Get a single post by a unique meta value
Is there a fast way to retrieve a specific post by a unique meta value? I could run a meta_query and then loop through the first value to get the post's ID, but I am wondering if there is any other ...
3
votes
1answer
126 views
Storing meta fields multiple times OR once with multi dimensional array?
I got some options that I expand using a repeater type field. The values I save for each field is already an array so in essence I'm saving a multi dimentional array per option. (See this weekly ...
3
votes
2answers
298 views
How to use Post Custom Metadata in Post Titles and Post Permalinks
I am very new to WordPress. How can I use post custom metadata in place of Post Titles, and as the Post Permalink? For example, instead of domain.com/the-post-title, the permalink would be ...
3
votes
1answer
371 views
How to enable users to down-vote in this simple voting counter (that uses the post meta)?
This simple tutorial teaches you how to make a voting counter using the post's meta data.
I would like to know how to add down-votes to this small script (e.g. -1, -2).
In the following way: If the ...
2
votes
1answer
545 views
The “_encloseme” Meta-Key Conundrum
While working with metaboxes / custom fields I've seemed to indirectly create many of these _encloseme meta_keys all over my wp_postmeta.
Seen here:
So far no problems have arisen from this and ...
2
votes
1answer
2k views
How to save an array with one metakey in postmeta?
I have an array saved in postmata, each array key become a metakey. I want to change the code to save the whole array with one metakey. How to do that? Thanks!
$poddata = Array(
'pod_id' => ...
2
votes
3answers
3k views
WP_Query, custom sort and custom filter
Is it possible using WP_Query to return a filtered list of items based on the following criteria set? I seem to be struggling as there are numerous queries against custom fields.
Select all posts ...
2
votes
2answers
355 views
Post metadata deletes itself
I'm using a custom post type for a portfolio. I have a few option in there, bring saved by update_post_meta(), it seems to work fine, but then out of the blue (within the hour), the data deletes its ...
2
votes
3answers
26 views
Custom fields: In what order are they saved into the DB?
If I insert multiple custom fields to my article, they get sorted in "I don't know what" way. So when I insert some multiple fields in an article and call those via
$cf = get_post_custom();
foreach ...
2
votes
3answers
100 views
Function to change meta value in database for each post
I have a meta key called 'prijs' in each post. The value of this meta key consist of numbers in the follow structure: 2,100.00
I want to remove the comma in the meta value to get this output: 2100.00
...
2
votes
2answers
51 views
Identifying Importer Posts
Given a site with 100 posts, where an unspecified number of posts are manually written, and the rest are created using the WordPress importer, how would I programmatically identify the posts imported ...
2
votes
2answers
937 views
Properly add an upload media button in a meta box field
i have a custom post which has a meta tag that needs to be using a file upload (for video files). I am wondering, what is the correct way of adding an Upload button that points to the wordpress media ...
2
votes
1answer
272 views
Meta keywords and descriptions plugin for manually editing meta for each page/post
Can anyone recommend a simple plugin that allows me to add/edit meta tags for keywords and description on each page of my wordpress site? Just something that adds the fields to the page editor would ...
2
votes
2answers
2k views
How to delete outdated, wrongly sized images in _wp_attachment_metadata?
I've got several custom image sizes for my blog. One of these is setup as add_image_size( 'slide', 640, 290, true );. These are used in a header slideshow.
My problem is I've upped the dimensions of ...
2
votes
2answers
2k views
Query between two meta values?
How do I limit the query by two custom meta fields, a start date and an end date? This is what my data looks like:
meta_key | meta_value |
------------------------|
start_date | 20100131 | //Jan ...
2
votes
1answer
47 views
unable to save post meta on single field with multiple selects
I set up two select boxes in one meta field by putting two arrays inside the 'options' array of my callback. The HTML is outputting fine, but the meta is not being saved to the database...
Here is a ...
2
votes
2answers
645 views
Can I exclude a post by meta key using pre_get_posts function?
I see many people prefer to use pre_get_posts hook instead of query_posts. The code below works and shows all posts which have meta key "featured"
function featured_posts( $query ) {
if ( ...
2
votes
2answers
213 views
Use custom posts as taxonomy term meta replacement?
Taxonomies are very useful for all sorts of things. But as many have pointed out they suffer from their lack of ability to carry metadata.
Assuming I have only posts that don't have 'natural' parents ...
2
votes
1answer
1k views
delete unused postmeta
I love the comment by s_ha_dum : http://wordpress.org/support/topic/sql-query-to-delete-postmeta and havent tried it yet, but Im wondering just how 'clever' this actually is?
Does the unused postmeta ...
2
votes
3answers
413 views
metabox upload file
I have a custom meta filed with upload file functionality but the problem is I can't get the fileurl button value when hit "insert into Post" below are my jQuery code
window.send_to_editor = ...
2
votes
3answers
538 views
Search everything (posts, pages, tags, cpt, meta)
I would like to know how to use the built in wordpress search to return results from all content on my site. Specifically, I want to search;
posts
pages
tags
custom post type (portfolio)
custom ...
2
votes
1answer
305 views
Metabox Data not being saved [closed]
My meta box won't save data. It's a select form field and when I select and update the post, there's nothing selected on refresh.
So here it is on PasteBin.
http://pastebin.com/tfrgasQC
Can anyone ...
2
votes
1answer
926 views
meta_query: using BETWEEN with floats and/or casting to DECIMAL
Each post has a lat/lng value attached to it via postmeta. I'm trying to grab all posts within a bounding lat/lng value. Here's the get_posts query:
$posts = get_posts(array(
'posts_per_page' ...
2
votes
2answers
623 views
Using date stored as custom field to filter posts displayed in admin
This seems like a fairly common problem, but I'm posting this as I've yet to find a solution to my problem here on WP Answers - any help is HUGELY appreciated!
Ok - so I have a custom post type of ...
2
votes
1answer
178 views
Convert User ID's to User Names in a single.php file
I have a post_meta "thevoters" that store users ids like: 1,2,20 ...etc,
How i can turn this id's to User Names to list them in a single page?
This will echo the numbers as text,
echo ...
