<?php




function connect_db()
{
    $dsn = 'mysql:localhost=xxxx;dbname=xxxx;charset=utf8';
    $username = 'xxxx';
    $password = 'xxxx';
    $options =
    [
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
        , PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
    ];
    return new PDO($dsn, $username, $password, $options);
}


function insert($sql, $arr = [])
{
    $pdo = connect_db();
    $stmt = $pdo->prepare($sql);
    $stmt->execute($arr);
    return $pdo->lastInsertId();
}


function select($sql, $arr = [])
{
    $pdo = connect_db();
    $stmt = $pdo->prepare($sql);
    $stmt->execute($arr);
    return $stmt->fetchAll();
}


function h($string)
{
    return htmlspecialchars($string, ENT_QUOTES, 'utf-8');
}