/** * create a core (create database and add core record in __casebox.cores table) * @param array $p * @return int | false */ public static function create($p) { $rez = false; $dbName = Config::get('prefix') . '_' . $p['name']; if (DB\dbQuery('CREATE DATABASE `' . $dbName . '` CHARACTER SET utf8 COLLATE utf8_general_ci')) { $rez = parent::create($p); } return $rez; }
/** * add a record * @param array $p associative array with table field values * @return int created id */ public static function create($p) { parent::create($p); if (empty($p['name'])) { trigger_error(L\get('ErroneousInputData') . ' Empty name for GUID.', E_USER_ERROR); } //prepare params //add database record $sql = 'INSERT INTO ' . \CB\PREFIX . '_casebox.guids (`name`) VALUES ($1)'; DB\dbQuery($sql, $p['name']) or die(DB\dbQueryError()); $rez = DB\dbLastInsertId(); return $rez; }
/** * add a record * @param array $p associative array with table field values * @return int created id */ public static function create($p) { parent::create($p); //prepare params $params = array(empty($p['object_id']) ? null : $p['object_id'], empty($p['object_pid']) ? null : $p['object_pid'], empty($p['user_id']) ? null : $p['user_id'], empty($p['action_type']) ? null : $p['action_type'], empty($p['data']) ? null : $p['data'], empty($p['data']) ? null : $p['data'], empty($p['activity_data_db']) ? null : $p['activity_data_db'], empty($p['activity_data_solr']) ? null : $p['activity_data_solr']); //add database record $sql = 'INSERT INTO `' . static::$tableName . '` ( `object_id` ,`object_pid` ,`user_id` ,`action_type` ,`data` ,`activity_data_db` ,`activity_data_solr` ) VALUES ($1, $2, $3, $4, $5, $6, $7)'; DB\dbQuery($sql, $params) or die(DB\dbQueryError()); $rez = DB\dbLastInsertId(); return $rez; }
/** * add a record * @param array $p associative array with table field values * @return int created id */ public static function create($p) { parent::create($p); $p = array_intersect_key($p, static::$tableFields); $p['type'] = static::$type; $fields = array_keys($p); $values = array_values($p); //prepare params $params = array_keys($values); $params[] = sizeof($params); array_shift($params); for ($i = 0; $i < sizeof($fields); $i++) { $params[$i] = $fields[$i] == 'password' ? 'MD5(CONCAT(\'aero\', $' . $params[$i] . '))' : '$' . $params[$i]; } //prepare sql $sql = 'INSERT INTO `' . static::$tableName . '` (`' . implode('`,`', $fields) . '`) VALUES (' . implode(',', $params) . ')'; //add database record DB\dbQuery($sql, $values) or die(DB\dbQueryError()); $rez = DB\dbLastInsertId(); return $rez; }
/** * add a record * @param array $p associative array with table field values * @return int created id */ public static function create($p) { \CB\raiseErrorIf(empty($p['name']), 'ErroneousInputData'); return parent::create($p); }
/** * add a record * @param array $p associative array with table field values * @return int created id */ public static function create($p) { $p['type'] = static::$type; $rez = parent::create($p); return $rez; }