codeboxsql/php

mysqli类的PHP包装器

维护者

详细信息

github.com/esiokugbechoice/codeboxsql

源代码

问题

安装次数: 7

依赖项: 0

建议者: 0

安全性: 0

星标: 0

关注者: 1

分支: 0

开放问题: 0

v1 2023-04-09 21:07 UTC

Requires

  • php: ^7.3|^8.0

MIT 0fafefcb2aa2083d46e8df9023d9202ccf1787ab

  • CodeBox NG <contact.woop@codebox.ng>

This package is auto-updated.

Last update: 2024-09-10 00:58:43 UTC

README

PHP MySQLi 扩展的包装器

要求

  • PHP ^7.3

安装

使用composer安装，请运行以下命令

composer require codeboxsql/php

用法

//Autoload classes using composer
require_once 'vendor/autoload.php';
//OR
//Include the classes directly from path
require_once 'vendor/codeboxsql/php/dist/mysql.php';

$host = 'localhost';
$user = 'root';
$pass = '';
$database = 'test';

$mysqli = new codeboxsql\mysql($host, $user, $pass, $database);

//INSERT
$mysqli->insertInto('tableOne',array('name' => 'lolo' , 'deg' => '100')); //return string

//SELECT
//Single Select
$mysqli->singleSelect('accounts',array('id' => '60' , 'mobile' => '+2348023775657'), 'fetch', array('ORDER BY' => 'rand()' , 'LIMIT' => '3')); //return array
$mysqli->singleSelect('accounts',array('id' => '60' , 'mobile' => '+2348023775657'), 'count', array('ORDER BY' => 'rand()' , 'LIMIT' => '3')); //return string
//multi Select
$mysqli->multiSelect(array('accounts' => 'a' , 'bvn' => 'b'),array('a.id' => '60' , 'b.usrID' => '60'), 'fetch', array('ORDER BY' => 'rand()' , 'LIMIT' => '3'));// return array
//$mysqli->multiSelect(array('accounts' => 'a' , 'bvn' => 'b'),array('a.id' => '60' , 'b.usrID' => '60'), 'count', array('ORDER BY' => 'rand()' , 'LIMIT' => '3')); //return string

示例

请在浏览器中查看examples.php文件中的脚本。

贡献

如果您遇到错误或有一些建议可以帮助改进这个库以供他人使用，欢迎您在GitHub上为本存储库打开一个问题，我们的开发团队将进行审核。

许可

MIT - 查看 LICENSE