PHP app\service Database::lastInsertedId Examples

Example #1

File: AbstractModel.php Project: zhizunbaonie/blog-2

 /**
  * @return bool
  */
 protected function insert()
 {
     $colsNames = array_keys($this->data);
     $queryData = [];
     // [':foo' => 'Foo, ':bar' => 'Baz', ...]
     foreach ($colsNames as $col) {
         $queryData[':' . $col] = $this->data[$col];
     }
     $sql = "INSERT INTO " . static::$table . " (" . implode(', ', $colsNames) . ")" . " VALUES (" . implode(', ', array_keys($queryData)) . ")";
     $db = new Database();
     $isSuccess = $db->executeSqlQuery($sql, $queryData);
     if ($isSuccess) {
         $this->id = $db->lastInsertedId();
     }
     return $isSuccess;
 }