Thanks for your reply – of course – having it bundled in ACF would defeat the purpose!
Not a major issue – if I come across a function solution I will post it here.
Nailed it. Thanks.
A mixture of WordPress Class $wpdb (http://codex.wordpress.org/Class_Reference/wpdb) and your functions.
Saved me (for the moment) from having to write a Save to Database function using WordPress. Also means I can keep my Custom Admin Fields all together in ACF, a bit neater that way.
RoyalSlider places its data in a table called wp_new_royalsliders (obviously table prefix will be custom to each developers WordPress tables).
add_filter('acf/load_field/name=media_gallery_slider', 'my_acf_royalslider_choices');
function my_acf_royalslider_choices($field){
$field['choices'] = array();
// Required to make use of the wpdb Class
global $wpdb;
// Query the database
$query = $wpdb->prepare('SELECT * FROM %1$s ORDER BY ID ASC', 'wp_new_royalsliders');
$results = $wpdb->get_results($query);
// Check for $results
if(!empty($results)) :
foreach($results as $result) :
$value = $result->id;
$label = $result->name;
$field['choices'][ $value ] = $label;
endforeach;
endif;
return $field;
}
Well it took me a day of searching, but I hit upon the solution. Hope this helps someone to avoid the same trouble.
<?php
$values = get_field('notes_added');
if($values)
echo'<h1>Notes</h1>';
{
foreach ($values as $value){
echo '<table><tr><td>'.$value['user_meta']['nickname'].'</td><td>'.$value['note_text'].'</td></tr></table>';
}
}
?>
Point taken. I will go and Google how to do some proper debugging. Currently learning WordPress by myself, with very little guidance – and I am not experienced with PHP at all – any chance you can give me a pointer where I’m going wrong in the meantime?
Sorry, I don’t mean to waste other people’s time through laziness, I assure you this is not the case. I’ve spent several hours trying to figure this out already.
Another brave yet misguided attempt – tried to get closer to your example above – am I getting close?
<?php
if( get_field('notes_added') )
{
while( has_sub_field('user_meta') )
{
$values = get_sub_field('user_meta');
$content = get_sub_field('note_text');
echo '<h1>Notes</h1><table>';
foreach($values as $value)
{
echo '<tr><td>' . $value['nickname'] . '</td> <td>'.$content. '</td></tr>';
}
echo '</table>';
}
}
?>
Hi elliot, I am attempting to do the same thing, but the username field is part of a Repeater. So it is an array within an array!
Very new to WordPress (though have been kicking goals the last few days!) – can you give me a possible example I can work from?
Obviously the code below is dodge, but show you what i am trying to do. My repeater is ‘notes_added’, it contains a sub-field ‘user_meta’ which currently spits out an array of all user meta information, like ashley described. It also has a sub-field ‘note_text’ – not an array and requires no filtering. I only want to display the NICKNAME of the user on the page, in a table cell.
<?php
if(get_field('notes_added')): ?>
<h1>Notes</h1>
<table>
<?php while(has_sub_field('notes_added')): ?>
<tr><td><?php the_sub_field('user_meta', 'nickname'); ?></td> <td><?php the_sub_field('note_text'); ?></td></tr>
<?php endwhile; ?>
</table>
<?php endif; ?>
Hope you can help, thanks.
