Download the PHP package sinevia/php-library-sqldb without Composer
On this page you can find all versions of the php package sinevia/php-library-sqldb. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Please rate this library. Is it a good library?
Informations about the package php-library-sqldb
PHP Library SqlDB
PHP Library for working with SQL databases.
Features
- MySQL, SQlite and SQLiteDB (SQLite in the cloud) supported
- Unified data types. The data types are developer orientated (string, text, integer, float, blob). These are then translated to the correct column type for the corresponding database.
- Fluent interface for building queries
Installation
1) Via composer command line
2) Via composer file:
Add the latest stable version to your composer file, and update via composer
Data Types
Data Type | MySQL Data Type | SQLite Data Type |
---|---|---|
STRING | VARCHAR (255) | TEXT |
TEXT | LONG TEXT | TEXT |
INTEGER | BIG INT | INTEGER |
FLOAT | DOUBLE | REAL |
BLOB | LONG BLOB | TEXT |
Usage
1) Creating a new database instance
2) Drop a database
Depending on your database hosting this may or may not be supported
3) Creating a new table
3) Drop a table
3) Inserting rows
4) Selecting rows
5) Updating rows
5) Deleting rows
Helper Functions
1) Generating UUIDs
2) Generating HUIDs
HUIDs are human friendly unique identifiers, which are date based.
Related Projects
All versions of php-library-sqldb with dependencies
PHP Build Version
Package Version
Requires
sinevia/php-library-http Version
v1.3.0
The package sinevia/php-library-sqldb contains the following files
Loading the files please wait ....