JAVA日报

php(ex01b.php)

<?php
if(isset($_POST['name'])&&isset($_POST['sex'])&&isset($_POST['hobby'])&&isset($_POST['area'])&&isset($_POST['ect'])&&$_GET['act']=='add'){
    $ID = $_POST['name'];
    $sex = $_POST['sex'];
    $hobby = $_POST['hobby'];
    $area = $_POST['area'];
    $ect = $_POST['ect'];
    echo $_GET['act'].'++++';
    $conn=mysqli_connect("localhost","root","123","text3") or die("数据库连接失败");
    mysqli_query($conn,'set names utf8');

    $sql2="insert into student (id,sex,hobby,area,ect) VALUES ('$ID','$sex','$hobby','$area','$ect')";

    if ($conn->query($sql2) === TRUE) {
    } else {
        echo "Error: " . $sql2. "
" . $conn->error;
    }

    $conn->close();
}
else if(isset($_POST['name'])&&isset($_POST['sex'])&&isset($_POST['hobby'])&&isset($_POST['area'])&&isset($_POST['ect'])&&$_GET['act']=='update'){
    $ID1 = $_GET['ID'];
    $sex1 = $_GET['sex'];
    $hobby1 = $_GET['hobby'];
    $area1 = $_GET['area'];
    $ect1 = $_GET['ect'];

    $ID = $_POST['name'];
    $sex = $_POST['sex'];
    $hobby = $_POST['hobby'];
    $area = $_POST['area'];
    $ect = $_POST['ect'];
    echo $_GET['act'].'++++';
    $conn=mysqli_connect("localhost","root","123","text3") or die("数据库连接失败");
    mysqli_query($conn,'set names utf8');

    $sql3="update student set id='$ID',sex='$sex',hobby='$hobby',area='$area',ect='$ect' WHERE id='$ID1' and sex='$sex1' and hobby='$hobby1' and area='$area1' and ect='$ect1'";
    echo $sql3;

    if ($conn->query($sql3) === TRUE) {
        echo "成功";
    } else {
        echo "Error: " . $sql3 . "
" . $conn->error;
    }

    $conn->close();
}
else if(isset($_GET['ID'])&&isset($_GET['sex'])&&isset($_GET['hobby'])&&isset($_GET['area'])&&isset($_GET['ect'])&&$_GET['act']=='delete'){
    $ID = $_GET['ID'];
    $sex = $_GET['sex'];
    $hobby = $_GET['hobby'];
    $area = $_GET['area'];
    $ect = $_GET['ect'];

    echo $_GET['act'].'++++';
    $conn=mysqli_connect("localhost","root","123","text3") or die("数据库连接失败");
    mysqli_query($conn,'set names utf8');

    $sql4="delete from student WHERE id='$ID' and sex='$sex' and hobby='$hobby' and area='$area' and ect='$ect'";
    echo $sql4;

    if ($conn->query($sql4) === TRUE) {
        echo "成功";
    } else {
        echo "Error: " . $sql4 . "
" . $conn->error;
    }

    $conn->close();
}

?>

    











        <?php
        $conn2=mysqli_connect("localhost","root","123","text3") or die("数据库连接失败");
        mysqli_query($conn2,'set names utf8');
        $sql3="select * from student";
        $result=mysqli_query($conn2,$sql3)or die("数据查询失败");
        foreach ($result as $value){
            echo '';
        }
        $conn2->close();
        ?>
        
            
学生个人信息表
        
        
            
姓名
            
性别
            
爱好
            
家庭住址
            
备注
            
        
'.$value["id"].'
'.$value["sex"].'
'.$value["hobby"].'
'.$value["area"].'
'.$value["ect"].'
修改  删除