function __construct() { include 'files/config.php'; $msql = new Db(); $msql->connect(); $this->is_login(); }
public function dologinAction() { Db::connect(); $bean = R::dispense('user'); // the redbean model $required = ['Name' => 'name', 'Email' => 'email', 'User_Name' => ['rmnl', 'az_lower'], 'Password' => 'password_hash']; \RedBeanFVM\RedBeanFVM::registerAutoloader(); // for future use $fvm = \RedBeanFVM\RedBeanFVM::getInstance(); $fvm->generate_model($bean, $required); //the magic R::store($bean); $val = new validation(); $val->addSource($_POST)->addRule('email', 'email', true, 1, 255, true)->addRule('password', 'string', true, 10, 150, false); $val->run(); if (count($val->errors)) { Debug::r($val->errors); foreach ($val->errors as $error) { Notification::setMessage($error, Notification::TYPE_ERROR); } $this->redirect(Request::createUrl('login', 'login')); } else { Notification::setMessage("Welcome back !", Notification::TYPE_SUCCESS); Debug::r($val->sanitized); session::set('user', ['sanil']); $this->redirect(Request::createUrl('index', 'index')); } }
function conectar() { $con = new Db("localhost", "root", "benjamin13"); $con->connect(); $con->select_db("conquistadores"); return $con; }
public function save() { $query = "INSERT INTO miembros values (null,'" . $this->getNombre() . "',null,'" . $this->getEmail() . "')"; $conn = new Db("localhost", "root", "benjamin13"); $conn->connect(); $conn->insert($query, "conquistadores"); }
public function login() { $conn = Db::connect(); $sql = 'SELECT user_id FROM users ' . ' WHERE email = ? AND password = ?'; $email = $conn->real_escape_string($_POST['email']); $password = md5($_POST['password']); $statement = $conn->prepare($sql); $statement->bind_param('ss', $email, $password); $statement->execute(); $statement->bind_result($userId); $statement->fetch(); if ($userId == NULL) { return false; } else { session_start(); $_SESSION['user_id'] = $userId; if (isset($_SESSION['cart']) && $_SESSION['cart'] != []) { require_once '../app/models/Cart.php'; $cart = new Cart(); foreach ($_SESSION['cart'] as $product_id => $value) { $cart->addProductToCart($product_id, $_SESSION['cart'][$product_id]['cart_quantity']); } } return true; } }
public static function getStandartTheme() { $db = Db::connect(); $query = "SELECT themes.file FROM themes WHERE themes.id = 1"; $result = $db->query($query)->fetch(PDO::FETCH_ASSOC); return $result['file']; }
public function deleteArticleById($id) { $pdo = Db::connect(); $sql = "DELETE FROM `article` WHERE `article_id` = {$id}"; $query_result = $pdo->query($sql); return $query_result; }
/** * Prywatny konstruktor klasy inicjujący połączenie z bazą danych * @global type $CONFIG mixed tablica przechowująca configuracje systemu */ private function __construct() { global $CONFIG; self::$connect = new PDO('mysql:host=' . $CONFIG["host"] . ";dbname=" . $CONFIG["database"], $CONFIG["user"], $CONFIG["pass"]); self::$connect->query("SET NAMES utf8"); self::$connect->query("SET CHARSET utf8"); self::$connect->num_queries = 0; }
/** * Return an instance of Db Class * If not connection to the database is made then firstly will try to connect to the database * If connection to the database fails then `false` value will be returned * * @return Mixed; */ public function db() { if (!self::$db) { self::$db = new Db($this->config('db')); self::$db->connect(); } return self::$db; }
public static function incrementProductQuantity($productId, $quantity) { $sql = "UPDATE shopping_cart SET cart_quantity = cart_quantity + ? " . "WHERE fk_shopping_cart_user = ? AND fk_shopping_cart_product_version = ?"; $conn = Db::connect(); $statement = $conn->prepare($sql); $statement->bind_param('iii', $quantity, $_SESSION['user_id'], $productId); $statement->execute(); }
public function setup() { global $baseParams; $db = new Db($baseParams['__YKVAL_DB_DSN__'], 'root', 'lab', $baseParams['__YKVAL_DB_OPTIONS__']); $db->connect(); # $db->truncateTable('queue'); $db->disconnect(); }
public function destroy($wishListId) { $sql = 'DELETE FROM wish_list WHERE wish_list_id = ?'; $conn = Db::connect(); $stmt = $conn->prepare($sql); $stmt->bind_param('i', $wishListId); $stmt->execute(); $stmt->close(); }
static function table($with_db_name = true) { $conn = Db::getConnection('streams'); $prefix = empty($conn['prefix']) ? '' : $conn['prefix']; $table_name = $prefix . 'notification'; if (!$with_db_name) { return $table_name; } $db = Db::connect('streams'); return $db->dbName() . '.' . $table_name; }
public function emptyCart() { $sql = 'DELETE FROM shopping_cart WHERE fk_shopping_cart_user = ?'; $database = Db::connect(); $statement = $database->prepare($sql); $statement->bind_param('i', $_SESSION['user_id']); $statement->execute(); if (isset($_SESSION['cart'])) { unset($_SESSION['cart']); } }
private function runConfirmationQuery($sql, $id) { $conn = Db::connect(); $stmt = $conn->prepare($sql); $stmt->bind_param('ii', $id, $_SESSION['user_id']); $stmt->execute(); $stmt->bind_result($id); $stmt->fetch(); $conn->close(); $_SESSION['test'] = $id; return $id; }
private static function sql_inner() { $db = Db::connect(); $fna = func_num_args(); $result = $db->prepare(func_get_arg(0)); $result->bindParam(':login', func_get_arg(1), PDO::PARAM_INT); if (func_num_args() > 2) { $result->bindParam(':password', func_get_arg(2), PDO::PARAM_INT); } $result->execute(); return $result; }
public static function changeStandartTheme($newTheme) { $db = Db::connect(); $query = "SELECT * FROM themes WHERE themes.id = :id"; $stmt = $db->prepare($query); $stmt->bindValue(':id', $newTheme); $stmt->execute(); $theme = $stmt->fetch(PDO::FETCH_ASSOC); $query = "UPDATE themes SET themes.name = :name, themes.file = :file WHERE themes.id = 1"; $stmt = $db->prepare($query); $stmt->bindValue(':name', $theme['name']); $stmt->bindValue(':file', $theme['file']); $stmt->execute(); }
public static function saveMessage($chatId, $userId, $message) { $message = Validator::clear($message); try { $db = Db::connect(); $query = "INSERT INTO messages(text, chat_id, user_id, date) VALUES (:text, :chat_id, :user_id, NOW())"; $stmt = $db->prepare($query); $stmt->bindParam(':text', $message); $stmt->bindParam(':chat_id', $chat_id); $stmt->bindParam(':user_id', $user_id); $stmt->execute(); } catch (PDOException $e) { echo $e->getMessage(); } }
public function findBy($columns, $val) { $conn = Db::connect(); $sql = "SELECT user_id, first_name, last_name, email, admin FROM users WHERE "; if (is_array($columns)) { foreach ($columns as $col) { $sql .= $col . "='" . $val[array_search($col, $col_list)] . "' AND "; } $sql = rtrim($sql, " AND "); } else { $sql .= $columns . "='" . $val . "'"; } $results = $conn->query($sql); return $results->fetch_assoc(); }
public function __construct() { self::$root = rtrim(dirname($_SERVER['SCRIPT_FILENAME']), DIRECTORY_SEPARATOR); self::$base = rtrim(dirname($_SERVER['SCRIPT_NAME']), DIRECTORY_SEPARATOR); spl_autoload_register(array('TwCensus', 'loader')); Session::init(); Session::$prefix = 'TwCensus_'; Db::connect(self::$config['db']); Request::init(); if (Request::hasQuery('kml')) { $this->actionKML(); } else { $this->actionWebsite(); } }
/** * Retrieve the table name to use in SQL statement * @method table * @static * @param {boolean} [$with_db_name=true] Indicates wheather table name should contain the database name * @return {string|Db_Expression} The table name as string optionally without database name if no table sharding * was started or Db_Expression class with prefix and database name templates is table was sharded */ static function table($with_db_name = true) { if (Q_Config::get('Db', 'connections', 'Metrics', 'indexes', 'Session', false)) { return new Db_Expression(($with_db_name ? '{$dbname}.' : '') . '{$prefix}' . 'session'); } else { $conn = Db::getConnection('Metrics'); $prefix = empty($conn['prefix']) ? '' : $conn['prefix']; $table_name = $prefix . 'session'; if (!$with_db_name) { return $table_name; } $db = Db::connect('Metrics'); return $db->dbName() . '.' . $table_name; } }
public static function getInstance($dotype = "read") { if (!in_array($dotype, array("read", "write"))) { $dotype = "read"; } $conf = c("db." . $dotype); if ($dotype == "write") { $instance =& self::$instance_master; } else { $instance =& self::$instance_slave; } if ($instance === NULL || !$instance instanceof Db) { $instance = new Db(); $instance->connect($conf); } }
public static function addQuiz($postId, $question, $answers) { $db = Db::connect(); $query = "INSERT INTO quizes(question, post_id) VALUES(:question, :post_id)"; $stmt = $db->prepare($query); $stmt->bindParam(':question', $question); $stmt->bindParam(':post_id', $postId); $stmt->execute(); $query = "SELECT MAX(quizes.id) AS id FROM quizes"; $result = $db->query($query)->fetch(PDO::FETCH_ASSOC); $id = $result['id']; $query = "INSERT INTO quiz_answers(quiz_id, answer) VALUES(:id, :answer)"; $stmt = $db->prepare($query); foreach ($answers as $answer) { $stmt->bindParam(':answer', $answer); $stmt->bindParam(':id', $id); $stmt->execute(); } }
/** * test_ExecAndTransaction_ExecWithInTrans() * * exec()のテスト(トランザクションあり) */ public function test_ExecAndTransaction_ExecWithInTrans() { $params = ["driver" => $GLOBALS['DB_DRIVER'], "user" => $GLOBALS['DB_USER'], "pass" => $GLOBALS['DB_PASSWORD'], "dbname" => $GLOBALS['DB_DBNAME'], "host" => $GLOBALS['DB_HOST'], "persistent" => false]; $instance = new Db(); $instance->connect($params); // commit pattern $this->assertTrue($instance->beginTransaction()); $this->assertTrue($instance->inTransaction()); $this->assertEquals(1, $instance->exec('INSERT INTO risoluto_db_test(id, column1, column2) values ("10", "TEST_A", "TEST_B");')); $this->assertEquals(2, $this->getconnection()->getRowCount('risoluto_db_test')); $this->assertEquals(10, $instance->lastInsertId()); $this->assertEquals(10, $instance->lastInsertId('id')); $this->assertTrue($instance->commit()); $this->assertFalse($instance->inTransaction()); $this->assertEquals(3, $this->getconnection()->getRowCount('risoluto_db_test')); // Rollback pattern $before_val = $this->getconnection()->createQueryTable('risoluto_db_test', 'SELECT id, column1, column2 FROM risoluto_db_test WHERE id="10";'); $this->assertTrue($instance->beginTransaction()); $this->assertTrue($instance->inTransaction()); $this->assertEquals(1, $instance->exec('UPDATE risoluto_db_test SET column1="TEST_C", column2="TEST_C" WHERE id="10";')); $this->assertEquals(3, $this->getconnection()->getRowCount('risoluto_db_test')); $this->assertEquals(1, $instance->exec('DELETE FROM risoluto_db_test WHERE id="10";')); $this->assertEquals(3, $this->getconnection()->getRowCount('risoluto_db_test')); $this->assertTrue($instance->rollBack()); $this->assertFalse($instance->inTransaction()); $after_val = $this->getconnection()->createQueryTable('risoluto_db_test', 'SELECT id, column1, column2 FROM risoluto_db_test WHERE id="10";'); $this->assertEquals(3, $this->getconnection()->getRowCount('risoluto_db_test')); $this->assertTablesEqual($before_val, $after_val); // Cleaning $this->assertEquals(1, $instance->exec('DELETE FROM risoluto_db_test WHERE id="10";')); $this->assertEquals(2, $this->getconnection()->getRowCount('risoluto_db_test')); $instance->disConnect(); unset($instance); }
/** * 实例化数据库 * @param mixed $config 数据库配置 * @return object */ public static function db($config = []) { return Db::connect($config); }
/** @return Db_Mysql */ static function db() { return Db::connect('streams'); }
/** * This method calls Db.connect() using information stored in the configuration. * If this has already been called, then the same db object is returned. * @method db * @return {iDb} The database object */ static function db() { return Db::connect('Platform'); }
<?php // DBライブラリ読み込み require 'lib/db.php'; // 格納する引数受け取り $title = isset($_POST['title']) ? $_POST['title'] : NULL; $detail = isset($_POST['detail']) ? $_POST['detail'] : NULL; $asin = isset($_POST['asin']) ? $_POST['asin'] : NULL; $medium_image_url = isset($_POST['medium_image_url']) ? $_POST['medium_image_url'] : NULL; $large_image_url = isset($_POST['large_image_url']) ? $_POST['large_image_url'] : NULL; // MySQL接続 $db = new Db(); $pdo = $db->connect(); if (!$pdo) { exit(1); } // UPDATE $sqls = array("UPDATE item SET\n title = '{$title}',\n detail = '{$detail}',\n medium_image_url = '{$medium_image_url}',\n large_image_url = '{$large_image_url}',\n create_time = NOW()\n WHERE asin = '{$asin}'", "UPDATE other SET\n title = '{$title}',\n detail = '{$detail}',\n medium_image_url = '{$medium_image_url}',\n large_image_url = '{$large_image_url}',\n create_time = NOW()\n WHERE asin = '{$asin}'"); $status = array(); foreach ($sqls as $sql) { $stmt = $pdo->prepare($sql); if (!$stmt) { error_log(var_export($pdo->errorInfo(), true)); $status[] = false; } if (!$stmt->execute()) { $status[] = false; } else { $status[] = true; } }
/** * This method calls Db.connect() using information stored in the configuration. * If this has already been called, then the same db object is returned. * @method db * @return {iDb} The database object */ static function db() { return Db::connect('Websites'); }
/** * 切换当前的数据库连接 * @access public * @param mixed $linkId 连接标识 * @param mixed $config 数据库连接信息 * @return Model */ public function db($linkId = '', $config = '') { if ('' === $linkId && $this->db) { return $this->db; } if (!isset($this->links[$linkId])) { // 创建一个新的实例 if (is_string($linkId) && '' == $config) { $config = Config::get($linkId); } $this->links[$linkId] = Db::connect($config); } elseif (null === $config) { $this->links[$linkId]->close(); // 关闭数据库连接 unset($this->links[$linkId]); return; } // 切换数据库连接 $this->db = $this->links[$linkId]; $this->_after_db(); return $this; }