unexpected T_STRING in prestashop

Question

public static function getPressRelease()
{
$res = Db::getInstance()->executeS('
        SELECT az.id_album, az.type, az.description, az.id_custom_pages, as.id_image, as.id_album , as.youtube, cp.custom_page_type, cp.title_custom_page
            FROM `'._DB_PREFIX_.'azgallery_album` AS az
            LEFT JOIN `'._DB_PREFIX_.'azgallery` AS ag
            LEFT JOIN `'._DB_PREFIX_.'custom_pages` AS cp WHERE cp.custom_page_type = 'gallery''); 
            return $res;
}

This line is throwing me error Parse error: syntax error, unexpected T_STRING in process.php on line 121

Mixing the quotes. `"SELECT ..... cp.custom_page_type = 'gallery'"` — Sougata Bose, Jan 12 '16 at 07:29

score 0 · Answer 1 · answered Jan 12 '16 at 07:29

Your last line is using ' for the gallery string and it breaks your whole SQL string. Try the following:

public static function getPressRelease()
{
$res = Db::getInstance()->executeS('
        SELECT az.id_album, az.type, az.description, az.id_custom_pages, as.id_image, as.id_album , as.youtube, cp.custom_page_type, cp.title_custom_page
            FROM `'._DB_PREFIX_.'azgallery_album` AS az
            LEFT JOIN `'._DB_PREFIX_.'azgallery` AS ag
            LEFT JOIN `'._DB_PREFIX_.'custom_pages` AS cp WHERE cp.custom_page_type = "gallery"'); 
            return $res;
}

score 0 · Answer 2 · answered Jan 12 '16 at 07:34

You have twisted single quotes.

Use double quotes for last segment of the query like this:

public static function getPressRelease()
{
$res = Db::getInstance()->executeS('
        SELECT az.id_album, az.type, az.description, az.id_custom_pages, as.id_image, as.id_album , as.youtube, cp.custom_page_type, cp.title_custom_page
            FROM `'._DB_PREFIX_.'azgallery_album` AS az
            LEFT JOIN `'._DB_PREFIX_.'azgallery` AS ag
            LEFT JOIN `'._DB_PREFIX_.'custom_pages` AS cp WHERE cp.custom_page_type = ' . "'gallery'"); 
            return $res;
}

unexpected T_STRING in prestashop

2 Answers2