Download the PHP package midorikocak/querymaker without Composer
On this page you can find all versions of the php package midorikocak/querymaker. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download midorikocak/querymaker
More information about midorikocak/querymaker
Files in midorikocak/querymaker
Package querymaker
Short Description QueryMaker is a little library that helps you create simple PDO queries
License MIT
Homepage https://github.com/midorikocak/querymaker
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package querymaker
querymaker
This small library, allows you to create simple SQL queries to use with PDO easily. Just using methods with simple db command names, you can create seamless statements and key value array to use in execution.
Motivation
When using PDO, writing queries are prone to syntax and parameter errors. To prevent them in simple queries you can use this library.
Requirements
Strictly requires PHP 7.4.
Install
Via Composer
Usage
There are starter methods to create a query, such as SELECT and UPDATE.
Select
The above example will output:
Select with fields
Fields to select can be specified as well:
The above example will output:
Fields with different operators
Field values can include operators, such as: =,>, <,<=,>=
The above example will output:
Delete
The above example will output:
Where
To specify WHERE clauase use where($key, $value) method.
The above example will output:
AND and OR
Contraints such as AND and OR, are methods as well. and($key, $value) and or($key, $value)
The above example will output:
Multiple AND and OR clauses can have same field conditions.
ORDER BY
To specify ORDER BY clauase use order($key, $order) method.
The above example will output:
OFFSET and LIMIT
To specify OFFSET and LIMIT clauase use offset($offset) and limit($offset) methods.
The above example will output:
Get key value array to execute
It's also possible to get values as key value pair to easily execute.
Insert
To specify INSERT operation, insert() method, expects a key value array.
The above example will output:
Update
To specify UPDATE operation, handy update() method, expects a key value array. All statement params are generated thoroughly.
The above example will output:
Warning
This library is for educational purposes. Use at your own risk. Exposing query values and using it would create security issues.
Change log
Please see CHANGELOG for more information on what has changed recently.
Testing
Contributing
Please see CODE_OF_CONDUCT for details.
Security
If you discover any security related issues, please email [email protected] instead of using the issue tracker.
Credits
- Midori Kocak
- All Contributors
License
The MIT License (MIT). Please see License File for more information.
