public function insert(array $array = array())
{
if (!empty($array)) {
$this->inject($array);
}
$columns = $this->queryColumns();
$cols = array();
$vals = array();
$params = array();
foreach ($columns as $c) {
if (array_key_exists($c, $this->data)) {
$cols[] = $c;
$vals[] = ':' . $c;
$params[':' . $c] = $this->data[$c];
}
}
if (in_array('created_on', $columns) && !in_array('created_on', $cols)) {
$cols[] = 'created_on';
$vals[] = ':created_on';
$params[':created_on'] = date('Y-m-d H:i:s');
}
$sql = "INSERT INTO " . static::$table . ' (' . implode(', ', $cols) . ') ' . 'VALUES (' . implode(', ', $vals) . ')';
$s = $this->db->prepare($sql);
$check = $s->execute($params);
$this->{static::$primary} = $this->db->lastInsertId(static::$sequence);
return $check;
}
/**
* Add a site.. but take care! This works with regex!!!
* @param unknown_type $name
* @param unknown_type $connection
*/
public function addSite($name, $connection)
{
if ($connection->exec("INSERT INTO `learncards`.`config_loginneedlesssites` (`site`) VALUES ('" . $name . "');") > 0) {
$site = new allowedSite();
$site->setName($name);
$site->setId($connection->lastInsertId());
array_push($this->allAllowedSites, $site);
return "Site " . $name . " is successfully added";
} else {
return "A error happend. Nothings changed!";
}
}
/**
* (non-PHPdoc)
* @see RedBean/RedBean_Driver#GetInsertID()
*/
public function GetInsertID()
{
return (int) $this->pdo->lastInsertId();
}
/**
* Create a new question
* @param question $question
* @param unknown_type $connection
*/
public function newQuestion($question, $connection)
{
$connection->exec("INSERT INTO `" . $GLOBALS['dbPrefix'] . "question_question` (`set`, `question`, `mode`) VALUES (" . $this->setid . ", '" . $question->getQuestion() . "', '" . $question->getMode() . "')");
$question->setId($connection->lastInsertId());
array_push($this->questions, $question);
}
/**
* (non-PHPdoc)
* @see RedBean/RedBean_Driver#GetInsertID()
*/
public function GetInsertID()
{
$this->connect();
return (int) $this->pdo->lastInsertId();
}