API Endpoints Test

1. Database Tables Check

✗ Error checking table 'brands': SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?' at line 1

✗ Error checking table 'modules': SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?' at line 1

✗ Error checking table 'vendors': SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?' at line 1

2. Brands API Test

✓ Brands query successful

Found 5 brands (showing first 5):

JSON Response Format:

{
    "success": true,
    "brands": [
        {
            "id": "7",
            "brand_name": "Iq",
            "created_at": "2025-11-07 06:28:13"
        },
        {
            "id": "1",
            "brand_name": "Oppo",
            "created_at": "2025-11-07 02:40:31"
        },
        {
            "id": "5",
            "brand_name": "Realme",
            "created_at": "2025-11-07 02:41:09"
        },
        {
            "id": "8",
            "brand_name": "REALME C55",
            "created_at": "2025-11-19 08:21:38"
        },
        {
            "id": "3",
            "brand_name": "Samsung",
            "created_at": "2025-11-07 02:40:49"
        }
    ],
    "message": "Brands retrieved successfully"
}

3. Modules API Test

✓ Modules query successful

Found 5 modules (showing first 5):

JSON Response Format:

{
    "success": true,
    "modules": [
        {
            "id": "49",
            "brand_id": "7",
            "module_name": "Z10lite",
            "brand_name": "Iq",
            "created_at": "2025-11-07 06:28:46"
        },
        {
            "id": "28",
            "brand_id": "1",
            "module_name": "A3 5G",
            "brand_name": "Oppo",
            "created_at": "2025-11-07 02:57:27"
        },
        {
            "id": "31",
            "brand_id": "1",
            "module_name": "A3 Pro 5G",
            "brand_name": "Oppo",
            "created_at": "2025-11-07 02:58:27"
        },
        {
            "id": "23",
            "brand_id": "1",
            "module_name": "A3X 4G",
            "brand_name": "Oppo",
            "created_at": "2025-11-07 02:56:18"
        },
        {
            "id": "24",
            "brand_id": "1",
            "module_name": "A3X 5G",
            "brand_name": "Oppo",
            "created_at": "2025-11-07 02:56:33"
        }
    ],
    "message": "Modules retrieved successfully"
}

4. Vendors API Test

✓ Vendors query successful

Found 3 vendors (showing first 5):

JSON Response Format:

{
    "success": true,
    "vendors": [
        {
            "id": "3",
            "vendor_name": "B M COMMUNICATION",
            "gst_number": "19AIFPR0663M1ZR",
            "phone": "9126200008",
            "email": "bcommunication123@gmail.com",
            "address": "KANDI RADHABAZAR",
            "created_at": "2025-11-07 07:08:43",
            "updated_at": "2025-11-07 07:08:43"
        },
        {
            "id": "1",
            "vendor_name": "MANISA TELECOM AGENCY",
            "gst_number": "19CPCPP3783C1ZQ",
            "phone": "8972874819",
            "email": "totanpal.49@gmail.com",
            "address": "Andi , School Para, Andi School, Murshidabad",
            "created_at": "2025-11-07 06:45:17",
            "updated_at": "2025-11-07 06:45:17"
        },
        {
            "id": "2",
            "vendor_name": "RHODIUM ELECTRONICS LLP",
            "gst_number": "19AAWFR7770E1ZF",
            "phone": "8777632422",
            "email": "rhodiumbengal@gmail.com",
            "address": "BERHAMPUR",
            "created_at": "2025-11-07 06:57:08",
            "updated_at": "2025-11-07 06:57:08"
        }
    ]
}

5. API Endpoint URLs

Test these URLs in your browser or Postman:


Test completed at 2025-12-08 19:43:56