Php скрипт возврашает из бд таблицы id = null
Php скрипт обращается к таблице в БД и возвращает все данные, вот что возвращает скрипт, ниже таблица
{"products":[{"id":null,"name":"reg","description":"dfghf","netWeight":"245","grossWeight":"2242","purchasePrice":"2452"}
$response = array();
$result = $database->query("SELECT * FROM Products");
if ($result != null) {
$response["products"] = array();
while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
$product = array();
$product["id"] = $row["Id"];
$product["name"] = $row["Name"];
$product["description"] = $row["Description"];
$product["netWeight"] = $row["NetWeight"];
$product["grossWeight"] = $row["GrossWeight"];
$product["purchasePrice"] = $row["PurchasePrice"];
array_push($response["products"], $product);
}
$response["success"] = 1;
$response["message"] = "Products found";
echo json_encode($response);
}
Источник: Stack Overflow на русском