filter rekod

<?php

// Database configuration
$dbHost     = 'localhost';
$dbUsername = '';
$dbPassword = '';
$dbName     = '';

// Connect with the database
$db = new mysqli($dbHost, $dbUsername, $dbPassword, $dbName);

// Get search term
$searchTerm = $_GET['term'];

// Get matched data from nama table
// status pelajar aktif = 1
$query = $db->query("SELECT * FROM tahun1 WHERE nama LIKE '%".$searchTerm."%' AND status = '1' ORDER BY nama ASC");

// Generate nama data array
$namaData = array();
if($query->num_rows > 0){
    while($row = $query->fetch_assoc()){
        $data['id'] = $row['nama'];
        $data['value'] = $row['nama'];
        array_push($namaData, $data);
    }
}

// Return results as json encoded array
echo json_encode($namaData);

?>