Live search from database table

So in php it needs to be:

$query = 'SELECT Location FROM locations';
$result = mysqli_query($link, $query);
$rows = array();
while($r = mysqli_fetch_assoc($result)) {
 $rows[] = $r['Location'];
 }

and jquery ui autocomplete:

$("#location1").autocomplete({
            source: <?php echo json_encode($rows);?>,
// this part is only if you want to force autocomplete select
change: function (event, ui) {
    if(!ui.item){
        $(event.target).val("");
    }
}, 
focus: function (event, ui) {
    return false;
} //end autocomplete force
        });