Support

Account

Register Login

Forum Replies Created

  • 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.

Viewing 6 posts - 1 through 6 (of 6 total)