KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

SQL Query Builder Made Easy

Tagged topics

Writing a simple SQL Query to get data is very simple however when your query is getting complicated, you may easily made mistake which will make you scratch your head to debug. Also, your query may prone to security that you may want to avoid such as SQL Injection.

To avoid those problems, we would like to introduce QueryBuilder solution. Using QueryBuilder, you may construct a good SQL Query with PHP language with fluent language. The advantages of using query builder are plenty:

  1. Generate error-free sql query
  2. Preventing SQL Injection which will keep your data safe
  3. Able to create complex query with JOIN, GROUP, WHERE without hassle.
  4. Able to debug with PHP, seeing detail error message rather than common message like "syntax error near ..." of SQL.

Our QueryBuilder support parameters binding method which will made your task of inputting parameters into SQL statement easier and safer.

As you may know, each of SQL databases may contains slightly different syntax of SQL. For example, in MySQL we use LIMIT to get top results while in SQL Server we use TOP. Our QueryBuilder can eliminate those differences, you can write once and your code will be compiled into specific SQL database language.

Please download KoolReport and its QueryBuilder package. Note that the QueryBuilder package can work as standalone to facilitate SQL Query generation in your application without using KoolReport.

Both KoolReport and QueryBuilder package are open-source and free. This is the best SQL Query Builder you can find. So get them now and make your SQL query creating task become easy and secure as ever!

Download KoolReport - Download QueryBuilder

1
#1033 opened on Aug 7, 2019 by SOFMAN with last post of KoolReport
15
#246 opened on Apr 13, 2018 by Tyler Neal with last post of KoolReport