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);
