I'm very new to WordPress; I was wondering if someone would be able to let me know how I can add one of my database tables in a table format in one of my pages in WordPress; I did a research and I found this: http://www.youtube.com/watch?v=hb3lfwq1bfM but I don't know whether "wpData Tables" is a plugin that I need to install or...? I don't have that option in my wordpress!
If you need more clarification please let me know.
If someone can show me the right direction, I appreciate it :)
Thanks
In your page.php add this code within the loop at required area.
Replace values of $my_page_id, $table_name and add columns as per your requirement.
<?php
$my_page_id = 111; // page ID here
if( get_the_ID() === $my_page_id) {
global $wpdb;
$table_name = 'your_table_name_here';
$myrows = $wpdb->get_results( "SELECT column_1, column_2, column_3 FROM ". $table_name); // add columns as you want
?>
<table>
<thead>
<tr>
<th>Column 1</th>
<th>Column 2</th>
<th>Column 3</th>
</tr>
</thead>
<tbody>
<?php foreach ( $myrows as $myrow ) { ?>
<tr>
<td><?php echo $myrow->column_1; ?></td>
<td><?php echo $myrow->column_2; ?></td>
<td><?php echo $myrow->column_3; ?></td>
</tr>
<?php } ?>
</tbody>
</table>
<?php
}
/wp-content/themes/{theme-name}/page.php at your web server. Here is how you can find out where is page ID: wpbeginner.com/beginners-guide/…. I hope you know the database table name and column names that you want to retrieve :)