手动编写DQL

对于你的sql buff,我们没有忘记你.您可以选择手动编写DQL查询并将其解析为Doctrine_Query实例或只执行它们.

$dql = "FROM User u,u.Phonenumbers p";
$q = Doctrine_Query::create()->parseQuery($dql);

或者您可以使用Doctrine_Query的query()方法执行它们.

$dql = "FROM User u,u.Phonenumbers p";
$q = Doctrine_Query::create()->query($dql);

然而,由于遇到以下错误,我遇到了困难：

你能帮帮我吗？

<?PHP

namespace AppBundle\Controller;

use Symfony\Component\HttpFoundation\Response;
use Symfony\Bundle\FrameworkBundle\Controller\Controller;
use Sensio\Bundle\FrameworkExtraBundle\Configuration\Route;
use AppBundle\Entity\TblProduct;

class DefaultController extends Controller
{
    /**
     * @Route("/",name="homepage")
     */
    public function indexAction()
    {
        $products = "SELECT * FROM TblProduct";
        $q = Doctrine_Query::create()->query($products);

        if (!$products) {
            throw $this->createNotFoundException(
                'No products registered yet.'
            );
        }
        return $this->render('default/index.html.twig',array('products' => $products));
    }