Download the PHP package memran/marwadb without Composer
On this page you can find all versions of the php package memran/marwadb. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Informations about the package marwadb
MarwaDB for MarwaPHP Framework
MarwaDB is php mysql library for MarwaPHP framework based on PDO. It is robust, faster and simple. It is query builder with PDO connection. No External Library has been used. It is raw and simple PHP Mysql Library by focusing speed, simplicity and scalability. Function names are same as Laravel Eloquent Builder.
Just install the package, add the config and it is ready to use!
Requirements
- PHP >= 7.2.0
- PDO Extension
Features
- Easy to create flexible queries
- Supports any database compatible with PDO
- Simple to build complex queries with little code
- Blazing Fast
Installation
This package is installable and PSR-4 autoloadable via Composer as
composer require memran/marwadb:dev-master
Usage
Create a new DB class, and pass the configruation array to MarwaDB:
DB Raw Query
Alternatively , you can use following function also:
Get Total Result
PDO Server Status
Connection name Specified Query
Change Result Fetch Mode
Transaction
Simple Select Query without Placeholder
With Placeholder
PDO Bind Param
Get Connection Driver
Retrieving All Rows From A Table
Retrieving A Single Row / Column From A Table
Retrieving A List Of Column Values
Aggregates Function
Selects
Specifying A Select Clause
the distinct method allows you to retrieve distinct results:
You may add column:
Joins
Inner Join Clause
Left Join / Right Join Clause
Unions
Where Clauses
Simple Where Clauses
You may use a variety of other operators when writing a where
clause:
Or Statements
Additional Where Clauses
whereBetween / orWhereBetween
whereNotBetween / orWhereNotBetween
whereIn / whereNotIn / orWhereIn / orWhereNotIn
whereNull / whereNotNull / orWhereNull / orWhereNotNull
whereDate / whereMonth / whereDay / whereYear / whereTime
Where Exists Clauses
orderBy
latest / oldest
inRandomOrder
groupBy / having
skip / take
Inserts
Insert multiple records:
Updates
Update Or Insert
Deletes
Debugging
Enable Sql Logging
Print Sql Query
Contribution
Please see CONTRIBUTING for details.
License
The MIT License (MIT). Please see License File for more information.