/** * @return Boolean * @param String $table * @param String $where * @desc See if a field match sql query is in the DB */ function existence_complex($table, $where) { $row = dbs::selrecord('*', $table, $where, '0', '0'); if (dbs::numrecords($row)) { return true; } return false; }
if (!isset($start)) { // record number to start the query from $start = 0; } // limit the number of records returned $end = 10; if ($mode == 'preview') { $check = dbs::selrecord('*', $table, $sql, '0', '0'); $count = dbs::numrecords($check); $result = dbs::selrecord('*', $table, $sql, 'name ASC LIMIT ' . $start . ',' . $end, '0'); $final = dbs::numrecords($result); } else { $check = dbs::selrecord('*', $table, '0', '0', '0'); $count = dbs::numrecords($check); $result = dbs::selrecord('*', $table, '0', 'name ASC LIMIT ' . $start . ',' . $end, '0'); $final = dbs::numrecords($result); } if ($count > 0) { hr(2); ?> <tr> <td class="bodybold">GROUPNAME</td><td class="bodybold" align="right">ACTIONS</td> </tr> <?php while ($row = dbs::fetchrecord($result)) { hr(2); ?> <tr> <td valign="top" class="bodybold" title="ID: <?php echo $row[$key]; ?>
/** * @return Array * @param unknown $name * @param unknown $dbfield * @param unknown $displayfield * @param unknown $current * @param unknown $populate * @param unknown $populatevalues * @param unknown $where * @param unknown $orderby * @desc returns all data for a select box populated from a db table or array */ function getdata_select_extra($name, $dbfield, $displayfield, $current, $populate, $populatevalues, $where, $orderby) { $index = 0; if (!is_array($populate)) { // populate from table if ($siteid && !$where) { $where = 'siteid=' . $s_siteid; } elseif ($where && $siteid) { $where = ' AND siteid=' . $s_siteid; } $rows = dbs::selrecord($dbfield . ',' . $displayfield, $populate, $where, $orderby, '0'); if (dbs::numrecords($rows) != 0) { // No results returned while ($row = dbs::fetchrecord($rows)) { if (preg_match("/,/", $displayfield)) { $display = ''; $displays = explode(",", $displayfield); for ($i = 0; $i < count($displays); $i++) { $display .= $row[$displays[$i]] . '&%&'; } } else { $display = $row[$displayfield]; } $resultpackage[$index] = formdata::select_createpackage($row[$dbfield], $current, $display); $index++; } } else { $resultpackage = false; } } else { // populate from an array if (sizeof($populate) != 0) { // no results returned $popvalsindex = 0; foreach ($populate as $element) { if ($populatevalues) { // an array has been provided to populate values $resultpackage[$index] = formdata::select_createpackage($element, $current, $populatevalues[$popvalsindex]); } else { // use the populate array as the values and the display values $resultpackage[$index] = formdata::select_createpackage($element, $current, $element); } $index++; $popvalsindex++; } } else { $resultpackage = false; } } // all setup data goes here in the last element $resultpackage[$index]['optionname'] = $name; return $resultpackage; }