創(chuàng)建數(shù)據(jù)表

$sql = "CREATE TABLE MyGuests (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
email VARCHAR(50),
reg_date TIMESTAMP
)";
if (mysqli_query($conn, $sql)) {
    echo "數(shù)據(jù)表 MyGuests 創(chuàng)建成功";
} else {
    echo "創(chuàng)建數(shù)據(jù)表錯誤 : " . mysqli_error($conn);
}

往數(shù)據(jù)表中插入單條數(shù)據(jù)

插入多條數(shù)據(jù)：mysqli_multi_query($conn,$sql)

$sql = "INSERT INTO MyGuests (firstname, lastname, email) 
VALUES ('qiong', 'wu', 'dacha@example.com')";
if (mysqli_query($conn, $sql)) {
    echo "新紀錄插入成功";
 } else { 
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

使用預(yù)處理語句執(zhí)行SQL

$sql = "INSERT INTO MyGuests VALUES(?, ?, ?)";
// 為 mysqli_stmt_prepare() 初始化 statement 對象 
$stmt = mysqli_stmt_init($conn);
// 預(yù)處理語句
if (mysqli_stmt_prepare($stmt, $sql)) {
    // 綁定參數(shù)，"sss"指后面三個參數(shù)都是字符串類型
    //四種參數(shù)：i-整數(shù)  d-浮點數(shù)  s-字符串  b-布爾值
    mysqli_stmt_bind_param($stmt, 'sss', $firstname, $lastname, $email);
    //設(shè)置參數(shù)并執(zhí)行  
    $firstname = 'san';
    $lastname = 'zhang';
    $email = 'zhang@example.com';
    mysqli_stmt_execute($stmt);
 } 
mysqli_stmt_close($stmt);

讀取MySQLi數(shù)據(jù)表中的數(shù)據(jù)

從表MyGuests讀取id,firstname和lastname列的數(shù)據(jù)并顯示在頁面上

<?php
// 創(chuàng)建連接  
$conn = new mysqli_connect("localhost","username", "password", "TestDB");
//檢查連接
if ($conn->connect_error) {
    die(" : " . mysqli_connect_error()`|);
}
$sql = "SELECT id, firstname, lastname FROM MyGuests";
$result = $mysqli_query($conn,$sql);
if (mysqli_num_rows($result) > 0) {
    //  輸出每行數(shù)據(jù)
    while($row = mysqli_fetch_assoc($result)) {
        echo "<br> id: ".$row["id"]." - Name: ".$row["firstname"]." ".$row
    }
}else{
    echo "0 個結(jié)果";
}
// 釋放結(jié)果集 
mysqli_free_result($result);
mysqli_close($conn);
?>

update更新數(shù)據(jù)

UPDATE table_name
SET column1=value
WHERE some_column=some_value

delete刪除數(shù)據(jù)

DELETE FROM table_name
WHERE some_column = some_value
``