<?php
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
$dbname = "igscript";
$con = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
$query = "SELECT * FROM lastsearches";
$result = mysqli_query($con, $query);

if(mysqli_connect_errno()) {
	die("Eroare la conexiunea cu baza de date : " . mysqli_connect_error() . " ( " .mysqli_connect_errno() . ")");
}
if(!isset($_POST['username']) || $_POST['username'] == "")
{
	echo '<center><h1> - </h1></center>
		<form action="" method="POST">
			<div class="input-group mb-3">
				<input type="text" name="username" class="form-control" placeholder="Username" aria-label="Username" aria-describedby="basic-addon1">
			</div>
			<input type="submit" value="Cauta" class="btn btn-primary">
			<br><br><small class="text-muted"></small>
			<br><br><center><h5>Last searches:</center></h5>
		</form></div>
		';
		while($row = mysqli_fetch_assoc($result)) {
			//$query ="SELECT * FROM lastsearches Order By data DESC LIMIT 5";
			$query = "SELECT TOP 10 name FROM lastsearches Order By data DESC 1;";
			echo '<center><p>'.$row["name"].'</p> </center><hr>';

			if(!mysqli_query($con, $query))
					{
						die('Error : '.mysqli_error($con));
					}
	}
	$result = mysqli_query($con, $query);
	die('<footer class="footer">
		  <div class="container">
			<span class="text-muted">
				<a href="/"><img src="https://image.flaticon.com/icons/svg/174/174855.svg" width="30px"/> Instagram</a>
				<span style="float: right">Made with <img src="https://image.flaticon.com/icons/svg/148/148836.svg" width="25px"/> by bogdan_mardale.</span>
			</span>
		  </div>
		</footer>');
}