Empty Array Issue in JSON Request

 Empty Array Issue in JSON Request

The “empty array issue” in JSON requests usually refers to a situation where your server-side code (e.g., in PHP, Python, Node.js, etc.) is receiving an empty array ([]) in the request body when you expect it to contain data. This can happen even if your client-side code (e.g., JavaScript in a browser or mobile app) is correctly sending a populated array.

Here’s a breakdown of common causes and how to fix them:

1. Content-Type Header Mismatch:

• Problem: The server needs to know how to parse the incoming data. If the Content-Type header in the request is incorrect or missing, the server might not recognize the data as JSON and fail to parse the array correctly.
• Solution (Client-Side): Ensure your client-side code sets the Content-Type header to application/json when sending the request.

Issues in Your Code
Wrong Usage of oci_num_rows()
oci_num_rows() does not work with SELECT queries unless it is a scrollable cursor (not default in Oracle).
Use oci_fetch_all($sql, $result, 0, -1, OCI_FETCHSTATEMENT_BY_ROW); instead.
Incorrect SQL Execution Handling
$row = oci_execute($sql) or die(oci_error($sql));
Should be: oci_execute($sql); if (!$sql) { $e = oci_error(); die(json_encode($e)); }
Not Fetching Data Properly
oci_fetch_array($sql) fetches only one row.
If you need multiple rows, use oci_fetch_all().

<?php

$response = array();
$EMPNO = $_REQUEST[‘EMPNO’];

$sql = oci_parse($conn, “SELECT * FROM Tablename WHERE EMPNO= :empno ”);

// Bind parameter to prevent SQL injection
oci_bind_by_name($sql, “:empno”, $EMPNO);

oci_execute($sql);
$data = array();

// Fetch all results into an array
while ($row = oci_fetch_assoc($sql)) {
$data[] = $row;
}

if (!empty($data)) {
$response[“success”] = 1;
$response[“message”] = “Found successfully.”;
$response[“data”] = $data; // Send data array
} else {
$response[“success”] = 0;
$response[“message”] = “Please enter correct Empno.”;
}

echo json_encode($response);
?>

By systematically checking these points, you should be able to identify the cause of the empty array issue and get your JSON requests working correctly. The most common problem is usually server-side JSON parsing, so focus on that area first.