private function addPoint() { $user = new User($this->getData()); if ($this->get("group_id") == self::$CLOSED_GROUP) { $timeout = self::$CLOSED_GROUP_TIMEOUT; } else { $timeout = self::$OPEN_GROUP_TIMEOUT; } if ($user->isReadOnly()) { $this->noRightsError(); } else { if (time() - $user->getLastCreate()->getTimeStamp() < $timeout && !$user->isModerator()) { $this->timeOutError(round((time() - $user->getLastCreate()->getTimeStamp()) / 60)); } else { $userId = $this->get('userid'); $db = new DB(); $query = 'INSERT INTO mototimes_events (userid, lat, lng, alignment, transport, text) VALUES(?,?,?,?,?,?)'; $stmt = $db->prepare($query); $stmt->bind_param('iddiis', $userId, $this->get('lat'), $this->get('lng'), $this->get('alignment'), $this->get('transport'), $this->get('text')); $stmt->execute(); if ($stmt->errno != 0) { $this->unknownError(); } else { $query = 'UPDATE mototimes_users SET last_create = NOW() WHERE id_vk=?'; $stmt = $db->prepare($query); $stmt->bind_param('i', $userId); $stmt->execute(); $result = array('response' => 'ok'); $this->setResult($result); } } } }
public function delete($id) { $sql = "DELETE FROM cadastro_funcionario WHERE id = :id"; $stmt = DB::prepare($sql); $stmt->bindParam(':id', $id, PDO::PARAM_INT); return $stmt->execute(); }
protected function makeRelation($concepto, $parent) { if ($this->sthExistsRel == null) { $query = "SELECT count(*) as count FROM relaciones_maestros WHERE id_inf = ? AND id_sup = ? "; $this->sthExistsRel = DB::prepare($query); } $objCount = DB::executeFetch($this->sthExistsRel, array($concepto->id, $parent->id)); if ($objCount->count == 1) { // ya existe la relación no se agrega. return false; } if ($this->sthInsertRel == null) { $query = "INSERT INTO relaciones_maestros (id_sup,id_inf,cantidad,factor,custom_nombre) values (?,?,?,?,?) "; $this->sthInsertRel = DB::prepare($query); } $params = array(); $params[] = $parent->id; $params[] = $concepto->id; $params[] = $concepto->cantidad; $params[] = $concepto->factor; $params[] = isset($concepto->custom_nombre) ? $concepto->custom_nombre : ''; $this->sthInsertRel->execute($params); //echo 'se creo relacion '. $concepto->id . ' ---> '. $parent->id .'\n<br/>' ; return true; }
public function get($ID) { $q = DB::prepare('SELECT * FROM MeCommentMockComment NATURAL JOIN Comment WHERE Comment.ID=:ID'); $q->execute(array(':ID' => $ID)); return self::fetch($q->fetch(), 'MeCommentMockComment'); }
public function get($name) { $q = DB::prepare('SELECT * FROM Bar WHERE ID=:ID'); $q->execute(array(':ID' => $name)); return self::fetch($q->fetch(), 'Bar'); }
public function get($username) { $q = DB::prepare('SELECT * FROM UserProfile WHERE username=:username'); $q->execute(array(':username' => $username)); return self::fetch($q->fetch(), 'UserProfile'); }
/** * Write out the tags for a specific resource. * * @param int $resource_id The story we are tagging. * @param int $channel_id The channel id for the story we are tagging * @param array $tags An array of tags. * * @TODO: Move this to a tagger class that uses Content_Tagger * @return boolean * @throws Jonah_Exception */ public function writeTags($resource_id, $channel_id, $tags) { global $conf; // First, make sure all tag names exist in the DB. $tagkeys = array(); $insert = $this->_db->prepare('INSERT INTO jonah_tags (tag_id, tag_name) VALUES(?, ?)'); $query = $this->_db->prepare('SELECT tag_id FROM jonah_tags WHERE tag_name = ?'); foreach ($tags as $tag) { $tag = Horde_String::lower(trim($tag)); $results = $this->_db->execute($query, $this->_db->escapeSimple($tag)); if ($results instanceof PEAR_Error) { throw new Jonah_Exception($results); } elseif ($results->numRows() == 0) { $id = $this->_db->nextId('jonah_tags'); $result = $this->_db->execute($insert, array($id, $tag)); $tagkeys[] = $id; } else { $row = $results->fetchRow(DB_FETCHMODE_ASSOC); $tagkeys[] = $row['tag_id']; } } // Free our resources. $this->_db->freePrepared($insert, true); $this->_db->freePrepared($query, true); $sql = 'DELETE FROM jonah_stories_tags WHERE story_id = ' . (int) $resource_id; $query = $this->_db->prepare('INSERT INTO jonah_stories_tags (story_id, channel_id, tag_id) VALUES(?, ?, ?)'); Horde::log('SQL query by Jonah_Driver_sql::writeTags: ' . $sql, 'DEBUG'); $this->_db->query($sql); foreach ($tagkeys as $key) { $this->_db->execute($query, array($resource_id, $channel_id, $key)); } $this->_db->freePrepared($query, true); /* @TODO We should clear at least any of our cached counts */ return true; }
public function indexAction() { //get the aff_camapaign_id $mysql['use_pixel_payout'] = 0; //see if it has the cookie in the campaign id, then the general match, then do whatever we can to grab SOMETHING to tie this lead to if ($_COOKIE['btclickid']) { $click_pid = $_COOKIE['btclickid']; } else { //ok grab the last click from this ip_id $mysql['ip_address'] = DB::quote($_SERVER['REMOTE_ADDR']); $daysago = time() - 2592000; // 30 days ago $click_sql1 = "\tSELECT \tbt_s_clicks.click_id\n\t\t\t\t\t\t\tFROM \t\tbt_s_clicks\n\t\t\t\t\t\t\tLEFT JOIN\tbt_s_clicks_advanced USING (click_id)\n\t\t\t\t\t\t\tLEFT JOIN \tbt_s_ips USING (ip_id)\n\t\t\t\t\t\t\tWHERE \tbt_s_ips.ip_address='" . $mysql['ip_address'] . "'\n\t\t\t\t\t\t\tAND\t\tbt_s_clicks.time >= '" . $daysago . "'\n\t\t\t\t\t\t\tORDER BY \tbt_s_clicks.click_id DESC\n\t\t\t\t\t\t\tLIMIT \t\t1"; $click_row1 = DB::getRow($click_sql1); $click_pid = base_convert($click_row1['click_id'], 10, 36); $mysql['ad_account_id'] = DB::quote($click_row1['ad_account_id']); } $click = ClickModel::model()->getRow(array('conditions' => array('click_id' => base_convert($click_pid, 36, 10)))); if (!$click) { BTApp::end(); } if ($click->get('ad_account_id')) { if (getArrayVar($_GET, 'amount') && is_numeric($_GET['amount'])) { $mysql['use_pixel_payout'] = 1; } if ($mysql['use_pixel_payout'] == 1) { $click->convert(0, $_GET['amount']); } else { $click->convert(); } if ($click->campaign->option('pixel_type')->value) { $sql = "select v1.var_value as v1, v2.var_value as v2, v3.var_value as v3, v4.var_value as v4 from bt_s_clicks_advanced adv\n\t\t\t\t\tleft join bt_s_variables v1 on (v1.var_id=adv.v1_id)\n\t\t\t\t\tleft join bt_s_variables v2 on (v2.var_id=adv.v2_id)\n\t\t\t\t\tleft join bt_s_variables v3 on (v3.var_id=adv.v3_id)\n\t\t\t\t\tleft join bt_s_variables v4 on (v4.var_id=adv.v4_id)\n\t\t\t\t\twhere adv.click_id=?"; $st = DB::prepare($sql); $st->execute(array($click->id())); $row = $st->fetch(); $data['v1'] = $row['v1']; $data['v2'] = $row['v2']; $data['v3'] = $row['v3']; $data['v4'] = $row['v4']; $data['clickid'] = $click->id(); $data['keyword'] = ''; $data['amount'] = $click->payout; $code = replaceTrackerPlaceholders($click->campaign->option('pixel_code')->value, $data); $code = str_replace('[[amount]]', $data['amount'], $code); switch ($click->campaign->option('pixel_type')->value) { case 1: case 2: case 3: echo $code; break; case 4: $ch = curl_init($code); curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 Postback-Bot v1.0'); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_exec($ch); break; } } } }
public function delete($id) { $sql = "DELETE FROM {$this->table} WHERE id = :id"; $stmt = DB::prepare($sql); $stmt->bindParam(':id', $id, PDO::PARAM_INT); return $stmt->execute(); }
public function get($ID) { $q = DB::prepare('Select * FROM AnonProfile WHERE ID=:ID'); $q->execute(array(':ID' => $ID)); return self::fetch($q->fetch(), 'AnonProfile'); }
public static function createPGPKey($username, $password) { // Can't create a pgp key without a name or a password. // Also, if they shouldn't have a whitespace in their name but if they do somehow it could be an exploit. if (empty($username) || empty($password)) { return false; } elseif (preg_match('/(\\s|\\n|\\r|\\/|\\.)/', $username) || preg_match('/\\s\\n\\r/', $password)) { trigger_error("{$username} attempted exploit! - PGP Key creation"); return false; } // Create batch script for user. // RSA Keys // 2048 bit file_put_contents("/tmp/{$username}", "Key-Type: default\n\t\t\tSubkey-Type: default\n\t\t\tName-Real: {$username}\n\t\t\tName-Comment: generated key for securechatty\n\t\t\tName-Email: noreply@securechatty.com\n\t\t\tExpire-Date: 0\n\t\t\tPassphrase: {$password}\n\t\t\t%pubring /tmp/{$username}.pub\n\t\t\t%secring /tmp/{$username}.sec\n\t\t\t%commit"); // Create the keys $file = escapeshellarg('/tmp/' . $username); exec("gpg2 --gen-key --batch {$file}"); // Retrieve the keys $publickey = file_get_contents("/tmp/{$username}.pub"); $privatekey = file_get_contents("/tmp/{$username}.sec"); // Remove all unneeded files. unlink("/tmp/{$username}"); unlink("/tmp/{$username}.pub"); unlink("/tmp/{$username}.sec"); if (empty($publickey) || empty($privatekey)) { trigger_error("Key generation failed for {$username}!"); return false; } $db = new DB(); $update = $db->prepare("UPDATE users SET\n\t\t\t\tpublickey = :publickey,\n\t\t\t\tprivatekey = :privatekey\n\t\t\t WHERE username = :username"); $update->execute(array(':publickey' => $publickey, ':privatekey' => $privatekey, ':username' => $username)); return true; }
function getDBUsage($domainID) { $dbSize = 0; // get database information for given domain $sql_param = array(':domain_id' => $domainID); $sql_query = "\n\t\t\tSELECT\n\t\t\t\tsqld_id, sqld_name\n\t\t\tFROM\n\t\t\t\tsql_database\n\t\t\tWHERE\n\t\t\t\tdomain_id = :domain_id\n\t\t"; DB::prepare($sql_query); $sqlData = DB::execute($sql_param); // get usage for each database $sql_query = ' SELECT sum(data_length + index_length) size FROM information_schema.tables WHERE table_schema = :table_schema GROUP BY table_schema '; while ($row = $sqlData->fetch()) { $sql_param = array(':table_schema' => $row['sqld_name']); DB::prepare($sql_query); $sqlSize = DB::execute($sql_param, true); $dbSize += $sqlSize[0]; } return $dbSize; }
public function delete($id) { $qry = "DELETE FROM {$this->tabela} WHERE id = :id"; $stm = DB::prepare($qry); $stm->bindParam(':id', $id, PDO::PARAM_INT); return $stm->execute(); }
function menu_delete_db() { $s = DB::prepare('DROP TABLE IF EXISTS MenuEntry'); $s->execute(); $s = DB::prepare('DROP TABLE IF EXISTS Menu'); $s->execute(); }
private function findFree() { $args = array(); $wheres = array(); foreach ($this->_fixed as $fix) { $fixDB = $fix.'_db'; $args[':'.$fix] = $this->_object->$fixDB; $wheres[] = $fix.'=:'.$fix; } $wheres[] = $this->_normalized .'=:_a'; $q = DB::prepare('SELECT * FROM ' . $this->_class . ' WHERE '. implode(' AND ', $wheres)); $f = $this->_toNormalize; $base = $this->normalize($this->_object->$f); $i = 0; $full = $base; $args[':_a'] = $full; $q->execute($args); while ($q->fetch()) { $i++; $full = $base.$i; $args[':_a'] = $full; $q->execute($args); } return $full; }
function check_login() { global $db, $mem; if (defined('MEM') && MEM == True) { $mem = new Memcached('moyoj'); $mem->setOption(Memcached::OPT_LIBKETAMA_COMPATIBLE, true); if (!count($mem->getServerList())) { $mem->addServer(MEM_HOST, MEM_PORT); } } $db = new DB(); $db->init(DB_HOST, DB_USER, DB_PASS, DB_NAME); $db->connect(); $admin_info = mo_read_cache('mo-admin-' . $_SESSION['aid']); if (!$admin_info) { $sql = 'SELECT `id`, `username`, `password`, `nickname`, `role` FROM `mo_admin` WHERE `id` = ? AND `role` > 0'; $db->prepare($sql); $db->bind('i', $_SESSION['aid']); $result = $db->execute(); if (!$result || $result[0]['password'] != $_SESSION['admin_password']) { unset($_SESSION['aid']); header("Location: login.php"); exit(0); } mo_write_cache('mo-admin-' . $_SESSION['aid'], $result[0]); } $mo_settings = array(); mo_load_settings(); if (!isset($active)) { $active = ''; } }
/** * @return mixed */ public static function CreatePDNSPass() { System_Daemon::debug('Starting "DaemonConfigDNS::createPDNSPass" subprocess.'); $xml = simplexml_load_file(DaemonConfig::$cfg->{'CONF_DIR'} . '/tpl/EasySCP_Config_DNS.xml'); System_Daemon::debug('Building the new pdns config file'); $xml->{'PDNS_USER'} = 'powerdns'; $xml->{'PDNS_PASS'} = DB::encrypt_data(DaemonCommon::generatePassword(18)); $xml->{'HOSTNAME'} = idn_to_ascii(DaemonConfig::$cfg->{'DATABASE_HOST'}); $handle = fopen(DaemonConfig::$cfg->{'CONF_DIR'} . '/EasySCP_Config_DNS.xml', "wb"); fwrite($handle, $xml->asXML()); fclose($handle); DaemonCommon::systemSetFilePermissions(DaemonConfig::$cfg->{'CONF_DIR'} . '/EasySCP_Config_DNS.xml', DaemonConfig::$cfg->{'ROOT_USER'}, DaemonConfig::$cfg->{'ROOT_GROUP'}, 0640); // Create/Update Powerdns control user account if needed System_Daemon::debug('Adding the PowerDNS control user'); $sql_param = array(':PDNS_USER' => $xml->{'PDNS_USER'}, ':PDNS_PASS' => DB::decrypt_data($xml->{'PDNS_PASS'}), ':HOSTNAME' => $xml->{'HOSTNAME'}); $sql_query = "\n\t\t\tGRANT ALL PRIVILEGES ON powerdns.* TO :PDNS_USER@:HOSTNAME IDENTIFIED BY :PDNS_PASS;\n\t\t\tFLUSH PRIVILEGES;\n\t\t"; DB::prepare($sql_query); DB::execute($sql_param)->closeCursor(); $sql_param = array(':DATABASE_USER' => DaemonConfig::$cfg->DATABASE_USER, ':DATABASE_HOST' => idn_to_ascii(DaemonConfig::$cfg->{'DATABASE_HOST'})); $sql_query = "\n\t\t\tGRANT ALL PRIVILEGES ON powerdns.* TO :DATABASE_USER@:DATABASE_HOST;\n\t\t\tFLUSH PRIVILEGES;\n\t\t"; DB::prepare($sql_query); DB::execute($sql_param)->closeCursor(); System_Daemon::debug('Finished "DaemonConfigDNS::createPDNSPass" subprocess.'); return true; }
public function changeKarma() { if ($this->isError()) { return false; } $this->setPrerequisites('karma'); $this->checkPrerequisites(); if ($this->isError()) { return false; } $user = new User($this->getData()); if (!$user->isModerator()) { $this->setUpError("NO RIGHTS"); return false; } $karma = $this->karma + $this->get('karma'); $db = new DB(); $query = 'UPDATE mototimes_events SET karma=? WHERE id=?'; $stmt = $db->prepare($query); $stmt->bind_param('ii', $karma, $this->id); $stmt->execute(); if ($stmt->errno) { $this->setUpError(); } else { $result = array('response' => 'ok'); $this->setResult($result); } return true; }
/** * @return mixed */ public static function CreateProFTPdPass() { System_Daemon::debug('Starting "DaemonConfigFTP::CreateProFTPdPass" subprocess.'); $xml = simplexml_load_file(DaemonConfig::$cfg->{'CONF_DIR'} . '/tpl/EasySCP_Config_FTP.xml'); System_Daemon::debug('Building the new ftp config file'); $xml->{'DB_DATABASE'} = DB::$DB_DATABASE; $xml->{'DB_HOST'} = idn_to_ascii(DaemonConfig::$cfg->{'DATABASE_HOST'}); $xml->{'FTP_USER'} = 'vftp'; $xml->{'FTP_PASSWORD'} = DB::encrypt_data(DaemonCommon::generatePassword(18)); $handle = fopen(DaemonConfig::$cfg->{'CONF_DIR'} . '/EasySCP_Config_FTP.xml', "wb"); fwrite($handle, $xml->asXML()); fclose($handle); System_Daemon::debug('Create/Update Proftpd SQL user data'); $sql_param = array(':DATABASE_HOST' => $xml->{'DB_HOST'}, ':FTP_USER' => $xml->{'FTP_USER'}, ':FTP_PASSWORD' => DB::decrypt_data($xml->{'FTP_PASSWORD'})); $sql_query = "\n\t\t\tGRANT SELECT,INSERT,UPDATE,DELETE ON ftp_group TO :FTP_USER@:DATABASE_HOST IDENTIFIED BY :FTP_PASSWORD;\n\t\t\tGRANT SELECT,INSERT,UPDATE,DELETE ON ftp_log TO :FTP_USER@:DATABASE_HOST IDENTIFIED BY :FTP_PASSWORD;\n\t\t\tGRANT SELECT,INSERT,UPDATE,DELETE ON ftp_users TO :FTP_USER@:DATABASE_HOST IDENTIFIED BY :FTP_PASSWORD;\n\t\t\tGRANT SELECT,INSERT,UPDATE,DELETE ON quotalimits TO :FTP_USER@:DATABASE_HOST IDENTIFIED BY :FTP_PASSWORD;\n\t\t\tGRANT SELECT,INSERT,UPDATE,DELETE ON quotatallies TO :FTP_USER@:DATABASE_HOST IDENTIFIED BY :FTP_PASSWORD;\n\t\t\tFLUSH PRIVILEGES;\n\t\t"; DB::prepare($sql_query); DB::execute($sql_param)->closeCursor(); /* $xml = simplexml_load_file(DaemonConfig::$cfg->{'ROOT_DIR'} . '/../setup/config.xml'); System_Daemon::debug('Create/Update Proftpd SQL user data'); $sql_param = array( ':DATABASE_HOST'=> $xml->{'DB_HOST'}, ':FTP_USER' => $xml->{'FTP_USER'}, ':FTP_PASSWORD' => $xml->{'FTP_PASSWORD'} ); $sql_query = " GRANT SELECT,INSERT,UPDATE,DELETE ON ftp_group TO :FTP_USER@:DATABASE_HOST IDENTIFIED BY :FTP_PASSWORD; GRANT SELECT,INSERT,UPDATE,DELETE ON ftp_log TO :FTP_USER@:DATABASE_HOST IDENTIFIED BY :FTP_PASSWORD; GRANT SELECT,INSERT,UPDATE,DELETE ON ftp_users TO :FTP_USER@:DATABASE_HOST IDENTIFIED BY :FTP_PASSWORD; GRANT SELECT,INSERT,UPDATE,DELETE ON quotalimits TO :FTP_USER@:DATABASE_HOST IDENTIFIED BY :FTP_PASSWORD; GRANT SELECT,INSERT,UPDATE,DELETE ON quotatallies TO :FTP_USER@:DATABASE_HOST IDENTIFIED BY :FTP_PASSWORD; FLUSH PRIVILEGES; "; DB::prepare($sql_query); DB::execute($sql_param)->closeCursor(); if (!file_exists(DaemonConfig::$cfg->{'CONF_DIR'} . '/EasySCP_Config_FTP.xml')) { $ftp = simplexml_load_file(DaemonConfig::$cfg->{'CONF_DIR'} . '/tpl/EasySCP_Config_FTP.xml'); System_Daemon::debug('Building the new ftp config file'); $ftp->{'DB_DATABASE'} = $xml->{'DB_DATABASE'}; $ftp->{'DB_HOST'} = $xml->{'DB_HOST'}; $ftp->{'FTP_USER'} = $xml->{'FTP_USER'}; $ftp->{'FTP_PASSWORD'} = DB::encrypt_data($xml->{'FTP_PASSWORD'}); $handle = fopen(DaemonConfig::$cfg->{'CONF_DIR'} . '/EasySCP_Config_FTP.xml', "wb"); fwrite($handle, $ftp->asXML()); fclose($handle); } */ System_Daemon::debug('Finished "DaemonConfigFTP::CreateProFTPdPass" subprocess.'); return true; }
public static function enqueue(DB $db, $handler, array $message) { if (!isset(self::$handlers[$handler])) { throw new UnexpectedValueException('Unsupported handler (' . $handler . ').'); } $prepared = $db->prepare("\n\t\t\tINSERT INTO `jobs` (\n\t\t\t\t`handler`,\n\t\t\t\t`status`,\n\t\t\t\t`message`\n\t\t\t) VALUES (\n\t\t\t\t:handler,\n\t\t\t\t:status,\n\t\t\t\t:message\n\t\t\t)\n\t\t"); $result = $prepared->execute([':handler' => $handler, ':status' => self::QUEUED, ':message' => JSON::encode($message)]); }
/** * Prepares a query for multiple execution with the get methods * * Creates a query that can be run multiple times. Each time it is run, * the placeholders, if any, will be replaced by the contents of * get methods $data arguement. * * Get methods are: getOne, getAll, getColumn, getRow * * Three types of placeholders can be used: * + <kbd>?</kbd> scalar value (i.e. strings, integers). The system * will automatically quote and escape the data. * + <kbd>!</kbd> value is inserted 'as is' * + <kbd>&</kbd> requires a file name. The file's contents get * inserted into the query (i.e. saving binary * data in a db) * * Example 1. * <code> * $sth = $db->prepare('INSERT INTO tbl (a, b, c) VALUES (?, !, &)'); * $data = array( * "John's text", * "'it''s good'", * 'filename.txt' * ); * $res = $db->getAll($sth, $data); * </code> * * Use backslashes to escape placeholder characters if you don't want * them to be interpreted as placeholders: * <pre> * "UPDATE foo SET col=? WHERE col='over \& under'" * </pre> * * With some database backends, this is emulated. * * <b>This documentation was taken from: http://pear.php.net/package/DB/docs/1.7.6/DB/DB_common.html#methodprepare and modified</b> * * @param string $sql the query to be prepared * * @throws An exception in the event of an error */ public function prepare($sql) { $result = $this->conn->prepare($sql); if (DB::isError($result)) { throw new LoggedException($result->getMessage(), $result->getCode(), self::module); } return $result; }
public function findUsuariofetchAll($id_usuario) { $sql = "SELECT id_usuario, status, permissao FROM {$this->table} WHERE id_usuario = :id_usuario"; $stmt = DB::prepare($sql); $stmt->bindParam(':id_usuario', $id_usuario, PDO::PARAM_INT); $stmt->execute(); return count($stmt->fetchAll()) > 0; }
function get_listAll() { $sql = "SELECT * FROM fornecedores"; $stmt = DB::prepare($sql); $stmt->execute(); $result = $stmt->fetchAll(); return $result; }
/** * Remove uma resposta * @param int $id ID da resposta * @return bool TRUE em caso de sucesso, FALSE em falhas */ public static function delete($id) { $DB = new \DB(); $sql = "DELETE FROM answers WHERE id = :id"; $stmt = $DB->prepare($sql); $stmt->bindParam(':id', $id, \PDO::PARAM_INT); return $stmt->execute(); }
public function delete($montadora) { DB::beginTransaction(); $smtm = DB::prepare($this->sqlDelete); $smtm->bindParam("ID", $montadora->id); $smtm->execute(); DB::commit(); }
public function update($id) { $sql = "UPDATE {$this->table} SET nome = ?, email = ? WHERE id = ?"; $stmt = DB::prepare($sql); $stmt->bindParam(1, $this->usuario); $stmt->bindParam(2, $this->senha); $stmt->bindParam(3, $id); return $stmt->execute(); }
function __construct() { $query = "SELECT * FROM subfamilias WHERE id_familia = ? and id_parent is null ORDER BY nombre"; $this->sthSubFamOfF = DB::prepare($query); $query = "SELECT * FROM subfamilias WHERE id_parent = ? ORDER BY nombre"; $this->sthSubFam = DB::prepare($query); $query = "select c.nombre,c.nombre_feed, c.minimo,c.maximo, " . "\ttmp.id as tmp_id, tmp.precio as tmp_precio,tmp.date as tmp_date, " . " tmp.minimo as tmp_minimo, tmp.maximo as tmp_maximo " . " FROM conceptos_maestros c " . " LEFT JOIN precios_insumos_tmp as tmp on tmp.id_concepto_maestro = c.id " . " WHERE c.tipo = 3 AND c.feed = 1 " . "\tAND c.id in (select DISTINCT id_concepto FROM conceptos_subfamilias_maestros where id_subfamilia = ?) "; $this->sthInsumosFam = DB::prepare($query); }
public function update($id) { $sql = "UPDATE {$this->table} SET nome = :nome, email = :email WHERE id = :id"; $stmt = DB::prepare($sql); $stmt->bindParam(':nome', $this->nome); $stmt->bindParam(':email', $this->email); $stmt->bindParam(':id', $id); return $stmt->execute(); }
/** * @brief Retrieves existing buildset. * * @param buildsetid Buildset ID. * * @returns Buildset object or @c null if there is no such buildset. */ public static function get($buildsetid) { $sql = 'SELECT name, revision, timestamp FROM buildsets ' . 'WHERE buildsetid = ?'; $statement = DB::prepare($sql); if (!$statement || $statement->execute([$buildsetid]) !== true || ($buildsetinfo = $statement->fetch()) === false) { return null; } return new Buildset($buildsetid, $buildsetinfo['name'], $buildsetinfo['revision'], $buildsetinfo['timestamp']); }
function blog_delete_db() { $s = DB::prepare('DROP TABLE IF EXISTS BlogSearchIndex'); $s->execute(); $s = DB::prepare('DROP TABLE IF EXISTS BlogComment'); $s->execute(); $s = DB::prepare('DROP TABLE IF EXISTS Blog'); $s->execute(); }