Pommo_Groups::nameExists PHP Method

nameExists() public static method

returns (bool) true if exists, false if not
public static nameExists ( $name = null )
    public static function nameExists($name = null)
    {
        $dbo =& Pommo::$_dbo;
        $query = "\n            SELECT count(group_id)\n            FROM " . $dbo->table['groups'] . "\n            WHERE group_name='%s'";
        $query = $dbo->prepare($query, array($name));
        return (bool) $dbo->query($query, 0);
    }

Usage Example

Example #1
0
	INITIALIZATION METHODS
*********************************/
require 'bootstrap.php';
require_once Pommo::$_baseDir . 'classes/Pommo_Groups.php';
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.