我创建的数据库的结果不会出现在wordpress中。

Question

Example of code where I can make a table's properties show on page.

if (current_user_can('administrator'))
    {
      global $wpdb;
      $result = $wpdb->get_results ( "   SELECT * 
                                      FROM  $wpdb->posts
                                      WHERE post_type = 'product'
                                     " );

   foreach ( $result as $row )
    {

   echo $row->ID.'<br/>';
   echo $row->post_title.'<br/>';
}

Then I put data into the table and I get nothing, not ever error messages.

Does anyone have an idea why this happens ? And how can I make any table's results appear in my page? Thank you

Answer 1

Let me know if it helps

1. Enable debug in wp-config using define( 'WP_DEBUG', true );
2. Print sql query using $wpdb->show_errors(); and add query you get directly in phpmyadmin and check if it works.
3. Also add $wpdb->prefix_{table_name_here}, before table name.