<?php require '../init.php'; require '../tools.php'; try { Database::runQuery("DELETE FROM brew WHERE id = :brewid LIMIT 1", array("brewid" => (int) $_POST['brewId'])); success(); } catch (PDOException $e) { fail("Error in api/schedule/create.php: " . $e->getMessage()); }
public function storeAddress($searchId, $paramAdd, $paramCom) { $db = new Database(); $query = "select * from searchAddresses where searchId='{$searchId}'"; $result = mysql_query($query) or die(mysql_error()); $row = mysql_num_rows($result); if ($row > 0) { $rw = mysql_fetch_array(mysql_query($query)); $id = $rw['id']; $query = "update searchAddresses set paramAddress='{$paramAdd}', paramComments='{$paramCom}' where id='{$id}'"; $result = $db->runQuery($query); } else { $db->runQuery("insert into searchAddresses (searchId, paramAddress, paramComments) values ('{$searchId}','{$paramAdd}','{$paramCom}')"); } }
<?php require '../init.php'; require '../tools.php'; if (!isLoggedIn()) { fail("Only logged in users can get recipes"); } $beerId = htmlspecialchars($_GET['beerId']); $query = "SELECT \n beer.id,\n beer.name,\n beer.beerTypeId,\n beer.beerType,\n beer.createdBy,\n user.username\n FROM\n (SELECT\n beer.id,\n beer.name,\n beer.beerTypeId,\n beerType.name as beerType,\n beer.createdBy\n FROM beer INNER JOIN beerType\n ON beer.beerTypeId = beerType.id)\n AS beer\n INNER JOIN user\n ON beer.createdBy = user.id\n WHERE beer.id= :id\n LIMIT 1"; $bind_params = array("id" => $beerId); if ($data = Database::runQuery($query, $bind_params)) { success($data[0]); } fail("Error in beer/get.php");
<?php require '../utilities/init.php'; require '../utilities/tools.php'; $data = Database::runQuery("SELECT * FROM keg WHERE id = :id", array("id" => $_GET['kegId'])); $keg = $data[0]; // Grab the first result (should only be one) ?> <form id="updateKegForm" method="post" action="<?php echo getBaseUrl(); ?> api/keg/update.php"> <input type="hidden" name="kegId" id="kegId" value="<?php echo $keg['id']; ?> "> <div id="errorMessage" class="alert alert-danger text-center" role="alert" style="display: none;"></div> <div class="form-group"> <label for="serialNum">Serial Number</label> <input type="text" class="form-control" id="serialNum" name="serialNum" maxlength="50" required value="<?php echo $keg['serialNum']; ?> "> </div> </form>
<!-- Local JavaScript --> <script src="js/docs.js"></script> <script src="js/github.info.js"></script> <script src="js/custom.js"></script> <title>Metro UI CSS : Metro Bootstrap CSS Library</title> </head> <body class="metro"> <?php if (isset($_GET['jid'])) { $id = $_GET['jid']; } include 'functions.php'; $handle = new Database(); $result = $handle->runQuery("SELECT JobId, JobTitle, JobDepartment, JobLocation, JobShortDesc, JobDetailDesc, JobCreated from webx_jobs WHERE JobActive = 1 AND JobId = '" . $handle->decryption($id) . "' ORDER BY JobOrderBy"); ?> <header class="bg-dark" data-load="header.php"></header> <div class=""> <!--<div style="background: url(images/b1.jpg) top left no-repeat; background-size: cover; height: 300px;"> <div class="container" style="padding: 50px 20px"> <h1 class="fg-white">Abx</h1> <h2 class="fg-white">Metro UI CSS a set of styles to create a site<br /> with an interface similar to Windows 8.</h2> <a href="https://github.com/olton/Metro-UI-CSS/archive/master.zip" class="place-left button bg-darkRed bg-hover-red fg-white fg-hover-white bd-orange" style="margin-top: 10px"> <h3 style="margin: 10px 40px">Download <span class="icon-download-2 on-right"></span></h3> </a> </div> </div>--> <?php while ($row = $result->fetch_array(MYSQLI_ASSOC)) { ?>
echo $data['supplier']; ?> "> </div> <div class="form-group"> <label for="quantity">Quantity</label> <input type="number" class="form-control" id="quantity" name="quantity" value='<?php echo $data['quantity']; ?> ' required> </div> <div class="form-group"> <label for="unitId">Units</label> <select name="unitId" class="form-control"> <?php $units = Database::runQuery("SELECT * FROM unit"); foreach ($units as $unit) { if ($unit['id'] == $data['unitId']) { $selected = "selected"; } else { $selected = ""; } echo "<option value='{$unit['id']}' {$selected}>{$unit['name']}</option>"; } ?> </select> </div> <div class="form-group"> <label for="lowValue">Low Value</label> <input type="number" class="form-control" id="lowValue" name="lowValue" value='<?php echo $data['lowValue'];
<?php require '../init.php'; require '../tools.php'; $dateStart = $_GET['start'] . " 00:00:00"; $dateEnd = $_GET['end'] . " 23:59:59"; $returnJSON = array(); $events = Database::runQuery("SELECT\n\t\tbrew.id AS brewId,\n\t\tbrew.brewStart,\n\t\tbrew.brewEnd,\n\t\tbrew.quantity,\n\t\tbrew.beerid,\n\t\tbrew.userid,\n\t\tbeer.name AS beerName,\n\t\tu.username as username,\n\t\tu.id as userId\n\tFROM\n\t\tbrew\n\tLEFT OUTER JOIN\n\t\tbeer ON beerid = beer.id\n\tLEFT OUTER JOIN\n\t\t`user` AS u ON userid = u.id\n\tWHERE :start1 BETWEEN brewStart AND brewEnd\n\tOR\t:end1 BETWEEN brewStart AND brewEnd\n\tOR brewStart BETWEEN :start2 AND :end2\n\tOR brewEnd BETWEEN :start3 AND :end3", array("start1" => $dateStart, "start2" => $dateStart, "start3" => $dateStart, "end1" => $dateEnd, "end2" => $dateEnd, "end3" => $dateEnd)); foreach ($events as $event) { $returnJSON[] = array('title' => $event['beerName'] . " - " . $event['brewId'] . " - " . $event['username'], 'id' => $event['brewId'], 'start' => $event['brewStart'], 'end' => $event['brewEnd'], 'editable' => $event['userid'] == $_SESSION['userId'] ? true : false, 'color' => $event['userid'] == $_SESSION['userId'] ? "#337ab7" : "#7BA9D0"); } echo json_encode($returnJSON);
<?php require '../init.php'; require '../tools.php'; try { $data = Database::runQuery("INSERT INTO keg (serialNum) VALUES (:serialNum)", array("serialNum" => $_POST['serialNum'])); success(); } catch (PDOException $e) { fail("Error in api/update.php: " . $e->getMessage()); }
<?php require '../init.php'; require '../tools.php'; $query = "SELECT \n keg.id as kegId,\n keg.serialNum,\n kegorder.id as kegOrderId,\n kegorder.customerId as customerId,\n customer.firstName as customerFirstName,\n customer.lastName as customerLastName\n FROM keg\n LEFT OUTER JOIN \n (SELECT * FROM kegorder WHERE returned = 0) AS kegorder\n ON kegorder.kegId=keg.id\n LEFT OUTER JOIN customer ON kegorder.customerId = customer.id\n GROUP BY keg.id"; if ($data = Database::runQuery($query)) { success($data); } fail("Error in keg/getAll.php");
<?php require '../init.php'; require '../tools.php'; $brewStart = new DateTime($_POST['brewStart']); $brewStart = $brewStart->format("Y-m-d H:i:s"); $brewEnd = new DateTime($_POST['brewEnd']); $brewEnd = $brewEnd->format("Y-m-d H:i:s"); try { $data = Database::runQuery("UPDATE brew\n SET brewStart = :brewStart,\n brewEnd = :brewEnd,\n quantity = :quantity,\n beerId = :beerId,\n userId = :userId\n WHERE id = :brewId", array("brewStart" => $brewStart, "brewEnd" => $brewEnd, "quantity" => (int) $_POST['quantity'], "beerId" => (int) $_POST['beerId'], "userId" => (int) $_POST['userId'], "brewId" => (int) $_POST['brewId'])); if ($data) { success(); } else { fail("Error in api/schedule/create.php: {$data} not valid"); } } catch (PDOException $e) { fail("Error in api/schedule/create.php: " . $e->getMessage()); }
public static function getCopenameFromId($userid) { try { $data = Database::runQuery("SELECT username, copename FROM user WHERE userid = :userid", array("userid" => $userid)); if ($data[0]['copename']) { return $data[0]['copename']; } else { return $data[0]['username']; } } catch (Exception $e) { echo "getCopenameFromId Error: " . $e->getMessage(); } }
<?php require '../init.php'; require '../tools.php'; $dateTime = new DateTime($_POST['dateTime']); $dateTime = $dateTime->format("Y-m-d H:i:s"); try { $data = Database::runQuery("INSERT INTO fermentation(value, dateTime, typeId, unitId, brewId, userId)\r\n VALUES (:value, :dateTime, :typeId, :unitId, :brewId, :userId)", array("value" => (double) $_POST['value'], "dateTime" => $dateTime, "typeId" => (int) $_POST['quantity'], "unitId" => (int) $_POST['unitId'], "brewId" => (int) $_POST['beerId'], "userId" => $_SESSION['userId'])); if ($data) { success(); } else { fail("Error in api/analytics/addAnalytics.php: {$data} not valid"); } } catch (PDOException $e) { fail("Error in api/analytics/addAnalytics.php: " . $e->getMessage()); } fail("Testing Fail");
public static function editGame($gameDetails) { $return = array(); if (!is_array($gameDetails)) { $return['status'] = 'error'; $return['message'] = 'Expecting an Array'; return $return; } $primaryInsert = ""; $primaryVal = ""; $secondaryInsert = ""; $secondaryVal = ""; $bind_array = array("title" => $gameDetails['title'], "description" => $gameDetails['description'], "instruction" => $gameDetails['instruction'], "discussion" => $gameDetails['discussion'], "icon" => $gameDetails['icon'], "gameid" => $gameDetails['gameid']); if ($gameDetails['primary_type'] == "None") { $gameDetails['primary_type'] = "NULL"; $primaryUpdate = ", primary_type = NULL"; } else { $primaryUpdate = ", primary_type = :primary_type"; $bind_array['primary_type'] = $gameDetails['primary_type']; } if ($gameDetails['secondary_type'] == "None") { $gameDetails['secondary_type'] = "NULL"; $secondaryUpdate = ", secondary_type = NULL"; } else { $secondaryUpdate = ", secondary_type = :secondary_type"; $bind_array['secondary_type'] = $gameDetails['secondary_type']; } if ($gameDetails['primary_type'] != 'NULL' or $gameDetails['secondary_type'] != "NULL") { if ($gameDetails['primary_type'] == $gameDetails['secondary_type']) { $return['status'] = 'error'; $return['message'] = "Primary Type and Secondary Type Must Be Different"; } } try { Database::runQuery("UPDATE game \n SET icon = :icon, \n title = :title, \n description = :description, \n instruction = :instruction, \n discussion = :discussion\n {$primaryUpdate} \n {$secondaryUpdate}\n WHERE gameid = :gameid", $bind_array); $return['status'] = 'success'; return $return; } catch (Exception $e) { $return['status'] = 'error'; $return['message'] = 'Database Error'; return $return; } }
<?php require '../utilities/init.php'; require '../utilities/tools.php'; ?> <form id="createBrewForm" method="post" action="<?php echo getBaseUrl(); ?> api/schedule/create.php"> <div id="errorMessage" class="alert alert-danger text-center" role="alert" style="display: none;"></div> <div class="form-group"> <label for="beerId">Beer</label> <select name="beerId" class="form-control"> <?php $beers = Database::runQuery("SELECT * FROM beer"); foreach ($beers as $beer) { echo "<option value='{$beer['id']}'>{$beer['name']}</option>"; } ?> </select> </div> <div class="form-group"> <label for="brewStart">Start Brew</label> <div class="input-group date datepicker" id="startDatepicker"> <input type="text" class="form-control" name="brewStart"> <span class="input-group-addon"> <span class="glyphicon glyphicon-calendar"></span> </span> </div> </div>
<?php /* * *** PocketMine-MP Crash Archive *** * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Lesser General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * @author PocketMine Team * @link http://www.pocketmine.net/ * * */ define("ARCHIVE_ROOT", realpath(dirname(__FILE__)) . DIRECTORY_SEPARATOR); if (php_sapi_name() !== "cli") { exit; } require_once "src/config.php"; require_once "src/Database.php"; $db = new Database(); if ($argv[1] === "delete") { $reportId = (int) $argv[2]; $db->runQuery("DELETE FROM crash_report WHERE id = {$reportId};"); unlink("reports/" . sha1($reportId . SECRET_SALT) . ".log"); echo "Report {$reportId} deleted!\n"; }
<?php include 'functions.php'; $handle = new Database(); $output_dir = "uploads/"; if (isset($_SESSION['UserId'])) { if (isset($_FILES["user-resume"])) { //Filter the file types , if you want. if ($_FILES["user-resume"]["error"] > 0) { echo "Error: " . $_FILES["file"]["error"] . "<br>"; } else { //move the uploaded file to uploads folder; move_uploaded_file($_FILES["user-resume"]["tmp_name"], $output_dir . $_FILES["user-resume"]["name"]); $name = $_FILES["user-resume"]["name"]; $userid = $_SESSION['UserId']; $result = $handle->runQuery("select count(*) as count from webx_users_resume where UserId = '" . $userid . "'"); $row = $result->fetch_array(MYSQLI_ASSOC); if (!empty($row['count'])) { $result = $handle->runQuery("update webx_users_resume set ResumeName = '" . $name . "' where UserId = '" . $userid . "'"); } else { $result = $handle->runQuery("insert into webx_users_resume(UserId, ResumeName) values('" . $userid . "', '" . $name . "')"); } echo "Resume Updated"; } } } else { echo "Something went wrong please login"; }
<?php require_once "config.php"; try { $types = array(); $typesDB = Database::runQuery("SELECT * FROM type"); foreach ($typesDB as $type) { $types[$type['typeid']] = $type['keyword']; } $config['smarty']->assign('types', $types); $config['smarty']->display('game/new_game.tpl'); } catch (Exception $e) { echo "Error: " . $e->getMessage(); }
<?php require '../utilities/init.php'; require '../utilities/tools.php'; ?> <form id="createBeerRecipeForm" method="post" action="<?php echo getBaseUrl(); ?> api/beer/create.php"> <div id="errorMessage" class="alert alert-danger text-center" role="alert" style="display: none;"></div> <div class="form-group"> <label for="name">Beer Name</label> <input type="text" class="form-control" id="name" name="name" maxlength="50" required> </div> <div class="form-group"> <label for="beerTypeId">Beer Type</label> <select name="beerTypeId" class="form-control"> <?php $beerTypes = Database::runQuery("SELECT * FROM beerType ORDER BY name"); foreach ($beerTypes as $beerType) { echo "<option value='{$beerType['id']}'>{$beerType['name']}</option>"; } ?> </select> </div> </form>
<?php include "database.php"; $db = new Database("localhost", "root", ""); $db->useDb("my_db"); $users = $db->runQuery("SELECT * FROM user"); //Insert into database; if (isset($_POST['submit'])) { $name = $_POST['name']; $password = $_POST['password']; $sql = "INSERT INTO user ( name, password) VALUES ( '{$name}', '{$password}' )"; $db->runQuery($sql); header("Location:viewUser.php"); }
public function getDeckGames($limit = 100, $offset = 0) { $limit = (int) $limit; $offset = (int) $offset; $games = array(); $data = Database::runQuery("SELECT gameid FROM game WHERE deckid = {$this->deckid} LIMIT {$limit} OFFSET {$offset}"); foreach ($data as $game) { $games[] = new Game((int) $game['gameid']); } return $games; }
<?php require '../init.php'; require '../tools.php'; try { $brews = Database::runQuery("SELECT\n \t\tbrew.id AS brewId,\n \t\tbrew.brewStart,\n \t\tbrew.brewEnd,\n \t\tbrew.quantity,\n \t\tbrew.beerid,\n \t\tbrew.userid,\n \t\tbeer.name AS beerName,\n \t\tu.username as username,\n \t\tu.id as userId\n \tFROM\n \t\tbrew\n \tLEFT OUTER JOIN\n \t\tbeer ON beerid = beer.id\n \tLEFT OUTER JOIN\n \t\t`user` AS u ON userid = u.id"); success($brews); } catch (PDOException $e) { fail("Error in api/getBrews: " . $e->getMessage()); } ?>
<?php require '../init.php'; require '../tools.php'; $brewStart = new DateTime($_POST['brewStart']); $brewStart = $brewStart->format("Y-m-d H:i:s"); $brewEnd = new DateTime($_POST['brewEnd']); $brewEnd = $brewEnd->format("Y-m-d H:i:s"); try { $data = Database::runQuery("INSERT INTO brew (brewStart, brewEnd, quantity, beerId, userId)\n VALUES (:brewStart, :brewEnd, :quantity, :beerId, :userId)", array("brewStart" => $brewStart, "brewEnd" => $brewEnd, "quantity" => (int) $_POST['quantity'], "beerId" => (int) $_POST['beerId'], "userId" => $_SESSION['userId'])); if ($data) { success(); } else { fail("Error in api/schedule/create.php: {$data} not valid"); } } catch (PDOException $e) { fail("Error in api/schedule/create.php: " . $e->getMessage()); } fail("Testing Fail");
function GetStateCount($state) { $ok = parent::runQuery("SELECT COUNT(*) FROM `baseline` WHERE state=" . $state); $result = parent::getResult(); $row = $result->fetch_row(); return intval($row[0]); }