How to search record from database in php mysql | Search record PHP mysql | Search PHP record | PHP

if(!empty($_GET['s'])) { $searchname=$_GET['s']; $query="select * from student where name like '%$searchname%'"; } else { $query="select * from student"; } $result=mysqli_query($connect,$query);