Pommo_Groups::add PHP Method

add() public static method

returns the database ID of the added group or FALSE if failed
public static add ( $in )
    public static function add($in)
    {
        $dbo =& Pommo::$_dbo;
        if (!Pommo_Groups::validate($in)) {
            return false;
        }
        $query = "\n        INSERT INTO " . $dbo->table['groups'] . "\n        SET\n        group_name='%s'";
        $query = $dbo->prepare($query, @array($in['name']));
        return $dbo->lastId($query);
    }

Usage Example

Example #1
0
Pommo::init();
$logger =& Pommo::$_logger;
$dbo =& Pommo::$_dbo;
/**********************************
	SETUP TEMPLATE, PAGE
 *********************************/
require_once Pommo::$_baseDir . 'classes/Pommo_Template.php';
$smarty = new Pommo_Template();
$smarty->prepareForForm();
// add group if requested
if (!empty($_POST['group_name'])) {
    if (Pommo_Groups::nameExists($_POST['group_name'])) {
        $logger->addMsg(sprintf(Pommo::_T('Group name (%s) already exists'), $_POST['group_name']));
    } else {
        $group = Pommo_Groups::make(array('name' => $_POST['group_name']));
        $id = Pommo_Groups::add($group);
        $id ? Pommo::redirect("groups_edit.php?group={$id}") : $logger->addMsg(Pommo::_T('Error with addition.'));
    }
}
if (!empty($_GET['delete'])) {
    // make sure it is a valid group
    $group = current(Pommo_Groups::get(array('id' => $_GET['group_id'])));
    if (empty($group)) {
        Pommo::redirect($_SERVER['PHP_SELF']);
    }
    $affected = Pommo_Groups::rulesAffected($group['id']);
    // See if this change will affect any subscribers, if so, confirm the change.
    if ($affected > 1 && empty($_GET['dVal-force'])) {
        $smarty->assign('confirm', array('title' => Pommo::_T('Confirm Action'), 'nourl' => $_SERVER['PHP_SELF'] . '?group_id=' . $_GET['group_id'], 'yesurl' => $_SERVER['PHP_SELF'] . '?group_id=' . $_GET['group_id'] . '&delete=TRUE&dVal-force=TRUE', 'msg' => sprintf(Pommo::_T('%1$s filters belong this group . Are you sure you want to remove %2$s?'), '<b>' . $affected . '</b>', '<b>' . $group['name'] . '</b>')));
        $smarty->display('admin/confirm.tpl');
        Pommo::kill();