Download the PHP package geekcow/dbcore without Composer
On this page you can find all versions of the php package geekcow/dbcore. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download geekcow/dbcore
More information about geekcow/dbcore
Files in geekcow/dbcore
Package dbcore
Short Description A basic, simple and lightweight ORM engine for PHP
License Apache-2.0
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 dbcore
dbcore
DBCore Engine Usage Documentation
DBCore is a simple, lightweight ORM (Object-Relational Mapping) engine designed for PHP applications. It provides an easy way to interact with databases using PHP objects, abstracting the direct database queries and operations.
Getting Started
Installation
To use DBCore in your project, you need to install it via Composer. Run the following command in your project directory:
Ensure that your project is set up to autoload Composer dependencies. This is usually done by including the Composer-generated autoload.php file in your project:
Configuration
DBCore requires a configuration file named config.ini in your project directory. This file should contain your database connection settings. A sample configuration might look like this:
Make sure to adjust the settings according to your database server.
Basic Usage
Defining Entities
Entities in DBCore represent tables in your database. To define an entity, extend the Entity class and define your table schema within the class. For example:
Performing Database Operations
Once your entity is defined, you can perform various database operations such as fetch, insert, update, and delete.
Fetching Data
To fetch all records:
To fetch a specific record by ID:
Inserting Data
To insert a new record:
Updating Data
To update an existing record:
Deleting Data
To delete a record:
Advanced Usage
Query Builders
DBCore provides a set of query builder classes to simplify the construction of SQL queries. These builders support a fluent interface, allowing you to chain method calls to incrementally build a query.
QuerySelectBuilder
The QuerySelectBuilder is used to construct SELECT queries. It supports selecting columns, specifying conditions, ordering, and limiting results.
Example usage:
QueryInsertBuilder
The QueryInsertBuilder is used to create INSERT queries. It allows specifying the table and the data to insert.
QueryUpdateBuilder
The QueryUpdateBuilder is designed for constructing UPDATE queries. It enables specifying the table, the data to update, and conditions.
QueryDeleteBuilder
The QueryDeleteBuilder facilitates the creation of DELETE queries. It supports specifying the table and conditions for deletion.
These builders abstract the complexity of query syntax, making your code cleaner and easier to maintain.
For more advanced features and usage, refer to the specific methods and properties within the DBCore engine's source code. The engine is designed to be extendable, allowing for customization to fit more complex application requirements.
Contributing
Contributions to DBCore are welcome. To contribute:
- Fork the repository.
- Create your feature branch (
git checkout -b my-new-feature). - Commit your changes (
git commit -am 'Add some feature'). - Push to the branch (
git push origin my-new-feature). - Create a new Pull Request.
Your contributions will help make DBCore a better ORM engine for the PHP community.
