function getallmembers($groupid) { $field = 'members'; $resultsarray = array(); if (is_array($groupid)) { foreach ($groupid as $group) { $result = dbs::selrecord($field, 'groups', 'groupid=' . $group, '0', '1'); $memberlist = arrays::array_explode($result[$field], ','); if ($memberslist) { array_merge($resultsarray, $memberlist); } } } else { $result = dbs::selrecord($field, 'groups', 'groupid=' . $groupid, '0', '1'); $resultsarray = arrays::array_explode($result[$field], ','); } return $resultsarray; }
function irrecordArray($table, $valsarray, $showkey) { if ($table && sizeof($valsarray)) { $vals = ''; //Generate column names $cols = dbs::genfieldnames($table, $showkey); $cols = preg_replace('/`|\\s/', '', $cols); //Break up into an array $keyarray = arrays::array_explode($cols, ","); //$valsarray_size = sizeof($valsarray); $valsarray_size = sizeof($keyarray); $sql = "INSERT INTO `{$table}` (" . $cols . ") VALUES"; for ($valueIndex = 0; $valueIndex < sizeof($valsarray); $valueIndex++) { $vals = ''; for ($index = 0; $index < $valsarray_size; $index++) { if ($index != 0) { $vals .= ","; } $vals .= "'" . $valsarray[$valueIndex][$keyarray[$index]] . "'"; } if ($valueIndex != sizeof($valsarray) - 1) { $sql .= "(" . $vals . "),"; } else { $sql .= "(" . $vals . ")"; } } debug::message($sql . '<br><br>'); $result = mysql_query($sql) or die("Couldna execute record insert/replace - " . mysql_errno() . ": " . mysql_error()); return mysql_insert_id(); } return false; }
function testArrayExplode() { $this->assertEqual(arrays::array_explode("", ','), ''); $this->assertEqual(arrays::array_explode("string,string", ','), array('string', 'string')); $this->assertEqual(arrays::array_explode(",,", ','), array('', '', '')); }