1、首先在mysql中建一个数据库baixing,再建一个表user,里面有username、password两个字段主键默认为Id,见一下代码:
<?php
/**
* Created by PhpStorm.
* User: Jing
* Date: 2016/7/21
* Time: 17:09
*/
header("content-type:text/html;charset=utf-8");
$host="localhost";
$user="root";
$password="root";
$port=3306;
$db="baixing";
//顺序为$host,$user,$password,$db,$port
$conn=new mysqli($host,$user,$password,$db,$port);
if(!$conn){
die("error:".$conn->connect_error);
}
$result=$conn->query("select * from user");
echo "数据库连接成功";
var_dump($result);
$conn->close();