mysqli example.php

<?php
//creates db object
$db = new mysqli('localhost', 'user', 'pass', 'demo');

if($db->connect_errno > 0){
    die('Unable to connect to database');
}

//set up query
$query = 'SELECT *
    FROM posts';
//run it and confirm there are results to show
if($result = $db->query($query)):
   echo 'Total results: ' . $result->num_rows . '<br />';
//echo 'Total rows updated: ' . $db->affected_rows;
	while($row = $result->fetch_assoc()):

		?>
	<p>
	    <?php echo $row['body'] ;?>
	</p>
		<?php 
	endwhile;
	$result->free();
else:
 	die('There was an error running the query [' . $db->error . ']');
endif;

$db->close();
?>