php面向对象链接mysql_php面向对象&链接MySQL数据库

$host = "localhost:3306+";

$user = "root";

$password = "password";

//链接数据源

$link1 = new mysqli($host,$user,$password);

//判断是否成功

if($link1 -> connect_error) {

die ("链接失败:").$link1 ->connect_error;

} else {

echo "连接成功\n";

}

//创建数据库

$query1 = "create database if not exists runoob_db2";

//判断是否成功

if($link1 ->query( $query1)) {

echo "创建数据库成功\n";

}

else {

echo "Error:" . $link1->error();

}

//创建数据表

//首先选择数据库

$link1 ->select_db("runoob_db2");

if($link1 -> select_db("runoob_db2")) {

echo "链接数据库成功\n";

}

else {

echo "Error:".$link1->error();

}

// 使用 sql 创建数据表

$query2 = "create table if not exists MyGuests (

id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,

firstname VARCHAR(30) NOT NULL,

lastname VARCHAR(30) NOT NULL,

email VARCHAR(50)

)";

//判断是否成功

if($link1->query($query2)) {

echo "创建数据表成功\n";

}

else {

echo "Error:" .$link1->error();

}

//插入单条数据

$query3 = "INSERT INTO MyGuests (firstname, lastname, email)

VALUES ('John', 'Doe', 'john@example.com')";

if ($link1->query($query3) === TRUE) {

echo "新记录插入成功\n";

} else {

echo "Error: " . $link1->error;

}

//插入多条数据

$sql = "INSERT INTO MyGuests (firstname, lastname, email)

VALUES ('John', 'Doe', 'john@example.com');";

$sql .= "INSERT INTO MyGuests (firstname, lastname, email)

VALUES ('Mary', 'Moe', 'mary@example.com');";

$sql .= "INSERT INTO MyGuests (firstname, lastname, email)

VALUES ('Julie', 'Dooley', 'julie@example.com')";

if ($link1->multi_query($sql) === TRUE) {

echo "多条记录插入成功\n";

} else {

echo "Error: " . $sql . "
" . $link1->error;

}

//关闭数据源

$link1 ->close();

?>