PHP download

Download the PHP package websitesql/database without Composer

On this page you can find all versions of the php package websitesql/database. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

Table of contents
Download websitesql/database
More information about websitesql/database
Files in websitesql/database

Vendor websitesql
Package database
Short Description The lightweight PHP database framework to accelerate development and reduce complexity.
License MIT

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:

If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

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 PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

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.

Please rate this library. Is it a good library?

Example code of websitesql/database

Informations about the package database

WebsiteSQL Database

A powerful database wrapper library built on top of Medoo, providing a simple and intuitive interface for database operations in PHP applications.

Installation

Basic Usage

Initialization

CRUD Operations

Select Data

Insert Data

Update Data

Delete Data

Migrations

The database library includes a migration system for managing database schema changes:

API Reference

Base Operations

query(string $statement, array $map = []): Execute raw SQL queries
exec(string $statement): Execute raw statement
create(string $table, array $columns, array $options = null): Create a table
drop(string $table): Drop a table
select(string $table, array $join, array|string $columns = null, array $where = null): Select data
get(string $table, array $join, array|string $columns = null, array $where = null): Get a single record
insert(string $table, array $values, string $primaryKey = null): Insert data
update(string $table, array $data, array $where = null): Update data
delete(string $table, array $where = null): Delete data
replace(string $table, array $columns, array $where = null): Replace data

Aggregation

count(string $table, array $join = null, string $column = null, array $where = null): Count rows
avg(string $table, array $join, string $column = null, array $where = null): Calculate average
max(string $table, array $join, string $column = null, array $where = null): Get maximum value
min(string $table, array $join, string $column = null, array $where = null): Get minimum value
sum(string $table, array $join, string $column = null, array $where = null): Calculate sum

Transactions

action(callable $actions): Execute callback in transaction
beginTransaction(): Begin a transaction
commit(): Commit a transaction
rollBack(): Rollback a transaction

Utilities

id(?string $name = null): Get last inserted ID
pdo(): Get PDO instance
debug(): Get the last query for debugging
log(): Get query log
info(): Get database connection info
error(): Get error information
rand(string $table, array $join = null, array|string $columns = null, array $where = null): Get random records
has(string $table, array $join, array $where = null): Check if records exist

Migrations

migrations()->up(): Run pending migrations
migrations()->down(): Rollback the last batch of migrations
migrations()->reset(): Rollback all migrations
migrations()->refresh(): Rollback all and run again

License

MIT

All versions of database with dependencies

PHP Build Version

Package Version

Version v1.0.0 Release 12. Apr 2025
create-project require 0 people chose require and
0 people chose create-project.

Download

Download latest version of database from vendor websitesql

Requires php Version >=8.0
ext-pdo Version *
catfan/medoo Version ^2.1

Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package websitesql/database contains the following files

Loading the files please wait ...

Download the PHP package websitesql/database without Composer

FAQ

How can I use the PHP package after the download?

Do I need to create a project on this site?

When is it necessary to insert some auth.json content?

What is the advantage to use this site for my Composer projects?

Informations about the package database

WebsiteSQL Database

Installation

Basic Usage

Initialization

CRUD Operations

Select Data

Insert Data

Update Data

Delete Data

Migrations

API Reference

Base Operations

Aggregation

Transactions

Utilities

Migrations

License

All versions of database with dependencies

Version v1.0.0 Release 12. Apr 2025 create-project require 0 people chose require and0 people chose create-project. Add to Project Download

The package websitesql/database contains the following files

Version v1.0.0 Release 12. Apr 2025
create-project require 0 people chose require and
0 people chose create-project.

Download