static function connect()
{
self::$db = new mysqli(Conf::$DB_HOST, Conf::$DB_USER, Conf::$DB_PASSWORD, Conf::$DB_SELECT, Conf::$DB_PORT);
if (self::$db->connect_errno) {
die('Erreur de connexion (' . self::$db->connect_errno . ') ' . self::$db->connect_error);
}
}
public function __construct()
{
$this->db = DBConnection::db();
$this->updateWorkspaceStmt = $this->db->prepare("UPDATE workspaces_v2 " . "SET name= :name, content= :content " . "WHERE user_id= :user AND id= :id; ");
$this->insertWorkspaceStmt = $this->db->prepare("INSERT INTO workspaces_v2 (id, id_v1, user_id, name, content) " . "VALUES (:id, NULL, :user, :name, :content); ");
$this->getWorkspacesStmt = $this->db->prepare("SELECT id, id_v1, user_id, name, content " . "FROM workspaces_v2 " . "WHERE (user_id = :user AND (name LIKE :qname OR id LIKE :qid)) " . "ORDER BY name; ");
$this->getWorkspaceByIdStmt = $this->db->prepare("SELECT id, id_v1, user_id, name, content " . "FROM workspaces_v2 " . "WHERE (user_id = :user AND (name LIKE :qname OR id LIKE :qid)) OR (id = :id OR id_v1 = :idv1); ");
$this->deleteWorkspaceStmt = $this->db->prepare("DELETE FROM workspaces_v2 WHERE id= :id AND user_id= :user; ");
}
public static function db()
{
if (DBConnection::$db != null) {
return DBConnection::$db;
}
$server = DB_HOST;
$username = DB_USER;
$password = DB_PASSWD;
$dbname = DB_NAME;
try {
// Open a persistent database connection, for performance improvement
DBConnection::$db = new PDO('mysql:host=' . $server . ';dbname=' . $dbname . ';charset=utf8', $username, $password, array(PDO::ATTR_PERSISTENT => true, PDO::ATTR_EMULATE_PREPARES => false, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
} catch (Exception $e) {
echo 'caughtL ', $e->getMessage(), '\\n';
}
return DBConnection::$db;
}
public static function retrieveCustomer($consumerKey)
{
$db = DBConnection::db();
$statement = $db->prepare('SELECT `consumer_secret` FROM `api_clients` WHERE `active` = TRUE AND `consumer_key` = :consumer_key LIMIT 1');
$statement->bindParam(':consumer_key', $consumerKey, PDO::PARAM_STR);
$exe = $statement->execute();
if (!$exe || $exe == false || $statement->rowCount() != 1) {
// Looks like it's a no
return false;
} else {
// Fetch the info
$row = $statement->fetch(PDO::FETCH_ASSOC);
if (!$row) {
return false;
}
return $row['consumer_secret'];
}
}
public function getOrInsertUser($oauth_uid, $oauth_provider, $user_data)
{
$db = DBConnection::db();
$result = $this->getUser($oauth_uid, $oauth_provider);
if ($result != null) {
return $result;
}
$joined_keys = '(`oauth_uid`, `oauth_provider`, `' . implode('`, `', array_keys($user_data)) . '`)';
$joined_values = "('{$oauth_uid}', '{$oauth_provider}'";
foreach ($user_data as $v) {
$joined_values .= ', ';
$joined_values .= $v === null ? 'NULL' : "'{$v}'";
}
$joined_values .= ')';
$insert = "INSERT INTO users {$joined_keys} VALUES {$joined_values}";
print_r($insert);
$db->exec($insert);
return $this->getUser($oauth_uid, $oauth_provider);
}
public static function logSearchQuery($searchQuery, $from = "site")
{
$db = DBConnection::db();
if (!isset($_SERVER["HTTP_REFERER"])) {
$_SERVER["HTTP_REFERER"] = "";
}
$query = "INSERT INTO `stats_search_query` (query, referer, origin, date)";
$query .= " VALUES(:search_query, :referer, :from, NOW());";
$statement = $db->prepare($query);
$statement->bindParam(':search_query', trim($searchQuery), PDO::PARAM_STR);
$statement->bindParam(':referer', $_SERVER["HTTP_REFERER"], PDO::PARAM_STR);
$statement->bindParam(':from', $from, PDO::PARAM_STR);
// Executes the query
$exe = $statement->execute();
// Returns true if the query was well executed and returned a single line
if ($exe && $statement->rowCount() == 1) {
return true;
} else {
return false;
}
}
{
if (self::$_instance !== null || is_null($config)) {
//We have already stored the object locally so just return it.
//This is how the object always stays the same
return self::$_instance;
}
new DBConnection($config);
//Set the instance.
return self::$_instance;
}
public static function error()
{
if (self::$failSilently == true) {
return false;
}
// If we were called from a post request in ajax, we should just echo the error uri
if (self::$parentCalledFromPost == true) {
echo _SITE_BASE_URL . 'woops';
} else {
// Else : standard header:Location
header('Location: /woops');
}
}
}
/* *************************************************** */
/* */
/* FIRST CONNECTION ROUTINE */
/* */
/* *************************************************** */
$db = DBConnection::db(array('hostname' => "localhost", 'username' => $user, 'password' => $password, 'database' => $database, 'failSilently' => !isset($failSilently) ? false : $failSilently, 'parentCalledFromPost' => !isset($parentCalledFromPost) ? false : $parentCalledFromPost));
public static function addAPick($id)
{
$db = DBConnection::db();
// Latest first
$query = "SELECT id, name, album, artist, image FROM `items` WHERE id=:id AND type=" . _TABLE_TRACK . " LIMIT 1";
$statement = $db->prepare($query);
$statement->bindParam(':id', $id, PDO::PARAM_INT);
// Executes the query
$exe = $statement->execute();
if (!$exe || $exe == false) {
return false;
} else {
// Fetch the info
$row = $statement->fetchAll(PDO::FETCH_ASSOC);
$queryDate = "SELECT MAX(date) AS maxDate FROM `picks`";
$statementDate = $db->prepare($queryDate);
// Executes the query
$exeDate = $statementDate->execute();
if (!$exeDate || $exeDate == false) {
return false;
} else {
$rowDate = $statementDate->fetch(PDO::FETCH_ASSOC);
$maxDate = strftime("%Y-%m-%d", strtotime($rowDate['maxDate'] . " + 1 day"));
}
$queryPick = "INSERT INTO `picks` (name, artist, album, image, link, date) VALUES(:name, :artist, :album, :image, :link, :max_date)";
$statementPick = $db->prepare($queryPick);
$statementPick->bindParam(':name', $row["name"], PDO::PARAM_STR);
$statementPick->bindParam(':artist', $row["artist"], PDO::PARAM_STR);
$statementPick->bindParam(':album', $row["album"], PDO::PARAM_STR);
$statementPick->bindParam(':image', $row["image"], PDO::PARAM_STR);
$statementPick->bindParam(':link', _SITE_URL . '/t/' . DBUtils::toUid($row["id"], _BASE_MULTIPLIER), PDO::PARAM_STR);
$statementPick->bindParam(':max_date', $maxDate, PDO::PARAM_STR);
// Executes the query
$exePick = $statementPick->execute();
if (!$exePick || $exePick == false) {
return false;
} else {
return true;
}
}
}
public function checkDatabase()
{
$db = DBConnection::db();
if (!$db) {
$this->log("DB Connection as '{$user}'", false, "Error connecting to database : " . $db->errorInfo());
} else {
if ($this->verbose) {
$this->log("DB Connection as '" . $this->data['user'] . "'", true, "");
}
$statement = $db->prepare("SELECT * FROM items LIMIT 1");
$exe = $statement->execute();
if (!$exe || $exe == false) {
$this->log("DB Query", false, "Error ");
} else {
if ($this->verbose) {
$error = $db->errorInfo();
$this->log("DB Query", true, "Error making query : " . $error[2]);
}
}
}
}
/**
* Sets the DB with a database object
* (MUST BE MYSQLI FOR NOW)
*
* (Your application must establish a connection on its own... then pass here)
*
* @param $db MYSQLI database object
*/
public static function setDB($db)
{
self::$db = $db;
}
<?php
require '../../config.php';
$parentCalledFromPost = true;
require _PATH . 'include/database/DBUtils.class.php';
require _PATH . 'include/database/DBConnection.class.php';
$db = DBConnection::db();
// What type of share is it ?
if (isset($_REQUEST['itemType'])) {
if ($_REQUEST['itemType'] == _TABLE_TRACK) {
$itemType = _TABLE_TRACK;
$shortCode = '/t/';
} else {
if ($_REQUEST['itemType'] == _TABLE_ALBUM) {
$itemType = _TABLE_ALBUM;
$shortCode = '/a/';
} else {
header('Location: ' . _SITE_URL);
die(0);
}
}
} else {
header('Location: ' . _SITE_URL);
die(0);
}
// We check we have some info
if ((!isset($_REQUEST['name']) || $_REQUEST['name'] == "") && $itemType == 'track' || (!isset($_REQUEST['album']) || $_REQUEST['album'] == "") && $itemType == 'album' || !isset($_REQUEST['artist']) || $_REQUEST['artist'] == "") {
header('Location: ' . _SITE_URL);
die(0);
}
$name = trim(html_entity_decode($_REQUEST['name'], ENT_COMPAT, "UTF-8"));