function insertRole($data) { $connection = connect(); $role = new Role(); echo dump($data); $role->setRole(mysqli_real_escape_string($connection, $data['role'])); $role->setDescription(mysqli_real_escape_string($connection, $data['description'])); $query = "insert into role ("; $query .= " role,description "; $query .= ") values( "; $query .= " '{$role->getRole()}','{$role->getDescription()}'"; $query .= ")"; $result = mysqli_query($connection, $query); if ($result) { // echo dump($result); $query = "select id from role where role = '{$role->getRole()}' LIMIT 1"; $result = mysqli_query($connection, $query); confirm_query($result); $row = mysqli_fetch_assoc($result); colse_connection($connection); //echo dump($row['id']); return $row['id']; } colse_connection($connection); return null; }
/** * {@inheritDoc} */ public function setDescription($description) { $this->__initializer__ && $this->__initializer__->__invoke($this, 'setDescription', array($description)); return parent::setDescription($description); }