Download the PHP package laswitchtech/php-database without Composer

phpDB - [DEPRECATED] - Use coreDatabase instead

Description

This is a PHP class that provides an interface for interacting with a MySQL database using the mysqli extension. It provides methods for creating, reading, updating, and deleting data from a database, as well as for creating and modifying database tables. It also includes methods for transaction handling and error logging.

The class uses prepared statements to prevent SQL injection attacks and supports UTF-8 encoding. It also includes debugging functionality that allows you to log queries and parameters to a file.

Features

• Connection pooling for improved performance
• Automatic database schema migration
• Query builder for easier construction of complex SQL queries
• Support for transactions and rollbacks
• Query profiling and optimization
• Easy and secure interaction with a SQL database
• Debugging functionality
• Simplified handling of common SQL tasks
• Backup and restore your database
• Create database schema for future upgrades
• Upgrade database to a new schema

Why you might need it?

phpDB is a simple and easy-to-use PHP class that provides an interface for interacting with a MySQL database using the mysqli extension. If you're building a web application or website that needs to store and retrieve data from a MySQL database, then phpDB can save you a lot of time and effort. The class provides methods for creating, reading, updating, and deleting data from a database, as well as for creating and modifying database tables. It uses prepared statements to prevent SQL injection attacks and supports UTF-8 encoding, which ensures that your data is stored and retrieved accurately. Additionally, phpDB includes debugging functionality that allows you to log queries and parameters to a file, making it easier to troubleshoot issues with your database. Whether you're a beginner or an experienced developer, phpDB can simplify your database interactions and help you get your web application up and running quickly.

Can I use this?

Sure!

License

This software is distributed under the GNU General Public License v3.0 license. Please read LICENSE for information on the software availability and distribution.

Requirements

PHP >= 5.5.0

To Do

• Multiple Database Types Support (ex: MariaDB, MySQL, JSON, XML, PostgreSQL, SQLite)

Security

Please disclose any vulnerabilities found responsibly – report security issues to the maintainers privately.

Installation

Using Composer:

How do I use it?

In this documentations, we will use a table called users for our examples.

Examples

Connecting Database

Using Constant

Without Using Constant

Create a Table

Alter a Table

Truncate a Table

Drop a Table

Insert Data

Select Data

Update Data

Delete Data

Backup

Restore

Schema

Upgrade