標籤：
<!DOCTYPE html><!--To change this license header, choose License Headers in Project Properties.To change this template file, choose Tools | Templatesand 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表中插入一條資料
PHP向MySql中插入資料
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
