$MysqLi = new MysqLi('localhost',root123456test');
$MysqLi->query(set names utf8);
//添加数据
$result = $MysqLi->query("INSERT INTO users(name,money) VALUE (张三10)");
$result 李四200)");

修改数据
$result UPDATE users SET money=+10 WHERE id = 3");

删除数据
$result DELETE FROM users WHERE id=");

var_dump($result);

header("content-type:text/html;charset=utf-8");
$MysqLi );

$result SELECT * FROM users");
$data = $result->fetch_all(MysqLI_ASSOC);
var_dump($data);

header(content-type:text/html;charset=utf-8);
$MysqLi ->autocommit(false); 开启事务
$sql1 = "where id1";
$sql2 20";
$MysqLiquery($sql1);
$r1 affected_rows;
$MysqLiquery($sql2);
$r2 affected_rows;
if($r1>0 && $r20){
    $MysqLicommit(); 事务提交
    echo 操作成功;
}else{
    $MysqLirollback(); 事务回滚
    echo 操作失败;
}

header();
$sql money) VALUE(?,?)";
$stmt prepare($sql);

$name  "王小小";
$money 500;
$stmt->bind_param(si);
$result = $stmtexecute();
var_dump($result);

$name  "王大大";
$600();
var_dump($result);

header('',1)">>?";
$stmt ($sql);
$idi,$id);
$stmt->bind_result($id,1)">);
$stmt();

while($stmtfetch()){
    $data[] = [
        'id'=>$id,'name'=>$name,'money'=>$money
    ];
}
var_dump($data);

header();
$dsn = "MysqL:host=localhost;dbnametest";
$pdo = new PDO($dsn,1)">);
$pdoexec( users";
$stmt = $pdoquery($sql);
//$data (PDO::FETCH_ASSOC);
$data fetchAll(PDO::FETCH_ASSOC);
var_dump($data);

header(500 ";
$result exec($sql);
var_dump($result);

header(->beginTransaction(); 100 ";
$r1 ($sql1);

$sql2 = "UPDATE1 users 2";
$r2 ($sql2);

){
    $pdo事务提交
    echo "操作成功";
}{
    $pdorollBack(); 事务回滚
    echo "操作失败";
}
$pdo->setAttribute(PDO::ATTR_AUTOCOMMIT,1)">//var_dump($result);

header();

//$sql :id";
$sql 1000 :id";
$stmt ($sql);

$id 4bindParam(":id",$id);

//$stmt->bindValue(1,1)">();
var_dump($result);

//$data  fetchAll(PDO::FETCH_ASSOC);
//var_dump($data);

header();
$id = isset($_GET'id'])?$_GET]:;
$sql ".$id;
$stmt query($sql);
$data fetchAll(PDO::FETCH_ASSOC);
var_dump($data);

1
1 or 11     users
1;drop table test;--

header();

$sql ($sql);
$id ();
$data fetchAll(PDO::FETCH_ASSOC);
var_dump($data);