View difference between Paste ID: itV6ef0a and DjPEaqe1

 <?php
 	$host="localhost";
 	$username="root";
 	$password="";
 	$db_name="park";
 
  	// Create connection to the database
 	$con = mysqli_connect("$host", "$username", "$password", "$database");
 
         // Select database
 	mysql_select_db("$db_name")or die("cannot select DB");
 
 	// Run an sql query to return data from the database
 	$sql = "select title from events";
 
 	$result = mysqli_query($con, $sql);
 	$json = array();
 
  	// Get each row of data from the database
-	if(mysql_num_rows($result))
+	if(mysqli_num_rows($result))
 	{
-    	 	while($row = mysql_fetch_assoc($result))
+    	 	while($row = mysqli_fetch_assoc($result))
     	 	{
        	   		$json['events'][] = $row;
-
+
     		echo json_encode($json);
 	}
 	mysqli_close($con);
-	mysql_close($con);
+