Server : LiteSpeed System : Linux barito.iixcp.rumahweb.net 5.14.0-611.49.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Apr 21 16:39:08 EDT 2026 x86_64 User : elvh3918 ( 1528) PHP Version : 8.2.31 Disable Function : mail Directory :  /home/elvh3918/public_html/api-flutter-crud/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
// view_data.php

// tampilkan error sementara untuk debug di browser
ini_set('display_errors', '1');
ini_set('display_startup_errors', '1');
error_reporting(E_ALL);

header('Content-Type: application/json');

require_once "dbconnection.php";  // gunakan require_once agar aman

$con = dbconnection();

// query data user
$query = "SELECT * FROM user_table";
$exe = mysqli_query($con, $query);

// cek query error
if (!$exe) {
    http_response_code(500);
    echo json_encode(["error" => "Query gagal: " . mysqli_error($con)]);
    exit;
}

$arr = [];
while ($row = mysqli_fetch_assoc($exe)) {
    $arr[] = $row;  // fetch associative array saja, lebih bersih untuk JSON
}

// kembalikan data JSON
echo json_encode($arr);