function dumpData($table, $style, $query) { if ($_POST["format"] == "json") { if ($this->database) { echo ",\n"; } else { $this->database = true; echo "{\n"; register_shutdown_function(array($this, '_database')); } $connection = connection(); $result = $connection->query($query, 1); if ($result) { echo '"' . addcslashes($table, "\r\n\"\\") . "\": [\n"; $first = true; while ($row = $result->fetch_assoc()) { echo $first ? "" : ", "; $first = false; foreach ($row as $key => $val) { json_row($key, $val); } json_row(""); } echo "]"; } return true; } }
public function join($guild_name, $player_name) { $guild_name = (int) $guild_name; $player_name = (int) $player_name; $ide = new IDE(); if (empty($guild_name) or empty($player_name)) { $ide->redirect(WEBSITE . "/index.php/guilds"); } $ots = POT::getInstance(); $ots->connect(POT::DB_MYSQL, connection()); $guild = $ots->createObject('Guild'); $guild->load($guild_name); if (!$guild->isLoaded()) { $ide->redirect(WEBSITE . "/index.php/guilds"); } $player = new OTS_Player(); $player->load($player_name); if (!$player->isLoaded()) { $ide->redirect(WEBSITE . "/index.php/guilds"); } if ($player->getAccount()->getId() != $_SESSION['account_id']) { $ide->redirect(WEBSITE . "/index.php/guilds"); } require_once 'system/application/libraries/POT/InvitesDriver.php'; new InvitesDriver($guild); $invited_list = $guild->listInvites(); if (!in_array($player->getId(), $invited_list)) { $ide->redirect(WEBSITE . "/index.php/guilds"); } $guild->acceptInvite($player); $ide->redirect(WEBSITE . "/index.php/guilds/view/" . $guild->getId() . "/1"); }
public function createGuild($name, $character) { $ots = POT::getInstance(); $ots->connect(POT::DB_MYSQL, connection()); $player = new OTS_Player(); $player->load($character); $new_guild = new OTS_Guild(); $new_guild->setCreationData(time()); $new_guild->setName($name); $new_guild->setOwner($player); $new_guild->save(); $new_guild->setCustomField('motd', 'New guild. Leader must edit this text :)'); $new_guild->setCustomField('creationdata', time()); $new_guild->setCustomField('world_id', $player->getWorld()); $ranks = $new_guild->getGuildRanksList(); $ranks->orderBy('level', POT::ORDER_DESC); foreach ($ranks as $rank) { if ($rank->getLevel() == 3) { $player->setRank($rank); $player->save(); } } $ide = new IDE(); $ide->redirect(WEBSITE . "/index.php/guilds/view/" . $new_guild->getId()); success("{$name} has been created."); }
function create() { $ide = new IDE(); if ($ide->isLogged()) { $ide->redirect('../account'); } $this->load->helper('form'); if ($_POST) { $this->load->library('form_validation'); $this->form_validation->set_rules('name', 'Account Name', 'required|min_length[4]|max_length[32]|callback__account_exists|alpha'); $this->form_validation->set_rules('password', 'Password', 'required|matches[repeat]|min_length[4]|max_length[255]'); $this->form_validation->set_rules('email', 'Email', 'required|valid_email'); if ($this->form_validation->run() == TRUE) { require APPPATH . 'config/ide_default.php'; $ots = POT::getInstance(); $ots->connect(POT::DB_MYSQL, connection()); $account = new OTS_Account(); $name = $account->createNamed($_POST['name']); $account->setPassword($_POST['password']); $account->setEmail($_POST['email']); $account->setCustomField('premdays', PREMDAYS); try { $account->save(); $_SESSION['logged'] = 1; $_SESSION['name'] = $_POST['name']; $ide->redirect('../account'); } catch (Exception $e) { error($e->getMessage()); } } } #Load view of creating account $this->load->view('create'); }
function connection($conn_id, $ftp_user_name, $ftp_user_pass) { if (ftp_login($conn_id, $ftp_user_name, $ftp_user_pass)) { echo "Login was successfull"; } else { echo "Login failed"; connection($conn_id, $ftp_user_name, $ftp_user_pass); } }
function deleteMod($id) { $db = connection(); // tungod wala gi include sa index ang delete.php mao di makita ang conn() $sql = "UPDATE agency_user SET status = 'I' WHERE agencyUserId = {$id} "; $s = $db->prepare($sql); $s->execute(); $db = null; }
/** * Executa a exclusão no banco de dados * @return boolean */ public function run() { try { $delete = connection()->prepare($this->sql()); $delete->bindValue(':' . $this->data->getReference(), $this->data->getValue(), $this->data->getType()); return $delete->execute(); } catch (\PDOException $exc) { echo $exc->getMessage(); } }
function messageQuery($query) { //! doesn't work with sql.inc.php $connection = connection(); $result = $connection->query('SHOW MASTER STATUS'); if ($result) { restart_session(); $_SESSION["master"] = $result->fetch_assoc(); } }
function retrieve_subcategory($id) { $db = connection(); $sql = "select * from sub_category where category_id=?"; $st = $db->prepare($sql); $st->execute(array($id)); $result = $st->fetchAll(); return $result; $db = null; }
function selectEmailProcess($where, $foreignKeys) { $connection = connection(); if ($_POST["email_id"]) { $result = $connection->query("SELECT {$this->subject}, {$this->message} FROM {$this->table} WHERE {$this->id} = " . q($_POST["email_id"])); $row = $result->fetch_row(); $_POST["email_subject"] = $row[0]; $_POST["email_message"] = $row[1]; } }
function mappedConnection($mappedName) { static $configs; if (null === $configs) { $configs = (include_once APP_DIR . '/config/mapping.php'); } if (array_key_exists($mappedName, $configs)) { return connection($configs[$mappedName]); } return null; }
function query($query_string) { if (DATABASE_TYPE == "mysql") { $query = mysqli_query(connection(), $query_string); } elseif (DATABASE_TYPE == "sqlite") { $query = sqlite_query(connection(), $query_string); } elseif (DATABASE_TYPE == "pgsql") { $query = pg_query(connection(), $query_string); } return $query; }
function echo_all_db_user_data() { connection(); mysql_query(" SET NAMES 'utf8'"); $user_name = $_SESSION["user"]; $result_query = mysql_query("SELECT user_name, mark, date FROM stats WHERE user_name='{$user_name}'"); $row = mysql_fetch_array($result_query); do { printf("<p><table id='restab'>\n <tr>\n <td colspan='2'><strong>%s %s</strong></td>\n </tr>\n <tr>\n <td>Оценка:</td>\n <td>%s</td>\n </tr>\n <tr>\n <td>Дата сдачи</td>\n <td>%s</td>\n </tr>\n </table></p>", $row['user_name'], $row['id_stat'], $row['mark'], $row['date']); } while ($row = mysql_fetch_array($result_query)); }
function selectAll() { include '../connection.php'; $mysqli = connection(); $result = $mysqli->query('SELECT id, ref, des, qte, sa, dim, sdp, ger FROM tableau'); $tableau = $sql->fetchAll(); foreach ($tableau as $row) { foreach ($row as $fieldname => $field) { echo $fieldname . ' => ' . $field . '<br/>'; } } }
function dumpData($table, $style, $query) { if ($_POST['format'] == 'php') { $connection = connection(); $result = $connection->query($query, 1); if ($result) { while ($row = $result->fetch_assoc()) { $this->output[$table][] = $row; } } return true; } }
/** * Used to send data to the database, such as INSERT or DELETE statements. * Passing in a connection is optional. */ function boolQuery($query, $conn = null) { if ($conn == null) { $close = true; $conn = connection(); } else { $close = false; } if ($conn->query($query) === FALSE) { echo "Error: " . $sql . "<br>" . $conn->error; } if ($close) { $conn->close(); } }
function singleQuery($sql, $values, $column_names) { $dbh = connection(); $sth = $dbh->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY)); $sth->execute($values); $result = array(); $i = 0; while ($row = $sth->fetch(PDO::FETCH_ASSOC)) { $col = array(); foreach ($column_names as $col_name) { $col[$col_name] = $row[$col_name]; } $result[$i] = $col; $i += 1; } return $result; }
public function test_database() { $conn = connection(); $this->test(1, $conn); $conn->connect(); $this->test(2, $conn); $conn->disconnect(); $this->test(3, $conn); $this->test(4, $conn->query('SELECT 1')); $this->test(5, $conn); $this->test(6, $conn->query('SELECT 1 AS `test`')->fetch_object()); $conn->disconnect(); $conn->reconnect(); $this->test(7, $conn); $this->set_prefix('fake'); $conn = connection('fake'); $this->test(1, $conn->get_connection_string()); $this->test(2, $conn->get_connection_string()); $this->test(3, $conn->get_property('driver')); $this->test(4, $conn->get_property('username')); $this->test(5, $conn->get_property('password')); $this->test(6, $conn->get_property('port')); $this->test(7, $conn->get_property('database')); $this->test(8, $conn->get_property('persistent')); $this->test(9, $conn->get_property('connect')); $this->test(10, $conn->get_property('charset')); $this->test(11, $conn->set_property('driver', 'pdo'), 'currently only for test'); $this->test(12, $conn->set_property('username', 'newuser')); $this->test(13, $conn->set_property('password', 'oldpass')); $this->test(14, $conn->set_property('port', 2012)); $this->test(15, $conn->set_property('database', 'samedatabase')); $this->test(16, $conn->set_property('persistent', 'on')); $this->test(17, $conn->set_property('connect', 'yes')); $this->test(18, $conn->set_property('charset', 'utf8')); $this->test(19, $conn->get_connection_string()); $this->set_prefix('fake2'); $conn = connection('fake2'); $this->test(1, $conn->get_connection_string()); $this->set_prefix('fake3'); $conn = connection('fake3'); $this->test(1, $conn->get_connection_string()); }
function _translate($idf) { static $translations, $lang; if (!isset($lang)) { $lang = get_lang(); } if ($idf == "" || $lang == "en") { return $idf; } if (!isset($translations)) { $translations = get_key_vals("SELECT idf, translation FROM translation WHERE language_id = " . q($lang)); } $return =& $translations[$idf]; if (!isset($return)) { $return = $idf; $connection = connection(); $connection->query("INSERT INTO translation (language_id, idf, translation) VALUES (" . q($lang) . ", " . q($idf) . ", " . q($idf) . ")"); } return $return; }
function q($sql, $params = array(), $c = null) { if ($c == null) { $c = connection(); } if (sizeof($params) > 0) { $prep = array(); foreach ($params as $i => $v) { $prep[$i] = is_array($v) && isset($v["expr"]) ? $v["expr"] : (is_string($v) ? "'" . $c["conn"]->escapeString($v) . "'" : (is_bool($v) ? (int) $v : ($v === null ? "NULL" : $c["conn"]->escapeString($v)))); } $res = $c["conn"]->query(lastsql(vsprintf($sql, $prep))); } else { $res = $c["conn"]->query(lastsql($sql)); } if (!$res) { trigger_error(lastdberror($c["conn"]->lastErrorCode() . ": " . $c["conn"]->lastErrorMsg()), E_USER_WARNING); return $res; } return array(0, $res); }
function dumpData($table, $style, $query) { if ($_POST["format"] == "xml") { if (!$this->database) { $this->database = true; echo "<database name='" . h(DB) . "'>\n"; register_shutdown_function(array($this, '_database')); } $connection = connection(); $result = $connection->query($query, 1); if ($result) { while ($row = $result->fetch_assoc()) { echo "\t<table name='" . h($table) . "'>\n"; foreach ($row as $key => $val) { echo "\t\t<column name='" . h($key) . "'" . (isset($val) ? "" : " null='null'") . ">" . h($val) . "</column>\n"; } echo "\t</table>\n"; } } return true; } }
function viewAllRecords() { $arrayObject = array(); $conn = connection(); $sql = "SELECT * FROM sampleTable"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while ($row = $result->fetch_assoc()) { $object = array(); $object['id'] = $row["id"]; $object['name'] = $row["name"]; $object['date'] = $row["date"]; $object['count'] = $row["count"]; array_push($arrayObject, $object); } } else { echo "0 results"; } $conn->close(); return json_encode($arrayObject); }
public function test_query() { $tests = array(1 => 'SELECT 1;', 3 => 'SELECT [[test]];', 4 => 'SELECT [[[test]]];', 5 => 'SELECT [[[te\\]st]]];', 6 => 'SELECT [this];', 7 => 'SELECT [useful/user];', 8 => 'SELECT [this.id];', 9 => 'SELECT [useful/user.id];', 10 => 'SELECT [useful/user.date_created(date)];', 11 => 'SELECT [useful/user.date_created as date];', 12 => 'SELECT [useful/user.date_created(date) as date];', 13 => 'SELECT [*];', 14 => 'SELECT [this.*];', 15 => 'SELECT [useful/user: id];', 16 => 'SELECT [useful/user: id, name];', 17 => 'SELECT [this: id, name];', 18 => 'SELECT [useful/user: id(type) as test];', 19 => 'SELECT [useful/user: id(type) as test, date(subtype) as subtest];', 20 => 'SELECT [@telefone];', 21 => 'SELECT [@telefone(phone)];', 22 => 'SELECT [@1];', 23 => 'SELECT [@1(phone)];', 24 => 'SELECT [@telefone(phone)?];', 25 => 'SELECT [@telefone?];', 26 => 'SELECT [@telefone?null];'); foreach ($tests as $key => $test) { $this->test($key, core_model_query::parse_query($test), $test); } $this->set_prefix('query'); $conn = connection(); $model = model('useful/user')->model(); $model_args_1 = array('key' => 'test', 'int' => '1234', 'float' => '12.34', 'float2' => '12,34', 'sql' => 'DATE()'); $this->test(1, core_model_query::query($conn, 'SELECT [this];', $model)); $this->test(2, core_model_query::query($conn, 'SELECT [this.id];', $model)); $this->test(3, core_model_query::query($conn, 'SELECT [this.id(int)];', $model)); $this->test(4, core_model_query::query($conn, 'SELECT [this.id(int) as id_user];', $model)); $this->test(5, core_model_query::query($conn, 'SELECT [this: id, name];', $model)); $this->test(6, core_model_query::query($conn, 'SELECT [this.*];', $model)); $this->test(7, core_model_query::query($conn, 'SELECT [@int];', $model, $model_args_1)); $this->test(8, core_model_query::query($conn, 'SELECT [@int(int)];', $model, $model_args_1)); $this->test(9, core_model_query::query($conn, 'SELECT [@float(float)];', $model, $model_args_1)); $this->test(10, core_model_query::query($conn, 'SELECT [@float2(float)];', $model, $model_args_1)); $this->test(11, core_model_query::query($conn, 'SELECT [@float(int)];', $model, $model_args_1)); $this->test(12, core_model_query::query($conn, 'SELECT [@float2(int)];', $model, $model_args_1)); $this->test(13, core_model_query::query($conn, 'SELECT [@sql(sql)];', $model, $model_args_1)); $this->test(14, core_model_query::query($conn, 'SELECT [@key(key)];', $model, $model_args_1)); $this->test(16, core_model_query::query($conn, 'SELECT [@fake(int)?];', $model, $model_args_1)); $this->test(17, core_model_query::query($conn, 'SELECT [@fake(float)?];', $model, $model_args_1)); $this->test(18, core_model_query::query($conn, 'SELECT [@fake(string)?];', $model, $model_args_1)); $this->test(19, core_model_query::query($conn, 'SELECT [@fake?];', $model, $model_args_1)); $this->test(20, core_model_query::query($conn, 'SELECT [@fake(int)?null];', $model, $model_args_1)); $this->test(21, core_model_query::query($conn, 'SELECT [@fake?null];', $model, $model_args_1)); $this->set_prefix('model'); $row = model('useful/user'); $this->test(1, $row->query('SELECT [this.id] FROM [this] ORDER BY [this.id];')->fetch_object()); $this->test(2, $row->query('SELECT [@test];', array('test' => 'okay'))->fetch_object()); $row = model('useful/user', 1); $this->test(3, $row->query('SELECT [@this.id(int)] AS `test`;')->fetch_object()); }
<?php require './class/db-connection.php'; connection(); session_start(); $msg = ''; $qry = mysql_real_escape_string($_GET['qry']); if (!isset($_GET['qry']) || empty($_GET['qry'])) { header("location:locality-display.php"); } $query = "select * from locality where locality_id='{$qry}' limit 0,1"; $result = mysql_query($query) or die("Error in Selecting Locality :" . mysql_error()); $row = mysql_fetch_array($result); if ($row) { $locality_id = $row['locality_id']; $locality_name = $row['locality_name']; $city_id = $row['city_id']; } if ($_POST) { $locality_id = mysql_real_escape_string($_POST['locality_id']); $locality_name = mysql_real_escape_string($_POST['locality_name']); $city_id = $_POST['city1']; echo "<script>alert('city id :.{$city_id}');</script>"; $query = "update locality set locality_name='{$locality_name}',city_id='{$city_id}' where locality_id='{$locality_id}'"; $result = mysql_query($query); if ($result) { header("location:locality-display.php?qry=true"); } else { header("location:locality-display.php?qry=false"); } }
function getCourseByDepartment($department) { connection(); $sql = "SELECT * FROM `courses` where `department` = {$department}"; if (mysql_query($sql)) { $result = mysql_query($sql); $row = mysql_fetch_array($result); return $row; } }
<?php require 'connectionBD.php'; session_start(); //validamos si se ha hecho o no el inicio de sesion correctamente //si no se ha hecho la sesion nos regresará a login.php if (!isset($_SESSION['usuario'])) { header('Location: login.html'); exit; } $conn = connection(); if ($conn != null) { //header('Location: login.html'); //exit(); } $alta = $_POST["alta"]; if ($alta != null && $alta == "true") { altaArduino($conn); } $borrar = $_POST["borrar"]; if ($borrar != null && $borrar != "false") { echo "llamando a borrar"; $id = $_POST["id"]; borrarArduino($conn, $id); } $actualizar = $_POST["actualizar"]; if ($actualizar != null && $actualizar != "false") { $id = $_POST["id"]; updateArduino($conn, $id); } ?>
<?php $idpage = 'admin'; $nompage = 'articles'; $nompage2 = 'articles'; include '../../include/haut.php'; ?> <div id="content"> <?php // connection à la base de donnée if (connection($dbb)) { if (isset($_GET['IDartcl'])) { $chiffrerplt = array("0", "1", "2", "3", "4", "5", "6", "7", "8", "9"); //les chiffres autorisés pour un id d'article $rplt = array("", "", "", "", "", "", "", "", "", ""); $idnewsrplt = str_replace($chiffrerplt, $rplt, $_GET['IDartcl']); //on remplace tous les chiffre de l'id transmis par l'url par des vides $nbcaractèrefin = strlen($idnewsrplt); //on compte de nombre de caractère restant if ($nbcaractèrefin == 0) { $IDD = $dbb->prepare('SELECT ID AS idisset FROM articles WHERE ID = ?'); $IDD->execute(array($_GET['IDartcl'])); $Iddd = $IDD->fetch(); if (!empty($Iddd['idisset'])) { $reponse = $dbb->prepare('SELECT ID, titre AS titre1, contenu AS contenu1, auteur AS auteur1, sujet AS sujet1, nomcouverture FROM articles WHERE ID = ?'); $reponse->execute(array($_GET['IDartcl'])); $reponse1 = $dbb->prepare('SELECT DAY(date) AS jour1, YEAR(date) AS annee1, MONTHNAME(date) AS mois1 FROM articles WHERE ID = ?'); $reponse1->execute(array($_GET['IDartcl'])); $donnees = $reponse->fetch();
</a> <?php } } ?> </div> <div id="map-canvas"></div> </article> <div id="coordonnees"> <?php $bdd = connection(); if (isset($_GET['lieu'])) { //si un lieu est sélectionné, on lui donne ses coordonnées $lieu = $bdd->query('SELECT Lat, Lng FROM lieux WHERE lieu ="' . $_GET['lieu'] . '" '); $return = $lieu->fetch(); $lieu->closeCursor(); ?> <div id="lat"><?php echo $return[0]; ?> </div> <div id="lng"><?php
private function news_update($query) { connection(); return mysql_query($query); }
} function truncate($table) { $sql = 'TRUNCATE TABLE' . $table; mysql_query($sql); } function fetchAll($sql, $result_type = MYSQL_ASSOC) { $result = mysql_query($sql); $rowCount = mysql_num_rows($result); if ($rowCount) { while ($row = mysql_fetch_array($result, $result_type)) { $rows[] = $row; } return $rows; } return FALSE; } function fetchOne($sql, $result_type = MYSQL_ASSOC) { $result = mysql_query($sql); $rowCount = mysql_num_rows($result); if ($rowCount) { return mysql_fetch_array($result, $result_type); } return FALSE; } connection('localhost', 'root', 'root', 'test'); $sql = 'SELECT * FROM users'; $rowset = fetchOne($sql); print_r($rowset);