【php基础】pdo操作与mysql 增删改查基本语法

<?php

// $dsn = '数据库类型：host=数据库主机名；dbname=默认数据库名称';
$db = [
	'type'    =>'mysql',
	'host'    =>'127.0.0.1',
	'dbname'  =>'base',
	'username'=>'root',
	'password'=>'root'
];
$dsn = $db['type'].":host=". $db['host'].";dbname=".$db['dbname'];
try{
	$pdo = new PDO($dsn,$db['username'],$db['password']);
}catch(PDOException $e){
	die( '链接失败:'.$e->getMessage());
}

$data = [
	'pid'=>'4',
	'title'=>'人员列表',
	'controller'=>'Admins',
	'method'=>'admin_lists',
	'ishidden'=>'0',
	'status'=>0
]; 


//1.创建数据库
$sql = 'CREATE DATABASE `base`';
//2.创建数据表
$sql = "CREATE TABLE `admins` (
`id`       INT(10) unsigned NOT NULL  COMMENT'用户ID' AUTO_INCREMENT,
`username` CHAR(20) NOT NULL COMMENT'用户名',
`email`    CHAR(30) NOT NULL COMMENT'邮箱',
`password` CHAR(30) NOT NULL COMMENT'密码',
`status`   TINYINT(1) NOT NULL DEFAULT'0' COMMENT'状态：0正常，1禁用', 
`add_time` DATETIME NOT NULL COMMENT'创建时间',
PRIMARY KEY (`id`)
) ENGINE= InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8";

//3.增删改查
//3.1 新增
$sql = "INSERT INTO `admins`(username,email,password,status,add_time) VALUES('wangbin','<?php

// $dsn = '数据库类型：host=数据库主机名；dbname=默