PHP查询整个表，同时有一个搜索框来搜索而无需提交表单

Question

I have a table that is displaying all the data i query from the database, here i want to add a search box ontop of it to help me sort or find the data i want. I Wish not to refresh the page but directly change the data display, Only thing i can think is to use Jquery but i remember you can't change the PHP Query string with javascript. How do i archive this? like using onchange condition of search box,and search data shown on the table.

sql='SELECT * FROM XXX'
$row=mysqli_fetch_array($result);


<form>
    <input type='text' name='Search'/>
</form>      
<table>
    <tr><td><?php echo $row['Name'] ?></td><td><?php echo $row['Job'] ?></td></tr>
    etc.....
</table>

Answer 1

I use DataTables for these kind of things. It does exactly what you are looking for. You might want to check it out, its well documented