<?php
    include("common.php");

    #select all columns from the todos table
    $rows = $db->query("SELECT id, name, img, description FROM products;");
    
    header("Content-Type: application/json");
    $output = array();
    $output["products"] = array();
    
    foreach($rows as $row){
        $product_array = array();
        $product_array["id"] = $row["id"];
        $product_array["name"] = $row["name"];
        $product_array["img"] = $row["img"];
        $product_array["description"] = $row["description"];
        
        $output["products"] []= $product_array;
    }
    
    print(json_encode($output));
?>