function RemoveAuction($config, $jsonResult) { $id = $_GET['auction_id']; $conn = new connection($config); $jsonResult->json_data['result_code'] = JSON::$resultCodes['ok']; $conn->query("DELETE FROM allegro where auction_id='" . $id . "';"); }
function AddProduct($config, $jsonResult) { $cargo_id = $_GET["cargo_id"]; $kind_id = ""; $kind = $_GET["kind"]; $amount = $_GET["amount"]; $sql1 = "SELECT COUNT(name) as kind_amount , kind_id FROM kind WHERE name = '" . $kind . "';"; $sql2 = "INSERT INTO kind(name) VALUES('" . $kind . "')"; $conn = new connection($config); $jsonResult->json_data['result_code'] = JSON::$resultCodes['ok']; try { $result1 = $conn->query($sql1); foreach ($result1 as $row) { if ($row['kind_amount'] === "0") { $conn->query($sql2); $kind_id = $conn->conn->lastInsertId(); } else { $kind_id = $row['kind_id']; } } $conn->query("INSERT INTO product(cargo_id , amount , kind_id) VALUES(" . $cargo_id . " , " . $amount . " , " . $kind_id . ")"); $product_id = $conn->conn->lastInsertId(); $jsonResult->json_data['result_data'] = $product_id; } catch (PDOException $e) { $jsonResult->json_data['result_code'] = JSON::$resultCodes['mysql_exception']; } }
public static function fetchOne($sql) { $con = new connection(); $con->execute($sql); $con->fetch(); return $con->rows; }
function the_cat($by_name = null, $linked = null) { if ($this->is_object()) { if (!empty($this->cat)) { // Gibt die ID der Kategorie zurück if (null == $by_name) { return $this->cat; // Gibt den Titel der Kategorie zurück } else { $db = new connection(); $get_the_catname = $db->query('SELECT * FROM object WHERE id=' . $this->cat); $the_catname = $db->fetch_array(); if (null !== $linked) { // Kategorie wird als Link ausgegeben return '<a href="./?cat=' . $the_catname['id'] . '" rel="nofollow">' . $the_catname['title'] . '</a> '; } else { // Kategorie wird nicht als Link ausgegeben return $the_catname['title'] . " "; } } } else { return false; } } }
function has_items($id) { $db = new connection(); $db->query('SELECT * FROM object WHERE type="page" AND status=1 AND parent_id=' . $id); if ($this->has_child($id)) { ?> <ul class="submenu"> <?php } while ($result = $db->fetch_array()) { ?> <li><a href='./?page_id=<?php echo $result['id']; ?> '><?php echo $result['menu_title']; ?> </a> <?php if ($this->has_items($result['id'])) { echo $this->has_items($result['id']); } ?> </li> <?php } if ($this->has_child($id)) { ?> </ul> <?php } }
public static function getRowCount() { $con = new connection(); $connection = $con->getConnection(); $query = "select * from manufacturer"; $result = $connection->query($query) or die(mysqli_error($connection)); return mysqli_num_rows($result) + 10; }
function dateExists() { $date = date('Y-m-d', strtotime($_GET['date'])); $sql = "SELECT COUNT(*) AS count FROM ipodate WHERE ipodate = '" . mysql_escape_string($date) . "'"; $con = new connection(); $con->execute($sql); die($con->fetch()); }
public function uploadFile($uploadclassObj) { $fileid = $uploadclassObj->getFileid(); $upload_filename = $uploadclassObj->getFilename(); $con = new connection(); $connection = $con->getConnection(); $query = "insert into uploads values(null, '{$fileid}', '{$upload_filename}')"; $result = $connection->query($query) or die(mysqli_error($connection)); }
public function getUserByName($name) { $con = new connection(); $db = $con->getConnection(); $sql = "SELECT * FROM user WHERE name=" . $name; foreach ($db->query($sql) as $row) { $user[] = array('id' => $row['id'], 'name' => $row['name'], 'password' => $row['password'], 'mail' => $row['mail'], 'adresse' => $row['adresse'], 'tel' => $row['tel']); } }
function GetAuctionList($config, $jsonResult) { $conn = new connection($config); $jsonResult->json_data['result_code'] = JSON::$resultCodes['ok']; $result = $conn->query("SELECT auction_id , name , sandbox FROM allegro;"); foreach ($result as $row) { array_push($jsonResult->json_data['result_data'], array('id' => $row['auction_id'], 'name' => $row['name'], 'sandbox' => $row['sandbox'])); } }
function GetCargoName($config, $jsonResult) { $cargo_id = $_GET['cargo_id']; $conn = new connection($config); $result = $conn->query("SELECT name FROM cargo WHERE cargo_id = " . $cargo_id . ";"); foreach ($result as $row) { array_push($jsonResult->json_data["result_data"], $row['name']); } $jsonResult->json_data["result_code"] = JSON::$resultCodes['ok']; }
function AddCargo($config, $jsonResult) { $name = $_GET['name']; $conn = new connection($config); $jsonResult->json_data['result_code'] = JSON::$resultCodes['ok']; try { $conn->query("INSERT INTO cargo(name) VALUES('" . $name . "');"); } catch (PDOException $e) { $jsonResult->json_data['result_code'] = JSON::$resultCodes['mysql_exception']; } }
function useralive($userid) { $con= new connection(); $con->execute("select time from users where iduser='******'"); $con->fetch(); $time1= $con->rows['time']; if ($time1<(time()-13)) return false; else return true; }
function getSymbols() { // get the full list of IPOs in the database $sql = "SELECT DISTINCT symbol FROM ipo"; $con = new connection(); $con->execute($sql); $symbols = array(); while ($con->fetch()) { $symbols[] = $con->rows["symbol"]; } return $symbols; }
function getCargoListWithKinds($config, $jsonResult) { $conn = new connection(new Config(null, null)); $result = array(); $cargoes = $conn->query("SELECT * FROM cargo"); foreach ($cargoes as $cargo) { $kinds = $conn->query("SELECT DISTINCT kind.name\n FROM product INNER JOIN kind on product.kind_id = kind.kind_id\n WHERE cargo_id =" . $cargo['cargo_id']); $kinds = $kinds->fetchAll(); array_push($result, array('name' => $cargo['name'], 'kinds' => $kinds)); } $jsonResult->json_data['result_data'] = $result; }
public function query() { //get connection object $connection = new connection(); //get query object $query = new query(); //get database connection $pdo = $connection->connect(); //set database connection on query object $query->setConnection($pdo); return $query; }
function getSymbols() { // get a list of all IPOs that don't have first day open/close price set $sql = "SELECT DISTINCT symbol, ipodate FROM ipo WHERE closeprice = 0 OR openprice = 0"; $con = new connection(); $con->execute($sql); $symbols = array(); while ($con->fetch()) { $symbols[] = array("symbol" => $con->rows["symbol"], "ipodate" => $con->rows["ipodate"]); } return $symbols; }
function getSymbols() { // get a list of IPOs from database that are missing the ipoprice $sql = "SELECT DISTINCT symbol FROM ipo WHERE ipoprice IS NULL"; $con = new connection(); $con->execute($sql); $symbols = array(); while ($con->fetch()) { $symbols[] = $con->rows["symbol"]; } return $symbols; }
function AddItems($config, $jsonResult) { $conn = new connection($config); $product_id = $_GET['product_id']; $amount = $_GET['amount']; $jsonResult->json_data['result_code'] = JSON::$resultCodes['ok']; try { $conn->query("UPDATE product SET amount = amount + " . $amount . " WHERE product_id = " . $product_id); } catch (PDOException $e) { $jsonResult->json_data['result_code'] = JSON::$resultCodes['mysql_exception']; } }
public function getAllCategories() { $aCategories = array(); $oConnection = new connection(); $sSQL = "SELECT TypeID\n\t\tFROM tbproducttype"; $oResult = $oConnection->query($sSQL); while ($aRow = $oConnection->fetch_array($oResult)) { $oCategory = new category(); $oCategory->load($aRow["TypeID"]); $aCategories[] = $oCategory; } $oConnection->close_connection(); return $aCategories; }
public function load($iRecordID) { $oCon = new connection(); $sSQL = "SELECT RecordID, Title, Artist, Price, GenreID, PhotoPath\n\t\t\t\tFROM tbrecords \n\t\t\t\tWHERE RecordID = " . $iRecordID; $oResultSet = $oCon->query($sSQL); $aRow = $oCon->fetchArray($oResultSet); $this->iRecordID = $aRow['RecordID']; $this->sTitle = $aRow['Title']; $this->sArtist = $aRow['Artist']; $this->fPrice = $aRow['Price']; $this->iGenreID = $aRow['GenreID']; $this->iPhotoPath = $aRow['PhotoPath']; $oCon->close(); }
function GetCargoList($config, $jsonResult) { $conn = new connection($config); $result = $conn->query("SELECT\n COUNT(DISTINCT kind_id) as kind_amount ,\n COUNT(product_id) as product_amount ,\n SUM(amount) as item_amount,\n cargo.cargo_id,\n cargo.name as cargo_name\n FROM product\n RIGHT JOIN cargo on product.cargo_id = cargo.cargo_id\n GROUP BY cargo.name\n ORDER BY cargo.cargo_id;"); print $conn->error; foreach ($result as $row) { array_push($jsonResult->json_data["result_data"], array('kind_amount' => $row['kind_amount'], 'product_amount' => $row['product_amount'], 'item_amount' => $row['item_amount'], 'cargo_id' => $row['cargo_id'], 'cargo_name' => $row['cargo_name'])); } if ($result->rowCount() === 0) { $jsonResult->json_data['result_code'] = JSON::$resultCodes['no_cargoes']; } else { $jsonResult->json_data['result_code'] = JSON::$resultCodes['ok']; } }
function symbolsNoScore() { // get a list of IPOs and their dates from the database that are missing tweets/hype or are in the future $sql = "SELECT DISTINCT symbol, ipodate FROM ipo WHERE hype IS NULL OR ipodate >= CURDATE()"; $con = new connection(); $con->execute($sql); $symbols = array(); while ($con->fetch()) { $symbol = array(); $symbol["symbol"] = $con->rows["symbol"]; $symbol["ipodate"] = strtotime($con->rows["ipodate"]); $symbols[] = $symbol; } return $symbols; }
function getProductList($kind_name) { $productsWithPhotos = array(); $conn = new connection(new Config(null, null)); $products = $conn->query("SELECT product_id , amount , kind.name as kind\nFROM product INNER JOIN kind on product.kind_id = kind.kind_id\nWHERE kind.name = '" . $kind_name . "';"); print $conn->error; foreach ($products as $product) { $tmp_photos = array(); $photos = $conn->query("SELECT photo.photo_id as id, photo.extension\n from product inner join photo on product.product_id = photo.product_id\n where product.product_id = '" . $product['product_id'] . "';"); foreach ($photos as $photo) { array_push($tmp_photos, new Photo($photo['id'], $photo['extension'])); } array_push($productsWithPhotos, new Product($product['product_id'], $product['kind'], $product['amount'], $tmp_photos)); } return $productsWithPhotos; }
function RemoveProduct($config, $jsonResult) { $conn = new connection($config); $product_id = $_GET['product_id']; $jsonResult->json_data['result_code'] = JSON::$resultCodes['ok']; try { $conn->query("DELETE FROM product WHERE product_id=" . $product_id . ";"); $result = $conn->query("SELECT photo_id , extension FROM photo WHERE product_id = " . $product_id . ";"); foreach ($result as $row) { $photo_id = $row['$photo_id']; unlink('../images/' . $photo_id . '.' . $row['extension']); $conn->query("DELETE FROM photo WHERE photo_id = " . $photo_id . ";"); } } catch (PDOException $e) { $jsonResult->json_data['result_code'] = JSON::$resultCodes['mysql_exception']; } }
function __construct() { try { parent::__construct(); } catch (mysqli_sql_exception $e) { throw $e; } }
function getCargoListWithKinds($config, $jsonResult) { $kind_name = $_GET['kind_name']; $productsWithPhotos = array(); $conn = new connection($config); $products = $conn->query("SELECT product_id , amount , kind.name as kind\nFROM product INNER JOIN kind on product.kind_id = kind.kind_id\nWHERE kind.name = '" . $kind_name . "';"); print $conn->error; foreach ($products as $product) { $tmp_photos = array(); $photos = $conn->query("SELECT photo.photo_id as id, photo.extension\n from product inner join photo on product.product_id = photo.product_id\n where product.product_id = '" . $product['product_id'] . "';"); foreach ($photos as $photo) { array_push($tmp_photos, new Photo($photo['id'], $photo['extension'])); } array_push($productsWithPhotos, new Product($product['product_id'], $product['kind'], $product['amount'], $tmp_photos)); } $jsonResult->json_data['result_data'] = $productsWithPhotos; }
public static function getInstance() { if (!isset(self::$instance)) { self::$instance = new PDO('mysql:host=' . DB_HOST . ';dbname=' . DB_DATABASE, DB_USER, DB_PASS, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); self::$instance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); self::$instance->setAttribute(PDO::ATTR_ORACLE_NULLS, PDO::NULL_EMPTY_STRING); } return self::$instance; }
function AddAuction($config, $jsonResult) { $id = $_GET['auction_id']; $sandbox = $_GET['sandbox']; $conn = new connection($config); $jsonResult->json_data['result_code'] = JSON::$resultCodes['ok']; $allegroConn = new ALLEGRO(); if ($sandbox) { if (!$allegroConn->Connect($allegroConn->sandbox)) { $jsonResult->json_data['result_code'] = JSON::$resultCodes['allegro_error']; return; } } else { if (!$allegroConn->Connect($allegroConn->production)) { $jsonResult->json_data['result_code'] = JSON::$resultCodes['allegro_error']; return; } } $itemInfoRequest = array('sessionHandle' => $allegroConn->sessionNumber, 'itemsIdArray' => array($id + 0), 'getDesc' => 1, 'getPostageOptions' => 1); try { $auction_info = $allegroConn->GetItemsInfo($itemInfoRequest); } catch (Exception $e) { $jsonResult->json_data['result_code'] = JSON::$resultCodes['allegro_error']; return; } $auction_name = $auction_info->arrayItemListInfo->item->itemInfo->itName; if ($auction_name !== null) { if ($sandbox) { $sandbox = 1; } else { $sandbox = 0; } $jsonResult->json_data['result_data'] = array('auction_id' => $id, 'name' => $auction_name, 'sandbox' => $sandbox); } else { $jsonResult->json_data['result_code'] = JSON::$resultCodes['allegro_no_auction_name']; return; } try { $conn->query("INSERT INTO allegro VALUES ('" . $id . "' , '" . $auction_name . "' , " . $sandbox . ");"); } catch (PDOException $e) { $jsonResult->json_data['result_code'] = JSON::$resultCodes['mysql_exception']; return; } }
function get_user_modules($login) { //get every module added by the user $sql = "SELECT * \n\t\t\t\tFROM module INNER JOIN menu_utilisateur \n\t\t\t\t\tON module.id = menu_utilisateur.module\n\t\t\t\tWHERE menu_utilisateur.utilisateur = '" . phpCAS::getUser() . "';"; $conn = new connection(); $conn->Connect(); $response = $conn->Conn->query($sql); $retour = array(); while ($vResult = $response->fetch()) { $module = array(); $module[titre] = $vResult['titre']; $module[description] = $vResult['description']; $module[lien] = $vResult['lien']; $module[id] = $vResult['id']; $module[img] = $vResult['img']; $retour[] = $module; } return $retour; }