DEBUG MODE: Checking get_services.php Functionality

PHP Version: 7.4.33

1. Checking Configuration

config.php FOUND

• Host: localhost
• User: laundry
• DB: laundry

2. Testing Database Connection

Database Connection SUCCESS!

3. Checking Table Structure

Table 'tbl_layanan' EXISTS

Columns found: id, id_outlet, id_kategori, nama_layanan, harga_satuan, satuan, keterangan, status, created_at, updated_at

All required columns EXIST.

4. Testing Query Execution

Testing with params: id_kategori=1, id_outlet=1

Query Executed Successfully!

Rows returned: 18

Array
(
    [0] => Array
        (
            [id] => 221
            [id_outlet] => 1
            [id_kategori] => 1
            [nama_layanan] => cuci ampas
            [harga_satuan] => 2000.00
            [satuan] => kg
            [keterangan] => 
            [status] => aktif
        )

    [1] => Array
        (
            [id] => 12
            [id_outlet] => 1
            [id_kategori] => 1
            [nama_layanan] => Cuci Kiloan Premium
            [harga_satuan] => 7000.00
            [satuan] => kg
            [keterangan] => Layanan cuci kiloan dengan perawatan khusus
            [status] => aktif
        )

    [2] => Array
        (
            [id] => 1
            [id_outlet] => 1
            [id_kategori] => 1
            [nama_layanan] => Cuci Kiloan Reguler
            [harga_satuan] => 5000.00
            [satuan] => kg
            [keterangan] => Layanan cuci kiloan reguler
            [status] => aktif
        )

    [3] => Array
        (
            [id] => 11
            [id_outlet] => 1
            [id_kategori] => 1
            [nama_layanan] => Cuci Kiloan Reguler
            [harga_satuan] => 5000.00
            [satuan] => kg
            [keterangan] => Layanan cuci kiloan reguler
            [status] => aktif
        )

    [4] => Array
        (
            [id] => 205
            [id_outlet] => 1
            [id_kategori] => 1
            [nama_layanan] => cuci lipat
            [harga_satuan] => 5000.00
            [satuan] => kg
            [keterangan] => 
            [status] => aktif
        )

    [5] => Array
        (
            [id] => 207
            [id_outlet] => 1
            [id_kategori] => 1
            [nama_layanan] => cuci lipat express 4 jam
            [harga_satuan] => 12000.00
            [satuan] => kg
            [keterangan] => 
            [status] => aktif
        )

    [6] => Array
        (
            [id] => 204
            [id_outlet] => 1
            [id_kategori] => 1
            [nama_layanan] => cuci setrika
            [harga_satuan] => 6000.00
            [satuan] => kg
            [keterangan] => 
            [status] => aktif
        )

    [7] => Array
        (
            [id] => 775
            [id_outlet] => 1
            [id_kategori] => 1
            [nama_layanan] => EXPRESS strika
            [harga_satuan] => 10000.00
            [satuan] => kg
            [keterangan] => 
            [status] => aktif
        )

    [8] => Array
        (
            [id] => 456
            [id_outlet] => 1
            [id_kategori] => 1
            [nama_layanan] => Gorden
            [harga_satuan] => 17000.00
            [satuan] => kg
            [keterangan] => 
            [status] => aktif
        )

    [9] => Array
        (
            [id] => 246
            [id_outlet] => 1
            [id_kategori] => 1
            [nama_layanan] => Gorden
            [harga_satuan] => 15000.00
            [satuan] => kg
            [keterangan] => 
            [status] => aktif
        )

    [10] => Array
        (
            [id] => 617
            [id_outlet] => 1
            [id_kategori] => 1
            [nama_layanan] => Horden
            [harga_satuan] => 17000.00
            [satuan] => kg
            [keterangan] => 
            [status] => aktif
        )

    [11] => Array
        (
            [id] => 3
            [id_outlet] => 1
            [id_kategori] => 1
            [nama_layanan] => Setrika Kiloan
            [harga_satuan] => 3000.00
            [satuan] => kg
            [keterangan] => Layanan setrika kiloan
            [status] => aktif
        )

    [12] => Array
        (
            [id] => 13
            [id_outlet] => 1
            [id_kategori] => 1
            [nama_layanan] => Setrika Kiloan
            [harga_satuan] => 3000.00
            [satuan] => kg
            [keterangan] => Layanan setrika kiloan
            [status] => aktif
        )

    [13] => Array
        (
            [id] => 286
            [id_outlet] => 1
            [id_kategori] => 1
            [nama_layanan] => Setrika Saja
            [harga_satuan] => 5000.00
            [satuan] => kg
            [keterangan] => 
            [status] => aktif
        )

    [14] => Array
        (
            [id] => 562
            [id_outlet] => 1
            [id_kategori] => 1
            [nama_layanan] => Strika horden
            [harga_satuan] => 10000.00
            [satuan] => kg
            [keterangan] => 
            [status] => aktif
        )

    [15] => Array
        (
            [id] => 563
            [id_outlet] => 1
            [id_kategori] => 1
            [nama_layanan] => Strika horden
            [harga_satuan] => 15000.00
            [satuan] => kg
            [keterangan] => 
            [status] => aktif
        )

    [16] => Array
        (
            [id] => 564
            [id_outlet] => 1
            [id_kategori] => 1
            [nama_layanan] => Strika Horden
            [harga_satuan] => 10000.00
            [satuan] => kg
            [keterangan] => 
            [status] => aktif
        )

    [17] => Array
        (
            [id] => 62
            [id_outlet] => 1
            [id_kategori] => 1
            [nama_layanan] => ttt
            [harga_satuan] => 20.00
            [satuan] => kg
            [keterangan] => 
            [status] => aktif
        )

)

Selesai. Jika Anda melihat error merah di atas, itulah penyebab HTTP 500.