test mysqli libraries

gistfile1.txt

<?php
	//grab the vars needed out of the form post body
	
	//connect to mysql database (so we can run commands)
		// Create connection
		$con=mysqli_connect("127.0.0.1","root","","test");

		// Check connection
		if (mysqli_connect_errno()) {
		  echo "Failed to connect to MySQL: " . mysqli_connect_error();
		}
		
		$result = mysqli_query($con,"SELECT * FROM goals");

		while($row = mysqli_fetch_array($result)) {
		  echo $row['name'] . "-" . $row['id'];
		  echo "<br>";
		}
	
	//insert a new goal into the mysql database

?>