2024-04-24 PHP之CURD

基本的查询业务逻辑（Read），返回 列表数据：data；操作信息：msg；操作状态：status

    $query = "SELECT * from os_system";
   
    $data = $mysqli->query($query) or die($mysqli->error);
    $total = $mysqli->query("SELECT found_rows() as total") or die($mysqli->error);
    
    $result = array('list' => array(), 'total' => 0);
    $result['total'] = $total->fetch_assoc()['total'];
    while ($row = $data->fetch_assoc()) {    
        array_push($result['list'], $row);
    }
    exit(JSON(array('data' => $result, 'msg' => 'success', 'status' => '0')));

更新数据（Update），如隐式删除数据

    $id=$_GET['id'];
　　 $query="update os_system set status = '-1' where id='$id' ";
　　 if ($mysqli->query($query)) {
       $result = array('data' => '',  'msg' => '删除成功', 'status' => '0');
　　 } else {
       $result = array('data' => '', 'msg' => '删除失败', 'status' => '1');
　　 }
　　 exit(JSON($result));

插入数据（Create），插入一个值name

    $name=$_GET['name'];
    $output = array();
    $sql = "insert into os_system set name = '$name' ";
    if ($mysqli->query($sql)) {
      $output = array('data' => '', 'msg' => '新增成功', 'status' => '0');
    } else {
      $output = array('data' => '', 'msg' => '新增失败', 'status' => '1');
    }
    exit(JSON($output));

删除数据（Delete），显式删除

    $id=$_GET['id'];
    $query="delete from os_system where id='$id' ";
    if ($mysqli->query($query)) {
        $result = array('data' => '',  'msg' => '删除成功', 'status' => '0');
    } else {
        $result = array('data' => '', 'msg' => '删除失败', 'status' => '1');
    }
    exit(JSON($result));