Download the PHP package koalaphp/database without Composer
On this page you can find all versions of the php package koalaphp/database. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
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:
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.
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?
Informations about the package database
KoalaPHP Database Component
1. 建立数据库连接
只需要在 Bootstrap 阶段初始化一次即可。
2. 获取PDO连接
3. SimpleDao 接口文档（增、删、改、查等）
前提假设条件：
-
user表SQL语句
-
UserModel PHP文件
- UserDao PHP文件
3.1 insert 插入一行记录
insertRow 插入一行数据到数据库的表中
示例代码：
3.2 update 更新记录
-
(1).
updateRow通过ID（主键）更新特定的一行记录 - (2).
updateMultiRows通过ID（主键）列表来更新特定的多行记录
示例代码：
3.3 delete 删除一行记录
示例代码：
3.4 select 查询记录
3.4.1 查询方法定义
主要有以下几个查询方法，函数定义如下：
-
(1).
findCount查询符合条件的某一个对象 -
(2).
findCount获取该查询条件下的总数 -
(3).
findAllRecordCore进行查询获取多行记录的方法 - (4).
createGenerator获取迭代器，可用于循环获取所有行的功能
示例代码：
3.4.2 $conditions 查询where条件语句语法介绍
-
(1). 基本的 AND 语句
-
(2). 某个字段带有不等式的查询
-
(3). 某个字段同时带有大于和小于的范围查询
-
(4). 某个字段带有 IN 范围查询
-
(5). 某个字段带有 LIKE 范围查询
-
(6). 带有某个或者多个字段的 OR 语句 (必须以"single_or_condition"为前缀)
-
(7). 带有某个或者多个字段的 AND 语句 (必须以"single_and_condition"为前缀)
- (8). 带有GROUP BY 语句的聚合查询语句
4. ShardingUserDao 高阶用法，支持查询分库分表Dao文件
示例代码：
All versions of database with dependencies
PHP Build Version
Package Version
Requires
php Version
>=5.6.0
The package koalaphp/database contains the following files
Loading the files please wait ....