WP Database, show array results in table

  • mitchellfr

    (@mitchellfr)


    10 years, 11 months ago

    Hi there!

    I am trying to show some database results on a wordpress page.

    I did some research and have used this code:

    <?php
$table_name = $wpdb->prefix . "scoreboard";
$sql = "SELECT <code>text-51938c6978af6</code> FROM  <code>wp_fm_data_6</code> ";
$pageposts = $wpdb->get_results($sql, ARRAY_N);
print_r($pageposts);
echo $pageposts[0]['team1'];
?>

    On my wordpress page, I get the following result:

    Array ( [0] => Array ( [0] => Testformulier ) [1] => Array ( [0] => hoihallo ) )

    “Testformulier” and “hoihallo” are the values I want to show on my page, but I want only this values in a table or something like that. So basically it have to look fancy and without the array code etc

    I was trying to get the values in a table, and tried some things but I can’t make it work.

    Anybody that could help?

    (Sorry for my bad english)

Viewing 1 replies (of 1 total)
  • ianhaycox

    (@ianhaycox)

    10 years, 11 months ago

    I don’t really understand your SQL query, but maybe it’s a cut-n-paste issue.

    In general to display a table of results use something like this,

    $sql = "SELECT field1,field2,field3 FROM table";
$results = $wpdb->get_results($sql);  // return an object, not ARRAY_N
if ($results) {
  echo '<table>';
  foreach ($results as $row) {
    // Each $row is a row from the query
    echo '<tr>';
    echo '<td>' . $row->field1; . '</td>';
    echo '<td>' . $row->field2; . '</td>';
    echo '<td>' . $row->field3; . '</td>';
    echo '</tr>';
  }
  echo '</table>';
}

    See http://codex.wordpress.org/Class_Reference/wpdb for more info

    Also read about SQL escaping and data validation to prevent SQL injection attacks.

    Ian.

Viewing 1 replies (of 1 total)
  • The topic ‘WP Database, show array results in table’ is closed to new replies.