PHP mysqli类

<?php
    header("content-type:text/html;charset=utf-8");
    $conn = new mysqli("localhost","root","root","test"); //ip、username、password、dbname
    $conn->query("set names utf8");    //设置编码
    
    $sql = "SELECT * FROM TEST";
    $result = $conn->query($sql);
    
    while ($row = $result->fetch_assoc()) {
        echo $row["name"];
        echo "<br/>";
    }
    while ($row = $result->fetch_row()) {
        echo $row[0];
        echo "<br/>";
    }
    
    $sql = "INSERT INTO TEST(id) VALUES(2)";
    $conn->query($sql);
    if($conn->affected_rows>0) {
        echo $conn->insert_id;
    } else {
        echo -1;
    }
    
    $conn->autocommit(FALSE); //默认是自动提交的，设置为不自动提交，才可以使用事务
    $sql1 = ".....";
    $sql2 = ".....";
    $conn->query($sql1);
    $conn->query($sql2);
    if(!$conn->errno) {
        $conn->commit();
    } else {
        $conn->rollback();
    }

?>