PHP getCategoryJSON Examples

Example #1

File: index.php Project: hevelmo/suzuki-lm-seminuevos

function getCategory()
{
    $sql = "SELECT *\r\n                FROM v_camSeminuevos\r\n                WHERE SEN_AGN_Id = 7\r\n                GROUP BY CAT_Id\r\n                ORDER BY CAT_Nombre ASC";
    getCategoryJSON($sql, '');
}

Example #2

File: index.php Project: hevelmo/compress

function getCategory()
{
    $sql = "SELECT *\n                    FROM v_camSeminuevos\n                    GROUP BY CAT_Id\n                    ORDER BY CAT_Nombre ASC";
    getCategoryJSON($sql, '');
}

Example #3

File: index.php Project: hevelmo/compress

function getCategory()
{
    $sql = "SELECT *\r\n                FROM camCategorias cat\r\n                ";
    getCategoryJSON($sql, '');
}

Example #4

File: index.php Project: hevelmo/compress

function getCategoryById($catId)
{
    $sql = "SELECT * FROM camSeminuevos sen\r\n                    INNER JOIN camAgencias agn\r\n                    ON sen.SEN_AGN_Id = agn.AGN_Id\r\n                    INNER JOIN camCategorias cat\r\n                    ON sen.SEN_CAT_Id = cat.CAT_Id\r\n                    INNER JOIN camModelos mdo\r\n                    ON sen.SEN_MDO_Id = mdo.MDO_Id\r\n                    INNER JOIN camMarcas mrc\r\n                    ON sen.SEN_MAR_Id = mrc.MAR_Id\r\n                    INNER JOIN camThumb thm\r\n                    ON sen.SEN_THM_Id = thm.THM_Id\r\n                    WHERE SEN_CAT_Id = :catId\r\n                    ORDER BY CAT_Id";
    getCategoryJSON($sql, $catId, '');
}