Download the PHP package cb-master/cbm-model without Composer
On this page you can find all versions of the php package cb-master/cbm-model. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download cb-master/cbm-model
More information about cb-master/cbm-model
Files in cb-master/cbm-model
Package cbm-model
Short Description A database model for cloud bill master application use.
License MIT
Informations about the package cbm-model
Cloud Bill Master Database Model
Cloud Bill Master Singleton Database Model is a PHP-based project that implements a robust, object-oriented database management system for handling complex transactions and data manipulation tasks. Built on top of MySQL, this singleton model aims to provide a high-performance, flexible, and secure way to interact with databases in PHP applications, specifically designed to streamline billing and cloud data management systems.
Key Features
- Object-Oriented Structure: Built with PHP OOP principles, ensuring code reusability, scalability, and maintainability.
- Custom Database and Model Classes: Uses a custom Database class for managing database connections, queries, and transactions, and a Model class to represent data entities in the application.
- Secure Transactions: Implements ACID-compliant transactions for consistent and reliable data handling.
- Dynamic Query Builder: Supports dynamic query generation with a range of options for filters, sorting, and pagination, making it easy to create complex queries without directly writing SQL.
- Error Handling: Comprehensive error handling and logging for tracking and debugging issues efficiently.
- Scalable Architecture: Designed with scalability in mind, suitable for all type of PHP applications.
- Easy Integration: Integrates seamlessly with other PHP-based applications and frameworks, allowing flexible deployment in diverse environments.
Technologies Used
- PHP (Object-Oriented): Core programming language, providing OOP features for structure and maintainability.
- MySQL: Relational database management system used for data storage, with optimized queries for faster performance.
- PDO (PHP Data Objects): Utilized for secure database access with prepared statements to prevent SQL injection.
Installation
Use Without Composer: Download the source code and copy it in your application directory. For manual installation, please remove the require vendor autoload file and use the 'model.php' file from the repository.
Install with composer:
Configure your database settings in your PHP application page top section.
By default fetching data as object. But you can fetch data as array.
You can ignore the driver key if you are using the mysql driver. Mysql is the default driver in this system.
Usage
This project provides a base for any PHP application needing a reliable and efficient database model, especially useful for billing and cloud services. For detailed usage examples, please see the given method implementation below.
Get Data From Table
Get Data From Table
Use Where Clause. Where clause need 3 arguments {where(array $where, string $operator = '=', string $compare = 'AND')} where 1st one is required.
Use between() method. Its like where. You also can use it with where() method. Between method needs 3 arguments {between(string $column, int|string $min, int|string $max, string $compare = 'AND')}
Get Limited Data From Table (Default is 20)
Additional method to use is limit()