Easier PDO

executeSQL.php

public function executeSQL($dbh, $sql, $params = array()) {
        try {
                $stmt = $dbh->prepare($sql); //Used by all query types.

                if (substr($sql, 0, 6) === "SELECT") {
                        //Select
                        $stmt->execute($params);
                        return $stmt->fetchAll(PDO::FETCH_ASSOC); //Returns an Array if data returned. Use is_array to check.
                } else {
                        //Create/Insert/Update/Delete/Drop
                        return $stmt->execute($params); //Returns true/false
                }

        } catch(PDOException $e) {
                trigger_error('An error has occured in the executeSQL Function. 
                                Error acquiring data: ' . $e->getMessage() .
                                (isset($stmt) ? 'Debug Params: ' . $stmt->debugDumpParams() : ''),
                                E_USER_ERROR);
                exit(0);
        }
}