{"repo":"nilportugues/php-sql-query-builder","free":true,"listed":false,"github":"https://github.com/nilportugues/php-sql-query-builder","clone":"git clone https://github.com/nilportugues/php-sql-query-builder.git","description":"An elegant lightweight and efficient SQL Query Builder with fluid interface SQL syntax supporting bindings and complicated query generation.","language":"PHP","stars":425,"topics":["sql-query-builder","builder","php","sql","php7","database","mysql","crud","mysqli","pdo"],"license":"MIT","category":"databases-storage","readme_excerpt":"SQL Query Builder ================= An elegant lightweight and efficient SQL Query Builder with fluid interface SQL syntax supporting bindings and complicated query generation. Works without establishing a connection to the database. 1. Installation 2. The Builder 2.1. Generic Builder 2.2. MySQL Builder 2.3. Human Readable Output 3. Building Queries 3.1. SELECT Statement 3.1.1. Basic SELECT statement 3.1.2. Aliased SELECT statement 3.1.3. SELECT with WHERE statement 3.1.4. Complex WHERE conditions 3.1.5. JOIN & LEFT/RIGHT/INNER/CROSS JOIN SELECT statements 3.1.6. COUNT rows 3.2. INSERT Statement 3.2.1. Basic INSERT statement 3.3. UPDATE Statement 3.3.1. Basic UPDATE statement 3.3.2. Elaborated UPDATE statement 3.4. DELETE Statement 3.4.1. Empty table with DELETE statement 3.4.2. Basic DELETE statement 3.4.3. Elaborated DELETE statement 3.5. INTERSECT Statement 3.6. MINUS Statement 3.7. UNION Statement 3.8. UNION ALL Statement 4. Advanced Quering 4.1. Filtering using WHERE 4.1.1. Changing WHERE logical operator 4.1.2. Writing complicated WHERE conditions 4.3. Grouping with GROUP BY and HAVING 4.3.1 Available HAVING operators 4.4. Changing HAVING logical operator 4.5. Columns as SELECT statements 4.6. Columns being Values 4.7. Columns using FUNCTIONS 5. Commenting queries 6. Quality Code 7. Author 8. License 1. Installation ↑ The recommended way to install the SQL Query Builder is through Composer. Run the following command to install it: 2. The Builder ↑ The SQL Query Builder ","default_branch":null,"files":null,"tree":[],"storefront":"/r/nilportugues","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/nilportugues/php-sql-query-builder/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}