MySQL原生代码增删改查

最新推荐文章于 2023-02-02 21:52:18 发布

转载最新推荐文章于 2023-02-02 21:52:18 发布 · 199 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://blog.youkuaiyun.com/hyy1206317124/article/details/80243196

文章标签：

#mysql #sql

本文介绍了如何使用PHP通过PDO连接MySQL，包括查询所有用户、根据ID筛选、条件查询，以及执行插入、更新和删除操作。展示了基本的SQL语句和PDO对象的使用技巧。

<?php

# PDO连接MySQL数据库 #
$db = new PDO("mysql:host=localhost;dbname=website_1", 'root', 'root');

# 查询语句 #
$sql = "SELECT * FROM user";
$sql = "SELECT * FROM user WHERE id=5";
$sql = "SELECT * FROM user WHERE id>5";
$sql = "SELECT * FROM user WHERE name='feige' or pass='xdrvrr'";
//$sql = "SELECT * FROM user WHERE qq=3432432";
//$sql = "SELECT * FROM user WHERE phone=13219057177";
$sth = $db->query($sql);
while ($row = $sth->fetch(PDO::FETCH_ASSOC)) {
    echo '<hr>';
    print_r($row);
    echo '<hr>';
}
if ($sth) {
    echo "成功查询";
}

# 添加语句 #
$sql = "INSERT INTO user ('id','name','pass','qq','phone','create_time','update_time') VALUES('11','hyy','21332','111111','123232','12','13')";
$res = $db->exec($sql);
if ($res) {
    echo "成功添加";
}

# 更新语句 #
$sql = "UPDATE user set pass='123456' WHERE id=4";
$sql = "UPDATE user set name='feige',pass='xdrvrr' WHERE id=5";
$sql = "UPDATE user set qq='3432432',phone='13219057177' WHERE id=8";
$hyy = $db->exec($sql);
if ($hyy) {
    echo "成功更新";
}

# 删除语句 #
//$sql="DELETE FROM user WHERE id=8";
//单条删除
$sql = "DELETE FROM user WHERE id in(1,2,6,7)";
//多条删除
$hhh = $db->exec($sql);
if ($hhh) {
    echo "成功删除";
}
?>