nasirgolflan/database

数据库测试

v1.3 2019-08-09 11:46 UTC

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),
        ]);