php Demo

<?php

namespace app\index\controller;

define('APP_DEBUG',true);

public function login(){
    if (request()->isPost()) {
        $username = input("post.username");
        $password = input("post.password");
        if(empty($username) || empty($password)) {
            returnjson(array(2,"请输入用户名和密码",""));
        }
        $searchusers = db('users');
        $where['username'] = $username;
        $where['password'] = $password;
        $arr_id = $searchusers->where($where)->field('id')->find();
        $arr = $searchusers->where($arr_id)->find();
        if(empty($arr)){
            returnjson(array(2,'没有这条数据！',''));
        }else{
            returnjson(array(1,'success',$arr));
        }
    }
}

#数据库连接
public function connection(){
    $servername = 'localhost';
    $username = 'root';
    $password = '';
    $dbname = 'mydatabase';
    $conn = mysqli_connect($servername,$username,$password);
    // 检测连接
    if ($conn->connect_error) {
        die("连接失败: " . $conn->connect_error);
    }
    echo "连接成功";
}

#数据库连接
public function connection(){
    $servername = 'localhost';
    $username = 'root';
    $password = '';
    $dbname = 'mydatabase';
    $conn = mysqli_connect($servername,$username,$password);
    
    // 检测连接
    if ($conn->connect_error) {
        die("连接失败: " . $conn->connect_error);
    } 
    echo "连接成功";
}

#数据库新增
public function insertdata(){
    $searchusers = db('users');
    $arr = array(
        'id' => '6',
        'username' => '123',
        'password' => '123'
    );
    #插入记录
    $data = $searchusers->insert($arr);
    returnjson(array(1,'success',$data));
}

#数据新增
public function addData(){
    if (request()->isPost()) {
        $username = input("post.username");
        $password = input("post.password");
        if(empty($username) || empty($password)) {
            returnjson(array(2,"新增无效!",""));
        }
        $searchusers = db('users');
        $where['username']  = $username;
        $where['password']  = $password;
        //插入记录
        $data = $searchusers->insert($where);
        returnjson(array(1,'新增成功!',$data));
    }
}

#数据库删除
public function delete(){
    $searchusers = db('users');
    $where['username'] = '123';
    $where['password'] = '123';
    $arr_id = $searchusers->where($where)->field('id')->find();
    $data = $searchusers->where($arr_id)->delete();
    returnjson(array(1,'success',$data));
}

#数据删除
public function DeleteData(){
    if (request()->isPost()) {
        $ucode = input("post.ucode");
        if(empty($ucode)) {
            returnjson(array(2,"没有取到要删除的数据标识!",""));
        }
        $searchusers = db('users');
        $where['id']  = $ucode;
        $data = $searchusers->where($where)->delete();
        returnjson(array(1,'success',$data));
    }
}

#数据库修改
public function updata(){
    $searchusers = db('users');
    $where['username'] = 'caac_zhangyingchun';
    $where['password'] = 'caac_zhangyingchun';
    $arr_id = $searchusers->where($where)->field('id')->find();
    $arr = array(
        'id' => '5',
        'username' => 'zhangyingchun',
        'password' => 'zhangyingchun'
    );
    $data = $searchusers->where('id='.$arr_id['id'])->update($arr);
    returnjson(array(1,'success',$data));
}

#users表 全查
public function selectName(){
    $searchusers = db('users');
    $username = input("post.search_data");
    $where['username'] = array('like',"%".$username."%");
    if(empty($where['username'])) {
        returnjson(array(2,"请输入用户名!",""));
    }
    $arr = $searchusers->where($where)->select();
    if(empty($arr) || $arr == false){
        returnjson(array(2,'没有这条数据！',''));
    }else{
        returnjson(array(1,'success',$arr));
    }
}