README

这是一个本地的 PHP ORM 包，适用于 MySQL，其主要目标是简化应用程序中的 CRUD 流程，包含所有 CRUD 操作（如插入、编辑、更新、删除、软删除）以及搜索操作

设置

1- 使用 composer require oussemakhlifi/orm-package
2- 使用以下变量设置 .env 文件

• db_host = "主机名"
  
• db_username = "数据库用户名"
  
• db_password = "数据库密码"
  
• db_name = "数据库名称"
  

使用方法

插入示例:

 $db = new \MysqlDB\MysqlDB(); 
 
 $table_name = "products"; 
 
 $columns = ["name", "category", "price"];
 
 $values = ["samsung a21", "phone", "1500"];
 
 $insert = $db->insert($table_name, $columns, $values);

选择示例:

 $db = new \MysqlDB\MysqlDB(); 
 
 $table_name = "products"; 
 
 $where = "id";
 
 $value = 1;
 
 $orderby = "id";
 
 $option = "desc";
 
 $select = $db->select($table_name, $where, $value, $orderby, $option);    

根据运算符选择示例:

 $db = new \MysqlDB\MysqlDB(); 
 
 $table_name = "products"; 
 
 $column = "price";
 
 $operation = "=";
 
 $value = 1500;
 
 $orderby = "id";
 
 $option = "desc";
 
 $select = $db->selectByOperator($table_name, $column, $operation, $value, $orderby, $option);

更新示例:

 $db = new \MysqlDB\MysqlDB(); 
 
 $table_name = "products"; 
 
 $where = "id";
 
 $where_value = "1";
 
 $columns = ["name", "category", "price"];
 
 $values = ["samsung a22", "phone", "1000"];
 
 $update = $db->update($table_name, $columns,$where, $where_value, $values);

删除示例:

 $db = new \MysqlDB\MysqlDB(); 
 
 $table_name = "products"; 
 
 $column = "id";
 
 $value = "1";
 
 $delete = $db->delete($table_name, $colum, $value);

软删除示例:

 $db = new \MysqlDB\MysqlDB(); 
 
 $table_name = "products"; 
 
 $column = "id";
 
 $value = "1";
 
 $soft_delete = $db->soft_delete($table_name, $colum, $value);

搜索示例:

 $db = new \MysqlDB\MysqlDB(); 
 
 $table_name = "products"; 
 
 $column = "category";
 
 $value = "phone";
 
 $search = $db->search($table_name, $column, $value);