search.php

<?php

    ini_set('display_errors', '0'); //to stop showing unnecessary warnings and errors

    $servername="127.0.0.1";
    $database="axel";
    $username="root";
    $password="";

    $conn=mysqli_connect($servername,$username,$password,$database);

    if(!$conn)
    {
        die("Connection error: " . mysql_connect_errno());
        header('location:error.php');
    }

    if(isset($_POST["query"]))
    {
        $output = '';
        $searchtext = mysqli_escape_string($conn,$_POST["query"]);
        $query = "SELECT * FROM users WHERE Name LIKE '%$searchtext%'";
        $result = mysqli_query($conn, $query);
        if(mysqli_num_rows($result) > 0)
        {
            while($row = mysqli_fetch_array($result))
            {
                $userid = $row["userID"];
                $username = $row["Name"];
                $output .= '<div class="searchlistitem" onclick= "selectuser(\''.$userid.'\')">'; 
                $output .= '<img class="sDP" src= "'.$row["DP"] . '" alt="avatar.png">';
                /*$output .= '<img class="DP" src= "'."avatar.png". '" alt="defaultimgholder.png">';*/
                $output .= '<span class="profile"><div class = "uname">' .$username.'</div>';
                $output .= '<div class="utype">' .$row["userType"].'</div></span></div>';

            }
        }
        else
        {
            $output .= '<div style="color:black;margin:15px 0px">No results found!</div>';
        }
        echo $output;
        }  
?>