# PD\SQL > A fluent SQL query builder for PHP that provides an elegant and safe way to build and execute database queries. Built on top of PDO, this library offers a chainable API that makes database interactions more intuitive and maintainable. ![tag](https://img.shields.io/badge/tag-PHP%20Library-bb4444) ![size](https://img.shields.io/github/size/pardnchiu/PHPSQL/src/SQL.php)
![version](https://img.shields.io/packagist/v/pardnchiu/sql) ![download](https://img.shields.io/packagist/dm/pardnchiu/sql) ## Features - Fluent interface for building SQL queries - Safe parameter binding to prevent SQL injection - Support for complex JOIN operations (INNER, LEFT, RIGHT) - Dynamic WHERE clause construction - Ordering and pagination support - Transaction handling - Query execution time monitoring - Environment-based configuration - Automatic connection management ## functions - Table selection with `table()` - Custom field selection with `select()` - Conditional filtering with `where()` - Join operations with `join()`, `left_join()`, `right_join()` - Result ordering with `order_by()` - Pagination with `limit()` and `offset()` - Record creation with `insertGetId()` - Record updates with `update()` - Total row count with `total()` - Raw query execution with `query()` for complex custom queries ## How to Use ### Install ```SHELL composer require pardnchiu/sql ``` ### Use ```PHP where('status', 'active') ->where('age', '>', 18) ->get(); $result_order = SQL::table('orders') ->select('orders.*', 'users.name') ->join('users', 'orders.user_id', 'users.id') ->where('orders.status', 'pending') ->get(); $result_product = SQL::table('products') ->total() ->limit(10) ->offset(0) ->order_by('created_at', 'DESC') ->get(); $result_user_1 = SQL::query( "SELECT * FROM users WHERE status = ? AND role = ?", ['active', 'admin'] ); ``` ## License This source code project is licensed under the [MIT](https://github.com/pardnchiu/PHPSQL/blob/main/LICENSE) license. ## Creator

邱敬幃 Pardn Chiu