Postingan lainnya
Cara menampilkan 2 data pada se
<?php
$dbHost = 'localhost';
$dbUsername = 'root';
$dbPassword = '';
$dbName = 'sppd';
//connect with the database
$db = new mysqli($dbHost,$dbUsername,$dbPassword,$dbName);
//get search term
$searchTerm = $_GET['term'];
//get matched data from skills table
$query = $db->query("SELECT NIP,Nama FROM pegawai WHERE Nama
LIKE '%".$searchTerm."%' OR NIP LIKE '%".$searchTerm."%' ORDER BY NIP ASC");
while ($row = $query->fetch_assoc()) {
$data[] = $row['NIP','Nama']; //kalau di running ini ga fungsi tapi kalau di hapus namanya jalan, saya juga tau ini salah, kasih tau dong yang benernya :D
}
//return json data
$var = json_encode($data);
echo $var;
?>
0
2 Jawaban:
Jawaban Terpilih
di bagian sini di return datanya
<pre><?php while ($row = $query->fetch_assoc()) { $data[] = $row['NIP','Nama']; } //jadi kayak gini while ($row = $query->fetch_assoc()) { $data[] = $row; ?> }return $data; </pre> semoga berhasil
0