PHP向MySql中插入数据

<!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>

  像student表中插入一条数据

原文地址:https://www.cnblogs.com/yosha/p/5728818.html