hardeep-vicky / php-query-builder
Query builder Tool for Php
1.1.1
2023-10-22 01:58 UTC
Requires
- php: >=8.0
README
A Library to generate complex query with fields, where, order, joins
composer require hardeep-vicky/php-query-builder
require_once './vendor/autoload.php'; use HardeepVicky\QueryBuilder\QuerySelect; use HardeepVicky\QueryBuilder\Join; use Symfony\Component\VarDumper\VarDumper; $qb = new QuerySelect("legder_sales", "Legder"); $qb->field("id"); $qb->join(Join::init("INNER JOIN", "legder_voucher_type_id", "legder_voucher_types", "LegderVoucherType", "id")); $legder_detail_join = Join::init("LEFT JOIN", "id", "legder_sale_details", "LegderDetail", "legder_sale_id")->noField(); $product_join = Join::init("LEFT JOIN", "product_id", "products", "Product", "id"); $product_join->join( Join::init("LEFT JOIN", "id", "product_files", "ProductFile", "product_id")->noField() ->join(Join::init("LEFT JOIN", "image_id", "images", "ProductFileImage", "id")) ); $product_join->join(Join::init("LEFT JOIN", "category_id", "categories", "Category", "id")->field("name")); $legder_detail_join->join($product_join); $legder_detail_join->join(Join::init("LEFT JOIN", "item_id", "items", "Item", "id")); $qb->join($legder_detail_join); VarDumper::dump($qb->get());