Wordpress page template for creating a simple listing of my database contents. Note that I have redacted my login info.

database_list.php

<?php
/**
 * Template Name: Custom database tables
 * @package WordPress
 * @subpackage Coraline
 * @since Coraline 1.0
 */

coraline_set_full_content_width();
get_header(); ?>

		<div id="content-container" class="full-width">
			<div id="content" role="main">

			<?php if ( have_posts() ) while ( have_posts() ) : the_post(); ?>

				<div id="post-<?php the_ID(); ?>" <?php post_class(); ?>>
					<h1 class="entry-title"><?php the_title(); ?></h1>
					<div class="entry-content">
						<?php the_content(); ?>


<?php
// The connection into my database and the code for creating the listing of all items.
$conn = new mysqli('[redacted]', '[redacted]', '[redacted]', '[redacted]');

// check connection
if (mysqli_connect_errno()) {
  exit('Connect failed: '. mysqli_connect_error());
} 

/*open connection*/

/* Select the fields */
$sql = "SELECT case_no, claim_total, final_total FROM claim";

/* Perform the query */
$result = $conn->query($sql);

/* Display */
if ($result->num_rows > 0) {
  /* output data of each row from $result */
  while($row = $result->fetch_assoc()) {
    echo '<br /> <b>Case number:</b> ', $row['case_no'], '<br /> <b>Claim Total:</b> $', $row['claim_total'], '<br />  <b>Total Verdict:</b> $', $row['final_total'], '<br />';
  }
}
else {
  echo '0 results';
}




$conn->close();         // close the connection

?>

						<?php wp_link_pages( array( 'before' => '<div class="page-link">' . __( 'Pages:', 'coraline' ), 'after' => '</div>' ) ); ?>
						<?php edit_post_link( __( 'Edit', 'coraline' ), '<span class="edit-link">', '</span>' ); ?>
					</div><!-- .entry-content -->
				</div><!-- #post-## -->

				<?php if ( comments_open() ) comments_template( '', true ); ?>

			<?php endwhile; ?>

			</div><!-- #content -->
		</div><!-- #content-container -->

<?php get_footer(); ?>