PHP7（一）：数据库操作（连接、增删改查操作）

1、连接（mysqli方式）

$con = new mysqli("localhost", "username", "password", "databasename");

• 1

2、查询

    $con->query('set names utf8;'); 
    $sql = "SELECT * FROM tablename";  
    $result = $con->query($sql);  
    $data=array();
    while ($tmp=mysqli_fetch_assoc($result)) {
        $data[]=$tmp;
    }
    var_dump($data);

• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8

3、插入

    $con->query('set names utf8;');
    $sql="INSERT INTO tablename (name,telphone) VALUES ('name','telphone')";
    if($result = $con->query($sql)){
        echo "成功";
    }else{
        echo "失败";
    }