<?php

// konfigurasi
$user = "root";
$pass = "";
$host = "localhost";
$db = "neardeal";

// connect ke database
$mysqli = new mysqli($host, $user, $pass, $db);

// cek koneksi
if(!$mysqli) {
    die("Gagal koneksi ke database");
}

// mulai query
$sql = "SELECT * FROM store";
$result = $mysqli->query($sql);

// definiskan array data
$data = array();

// iterasi tiap baris
while($row = $result->fetch_assoc()) {
    // append row ke array data
    $data[] = $row;
}

$response = array(
    'success' => true,
    'store' => $data
);

echo json_encode($response);