PHP创建MySQL数据库相关

2020-8-15 12:15| 发布者: 娃娃鱼| 查看: 1315| 评论: 7|原作者: 匿名

摘要: PHP创建MySQL数据库相关一、创建数据库 ?php $servername = localhost; $username = username; $password = password; // 创建连接 $conn = mysqli_connect($servername, $username, $password);// 检测连 ...

PHP创建MySQL数据库相关

一、创建数据库

php

$servername = "localhost";

$username = "username";

$password = "password"; // 创建连接

$conn = mysqli_connect($servername, $username, $password);// 检测连接

if (!$conn) {

die("连接失败: " . mysqli_connect_error());

} // 创建数据库

$sql = "CREATE DATABASE myDB";if (mysqli_query($conn, $sql)) {

echo "数据库创建成功";

}

else {

echo "Error creating database: " . mysqli_error($conn);

}

mysqli_close($conn);

如果使用其他端口（默认为3306），为数据库参数添加空字符串，如: new mysqli("localhost", "username", "password", "", port)

数据库连接编码问题:
//php7
mysqli_query($conn, "set character set 'utf8'");//读库
mysqli_query($conn,"set names 'utf8'");//写库
//php5
mysql_query("set character set 'utf8'");//读库
mysql_query("set names 'utf8'");//写库

二、创建数据库表

$servername = "localhost";

$username = "username";

$password = "password";

$dbname = "myDB"; // 创建连接

$conn = new mysqli($servername, $username, $password, $dbname);// 检测连接

if ($conn->connect_error) {

die("连接失败: " . $conn->connect_error);} // 使用 sql 创建数据表

$sql = "CREATE TABLE MyGuests (

id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,

firstname VARCHAR(30) NOT NULL,

lastname VARCHAR(30) NOT NULL,