用参数的joomla mysql查询

Question

I want to bind the id of the content item table and link the menu table. I need to build the query as follows:

protected function getListQuery() 
{

    $url="index.php?option=com_content&view=article&id=";
    // Create a new query object.
    $db = JFactory::getDBO();
    $query = $db->getQuery(true);

    // select the items
    $query->select('ar.id,ar.alias,ar.introtext,ar.images,ar.created,m.link,m.path');

    // of content table and menu table
    $query->from('#__content as ar, #__menu as m');
    $query->where('m.link like '+$url+'ar.id');

    $query->order('ar.id desc');
    return $query;
}

The query returns 0 results. I need to attach the $url parameter and ar.id to generate me find the full url.

What I want you to show me a list of menu items in the table are linked to the parameter. for example:

index.php?option=com_content&view=article&id=70

Thanks!

Answer 1

Try it with Concat

     $query->where("m.link like CONCAT('%','$url',ar.id,'%') ");