Fatal error: Uncaught ArgumentCountError: mysqli_query() expects at least 2 arguments, 1 given in on line 19
Stuck on this error help please!
<?php
$servername = "localhost";
$username = "root";
$password = "";
// Create connection
$conn = mysqli_connect($servername, $username, $password);
$alfabet = array('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z',);
for($teller = 0; $teller < count($alfabet); $teller++){
//Nu laten we mysql tellen hoeveel namen er voorkomen in de database met de mysql-functie COUNT(
$query = "SELECT COUNT(row1) AS aantal FROM table WHERE row1 LIKE '" . $alfabet[$teller] . "%'";
$query_result = mysqli_query($query);
//haal de waarden op!
$row = mysqli_fetch_assoc()($query_result);
//nu printen we een link als de waarde groter is als 0
if($row["aantal"] > 0 ){
echo "<a href='" . $_SERVER["PHP_SELF"] . "?letter=" . $alfabet[$teller] . "'>" . $alfabet[$teller] . "</a>";
} else {
//alleen de letter
echo $alfabet[$teller]; }
}
mysqli_free_result($result);
//Close the MySQL Link
mysqli_close($link);
?>