Untitled

<?php

/* Setting Database Details */

$host = 'localhost';
$username = '******';
$password = '******';
$dbname = '*********';
$tbl = 'anime';

/* Setting SQL Argument */

$sql = 'SELECT * FROM ' .$tbl;
$conn = new mysqli($host, $username, $password, $dbname);
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}

$result = $conn->query($sql);

?>


<html>
<head>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<link href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/select2.min.css" rel="stylesheet" />
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/js/select2.min.js"></script>

</head>
<body>
<form action="search.php" method="POST" class="search-bar">
        <select class="search" name="search">
        <?php
            while ($row = $result->fetch_assoc()) {
              echo '<option value="'.$row['a_title'].'" onclick="location.href=\''.$row['a_url'].'\'">'.$row['a_title'].'</option>';
            }
            if($result->num_rows == 0) { echo '<option value="blank">Nothing in the database or the database details are wrong</option>'; }
?>

</select>
<button class="search-btn" type="submit" name="submit-search">
		<span>Search</span>
	</button>
	<script>
$(document).ready(function() {
    $('.search').select2();
});
</script>
</form>
</body>
</html>