PHP getMapJSON Examples

Example #1

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

function getMapById($senId)
{
    $sql = "SELECT *\r\n                FROM (\r\n                    SELECT *\r\n                    FROM camSeminuevos\r\n                    WHERE SEN_Status = 1\r\n                ) sen\r\n                INNER JOIN (\r\n                    SELECT *\r\n                    FROM camAgencias\r\n                    WHERE AGN_Tipo = 0\r\n                ) agn\r\n                ON sen.SEN_AGN_Id = agn.AGN_Id\r\n                WHERE SEN_Id = :senId";
    getMapJSON($sql, $senId);
}

Example #2

File: index.php Project: hevelmo/compress

function getMapById($senId)
{
    $sql = "SELECT *\r\n                FROM camSeminuevos sen\r\n                INNER JOIN camAgencias agn\r\n                ON sen.SEN_AGN_Id = agn.AGN_Id\r\n                WHERE SEN_Id = :senId\r\n                ";
    getMapJSON($sql, $senId);
}