增删改查 原始写法

用框架写久了 就会原始写法忘了  今天特意备注一下

$link = mysqli_connect('localhost','root','','school') or die;
$link->set_charset('utf8');
$abc = "select * from think_user";
$result = $link->query($abc);
$a = array();
while($row = $result->fetch_assoc()) {
    $a[] = $row;
}
echo '<pre>';
var_dump($a);

// 新增
$sql = "insert into think_user values('哈哈','尴尬')";

// 修改
$sql="update think_user set `name`='京客隆',`age`=20,`address`='长江索道' where id=20";

// 删除
$sql="delete from think_user where id=20";

 

转载于:https://www.cnblogs.com/G921123/p/10219366.html