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(); }