zf2-subquery-1

zf2-subquery-1.php

<?php
            

$text = '*'.$text.'*';

// subquery
$sql = new Sql($this->dbAdapter);
$mainSelect = $sql->select()->from('searchs');
$subQry = $sql->select()
        ->from('searchs')
        ->columns(array('relevance' => new \Zend\Db\Sql\Expression(
            "MATCH (name,services_profile,username_user) AGAINST (? IN BOOLEAN MODE)", $text)));            
 //echo $sql->getSqlstringForSqlObject($subQry); die ;  
 
 
$mainSelect->columns(
    array(
        'name',
        'services_profile',
        'username_user',
        'relevancia' => new \Zend\Db\Sql\Expression('?', array($subQry)),
    )
)->where("MATCH (name, services_profile, username_user) AGAINST ( '$text' IN BOOLEAN MODE) ")
->limit(5);

$statement = $sql->prepareStatementForSqlObject($mainSelect);
$data = $statement->execute();
$resultSet = new ResultSet();
$resultSet->initialize($data);

$flag = $resultSet->toArray();