Generic PDO Prepare Statement Function

generic-pdo-prepare-statement.php

function insert($table, $data)
{
    $q = 'insert into ' . $table . ' values(';
    for ($i = 0; $i < count($data); $i++) {
        $q .= ($i == 0) ? '?' : ',?';
    }
    $q .= ');';
    $dsn = 'mysql:host=' . DBHOST . ';dbname=' . DBNAME;
    try {
        $pdo = new PDO($dsn, DBUSER, DBPASS);

        $stmt = $pdo->prepare($q, $data);
        for ($i = 1; $i <= count($data); $i++) {
            $stmt->bindParam($i, $data[$i - 1]);
        }

        $stmt->execute()? return true: return false;

    } catch (PDOException $e) {
        return array('err' => true, 'msg' => $e->getMessage());
    }
}