PHP向MySql中插入数据

工程师煜喆技术 2022年11月10日

0 收藏 468 点赞 4,266 浏览 931 个字

<!DOCTYPE html>
<!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->
<html>
    <head>
        <meta charset="UTF-8">
        <title>Yosha's PHP</title>
    </head>
    <body>
        <?php
        $servername = "localhost";
        $username = "yosha";
        $password = "leon0924";
        $dbname = "test";// 创建连接
        $conn = new mysqli($servername, $username, $password, $dbname);
// 检测连接
        if ($conn->connect_error) {
            die("连接失败: " . $conn->connect_error);
        }
 /////数据插入操作
        $sql3 = "INSERT INTO student(SID,Name,Age) values('B23','Yosha','22')";        if ($conn->query($sql3) === TRUE) {
            echo "新记录插入成功";
        }
        else {
           echo "Error: " . $sql3 . "<br>" . $conn->error;
        }
       // $sql2= "INSERT INTO student(SID,Name,Age) VALUES('B23','Yosha',22)";
        $sql = "SELECT * FROM student";
        $result = $conn->query($sql);        if ($result->num_rows > 0) {
            // 输出每行数据            while ($row = $result->fetch_assoc()) {                echo "<br> 学号: " . $row["SID"] . " 姓名： " . $row["Name"] . " 年龄：" . $row["Age"];            }        } else {
            echo "0 个结果";
        }
        $conn->close();
        ?>     </body>
</html>