/** * * @param <Inventory> $inventory * @return <Inventory> * @SQL Insert into inventory values (NULL,1,1,1) */ public function addToInventory($inventory) { $con = Connection::createConnection(); $artifact = $inventory->artifact; $user = $inventory->user; $result = mysql_query("Insert into inventory values (NULL,{$inventory->artifactLvl},{$artifact->id},{$user->id})"); $inventory->id = mysql_insert_id(); mysql_query("commit"); Connection::closeConnection($con); return $inventory; }
/** * * @param <User> $username * @return <User> * @SQL Select * From user Where username = 1 */ public function isUsernameAvailable($username) { $con = Connection::createConnection(); $result = mysql_query("Select * From user Where username = '******'"); $loginid = -1; $tempArray = mysql_fetch_array($result); if (mysql_num_rows($result) == 1) { $user = new User(); $user->id = $tempArray['id']; $user->username = $tempArray['username']; } Connection::closeConnection($con); return $user; }
/** constructor **/ public function __construct() { // validate arguments $num = func_num_args(); $argumments = func_get_args(); // create an empty object if ($num == 0) { $this->id = 0; $this->description = ''; $this->ip = ''; } // 1 values received if ($num == 1) { // pass the value to the id $id = $argumments[0]; // create the instruction $instruction = 'SELECT station_description, station_ip_address FROM station WHERE station_id = ?'; // open the connection parent::openConnection(); // create the command $command = parent::$connection->prepare($instruction); // parameters $command->bind_param('i', $id); // execute command $command->execute(); // link the results to local values $command->bind_result($description, $ip); // read data $found = $command->fetch(); // close command mysqli_stmt_close($command); // close the connection parent::closeConnection(); if ($found) { $this->id = $id; $this->description = $description; $this->ip = $ip; } else { $this->id = 0; $this->description = 'asdasd'; $this->ip = 'asdasd'; } } }
function getStationReadings($i) { $ids = array(); $readings = array(); $instruction = 'SELECT reading_id FROM readings WHERE date(reading_date)= curdate() AND reading_id_station=? ORDER BY reading_id DESC LIMIT 10'; parent::openConnection(); $command = parent::$connection->prepare($instruction); $command->bind_param('i', $i); $command->execute(); $command->bind_result($id); while ($command->fetch()) { array_push($ids, $id); } mysqli_stmt_close($command); parent::closeConnection(); foreach ($ids as $id) { array_push($readings, new Reading($id)); } return $readings; }
public function getWeekAverages() { $instruction = 'SELECT avg(case when `reading_id_station` = 1 then `reading_temperature` else null end) as Station1, avg(case when `reading_id_station` = 2 then `reading_temperature` else null end) as Station2, avg(case when `reading_id_station` = 3 then `reading_temperature` else null end) as Station3 FROM readings Where YEARWEEK (`reading_date`) = YEARWEEK(current_date)'; parent::openConnection(); $command = parent::$connection->prepare($instruction); $command->execute(); $command->bind_result($s1, $s2, $s3); $found = $command->fetch(); mysqli_stmt_close($command); parent::closeConnection(); $averages = new ArrayObject(); if ($found) { $averages['station1'] = $s1; $averages['station2'] = $s2; $averages['station3'] = $s3; } else { $averages['station1'] = 0; $averages['station2'] = 0; $averages['station3'] = 0; } return $averages; }
/** * * @param <Inventory> $inventory * @param <int> $artifactPrice * @param <GameProfile> $updatedGameProfile * @return <Boolean> * @SQL update gameprofile set gold = 100 where userid = 1 * @SQL delete from inventory where id=1 AND userid=1 * */ public function sellArtifact($inventory, $artifactPrice, $updatedGameProfile) { $con = Connection::createConnection(); $user = $updatedGameProfile->user; $updateGameProfile = mysql_query("update gameprofile set gold = {$updatedGameProfile->gold} where userid = {$user->id}"); //delete from inventory $deleteInventory = mysql_query("delete from inventory where id={$inventory->id} AND userid={$user->id}"); mysql_query("commit"); Connection::closeConnection($con); return true; }
/** * * @param <String> $columnName * @param <GameProfile> $gameProfile * @return <Boolean> * @SQL update gameprofile set spylvl=spylvl+1 where globallvl > spylvl+scoutlvl+buylvl+sharelvl AND userid =1 */ public function addSkill($columnName, $gameProfile) { $con = Connection::createConnection(); $user = $gameProfile->user; $addPoints = mysql_query("update gameprofile set {$columnName}={$columnName}+1 where globallvl > spylvl+scoutlvl+buylvl+sharelvl AND userid ={$user->id}"); if (mysql_affected_rows() < 1) { Connection::closeConnection($con); return false; } else { return true; } }
public function getShareProgress($gameProfile, $gameProgress) { $con = Connection::createConnection(); $share = ServerConstants::SHARE; $csp = $gameProgress->csp; $friendUser = $gameProgress->friend->user; $count = mysql_query("SELECT count(*) as count FROM gameprogress,progresstype where gameprogress.progresstypeid = progresstype.id AND progresstype.progresstype = '{$share}' AND gameprogress.cspid = {$csp->id} AND gameprogress.friendid = {$friendUser->id}"); while ($row = mysql_fetch_array($count)) { $rowcount = $row['count']; } $base = 0.5; $rowcount = $rowcount + 1; $progress = pow($base, $rowcount) * $gameProfile->shareLvl * 5; $progressType = $this->giveProgressTypeObj(ServerConstants::SHARE); $insert = mysql_query("insert into gameprogress values (NULL,{$csp->id},{$friendUser->id},{$progressType->id})"); mysql_query("commit"); Connection::closeConnection($con); return $progress; }
<?php /* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ require_once '../scriptsPHP/DAO/Connection.php'; require_once './utilidades/Authenticator.php'; header("Content-Type: text/html"); $authenticator = new Authenticator("Tirate una autenticacion papa", "No vas a pasar ni en pedo, puto"); $authenticator->setUser("jose"); $authenticator->setPassword("1234"); $authenticator->authenticate(TRUE, TRUE); $conexionObject = new Connection("localhost", "matias", "", "diccionario"); $conexion = $conexionObject->getConnection(); $conexion = $conexionObject->getConnection(); $query = "select * from palabra"; $resultSet = $conexion->query($query); while ($currentRow = mysqli_fetch_assoc($resultSet)) { echo $currentRow["palabra"] . " - "; echo "<br><br>"; } $conexionObject->closeConnection();
/** * * @param <CurrentSearchParty> $currentSearchParty * @return <CurrentSearchParty> * @SQL update currentsearchparty,artifactinfo set progress = 10 where currentsearchparty.id = 1 AND (select isactive from artifactinfo where artifactinfo.id= currentsearchparty.artifactid) = 1 */ public function updateCurrentSearchPartyProgress($currentSearchParty) { $con = Connection::createConnection(); $result = mysql_query("update currentsearchparty,artifactinfo set progress = '{$currentSearchParty->progress}' where currentsearchparty.id = '{$currentSearchParty->id}' AND (select isactive from artifactinfo where artifactinfo.id= currentsearchparty.artifactid) = 1"); if (mysql_affected_rows() < 1) { //means the current search party we want to update the artifact of that party is not active Connection::closeConnection($con); return null; } Connection::closeConnection($con); return $currentSearchParty; }
$reference = $_POST['check_tel']; } if (isset($_POST['check_email'])) { $reference = $_POST['check_email']; } echo "<h1>Recuperation variables</h1>"; echo "Nom : {$nom} <br />"; echo "Prénom : {$prenom} <br />"; echo "Adresse : {$adresse} <br />"; echo "Type : {$type} <br />"; echo "Description : {$description} <br />"; echo "severite : {$severite} <br />"; echo "Référence : {$reference} <br />"; if (isset($_FILES['photo'])) { echo "Photo : " . $_FILES['photo']['name']; } $incident = new Incident($description, $type, $adresse, $severite, $reference, $target); /*** La connection à la DB ***/ $database = new Connection("localhost", "root", "root"); /*** L'insertion dans la table incident ***/ $count = $database->insertIntoIncident($incident); echo $count; /*** Déconnexion de la DB ***/ $database->closeConnection(); $html = "<br/><br/><button class=\"btn btn-success\" type=\"button\" onclick=\"window.location.href='Display.php'\">Montrer les plaintes</button>"; echo $html; ?> </body> </HTML>