nasirgolflan/database
数据库测试
v1.3
2019-08-09 11:46 UTC
Requires
- php: >=5.4.0
This package is auto-updated.
Last update: 2024-09-14 16:55:44 UTC
README
自动配置默认值。
hostname=> 'localhost'
username => 'root'
password=> ''
database => 'default'
dbprefix => ''
要更改,请传递自己的配置变量
在您的代码中初始化安装
use \Nasirgolflan\Database\Mysqli;
$obj= new Mysqli([database'=>'tmp']);
插入操作
// $obj->insert('TABLE_NAME',[Column=>value ..... ]);
$obj->insert('city',['name'=>'rajsthan','state_id'=>1]);
更新操作
//$obj->update('TABLE_NAME','CONDITION',['COLUMN'=>'VALUE', ....]);
EXAMPLE
$obj->update('city','id=7',['name'=>'Noida']);
删除
//$obj->delete('TABLE_NAME',['COLUMN'=>'VALUE','COLUMN'=>VALUE],'and/or/'); //DEFAULT IS AND
$obj->delete('city',['name'=>'rajsthan','state_id'=>1]);
$obj->delete('city',['name'=>'rajsthan','state_id'=>1],'or');
描述您考虑过的替代方案
..
附加上下文
require __DIR__ . '/vendor/autoload.php';
$db= new \Nasirgolflan\Database\Mysqli(['password'=>'welcome','database'=>'tmp']);
$db2= new \Nasirgolflan\Database\Mysqli(['password'=>'welcome','database'=>'slim3']);
$db->insert('tasks',['task'=>'nasir'.rand(0,999)]);
$db2->insert('tasks',['task'=>'nasir']);
$db2->insert('books',[
'title'=>'nasir',
'author'=>"AU-".rand(0,999),
'category'=>'cat-'.rand(0,999),
]);