日常记录----小工具

导入数据库

数据格式例如, 以分号;结尾的整条sql语句
SET FOREIGN_KEY_CHECKS=0;
CREATE TABLE m_company (
id int(11) unsigned NOT NULL AUTO_INCREMENT,
name varchar(30) NOT NULL COMMENT ‘名称’,
describe text NOT NULL COMMENT ‘公司简介’,
email varchar(30) NOT NULL COMMENT ‘邮箱’,
logo_url varchar(255) NOT NULL COMMENT ‘logo链接’,
is_examine tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘0未** 1审核成功 2审核失败’,
create_time datetime NOT NULL COMMENT ‘创建时间’,
update_time datetime NOT NULL COMMENT ‘修改时间’,
create_man varchar(30) NOT NULL COMMENT ‘创建人’,
update_man varchar(30) NOT NULL COMMENT ‘修改人’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT=‘公司表’;

$servername = "127.0.0.1";
$username = "root";
$password = "root";
$database = "db_name";
 
// 创建连接
$conn = mysqli_connect($servername, $username, $password);
// 检测连接
if (!$conn) {
    die("连接失败: " . mysqli_connect_error());
}
 
// 创建数据库
$sql = "CREATE DATABASE $database";
if (mysqli_query($conn, $sql)) {
    echo "数据库创建成功";
} else {
    echo "Error creating database: " . mysqli_error($conn);
}

mysqli_select_db($conn,$database) or die("无法连接到数据库");

$_sql = file_get_contents('D:\paperless\PF\meeting\Uploads\meeting.sql');
$_arr = explode(';', $_sql);
foreach ($_arr as $_value) {
    mysqli_query($conn, $_value);
}
mysqli_close($conn);