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