public static function addAuthor(Base_PDO $_dbh, $name) { $_dbh->query("INSERT INTO author (name_full) VALUES (?)", array($name)); $id = $_dbh->lastInsertId(); self::$authors[$id] = $name; return intval($id); }
public static function addCategory(Base_PDO $_dbh, $name) { $_dbh->query("INSERT INTO category (`subject`) VALUES (?)", array($name)); $id = $_dbh->lastInsertId(); self::$categories[$id] = $name; return intval($id); }
public function __construct() { $dns = self::$ENGINE . ':dbname=' . self::$DATABASE . ';host=' . self::$HOST; try { parent::__construct($dns, self::$USERNAME, self::$PASSWORD); parent::setAttribute(parent::ATTR_ERRMODE, parent::ERRMODE_EXCEPTION); parent::setAttribute(parent::ATTR_EMULATE_PREPARES, false); } catch (PDOException $er) { new Error($er, $this->getLastQuery(true)); echo "Internal Database Connection Error."; die; } }