function parseFile($file, $type) { $sql = new MySQL(); $sql->connect('127.0.0.1', 'root', 'root'); $objReader = PHPExcel_IOFactory::createReader($type); $chunkSize = 200; $i = 1; $sql->clear('price_liga'); $r = array(); for ($startRow = 0; $startRow <= 5000; $startRow += $chunkSize + 1) { $chunkFilter = new chunkReadFilter($startRow, $chunkSize); $objReader->setReadFilter($chunkFilter); $objReader->setReadDataOnly(true); $objPHPExcel = $objReader->load($file); $data = $objPHPExcel->getActiveSheet()->toArray(); foreach ($data as $k => $v) { if ($data[$k][0] == '') { unset($data[$k]); } else { $sql->insert('price_liga', array('id' => $i, 'cat_num' => $data[$k][0], 'brand' => ucwords(strtolower($data[$k][1])), 'article' => $data[$k][2], 'descr' => str_replace("'", "\\'", $data[$k][3]), 'model' => str_replace("'", "\\'", $data[$k][4]), 'size' => $data[$k][5], 'price' => $data[$k][6], 'amount' => $data[$k][8]), true); $i++; } } } //print_r($r); $sql->close(); return array('counter' => $i); }
return FALSE; } } function get_uri_data($args) { $hmdb = new MySQL(true, DB_NAME, DB_HOST, DB_USER, DB_PASSWORD, DB_CHARSET); if (!is_array($args)) { parse_str($args, $args); } if (isset($args['uri'])) { $uri = $args['uri']; } else { $uri = FALSE; } if (isset($args['id'])) { $id_uri = $args['id']; } else { $id_uri = FALSE; } $tableName = DB_PREFIX . "request_uri"; if (is_numeric($id_uri)) { $whereArray = array('id' => MySQL::SQLValue($id_uri)); } else { $whereArray = array('uri' => MySQL::SQLValue($uri)); } $hmdb->SelectRows($tableName, $whereArray); if ($hmdb->HasRecords()) { $row = $hmdb->Row(); return $row; } else {
function inicializar() { $db = new MySQL(); $sql = "create table " . $this->tabla . "(" . "usuario integer(10) not null," . "alias varchar(128) not null," . "clave varchar(128) not null," . "fecha date not null," . "hora time not null," . "estado varchar(32) not null," . "primary key (usuario)" . ");"; $consulta = $db->sql_query($sql); $db->sql_close(); }
function login($email, $password) { require_once 'mysql/mysql.php'; require 'mysql/mysql_settings.php'; $mysql = new MySQL($mysql_user, $mysql_pw, $mysql_server, $mysql_db); $request = 'SELECT idUser, name, valid, picture FROM User WHERE user.email="' . $email . '" AND user.password="******";'; $response = $mysql->request($request); $response = json_decode(json_encode($response), true); /** * pr�fen der request * @return 'request failed' -> fehlgeschlagene mysql anfrage * 'wrong user' -> kein eintrag gefunden * 'wrong password' -> keine Passwort�bereinstimmung * 'invalid' -> noch nicht freigeschalteter account */ if (!$response) { $echo = mysqli_error($mysql->getCon()); } else { if (empty($response)) { $echo = 'wrong user'; } else { if ($request[0]['valide'] == 0) { $echo = 'invalid'; } else { $_SESSION['idUser'] = $response['idUser']; $_SESSION['name'] = $response['name']; $_SESSION['picture'] = $response['picture']; $echo = 'done'; } } } return $echo; }
/** * Query database. Retrun all values from a table * * @param $table String Table name * * @returns Object Database records. MySQL object */ public function checkNeededDataGoogleSearchAnalytics($website) { $core = new Core(); //Load core $mysql = new MySQL(); //Load MySQL $now = $core->now(); /* Identify date range */ $dateStartOffset = self::GOOGLE_SEARCH_ANALYTICS_MAX_DATE_OFFSET + self::GOOGLE_SEARCH_ANALYTICS_MAX_DAYS; $dateStart = date('Y-m-d', strtotime('-' . $dateStartOffset . ' days', $now)); $dateEnd = date('Y-m-d', strtotime('-' . self::GOOGLE_SEARCH_ANALYTICS_MAX_DATE_OFFSET . ' days', $now)); /* Query database for dates with data */ $query = "SELECT COUNT( DISTINCT date ) AS record, date FROM " . MySQL::DB_TABLE_SEARCH_ANALYTICS . " WHERE domain LIKE '" . $website . "' AND date >= '" . $dateStart . "' AND date <= '" . $dateEnd . "' GROUP BY date"; $result = $mysql->query($query); /* Create array from database response */ $datesWithData = array(); foreach ($result as $row) { array_push($datesWithData, $row['date']); } /* Get date rante */ $dates = $core->getDateRangeArray($dateStart, $dateEnd); /* Loop through dates, removing those with data */ foreach ($dates as $index => $date) { if (in_array($date, $datesWithData)) { unset($dates[$index]); } } /* Reindex dates array */ $dates = array_values($dates); $returnArray = array('dateStart' => $dateStart, 'dateEnd' => $dateEnd, 'datesWithNoData' => $dates); return $returnArray; }
function register($email, $password, $username) { require_once 'mysql/mysql.php'; require 'mysql/mysql_settings.php'; /** * Establish new connection * Check if email is already registered * If so give out failure message, otherwise give out success */ $mysql = new MySQL($mysql_user, $mysql_pw, $mysql_server, $mysql_db); /** *Check if email is registered */ $request = 'SELECT user.idUser FROM user WHERE user.email="' . $email . '";'; $response = $mysql->request($request); $response = json_decode(json_encode($response), true); //If so return failure message if (!empty($response)) { $echo = 'invalid email'; return $echo; } /** * If not put user into database */ $request = 'INSERT INTO user(name,password,email,valid) VALUES ("' . $username . '","' . $password . '","' . $email . '",0);'; $response = $mysql->insert($request); //Check if insertion worked out if (!$response) { $echo = mysqli_error($mysql->getCon()); } else { $echo = 'done'; } //Return result return $echo; }
function inicializar() { $db = new MySQL(); $sql = ""; $consulta = $db->sql_query($sql); $db->sql_close(); }
function parseFile($file, $type) { $sql = new MySQL(); $sql->connect('127.0.0.1', 'root', 'root'); $objReader = PHPExcel_IOFactory::createReader($type); $chunkSize = 200; $i = 1; $sql->clear('price_v8'); for ($startRow = 0; $startRow <= 5000; $startRow += $chunkSize + 1) { $chunkFilter = new chunkReadFilter($startRow, $chunkSize); $objReader->setReadFilter($chunkFilter); $objReader->setReadDataOnly(true); $objPHPExcel = $objReader->load($file); $data = $objPHPExcel->getActiveSheet()->toArray(); foreach ($data as $k => $v) { if (trim($data[$k][0]) == 'Артикул' || $data[$k][3] == '' || strstr($data[$k][3], 'камера') || $data[$k][7] == '') { unset($data[$k]); } else { $descr = str_replace('Ш', 'xSTUDEDx', trim($data[$k][3])); $descr = preg_replace('/[а-яА-Я]/', '', $descr); $sql->insert('price_v8', array('id' => $i, 'article' => trim($data[$k][0]), 'descr' => str_replace("'", "\\'", $descr), 'cat_num' => trim($data[$k][6]), 'season' => trim($data[$k][7]), 'price' => trim($data[$k][9]), 'amount' => trim(preg_replace('/[а-яА-Яa-zA-Z]{0,}/', '', $data[$k][10]))), true); $i++; } } } $sql->close(); return array('counter' => $i); }
/** Đăng nhập admin cp */ function admin_cp_login() { global $hmuser; $hmdb = new MySQL(true, DB_NAME, DB_HOST, DB_USER, DB_PASSWORD, DB_CHARSET); hook_action('admin_cp_login'); $user_login = hm_post('login'); $password = hm_post('password'); $logmein = hm_post('log-me-in'); if (is_numeric($logmein)) { $tableName = DB_PREFIX . "users"; $whereArray = array('user_login' => MySQL::SQLValue($user_login)); $hmdb->SelectRows($tableName, $whereArray); if ($hmdb->HasRecords()) { $row = $hmdb->Row(); $salt = $row->salt; $user_pass = $row->user_pass; $password_encode = hm_encode_str(md5($password . $salt)); if ($password_encode == $user_pass) { $time = time(); $ip = hm_ip(); $cookie_array = array('time' => $time, 'ip' => $ip, 'user_login' => $user_login, 'admincp' => 'yes'); $cookie_user = hm_encode_str($cookie_array); setcookie('admin_login', $cookie_user, time() + COOKIE_EXPIRES, '/'); $_SESSION['admin_login'] = $cookie_user; return json_encode(array('status' => 'success', 'mes' => _('Đăng nhập thành công'))); } else { return json_encode(array('status' => 'error', 'mes' => _('Sai mật khẩu'))); } } else { return json_encode(array('status' => 'error', 'mes' => _('Không có tài khoản này'))); } } }
function validationmail($email) { require_once 'mysql/mysql.php'; require 'mysql/mysql_settings.php'; //Build mysql connection $mysql = new MySQL($mysql_user, $mysql_pw, $mysql_server, $mysql_db); //Create request $request = 'INSERT INTO validationmails(email) VALUES ("' . $email . '");'; //Perform request $response = $mysql->insert($request); //Check if request was successfull if (!$response) { $echo = mysqli_error($mysql->getCon()); } else { $id = $mysql->insert_id; } return email($email, ' Hi ' . $user . ', um loszulegen klick einfach auf den Link und los geht\'s! http://fragdichab.de/?p=1&id=' . $id . '&req=validation Sch�ne Gr��e, Ruben & Jannes ', 'Bestaetigungsmail'); }
function create_multiple_choice_question($modul_name, $theme_name, $created_by, $question, $answer1, $desc1, $answer2, $desc2, $answer3, $desc3, $answer4, $desc4, $correct, $difficulty, $difficulty_num) { $mysql = new MySQL($mysql_user, $mysql_pw, $mysql_server, $mysql_db); //Start transaction $response = $mysql->request("START TRANSACTION;"); if (!$response) { $echo = mysqli_error($mysql->getCon()); return $echo; } //Create basic question create_basic_question($course_name, $modul_name, $theme_name, $created_by, $mysql); //Check if return value is error message, if so propagate if ($question_id[0] == '#') { return $question_id; } //If id build corresponding multiple choice question $request = "INSERT INTO `Multiplichoice` " . "(`idQuestions`, `idMultiplichoice`, `question`, `answer1`, `desc1`, `answer2`, `desc2`, `answer3`, `desc3`, `answer4`, `desc4`, `correct`, `difficulty`, `quality`, `difficulty_num`, `qualitiy_num`) " . "VALUES (" . $question_id . ", NULL, " . $question . "," . $answer1 . "," . $desc1 . "," . $answer2 . "," . $desc2 . "," . $answer3 . "," . $desc3 . "," . $answer4 . "," . $desc4 . "," . $correct . "," . $difficulty . " NULL, 1, NULL);"; $response = $mysql->request($request); //If not successful abort transaction if (!$response) { $echo = mysqli_error($mysql->getCon()); $response = $mysql->request("ROLLBACK;"); return $echo; } //Else commit and see if commit was successful $response = $mysql->request("COMMIT;"); if (!$response) { $echo = mysqli_error($mysql->getCon()); $response = $mysql->request("ROLLBACK;"); return $echo; } //If all worked out commit return "success"; }
public static function insertDiscuss($disObj) { $mysql = new MySQL(); $res = $mysql->insert("page_discs", $disObj); $mysql->closeCon(); PageService::updateDisNum($disObj['pageid']); return $res; }
public static function getPage($pageid) { $sql = "select a.id,a.pageid,a.title,a.viewnum,a.cover,a.imgnum,a.disnum,a.praisenum,a.status,a.cuserid,a.cusername,\n a.cdate,a.udate ,b.img\n from page a left join page_img b\n on a.pageid=b.pageid where a.pageid=" . $pageid; $mysql = new MySQL(); $res = $mysql->executeReturnObj($sql); $mysql->closeCon(); return $res; }
public static function getIconByName($name) { $sql = "select icon from emotion where value='" . $name . "'"; $mysql = new MySQL(); $res = $mysql->executeReturnFirstObj($sql); $mysql->closeCon(); return $res; }
public function load(&$mensaje) { $sql = $this->_crearLoad(); $bd = new MySQL(); $sql->addEjecutar(':codigo', $this->_codigo); $ejecucion = $sql->generarEjecucion(); return $bd->ejecutar($sql, $ejecucion, $mensaje); }
private function Atualizar(eEndereco $endereco) { $conexao = new MySQL(); $objEndereco = new eEndereco(); //Seleciona endereço na base $sql = "set @CEP = '{$endereco->getCep}()';\n set @LOGRADOURO = '{$endereco->getLogradouro}()';\n set @BAIRRO = '{$cep}';\n set @CIDADE = '{$cep}';\n set @ESTADO = '{$cep}';\n call USP_UPD_ENDERECO(@CEP, @LOGRADOURO, @BAIRRO, @CIDADE, @ESTADO);"; $retorno = $conexao->execSP($sql); }
public function __construct() { $mysql = new MySQL(); $res = $mysql->GetPostsByType("article"); foreach ($res as $row) { $this->Add(new Post($row)); } }
public function guardarUsuario(&$mensaje) { $bd = new MySQL(); $sql = $this->_crearGuardar(); $sql->addEjecutar(':nombre', $this->_nombre); $ejecucion = $sql->generarEjecucion(); return $bd->ejecutar($sql, $ejecucion, $mensaje); }
function consultar($dato) { $db = new MySQL(); $sql = "SELECT * FROM `" . $configuracion["empresa"] . "_ccv_datos` " . "WHERE `dato`='" . $dato . "';"; $consulta = $db->sql_query($sql); $fila = $db->sql_fetchrow($consulta); $db->sql_close(); return $fila; }
function consultar($modulo) { $db = new MySQL(); $sql = "SELECT * FROM `" . $configuracion["empresa"] . "_aplicacion_modulos` " . "WHERE `modulo`='" . $modulo . "';"; $consulta = $db->sql_query($sql); $fila = $db->sql_fetchrow($consulta); $db->sql_close(); return $fila; }
function consultar($id) { $db = new MySQL(); $sql = "SELECT * FROM `equipos` " . "WHERE `id`='" . $id . "';"; $consulta = $db->sql_query($sql); $fila = $db->sql_fetchrow($consulta); $db->sql_close(); return $fila; }
function Authorization($login, $password) { $mysql = new MySQL(); $array = $mysql->GetTable($this->NameBase, "User", NULL, "login='******'"); if ($array[0]["password"] === md5(md5($password))) { $token = $this->SetToken($array[0]['id']); return array('login' => $array[0]['login'], 'token' => $token); } }
function consultar($usuario) { $db = new MySQL(); $sql = "SELECT * FROM `" . $configuracion["empresa"] . "_usuarios_representantes` " . "WHERE `usuario`='" . $usuario . "';"; $consulta = $db->sql_query($sql); $fila = $db->sql_fetchrow($consulta); $db->sql_close(); return $fila; }
function contar() { $mySQL = new MySQL(); $sql = "SELECT * FROM usuarios"; $rs = $mySQL->contalinha($sql); //echo $sql; $mySQL->disconnect; return $rs; }
function consultar($rol) { $db = new MySQL(); $sql = "SELECT * FROM `" . $configuracion["empresa"] . "_politicas` " . "WHERE `rol`='" . $rol . "';"; $consulta = $db->sql_query($sql); $fila = $db->sql_fetchrow($consulta); $db->sql_close(); return $fila; }
/** * Конструктор инициализирует объект $_sql * * */ public function __construct() { try { $this->_sql = MySQL::creator("5.131.95.121", "test", "testtest"); } catch (Exception $ex) { $this->_sql = MySQL::creator(DB_SERVER, DB_USER, DB_PASSWORD); } $this->_sql->selectDB(DB_NAME); }
/** * Get a specific rating * * @param $offerId * @param $userId * @return null */ static function getRating($offerId, $userId) { $mysql = new MySQL(); $results = $mysql->query('SELECT * FROM rating WHERE offer = :offer AND createdby = :createdby', [':offer' => $offerId, ':createdby' => $userId]); if ($results['success'] == true && !empty($results['results']) && $results['results'] != null) { return $results['results']; } return null; }
public static function getUser($user) { $mysql = new MySQL(); $where = " (email='" . $user['user'] . "' or tel='" . $user['user'] . "') and password='******'password'] . "'"; $fd = array("userid,username,email,tel"); $res = $mysql->selectOne("user", $where, $fd); $mysql->closeCon(); return $res; }
static function setNotification($bookingId, $oneWeek, $threeDays, $oneDay) { $mysql = new MySQL(); if (self::getNotification($bookingId) === null) { $results = $mysql->query('INSERT INTO notification(booking_id, one_week, three_days, one_day) VALUES (:booking_id, :one_week, :three_days, :one_day)', [':booking_id' => $bookingId, ':one_week' => $oneWeek, ':three_days' => $threeDays, ':one_day' => $oneDay]); } else { $results = $mysql->query('UPDATE notification SET one_week = :one_week, three_days = :three_days, one_day = :one_day WHERE booking_id = :booking_id', [':booking_id' => $bookingId, ':one_week' => $oneWeek, ':three_days' => $threeDays, ':one_day' => $oneDay]); } return $results['success']; }
function obtenerTerceros($centro) { $db = new MySQL(); $sql = "SELECT * FROM `rondas`.`personal` WHERE `centro`='" . $centro . "';"; $consulta = $db->sql_query($sql); while ($row = $db->sql_fetchrow($consulta)) { array_push($rows, $row); } $db->sql_close(); return $rows; }