php mysqli和pdo两种方式操作msyql的基本操作

1、mysqli查询

$con = new mysqli('localhost', 'root', '', 'collectmail');
$con->set_charset('utf8');
$sql = "SELECT * FROM mail_data WHERE mail=?";
$stmt = $con->prepare($sql);
$stmt->bind_param('s', $mail);
$mail = 'sdfa@qq.com';
$stmt->execute();
$result = $stmt->get_result();
$arr = $result->fetch_all(MYSQLI_ASSOC);//$result->fetch_array(MYSQLI_ASSOC) 单行
$stmt->close();

2、mysqli插入（更新删除类似）

$con = new mysqli('localhost', 'root', '', 'collectmail');
$con->set_charset('utf8');
$sql = "INSERT INTO mail_data (mail, create_time) VALUES (?, ?)";
$stmt = $con->prepare($sql);
$stmt->bind_param('s', $mail, $time);
$time = time();
$mail = 'sdfa@qq.com';
$stmt->execute();
$insert_id = $stmt->insert_id;
echo $stmt->error;
$stmt->close();

3、pdo查询

$dsn = 'mysql:dbname=collectmail;host=localhost';
$user = 'root';
$pass = '';
$pdo = new PDO($dsn, $user, $pass);
$sql = "SELECT * FROM mail_data WHERE mail=?";
$sth = $pdo->prepare($sql);
// $sth->bind_param(1, $mail);
// $sth->execute();
$sth->execute([$mail]);
$result = $sth->fetchAll(PDO::FETCH_ASSOC);
var_dump($result);

4、pdo插入（更新删除类似）

$dsn = 'mysql:dbname=collectmail;host=localhost';
$user = 'root';
$pass = '';
$pdo = new PDO($dsn, $user, $pass);
$sql = "INSERT INTO mail_data (mail, create_time) VALUES (?, ?)";
$sth = $pdo->prepare($sql);
$mail = 'dfsf@qq.com';
$time = time();
// $sth->bind_param(1, $mail);
// $sth->bind_param(2, $time);
// $sth->execute();
$sth->execute([$mail, $time]);
$insert_id = $pdo->lastInsertId()