Title: Also compatible with php foreach?
Last modified: May 10, 2019

---

# Also compatible with php foreach?

 *  [Justus](https://wordpress.org/support/users/justusmeijsen/)
 * (@justusmeijsen)
 * [7 years, 1 month ago](https://wordpress.org/support/topic/also-compatible-with-php-foreach/)
 * I use your plugin with custom post types and default post query’s. Works perfect!!!
   Now i need a specific solution to use the plugin for data straight from the database.
   Is there any way to use wp_pagenavi plugin with this foreach loop?
 *     ```
       <?php
       global $wpdb;
       $table_name = $wpdb->prefix . "kv_beoordelingen";
       $beoordelingen = $wpdb->get_results("SELECT * FROM <code>{$table_name}</code>  \n". "ORDER BY <code>{$table_name}</code>.<code>datum</code> DESC LIMIT 40");
   
       if( $beoordelingen ) {
       echo '<div class="reviews"><div class="list">';
       foreach ( $beoordelingen as $beoordeling ) {
   
       //vars
       $id = $beoordeling->id;
       $voornaam = $beoordeling->voornaam;
       $achternaam = $beoordeling->achternaam;
       $woonplaats = $beoordeling->woonplaats;
       $datum = $beoordeling->datum;
       $beschrijving = $beoordeling->beschrijving;
       $redenbezoek = $beoordeling->redenbezoek;
       $aanbeveling = $beoordeling->aanbeveling;
       $service = $beoordeling->service;
       $deskundigheid = $beoordeling->deskundigheid;
       $prijskwaliteit = $beoordeling->prijskwaliteit;
       $gemiddelde = $beoordeling->gemiddelde;
   
   
       echo '<div class="review" id="'. $id. '"><div class="inner">';			
       echo '<div class="header">';						
       	if( $woonplaats ) {
       		echo '<span>'. $voornaam. ' uit '. $woonplaats .'</span> <span class="date">'. date("d-m-Y", $datum) . '</span>';
       	} else {
       		echo '<span>'. $voornaam. '</span><span class="date">'. date("d-m-Y", $datum) . '</span>';
       	}
       echo '</div>';
   
       if( $beschrijving ) {
       	echo "<p><strong>Ervaring</strong><br/> ".$beschrijving." </p>";				
       }
   
       echo '<div class="table"><div class="statistics"><p>';
       echo "<span>Service:</span> ".$service." <br />";
       echo "<span>Deskundigheid:</span> ".$deskundigheid." <br />";
       echo "<span>Prijs/Kwaliteit:</span> ".$prijskwaliteit." <br />";
       echo "<span>Aanbevolen:</span> ".$aanbeveling." <br />";
       echo "</p></div>";
   
       echo '<div class="gemiddelde"><span>'.$gemiddelde.' </span></div>';
   
       echo '</div></div></div>';
       };
   
       echo '</div></div>';
   
       } else {
       echo "Geen beoordelingen beschikbaar";
       }
       ?>
       ```
   
    -  This topic was modified 7 years, 1 month ago by [Justus](https://wordpress.org/support/users/justusmeijsen/).
    -  This topic was modified 7 years, 1 month ago by [Justus](https://wordpress.org/support/users/justusmeijsen/).

The topic ‘Also compatible with php foreach?’ is closed to new replies.

 * ![](https://ps.w.org/wp-pagenavi/assets/icon.svg?rev=977997)
 * [WP-PageNavi](https://wordpress.org/plugins/wp-pagenavi/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-pagenavi/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-pagenavi/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-pagenavi/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-pagenavi/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-pagenavi/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [Justus](https://wordpress.org/support/users/justusmeijsen/)
 * Last activity: [7 years, 1 month ago](https://wordpress.org/support/topic/also-compatible-with-php-foreach/)
 * Status: not resolved