TypechoJoeTheme

至尊技术网

统计
登录
用户名
密码
/
注册
用户名
邮箱

PHP连接数据库,通过接受post请求实现增删改查

2020-11-18
/
0 评论
/
125 阅读
/
正在检测是否收录...
11/18

1.html文件:

<!DOCTYPE html>
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <meta http-equiv="Cache-Control" content="no-cache">
    <title>PHP连接数据库实现增删改查</title>
</head>
<body>
<div>
    <input type="text" name="daiHao" placeholder="代号">
    <input type="text" name="keMu" placeholder="科目">
    <input type="text" name="jieShu" placeholder="节数">
    <button class="tianJia">添加</button>
    <button class="shanChu">删除</button>
    <button class="xiuGai">修改</button>
    <button class="chaZhao">查找</button>
</div>
<p>提示:添加可以填3个,删除只填代号,修改可以填科目和节数然后需要改哪个填代号,查询填科目和节数。</p>
<table>
    <tbody>
        <!-- <tr>
            <th>代号</th>
            <th>科目</th>
            <th>节数</th>
        </tr> -->
    </tbody>
</table>
<script src="https://libs.baidu.com/jquery/1.11.3/jquery.min.js"></script>
<script>
    function teVal(){
        daiHao = $('[name="daiHao"]').val();
        keMu = $('[name="keMu"]').val();
        jieShu = $('[name="jieShu"]').val();
        arr = '<tr><th>代号</th><th>科目</th><th>节数</th></tr>';
    }
    $.post('1.php',{a: 'synr'},function(ret){
        teVal();
        // console.log(ret);
        if(ret[0].code == '200'){
            // alert(ret[0].msg);
            for(var i = 1;i < ret.length;i++){
                arr += '<tr><td>'+ret[i].c_id+'</td><td>'+ret[i].c_name+'</td><td>'+ret[i].t_id+'</td></tr>';
            }
            $('tbody').html(arr);
        }else{
            alert(ret[0].msg);
        }
    })
    //添加
    $('.tianJia').on('click',function(){
        teVal();
        if(keMu == '' && jieShu == ''){
            alert('请输入你要添加的内容!');
        }else if(daiHao == ''){
            alert('请输入你要添加的内容!');
        }else{
            $.post('1.php',{a: 'tianJia',c_id: daiHao,c_name: keMu,t_id: jieShu},function(ret){
                // console.log(ret);
                if(ret.code == '200'){
                    alert(ret.msg);
                    location.reload();
                }else{
                    alert(ret.msg);
                }
            })
        }
    })
    //删除
    $('.shanChu').on('click',function(){
        teVal();
        if(daiHao != ''){
            var res = confirm('是否删除?');
            if(res){
                $.post('1.php',{a: 'shanChu',c_id: daiHao},function(ret){
                    if(ret.code == '200'){
                        alert(ret.msg);
                        location.reload();
                    }else{
                        alert(ret.msg);
                    }
                })
            }
        }else{
            alert('请输入你要删除的代号!');
        }
    })
    //修改
    $('.xiuGai').on('click',function(){
        teVal();
        if(keMu != '' || jieShu != ''){
            var res = confirm('是否修改?');
            if(res){
                $.post('1.php',{a: 'xiuGai',c_id: daiHao,c_name: keMu,t_id: jieShu},function(ret){
                    // console.log(ret);
                    if(ret.code == '200'){
                        alert(ret.msg);
                        location.reload();
                    }else{
                        alert(ret.msg);
                    }
                })
            }
        }else{
            alert('请输入你要修改的内容!');
        }
    })
    //查找
    $('.chaZhao').on('click',function(){
        teVal();
        if(keMu != '' || jieShu != ''){
            $.post('1.php',{a: 'chaZhao',c_id: daiHao,c_name: keMu,t_id: jieShu},function(ret){
                // console.log(ret)
                if(ret[0].code == '200'){
                    // alert(ret[0].msg);
                    for(var i = 1;i < ret.length;i++){
                        arr += '<tr><td>'+ret[i].c_id+'</td><td>'+ret[i].c_name+'</td><td>'+ret[i].t_id+'</td></tr>';
                    }
                    $('tbody').html(arr);
                }else{
                    alert(ret[0].msg);
                }
            })
        }
    })
</script>
</body>
</html>

1.php文件:

<?php
$conn = mysqli_connect('localhost','cs','123456','cs','3306');//主机名或 IP 地址,MySQL用户名,MySQL密码,规定默认使用的数据库,MySQL服务器的端口号,规定 socket 或要使用的已命名 pipe
if (!$conn) { 
    die("连接错误: " . mysqli_connect_error()); 
} 
// var_dump($conn);
mysqli_query($conn,"set names utf8");//设置数据库编码为utf8
header('content-type: application/json;charset=utf-8');//输出为json格式,并设置编码为utf-8

