function DBDelete($table, $where = null) { $table = DB_PREFIX . $table; $where = $where ? " WHERE {$where}" : null; $query = "DELETE FROM {$table}{$where}"; return DBExecute($query); }
function DBCreate($table, array $data) { // Inserção de valores na tabela $data = DBProtect($data); $fields = implode(', ', array_keys($data)); $values = "'" . implode(', ', $data) . "'"; $query = "INSERT INTO {$table} ( {$fields} ) VALUES ( {$values} )"; return DBExecute($query); }
function DBCreate($table, array $data, $insertId = false) { $table = DB_PREFIX . '_' . $table; $data = DBEscape($data); $fields = implode(', ', array_keys($data)); $values = "'" . implode("', '", $data) . "'"; $query = "INSERT INTO {$table} ( {$fields} ) VALUES ( {$values} )"; return DBExecute($query, $insertId); }
function DBRead($table, $params = null, $fields = '*') { $table = DB_PREFIX . '_' . $table; $params = $params ? " {$params}" : null; $query = "SELECT {$fields} FROM {$table}{$params}"; $result = DBExecute($query); if (!mysqli_num_rows($result)) { return false; } else { while ($res = mysqli_fetch_assoc($result)) { $data[] = $res; } return $data; } }
function remove_service_links($serviceid) { $query = 'DELETE FROM services_links WHERE serviceupid=' . $serviceid . ' OR (servicedownid=' . $serviceid . ' AND soft<>1)'; DBExecute($query); }
<?php require 'config.php'; require 'connection.php'; require 'database.php'; //$db_name = $_GET['db_name']; $sql = "SELECT nome FROM categoria"; $query = DBExecute($sql); while ($exibe = mysqli_fetch_assoc($query)) { echo $exibe['nome'] . '<br/>'; }
function DBSelect($fields = '*', $table, $args = null, $link) { $query = "SELECT {$fields} FROM {$table} {$args}"; return DBExecute($link, $query); }
/** * Delete UserMacros * * {@source} * @access public * @static * @since 1.8 * @version 1 * * @param array $globalmacroids * @param array $globalmacroids['globalmacroids'] * @return boolean */ public static function deleteGlobal($globalmacros) { $globalmacros = zbx_toArray($globalmacros); try { self::BeginTransaction(__METHOD__); if (empty($globalmacros)) { self::exception(ZBX_API_ERROR_PARAMETERS, 'Empty input parameter'); } // permissions + existance $options = array('filter' => array('macro' => $globalmacros), 'globalmacro' => 1, 'editable' => 1, 'output' => API_OUTPUT_EXTEND); $db_gmacros = self::get($options); $db_gmacros = zbx_toHash($db_gmacros, 'macro'); foreach ($globalmacros as $mnum => $gmacro) { if (!isset($db_gmacros[$gmacro])) { self::exception(ZBX_API_ERROR_PERMISSIONS, S_NO_PERMISSION); } } //-------- $sql = 'DELETE FROM globalmacro WHERE ' . DBcondition('macro', $globalmacros, false, true); if (!DBExecute($sql)) { self::exception(ZBX_API_ERROR_PARAMETERS, 'DBerror'); } self::EndTransaction(true, __METHOD__); return array('globalmacroids' => zbx_objectValues($db_gmacros, 'globalmacroid')); } catch (APIException $e) { self::EndTransaction(false, __METHOD__); $error = $e->getErrors(); $error = reset($error); self::setError(__METHOD__, $e->getCode(), $error); return false; } }