/** * Process an "insert get ID" query. * * @param CSQLQuery $query * @param string $sql * @param array $values * @param string $sequence * * @return int */ public function processInsertGetId(CSQLQuery $query, $sql, $values, $sequence = null) { $results = $query->getConnection()->select($sql, $values); //$sequence = $sequence ?: 'id'; if (!$sequence) { $sequence = 'id'; } return $results[0]->{$sequence}; }
/** * Process an "insert get ID" query. * * @param CSQLQuery $query Query * @param string $sql SQL * @param array $values Values * @param string $sequence Sequence * * @return int */ public function processInsertGetId(CSQLQuery $query, $sql, $values, $sequence = null) { $query->getConnection()->insert($sql, $values); $id = $query->getConnection()->getPdo()->lastInsertId($sequence); return is_numeric($id) ? (int) $id : $id; }