//全局
$c_id = isset($_POST['c_id']) ? trim($_POST['c_id']) : '';
$c_name = isset($_POST['c_name']) ? trim($_POST['c_name']) : '';
$t_id = isset($_POST['t_id']) ? trim($_POST['t_id']) : '';

//添加
function tianJia(){
    $conn = $GLOBALS['conn'];//引用全局作用域中可用的全部变量
    $c_id = $GLOBALS['c_id'];
    $c_name = $GLOBALS['c_name'];
    $t_id = $GLOBALS['t_id'];
    $sql = "insert into course (c_id,c_name,t_id) values ('$c_id','$c_name','$t_id')";//添加
    $result = mysqli_query($conn,$sql);
    if($result){
        return json_encode(array('code' => '200','msg' => '添加成功'));
    }else{
        return json_encode(array('code' => '400','msg' => '添加失败'));
    }
}

//删除
function shanChu(){
    $conn = $GLOBALS['conn'];
    $c_id = $GLOBALS['c_id'];
    $sql = "delete from course where c_id='$c_id'";//删除
    $result = mysqli_query($conn,$sql);
    if($result){
        return json_encode(array('code' => '200','msg' => '删除成功'));
    }else{
        return json_encode(array('code' => '400','msg' => '删除失败'));
    }
}

//修改
function xiuGai(){
    $conn = $GLOBALS['conn'];
    $c_id = $GLOBALS['c_id'];
    $c_name = $GLOBALS['c_name'];
    $t_id = $GLOBALS['t_id'];
    if($c_name != ''){
        $s = "c_name='$c_name'";
    }else if($t_id != ''){
        $s = "t_id='$t_id'";
    }else if($c_name != '' && $t_id != ''){
        $s = "c_name='$c_name',t_id='$t_id'";
    }
    $sql = "update course set $s where c_id='$c_id'";//修改
    $result = mysqli_query($conn,$sql);
    if($result){
        return json_encode(array('code' => '200','msg' => '修改成功'));
    }else{
        return json_encode(array('code' => '400','msg' => '修改失败'));
    }
}

//查找
function chaZhao(){
    $conn = $GLOBALS['conn'];
    $c_id = $GLOBALS['c_id'];
    $c_name = $GLOBALS['c_name'];
    $t_id = $GLOBALS['t_id'];
    if($c_name != ''){
        $s = "c_name='$c_name'";
    }else if($t_id != ''){
        $s = "t_id='$t_id'";
    }else if($c_name != '' && $t_id != ''){
        $s = "c_name='$c_name' and t_id='$t_id'";
    }
    $sql = "select * from course where $s";//查找
    $result = mysqli_query($conn,$sql);
    $arr = array();//建一个空数组
    $arr[] = array('code' => '200','msg' => '查找成功');//赋值到空数组里
    while ($row = mysqli_fetch_assoc($result)) {//通过while循环获取
        $arr[] = $row;
    }
    if($result){
        return json_encode($arr);
    }else{
        return json_encode(array('code' => '400','msg' => '查找失败'));
    }
}

//所有内容
function synr(){
    $conn = $GLOBALS['conn'];
    $sql = 'select * from course';
    $result = mysqli_query($conn,$sql);
    $arr = array();
    $arr[] = array('code' => '200','msg' => '获取成功');
    while ($row = mysqli_fetch_assoc($result)) {//通过while循环获取
        $arr[] = $row;
    }
    // print_r($arr);
    if($result){
        return json_encode($arr);
    }else{
        return json_encode(array('code' => '400','msg' => '获取失败'));
    }
}

//转换成数组
// $result = mysqli_query($conn,$sql);//对数据库执行一次查询
// $row = mysqli_fetch_array($result,MYSQLI_ASSOC);//函数从结果集中取得一行作为关联数组,或数字数组。 MYSQLI_ASSOC,MYSQLI_NUM,MYSQLI_BOTH(默认)
// print_r($row);
//mysqli_fetch_assoc($result);//关联数组
//mysqli_fetch_row($result);//数字数组

//错误提示
function bc(){
return json_encode(array('code' => '400', 'msg' => '操作失败'));
}

$a = isset($_POST['a']) ? trim($_POST['a']) : '';
switch ($a){
    case "tianJia": // 添加
        echo tianJia();
        break;
    case "shanChu": // 删除
        echo shanChu();
        break;
    case "xiuGai": // 修改
        echo xiuGai();
        break;    
    case "chaZhao": // 查找
        echo chaZhao();
        break;
    case "synr":
        echo synr();
        break;
    default:
        echo bc();
        mysqli_close($conn);//关闭先前打开的数据库连接
}        
?>

数据库表下载地址:https://zhizun.lanzoux.com/iuicqiiigxi

经验jsPHPajaxjQueryGetpost
朗读
赞(0)
版权属于:

至尊技术网

本文链接:

https://www.zzwll.cn/archives/4954/(转载时请注明本文出处及文章链接)

评论 (0)