PHP 原生连接数据库

<?php

$host = "localhost";  //数据库地址
$dbuser = "root";     //登录数据库用户名
$dbpwd = "root";      //登录数据库密码
$database = "mys_car";    //需要使用的数据库
$setNames = "set names utf8";   //程序编码格式

/**
 * 查询
 * @param $sql ,查询sql语句，
 * @return array，返回查询结果数组
 */
function select($sql)
{
    global $host, $dbuser, $dbpwd, $database, $setNames;
    $connect = mysqli_connect($host, $dbuser, $dbpwd, $database, '3306');
    mysqli_query($connect, $setNames);
    //3.发送SQL语句
    $result = mysqli_query($connect, $sql);
    $arr = array();//定义空数组
    while ($row = mysqli_fetch_array($result, MYSQL_ASSOC)) {
//        print_r($row);
        //array_push(要存入的数组，要存的值)
        array_push($arr, $row);
    }
    //4.关闭连接
    mysqli_close($connect);
    return $arr;
}

/**
 * 查询单（一）条数据
 * @param $sql ,查询sql语句，
 * @return array，返回查询结果数组
 */
function getOne($sql)
{
    global $host, $dbuser, $dbpwd, $database, $setNames;
    $connect = mysqli_connect($host, $dbuser, $dbpwd, $database, '3306');
    mysqli_query($connect, $setNames);
    //3.发送SQL语句
    $result = mysqli_query($connect, $sql);
    $row = mysqli_fetch_array($result, MYSQL_ASSOC);
    //4.关闭连接
    mysqli_close($connect);
    return $row;
}

/**
 * 添加，修改，删除
 * @param $sql，查询sql语句，
 * @return resource，返回boolean值，判断
 */
function query($sql)
{
    global $host, $dbuser, $dbpwd, $database, $setNames;
    //1.建立连接
    $connect = mysqli_connect($host, $dbuser, $dbpwd, $database, '3306');
    //2.定义sql语句
    mysqli_query($connect, $setNames);
    //3.发送SQL语句
    $result = mysqli_query($connect, $sql);
    //4.关闭连接
    mysqli_close($connect);
    return $result;
}