php操作数据库（增删改查）

使用PDO连接MySQL

database.php

<?php

return [
   'type' => 'mysql',
   'host' => '127.0.0.1',
    'dbname' => 'php',
    'username' => 'xxx',
    'password' => 'xxx'
];

connect.php

<?php

$db = require 'database.php';

$dsn = "{$db['type']}:host={$db['host']};dbname={$db['dbname']}";

$username = $db['username'];

$password = $db['password'];

try{
    $pdo = new PDO($dsn,$username,$password);
    //echo '连接成功';
}catch(PDOException $e){
    die('连接失败'.$e->getMessage());
}

insert.php

<?php
//连接数据库
require __DIR__.'/inc/connect.php';

//创建SQL语句模板
$sql = 'INSERT INTO `catagory` SET `name`=:name,`alias`=:alias';

//创建SQL语句预处理对象
$stmt = $pdo->prepare($sql);

//给SQL语句模板中的变量绑定值
$name = 'xiaogeg';
$alias = '小哥哥';
$stmt->bindParam(':name',$name,PDO::PARAM_STR);
$stmt->bindParam(':alias',$alias,PDO::PARAM_STR);

//执行SQL语句
if($stmt->execute()){
    echo '成功插入了'.$stmt->rowCount().'条数据，主键：'.$pdo->lastInsertId();
}else{
    echo '插入失败';
}
//关闭连接
$pdo = null;

insert1.php（简化写法）

<?php
//连接数据库
require __DIR__.'/inc/connect.php';

//创建SQL语句对象
$stmt = $pdo->prepare('INSERT INTO `category` SET `name`=:name,`alias`=:alias');

//执行语句
$stmt->execute(['name'=>'xiaogege','alias'=>'小哥哥']);

//关闭连接
$pdo = null;