README

可用于PHP侧的Mysql驱动程序开发

安装

要安装此包，可以使用composer

    composer require slvler/mysql-connectors

使用

use slvler\mysqlconnectors\Constant;
use slvler\mysqlconnectors\Config\Method;
use slvler\mysqlconnectors\Database\DatabaseController;


$Constant = new Constant();

$db = new DatabaseController($Constant->showDBHost(), $Constant->showDBName(), $Constant->showDBUser(), $Constant->showDBPassword(), $Constant->showConnection());

基本表 // 使用 northwind

表 "orders"

插入方法 (TableName, Data = array())

TableName, Data

$tableName = "Orders";

$data = Array
(
  "ShipName" => "Blue",
  "ShipAddress" => "Nottingham",
  "ShipCity" => "UK"
);

插入方法

$methodInsert = $method->Insert($tableName,$data);

更新方法 (TableName, Id = array() , Data = array())

TableName, Id , Data

$tableName = "Orders";

$Id = array(
 "OrderID" => "1"
);

$data = Array
(
  "ShipName" => "Blue",
  "ShipAddress" => "Nottingham",
  "ShipCity" => "UK"
);

更新方法

$methodUpdate = $method->Update($tableName', $id, $data);

删除方法 (TableName, Id = array())

TableName, Id

$tableName = "Orders";

$Id = array(
 "OrderID" => "1"
);

删除方法

$methodDelete = $method->Delete($tableName,$id);

选择所有方法 (TableName)

TableName

$tableName = "Orders";

选择所有方法

$methodSelectAll = $method->Select_all($tableName);

选择方法 (TableName, Data = array())

TableName, Data

$tableName = "Orders";

$data = Array
(
  "ShipName", "ShipAddress", "ShipCity"
);

选择方法

$methodSelectCh = $method->Select_ch($tableName,$data);

选择方法 (TableName, Data = array(), Conn = array(), If = array())

TableName, Data, Conn, If

$tableName = "Orders";

$data = Array
(  
    "EmployeeID" => "4"
);

$conn = Array
(  
    "!="
);

$if = Array
(  
    "AND"
);

选择方法

$methodSelectWh =  $method->Select_wh($tableName, $data, $conn, $if);

测试

vendor\bin\phpunit

致谢

• slvler

许可证

MIT许可证（MIT）。请参阅许可证文件获取更多信息。