Top "Query-builder" questions

PHP / MySQL Query Builder UI with jQuery?

So, I need to construct a front-facing query builder for a database, but I'm having trouble finding existing code for …

php jquery mysql query-builder

How to update a field in doctrine to set it null

I want to set null to a field in doctrine and here is the sentence $em = $this->getDoctrine()-&…

php symfony doctrine-orm doctrine query-builder

How to use countDistinct in Doctrine query builder (Symfony)

I am trying to count the distinct number of IDs returned for a query with his: $query = $repo->createQueryBuilder(…

php symfony doctrine-orm query-builder

AngularJS Query Builder similar to http://redquerybuilder.appspot.com/

I am trying to create a complete query builder with AngularJS only. I have seen http://redquerybuilder.appspot.com/ which …

angularjs query-builder redquerybuilder

How to do batchUpdate in yii2

Only batchInsert is available in yii2, bacthUpdate is not available in yii2, how can we do this in yii2 like …

yii2 query-builder batch-updates

Symfony2 subquery within Doctrine entity manager

I need to perform this query: SELECT * FROM (SELECT * FROM product WHERE car = 'large' ORDER BY onSale DESC) AS product_…

doctrine symfony entitymanager query-builder

Laravel: how to use derived tables / subqueries in the laravel query builder

Edit: Though this question originally was specific for the query I'm describing underneath, the answer I got applies to almost …

php laravel subquery query-builder

Doctrine 2 in Symfony 2 - Filtering a QueryBuilder by an association

I have my two classes User and Role, and I need to make a QueryBuilder which returns a query for …

php symfony doctrine-orm dql query-builder

Symfony 3 Too many parameters

I'm new to Symfony, and I got an error while running a query : public function getFilteredArticles($page, $nbPerPage, $data) { $query = $…

symfony parameters query-builder

Creating a mongodb query in Java with $or and $in

I am trying to write a java code using mongodb api to create this mongodb query: { "$or": [{"prd" : {"$in" : ["1234", "0987"]}} , {"rsin" : "3228742"}]} …

java mongodb mongodb-query query-builder mongodb-java