function attach_Image($fileDirectory) { $Mysql = new Mysql(); $uploadCheck = 1; $imageFileType = pathinfo($fileDirectory, PATHINFO_EXTENSION); //checks if image if (isset($_POST["submit"])) { $check = getimagesize($_FILES["fileToUpload"]["tmp_name"]); if ($check !== false) { $uploadCheck = 1; } else { return "File is not an image."; $uploadCheck = 0; } //check if image already exisits if (file_exists($fileDirectory)) { return "Sorry, file already exists."; $uploadCheck = 0; } } //check if ($uploadCheck == 0) { return "There was a problem uploading your file."; } else { if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $fileDirectory)) { $Mysql->attach_Image_To_Account("/userImages/" . basename($_FILES["fileToUpload"]["name"])); return "The file " . basename($_FILES["fileToUpload"]["name"]) . " has been uploaded."; } else { return "Sorry, there was an error uploading your file."; } } }
public function testGetConnectionInactive() { $config = ['host' => 'localhost', 'active' => false]; $object = new Mysql($this->string, $this->dateTime, $config); $logger = $this->getMockForAbstractClass('Magento\\Framework\\DB\\LoggerInterface'); $this->assertNull($object->getConnection($logger)); }
function buildPage() { global $mysql; $MySQLConnection = new Mysql($mysql['host'], $mysql['port'], $mysql['user'], $mysql['password'], $mysql['database']); $MySQLConnection->connect(); if ($result = $MySQLConnection->getQuery('SELECT x.matchID AS matchID, x.matchDate AS matchDate, y.teamName AS matchHomeTeam, y.teamLogo AS matchHomeTeamLogo, z.teamName AS matchForeignTeam, z.teamLogo AS matchForeignTeamLogo FROM matches AS x JOIN teams AS y ON y.teamID = matchHomeTeam JOIN teams AS z ON z.teamID = matchForeignTeam;')) { while ($row = mysqli_fetch_assoc($result)) { $userTips = getUserTips($MySQLConnection, $row["matchID"]); echo ' <div class="panel panel-default"> <form id="match_' . $row["matchID"] . '" method="POST"> <div class="panel-body"> <div class="panel-heading">' . $row["matchHomeTeam"] . ' vs. ' . $row["matchForeignTeam"] . '</div> <div class="input-group"> <label>' . $row["matchHomeTeam"] . '</label> <input type="number"min="0"value="' . $userTips["tipScoreHome"] . '" name="ScoreHome" id="ScoreHome" required/> </div> <div class="input-group"> <label>' . $row["matchForeignTeam"] . '</label> <input type="number"min="0" value="' . $userTips["tipScoreForeign"] . '" name="ScoreForeign" id="ScoreForeign" required/> <input type="button" value="Place Tip" onclick="placeTip(' . $row["matchID"] . ');"/> </div> </div> </form> </div> '; } } }
public static function mantenimientoDirectorio(EntidadDirectorio $objDirectorioEntidad, array $param) { $query = NULL; $query2 = NULL; $error = NULL; $objMysql = new Mysql(); $objMysql1 = new Mysql(); if ($param[0] == 'DEL') { $query2 = "select count(*) as 'cantidad' from cms_directorio where idcontenedor='" . $objDirectorioEntidad->getIdDirectorio() . "'"; $res_verificar = $objMysql1->ejecutar($query2); $reg = $res_verificar->fetch(PDO::FETCH_ASSOC); if ($reg['cantidad'] != 0) { $error = 2; } else { $objMysql = new Mysql(); try { $query = "CALL sp_mnt_directorio('" . $param[0] . "','" . $objDirectorioEntidad->getIdDirectorio() . "','" . $objDirectorioEntidad->getNombre() . "','" . $objDirectorioEntidad->getNivel() . "','" . $objDirectorioEntidad->getPosicion() . "','" . $objDirectorioEntidad->getContenido() . "','" . $objDirectorioEntidad->getIdpagina() . "','" . $objDirectorioEntidad->getRuta() . "','" . $objDirectorioEntidad->getIdcontenedor() . "','" . $objDirectorioEntidad->getAbrir() . "','" . $objDirectorioEntidad->getMostrar() . "','" . $objDirectorioEntidad->getEliminado() . "');"; $rs = $objMysql->ejecutar($query); $error = 1; } catch (PDOException $exc) { $error = 0; } } } else { try { $query = "CALL sp_mnt_directorio('" . $param[0] . "','" . $objDirectorioEntidad->getIdDirectorio() . "','" . $objDirectorioEntidad->getNombre() . "','" . $objDirectorioEntidad->getNivel() . "','" . $objDirectorioEntidad->getPosicion() . "','" . $objDirectorioEntidad->getContenido() . "','" . $objDirectorioEntidad->getIdpagina() . "','" . $objDirectorioEntidad->getRuta() . "','" . $objDirectorioEntidad->getIdcontenedor() . "','" . $objDirectorioEntidad->getAbrir() . "','" . $objDirectorioEntidad->getMostrar() . "','" . $objDirectorioEntidad->getEliminado() . "');"; $rs = $objMysql->ejecutar($query); $error = 1; } catch (PDOException $exc) { $error = 0; } } return $error; }
public static function removeProduct($barcode, $expiration) { $mysql = new Mysql(); $update = $mysql->update("delete from product where barcode='{$barcode}' and expiration='{$expiration}'"); $mysql->closeConnection(); return $update; }
function login() { require 'Conn/Redirect.php'; $redirect = new Redirect(); if (isset($_POST["name"]) && isset($_POST["pwd"])) { $name = $_POST["name"]; $pwd = md5($_POST["pwd"]); require_once 'Conn/Mysql.php'; $mysql = new Mysql(); $mysql->query("select * from users where name ='{$name}';"); $row = $mysql->get_object(); if (isset($row)) { if ($row->pwd == $pwd) { session_start(); $_SESSION['user'] = $name; $redirect->go('index.php'); } else { $error = "密码错误!"; $redirect->go('index.php?page=login'); } } else { $error = "用户名不存在!"; $redirect->go('index.php?page=login'); } } else { $error = "用户名或密码不能为空!"; $redirect->go('index.php?page=login'); } }
function buildPage() { global $mysql; $MySQLConnection = new Mysql($mysql['host'], $mysql['port'], $mysql['user'], $mysql['password'], $mysql['database']); $MySQLConnection->connect(); if ($result = $MySQLConnection->getQuery('SELECT * FROM users JOIN countries ON userCountry = iso3166 WHERE userID = ' . $_GET["userID"] . ';')) { while ($row = mysqli_fetch_assoc($result)) { echo ' <div class="col-md-2"> <div class="panel panel-default"> <div class="panel-heading">' . $row["userLogin"] . '</div> <div class="panel-body"> <div class="media"> <div class="media-left"> <a href="img/avatar/' . $row["userAvatar"] . '"> <img class="media-object" src="img/avatar/' . $row["userAvatar"] . '" /> </a> </div> </div> <p><b>First Name: </b>' . $row["userFirstName"] . '</p> <p><b>Last Name: </b>' . $row["userLastName"] . '</p> </div> </div> </div> '; } } }
public function getList($search) { $mysql = new Mysql(); $PageSize = intval($search->PageSize); $FirstRow = intval($search->PageIndex - 1) * $PageSize; $sqlList = "select Subject,Url from project where (Status=6 or Status=7) and Type=" . intval($this->Type) . " order by Pv desc LIMIT {$FirstRow}, {$PageSize};"; $sqlCount = "select count(Id) from project where (Status=6 or Status=7) and Type=" . intval($this->Type); $res = array(); if ($search->NeedCount) { // 查找 count 和 数据 $totalCount = $mysql->getVar($sqlCount); if (empty($totalCount)) { $res["Success"] = true; $res["Data"] = null; $res["Count"] = 0; } else { $res["Success"] = true; $res["Data"] = $mysql->getData($sqlList); $res["Count"] = $totalCount; } } else { // 只查找数据 $res["Success"] = true; $res["Data"] = $mysql->getData($sqlList); } $mysql->closeDb(); return $res; }
function buildPage() { global $mysql; $MySQLConnection = new Mysql($mysql['host'], $mysql['port'], $mysql['user'], $mysql['password'], $mysql['database']); $MySQLConnection->connect(); if ($result = $MySQLConnection->getQuery('SELECT messageID, messageRecipient, messageSender, messageTime, messageSubject, messageBody, userLogin, userID FROM messages JOIN users ON messageSender = userID WHERE messageRecipient = ' . $_SESSION["userID"] . ' LIMIT 0,25;')) { echo ' <div class="col-md-2"> '; while ($row = mysqli_fetch_object($result)) { $messageJSON = (string) json_encode($row); echo ' <div class="list-group"> <a href="#" onclick="displayMessage(\'' . $row->messageID . '\');"" class="list-group-item"> <p class="list-group-item-text">' . $row->messageTime . ' - ' . $row->userLogin . '</p> <h4 class="list-group-item-heading">' . $row->messageSubject . '</h4> </a> </div> '; } echo '</div>'; } else { echo '<script type="text/javascript">', 'printError(\'Error while getting your messages!\')', '</script>'; } }
public function getUserByProjectId($projectId) { $mysql = new Mysql(); $sql = "SELECT GROUP_CONCAT(DISTINCT result.UserId) as Ids ,GROUP_CONCAT(DISTINCT result.name) as Names FROM (SELECT d.UserId,u.Name FROM " . $mysql->dbpre . "developer" . $mysql->debug . " as d ," . $mysql->dbpre . "user" . $mysql->debug . " as u WHERE d.UserId=u.UserId and ProjectId=" . intval($projectId) . " ) as result"; //echo $sql; $result = $mysql->getLine($sql); $mysql->closeDb(); return $result; }
/** * Add main response fields. * * @param Mysql $query */ protected function setResponseData(Mysql $query) { $query_rows = clone $query; $this->setResponse('total_items', $query_rows->nolimit()->nogroupby()->noorderby()->count()->get()->counter()); //$this->setResponse('total_items', $query_rows->nolimit()->noorderby()->get()->count()); $this->setResponse('cur_page', $this->cur_page); $this->setResponse('selected_item', $this->selected_item); $this->setResponse('data', $query->get()->all()); }
function createUser($un, $pwd) { $mysql = new Mysql(); $createCredentials = $mysql->createUsernameandPass($un, md5($pwd)); if ($createCredentials) { header("location: login.php"); } else { return 1; } }
public function getList($projectId) { $mysql = new Mysql(); $sql = "SELECT m.*,u.Name FROM " . $mysql->dbpre . "memo" . $mysql->debug . " as m," . $mysql->dbpre . "user" . $mysql->debug . " as u WHERE m.UserId=u.UserId AND ProjectId=" . intval($projectId); // var_dump( $sql ); // exit; $result = $mysql->getData($sql); $mysql->closeDb(); return $result; }
public static function kill() { $mysql_name = env('container') . '_mysql'; $mysql = new Mysql($mysql_name); $mysql->kill(); $web_name = basename(self::getProjectDir()); $web_name .= '_web'; $web = new Web($web_name); $web->kill(); }
function validate_user($un, $pwd) { $mysql = new Mysql(); $ensure_credentials = $mysql->verify_Username_and_Pass($un, md5($pwd)); if ($ensure_credentials) { $_SESSION['status'] = 'authorized'; header("location: index2.php"); } else { return "Benutzername und Passwort nicht korrekt!"; } }
function validate_user($un, $pwd) { $mysql = new Mysql(); $ensure_credentials = $mysql->verify_Username_and_Pass($un, md5($pwd)); if ($ensure_credentials) { $_SESSION['status'] = 'authorized'; header('location: index.php'); } else { return "Please enter a correct username and password"; } }
public static function getClient($email, $password) { $mysql = new Mysql(); $response = $mysql->query("select * from client where email='{$email}' and password=PASSWORD('{$password}')"); $mysql->closeConnection(); if ($response == false) { return false; } $response = mysql_fetch_assoc($response); $client = new Client($response['name'], $response['surname'], $response['email'], $response['password']); return $client; }
function printCountrySelect() { global $mysql; $MySQLConnection = new Mysql($mysql['host'], $mysql['port'], $mysql['user'], $mysql['password'], $mysql['database']); $MySQLConnection->connect(); $result = $MySQLConnection->getQuery('SELECT * FROM countries;'); echo '<select id="userCountry" name="userCountry"><option value="">---NO COUNTRY SELECTED---</option>'; while ($row = mysqli_fetch_assoc($result)) { echo '<option value="' . $row["iso3166"] . '">' . $row["countryName"] . '</option>'; } echo '</select>'; }
function __construct($name = '') { static $db; if (!is_object($db)) { $db = new Mysql(); } if ($name) { $this->tablename = $name; } else { $this->tablename = MODEL_NAME; } $this->db = $db->t($this->tablename); }
public static function mantenimientoPopup(EntidadPopup $objPopupEntidad, array $param) { $query = NULL; $error = NULL; $objcons = new Mysql(); try { $query = "CALL SP_MNT_POPUP('" . $param[0] . "',\n '" . $objPopupEntidad->getIdpopup() . "',\n '" . $objPopupEntidad->getNom() . "', \n '" . $objPopupEntidad->getImg() . "', \n '" . $objPopupEntidad->getAncho() . "', \n '" . $objPopupEntidad->getAlto() . "', \n '" . $objPopupEntidad->getResizable() . "',\n '" . $objPopupEntidad->getPosition() . "', \n '" . $objPopupEntidad->getEnlace() . "',\n '" . $objPopupEntidad->getUrl() . "',\n '" . $objPopupEntidad->getAbrir() . "', \n '" . $objPopupEntidad->getSwactivo() . "');"; $rs = $objcons->ejecutar($query); $error = 1; } catch (PDOException $exc) { $error = 0; } return $error; }
public static function mantenimientoServicio(EntidadServicio $objServicio, array $param) { $query = NULL; $error = NULL; $objMysql = new Mysql(); try { $query = "CALL sp_mnt_servicio('" . $param[0] . "',\n '" . $objServicio->getIdservicio() . "',\n '" . $objServicio->getDescripcion() . "',\n '" . $objServicio->getFoto() . "', \n '" . $objServicio->getFotochico() . "', \n '" . $objServicio->getEliminado() . "',\n '" . $objServicio->getUrl() . "');"; $rs = $objMysql->ejecutar($query); $error = 1; } catch (PDOException $exc) { $error = 0; } return $error; }
public static function mantenimientoBanner(EntidadBannerInterior $objBannerEntidad, array $param) { $query = NULL; $error = NULL; $objMysql = new Mysql(); try { $query = "CALL sp_mnt_bannerinterno('" . $param[0] . "',\n '" . $objBannerEntidad->getIdbannerinterior() . "',\n '" . $objBannerEntidad->getDescripcion() . "',\n '" . $objBannerEntidad->getFoto() . "', \n '" . $objBannerEntidad->getFotochico() . "', \n '" . $objBannerEntidad->getEliminado() . "',\n '" . $objBannerEntidad->getUrl() . "');"; $rs = $objMysql->ejecutar($query); $error = 1; } catch (PDOException $exc) { $error = 0; } return $error; }
public static function mantenimientoConvocatoria(EntidadConvocatoria $objBannerConvocatoria, array $param) { $query = NULL; $error = NULL; $objMysql = new Mysql(); try { $query = "CALL sp_mnt_convocatoria('" . $param[0] . "',\n '" . $objBannerConvocatoria->getIdconvocatoria() . "',\n '" . $objBannerConvocatoria->getDescripcion() . "', \n '" . $objBannerConvocatoria->getFec_ini() . "', \n '" . $objBannerConvocatoria->getFec_fin() . "',\n '" . $objBannerConvocatoria->getDoc_conv() . "', \n '" . $objBannerConvocatoria->getDoc_res() . "', \n '" . $objBannerConvocatoria->getMostrar() . "',\n '" . $objBannerConvocatoria->getResultado() . "');"; $rs = $objMysql->ejecutar($query); $error = 1; } catch (PDOException $exc) { $error = 0; } return $error; }
public static function mantenimientoDatos(EntidadDatos $objDatosEntidad, array $param) { $query = NULL; $error = NULL; $objMysql = new Mysql(); try { $query = "CALL sp_mnt_datos('" . $param[0] . "','" . $objDatosEntidad->getIddatos() . "','" . $objDatosEntidad->getPosicion() . "','" . $objDatosEntidad->getNombre() . "','" . $objDatosEntidad->getContenido() . "','" . $objDatosEntidad->getUrl() . "');"; $rs = $objMysql->ejecutar($query); $error = 1; } catch (PDOException $exc) { $error = 0; } return $error; }
public static function mantenimientoPagina(EntidadPagina $objPaginaEntidad, array $param) { $query = NULL; $error = NULL; $objMysql = new Mysql(); try { $query = "CALL sp_mnt_pagina('" . $param[0] . "'," . "'" . $objPaginaEntidad->getIdpagweb() . "'," . "'" . $objPaginaEntidad->getIdusuario() . "'," . "'" . $objPaginaEntidad->getTitulo() . "'," . "'" . $objPaginaEntidad->getTipo() . "'," . "'" . $objPaginaEntidad->getTag() . "'," . "'" . $objPaginaEntidad->getDirecimag() . "'," . "'" . $objPaginaEntidad->getContenido() . "'," . "'" . $objPaginaEntidad->getImagen() . "'," . "'" . $objPaginaEntidad->getDesc() . "'," . "'" . $objPaginaEntidad->getIdclase() . "'," . "'" . $objPaginaEntidad->getScript() . "');"; $rs = $objMysql->ejecutar($query); $error = 1; } catch (PDOException $exc) { $error = 0; } return $error; }
public static function adicionar_contador($tabela, $id) { $db = new Mysql(); switch ($tabela) { case 'NOTICIA': $campo_id = 'NOTICIA_CDG'; break; case 'ITEM': $campo_id = 'ITEM_CDG'; break; } $db->Query(' UPDATE ' . $tabela . ' SET ' . $tabela . '_VIEW = ' . $tabela . '_VIEW + 1 WHERE ' . $campo_id . ' = ' . $id); }
public static function mantenimientoBanner(EntidadBanner $objBannerEntidad, array $param) { $query = NULL; $error = NULL; $objMysql = new Mysql(); try { $query = "CALL sp_mnt_banner('" . $param[0] . "',\n '" . $objBannerEntidad->getIdbanner() . "',\n '" . $objBannerEntidad->getTitulo() . "', \n '" . $objBannerEntidad->getUrl() . "', \n '" . $objBannerEntidad->getOrden() . "',\n '" . $objBannerEntidad->getFoto() . "', \n '" . $objBannerEntidad->getFotochico() . "', \n '" . $objBannerEntidad->getEliminado() . "', \n '" . $objBannerEntidad->getCargaurl() . "', \n '" . $objBannerEntidad->getMostrar() . "',\n '" . $objBannerEntidad->getIdcatempre() . "',\n '" . $objBannerEntidad->getDescripcion() . "',\n '" . $objBannerEntidad->getAbrir() . "',\n '" . $objBannerEntidad->getEnlace() . "');"; $rs = $objMysql->ejecutar($query); $error = 1; } catch (PDOException $exc) { $error = 0; } return $error; }
public static function mantenimientoProducto(EntidadProducto $objProductoEntidad, array $param) { $query = NULL; $error = NULL; $objMysql = new Mysql(); try { $query = "CALL sp_mnt_productos('" . $param[0] . "',\n '" . $objProductoEntidad->getIdproducto() . "',\n '" . $objProductoEntidad->getCodigo() . "', \n '" . $objProductoEntidad->getNombre() . "', \n '" . $objProductoEntidad->getIdcategoria() . "',\n '" . $objProductoEntidad->getFoto1() . "', \n '" . $objProductoEntidad->getFoto2() . "', \n '" . $objProductoEntidad->getFoto3() . "', \n '" . $objProductoEntidad->getDocumento() . "', \n '00-00-0000',\n '" . $objProductoEntidad->getEliminado() . "', \n '" . $objProductoEntidad->getDestacado() . "', \n '" . $objProductoEntidad->getDescripcion() . "',\n '" . $objProductoEntidad->getEdades() . "', \n '" . $objProductoEntidad->getIdgenero() . "', \n '" . $objProductoEntidad->getPotencia() . "', \n '" . $objProductoEntidad->getVoltaje() . "', \n '" . $objProductoEntidad->getCaracter() . "');"; $rs = $objMysql->ejecutar($query); $error = 1; } catch (PDOException $exc) { $error = 0; } return $error; }
public static function mantenimientoProyecto(EntidadProyecto $objProyectoEntidad, array $param) { $query = NULL; $error = NULL; $objMysql = new Mysql(); try { $query = "CALL sp_mnt_proyecto('" . $param[0] . "',\n '" . $objProyectoEntidad->getIdproyecto() . "',\n '" . $objProyectoEntidad->getFoto() . "', \n '" . $objProyectoEntidad->getDescripcion() . "',\n '" . $objProyectoEntidad->getContenido() . "',\n '" . $objProyectoEntidad->getUrl() . "',\n '" . $objProyectoEntidad->getAbrir() . "',\n '" . $objProyectoEntidad->getMostrar() . "');"; $rs = $objMysql->ejecutar($query); $error = 1; } catch (PDOException $exc) { $error = 0; } return $error; }
public static function mantenimientoClase(EntidadClase $objClaseEntidad, array $param) { $query = NULL; $error = NULL; $objMysql = new Mysql(); try { $query = "CALL sp_mnt_clase('" . $param[0] . "','" . $objClaseEntidad->getIdclase() . "','" . $objClaseEntidad->getNombre() . "','00-00-0000','" . $objClaseEntidad->getEliminado() . "');"; $rs = $objMysql->ejecutar($query); $error = 1; } catch (PDOException $exc) { $error = 0; } return $error; }