Top "Query-builder" questions

A query-builder is a set of classes and methods that is able to programmatically build queries.

Laravel query builder - re-use query with amended where statement

My application dynamically builds and runs complex queries to generate reports. In some instances I need to get multiple, somewhat …

php mysql laravel query-builder
Laravel: how to add where clause using query builder?

I have this query, made using Laravel query builder: $rows = DB::table('elements')->where('type', 1); That corresponds to: "…

php mysql sql laravel-4 query-builder
Left join to get a single row in Laravel

I have been unsuccessfully trying to leftjoin and get the required data Here is my code: $album = Albums::->…

php sql laravel-4 eloquent query-builder
How to use the ORMLite query builder to get the total records in a table

Similar to select count(*) from tablename; what should be query in ORMLITE i tried something like int total = dao.queryBuilder().("…

android ormlite query-builder
Laravel Query Builder WHERE NOT IN

I have the following sql query SELECT * FROM exams WHERE exams.id NOT IN (SELECT examId FROM testresults) how can …

mysql laravel query-builder
Laravel query builder - How to either group by alias, or do raw groupBy

My Laravel 5 app includes a dynamic query builder for report running. I need some group by clauses in there and …

mysql laravel group-by laravel-5 query-builder
Laravel Query Builder count from join

So in my database I have table called website_tags, which contains id, title and so on, and also I …

php mysql laravel query-builder
Web based visual query builder

I am after a visual query builder along the lines of http://ajax.easyquerydemo.com/. I am using ASP.NET …

asp.net query-builder
laravel search multiple words separated by space

I am new to laravel query builder, I want to search multiple words entered in an input field for example …

php mysql laravel eloquent query-builder
Doctrine QueryBuilder delete with joins

I'm trying to use the Doctrine QueryBuilder to perform the following SQL query: DELETE php FROM product_hole_pattern php …

php mysql doctrine-orm query-builder