php（一）：接受前端数据并查询数据库

多个项目都用到了php连接数据库的知识点，就整理一个方便自己以后看

1.接受来自前端的数据：

$post_data = json_decode(file_get_contents("php://input"), true);
if (is_null($post_data)) {
    $json['err'] = "Expected posting a JSON formatted string";
    echo json_encode($json, JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE);
    exit(0);
}

$recentSevenDays = $post_data['days'];     //days为前端传来的变量名

2.连接数据库并查询：(含连接函数)

$host = "rm-2ze5097an0rlp4ct490110.mysql.rds.aliyuncs.com";
$username = "a_jsb";
$password = "STC89c51";

$database="d_jsb_data";                  //数据库名
$sql_command="select * from t_log_all";  //*为查找全部，可变为表头字段，from后面为数据表名
$data=db_get($database,$sql_command,true);   //true返回全部数据，false返回第一条查询数据

function db_get($database, $sql, $fetch_all)    
{
    global $host, $username, $password;
    $create_mysqli = new mysqli($host, $username, $password, $database);
    if ($create_mysqli->connect_error) {
        die("连接失败: " . $create_mysqli->connect_error);
    }
    $result = $create_mysqli->query($sql);

    if ($fetch_all) {
        return $result->fetch_all(MYSQLI_ASSOC);
    }
    else {
        return $result->fetch_array(MYSQLI_ASSOC);
    }
}

3.取出对应字段数据：

$login_time = [];
foreach ($data as $value){
    array_push($login_time,$value['login_time']);
}

End