<?php

$servername = "localhost";

$username = "root";

$password = "beijing2007";

$dbname = "mydb";

// 创建连接

$conn = mysqli_connect($servername, $username, $password,$dbname);

// 检测连接

if (!$conn) {

    die("Connection failed: " . mysqli_connect_error());

}

echo "连接成功" . "<br>";

//插入数据

$sql="INSERT INTO user(user,pwd,tel)

VALUES('admin','password',1393322677)";

if(mysqli_query($conn,$sql)){

    echo "插入成功";

}else{

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

}

//关闭数据库连接

mysqli_close($conn);

?>

mysql> SELECT * FROM user;

+----+-------+----------+------------+----------+

| id | user  | pwd      | tel        | reg_date |

+----+-------+----------+------------+----------+

|  1 | admin | password | 1393322677 | NULL     |

+----+-------+----------+------------+----------+

1 row in set (0.00 sec)

<?php

$servername = "localhost";

$username = "root";

$password = "yanshan2007";

$dbname = "mydb";

// 创建连接

$conn = mysqli_connect($servername, $username, $password,$dbname);

// 检测连接

if (!$conn) {

    die("Connection failed: " . mysqli_connect_error());

}

echo "连接成功" . "<br>";

//读取

$sql="SELECT id, user, pwd, tel FROM user";

//$result变量返回了查询结果,该结果的数据结构是一个特定的结果集合

//这个结果集合不能直接输出，需要经过函数的特殊处理才能输出

$result=mysqli_query($conn,$sql);

//mysql_num_rows() 函数返回结果集中行的数目。

if(mysqli_num_rows($result)>0){

    while($row=mysqli_fetch_assoc($result)){

        echo "id:" . $row["id"] . "<br>";

        echo "user:" . $row["user"] . "<br>";

        echo "password:" . $row["pwd"] . "<br>";

        echo "tel:" . $row["tel"] . "<br>";

    }

}else{

    echo "0 结果";

}

//关闭数据库连接

mysqli_close($conn);

?>