static function getInstance()
{
if (self::$instance == NULL) {
self::$instance = new model_db();
}
return self::$instance;
}
static function getTags($modelId, $entityId)
{
$db = model_db::getInstance();
$sql = "select tag.`value` from tags b join tag on tag.id=b.tagid where b.model=? and b.id = ?";
$stmt = $db->prepare($sql);
$stmt->execute(array($modelId, $entityId));
return $stmt->fetchAll(PDO::FETCH_COLUMN, 0);
}
static function getInstance()
{
if (self::$instance == NULL) {
self::$instance = new model_db();
$s = self::$instance->prepare('set names utf8');
$s->execute();
}
return self::$instance;
}
public function delete($params)
{
$db = model_db::getInstance();
$sqlDelete = sprintf("delete from %scomment where id = ?", $this->parentModel);
$stmtDelete = $db->prepare($sqlDelete);
if (is_array($params)) {
foreach ($params as $id) {
$stmtInsert->execute(array($id));
}
} else {
$stmtInsert->execute(array($params));
}
}
public function getGroups($userid)
{
$args = array($userid);
$db = model_db::getInstance();
$sql = "select `groups`.groupid from `groups` where group.userid = ?";
$stmt = $db->prepare($sql);
$stmt->execute($args);
$stmt->setFetchMode(PDO::FETCH_NAMED);
$groups = $stmt->fetchAll();
$groups_short = array();
foreach ($groups as $g) {
$groups_short[] = $g['groupid'];
}
return $groups_short;
}
public function update($values)
{
$db = model_db::getInstance();
$sqlUpdateA = "update user set name=?, email=? where id=?;";
$sqlUpdateB = "update user set name=?, email=?, password=? where id=?;";
$stmtInsert = $db->prepare(count($values) > 3 ? $sqlUpdateB : $sqlUpdateA);
$stmtInsert->execute($values);
}
