使用实体管理器从表中选择列的最大值的最简单方法是什么 - What is the easiest, simplest way to select the max of a column from a table using Entity Manager?

What is the easiest, simplest way to select the max of a column from a table using Entity Manager?

MySQL

select max(PARAM_DATE) from access_param;

zf2

$em = $this->getEntityManager();
$pp = $em->createQuery("select max(pdate) as date1 from Access'Entity'Param B");
$user2 = $pp->getResult();
$q =$em->createQuery"selectB.pdate,B.userid,B.pdate,B.password,B.uppercase,B.useridspecial,B.number from Access'Entity'Param B where B.pdate='".$user2."' " );
$user1 = $q->getResult();

最后我得到了输出，我认为它对使用实体管理器的初学者很有用

$pp = $em->createQuery("select max(B.pdate) as date1 from Access'Entity'Param B");
$user2 = $pp->getResult();
foreach($user2 as $user2) { 
    $pdate=$user2['date1'];
}
$_POST['pdate']=$pdate; 
$q = $em->createQuery("SELECT 
                   B.pdate, B.userid, B.pdate, B.password, 
                   B.uppercase, B.useridspecial, B.number
                   FROM Access'Entity'Param B
                   WHERE B.pdate='".$_POST['pdate']."'");