top10apps.php

<?php

	
	//needs to set page title before including header template
	$page_title = 'topapps';
	require_once('templates/header.php');//includes stylesheets etc
	require_once('templates/navigation.php');
	require_once('templates/searchbar.php');

	require_once ('php/dbconnectvars.php');
	require_once ('php/appvariables.php');
	require_once('templates/display.php');

	$dbc=mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$query="SELECT * FROM apps ORDER BY total_downloads DESC limit 10";
	$data=mysqli_query($dbc,$query);


		if (empty($data)) {
			# code...
			echo 'no result found';

			$data;;
		}
		else
		{
			echo '' . mysqli_num_rows($data) . ' Result(s) found';
			while ($row = mysqli_fetch_array($data)) {
				displayApp($row);
				
			}//while
		}


	
	require_once("templates/footer.php");

?>