README

这是一个用于管理数据库连接、结果分页和构建PHP中查询的简单库。

这是一个用于管理数据库连接、结果分页和构建PHP中查询的简单库。

安装

使用Composer在您的项目中安装lions-software-database-manager

使用Composer在您的项目中安装lions-software-database-manager

composer require lions-software/lions-software-database-manager

使用方法

要使用此库，请按照以下示例操作

要使用此库，请按照以下示例操作

数据库

<?php

require 'vendor/autoload.php';

use LionsSoftware\DatabaseManager\DataBase;

//DATABASE CREDENTIALS
$dbHost = 'localhost';
$dbUser = 'root';
$dbPass = 'pass';
$dbName = 'database';
$dbPort = 3306;
$dbDriver = 'mysql';

//CONFIG DATABASE CLASS
DataBase::config($dbHost,$dbUser,$dbPass,$dbName, $dbPort, $dbDriver);

//CONNECTION INSTANCE
$objDatabase = DataBase::Connection();

分页

<?php

require 'vendor/autoload.php';

use LionsSoftware\DatabaseManager\DataBase;
use LionsSoftware\DatabaseManager\Pagination;

//DATABASE CREDENTIALS
$dbHost = 'localhost';
$dbUser = 'root';
$dbPass = 'pass';
$dbName = 'database';
$dbPort = 3306;
$dbDriver = 'mysql';

//CONFIG DATABASE CLASS
DataBase::config($dbHost,$dbUser,$dbPass,$dbName, $dbPort, $dbDriver);

//CONNECTION INSTANCE
$objDatabase = DataBase::Connection();

//COUNT TOTAL RESULTS
$totalResults = $objDatabase->select('id > 10',null,null,'COUNT(*) as total')->fetchObject()->total;

//CURRENT PAGE
$currentPage  = $_GET['page'] ?? 1;
$itemsPerPage = 10;

//PAGINATION
$objPagination = new Pagination($totalResults,$currentPage,$itemsPerPage);

//SELECT (return a PDOStatement object)
$results = $objDatabase->select('id > 10',null,$objPagination->getLimit());

//PAGES (array)
$pages = $objPagination->getPages();

要求

此库需要PHP 8.0或更高版本。