public function selectUserById($userId) { $connector = new DBConnector(); $connection = $connector->createConnection(); $query = 'SELECT name, lastname, password, alive FROM users u WHERE u.alive=1 AND u.id=' . $userId; $result = mysql_query($query) or die("Error in query: {$query}. " . mysql_error()); if (!$result || mysql_num_rows($result) == 0) { return false; } $data = mysql_fetch_assoc($result); $name = $data['name']; $lastname = $data['lastname']; $password = $data['password']; $alive = $data['alive']; mysql_free_result($result); $id = intval($userId); $query = 'SELECT * FROM userinfo u WHERE u.FK_users=' . $userId; $result = mysql_query($query) or die("Error in query: {$query}. " . mysql_error()); $data = mysql_fetch_row($result); $user = new User($name, $lastname, $password, $data[2], $data[3], $data[4], $data[5], $data[6], $data[7], $data[8], $data[9], $alive); $user->setId($id); mysql_free_result($result); mysql_close($connection); return $user; }
public static function filterQueries($queries, $user) { $result = array(); foreach ($queries as $qid => $title) { $qdao = new QueryDAO(); $segments = $qdao->getSegmentsByQueryId($qid); $tristate = User::createPropertyMap(0); foreach (array_values($segments) as $segment) { $prop = $segment[0]; $value = $segment[1]; if ($tristate[$prop] != 1) { $tristate[$prop] = User::indexOfUserValue($prop, $user) == $value ? 1 : -1; } } $applies = true; foreach (array_values($tristate) as $value) { if ($value == -1) { $applies = false; break; } } if ($applies) { $result[$qid] = $title; } } return $result; }
public function modifyUser() { $username = $_POST['userName']; $userLastName = $_POST['userLastName']; $userPassword = $_POST['password']; $passwordAgain = $_POST['rePassword']; $userDao = new UserDao(); $userInfoDao = new UserInfoDao(); $uid = getUID(); $user = $userDao->selectUserById($uid); $user->lastName = $userLastName; $user->password = $userPassword; $user->name = $username; User::readProperties($user, $_POST); $user->setInstitutionName($_POST['InstitutionName']); $userDao->updateUser($user, $uid); $userInfoDao->modifyUserInfo($id, $user); }
$dao->initTransaction(); $dao->persistNewQuery($queryName, $uid); for ($i = 0; $i < $qlength; $i++) { $dao->persistQuestion($_POST['questionname' . $i]); switch ($_POST['answers' . $i]) { case 'yesno': $dao->persistAnswer("Yes", 0); $dao->persistAnswer("No", 1); break; case 'lml': $dao->persistAnswer("A lot", 0); $dao->persistAnswer("Medium", 1); $dao->persistAnswer("Low", 2); break; case 'mf': $dao->persistAnswer("Male", 0); $dao->persistAnswer("Female", 1); break; case 'please': $dao->persistAnswer("Yes please!", 0); $dao->persistAnswer("No thanks!", 1); break; } } for ($i = 0; $i < $filterslength; $i++) { $cat = $_POST['filtercat' . $i]; $pop = User::indexOfSelectValue($cat, $_POST['filterpop' . $i]); $dao->persistSegment($cat, $pop); } $dao->endTransaction(); header("Location: /Qnet/target/classes/php/qnet/ui/newquery.php?commit=ok");
value="<?php echo $DefaultInstitutionName; ?> "/> </div> </fieldset> <fieldset> <legend>Other information</legend> <div> <?php User::printOptionsFor(User::$LOCATION, $default_country); ?> </div> <div> <?php User::printOptionsFor(User::$RELIGION, $default_religion); ?> </div> </fieldset> <fieldset id="termsArea"> <legend>Term and Conditions</legend> <div id="terms" class="terms"> <h3>Statement of Rights and Responsibilities</h3> <p> This Statement of Rights and Responsibilities (Statement) derives from the Qnet Principles, and governs our relationship with users and others who interact with Qnet. By using or accessing Qnet, you agree to this Statement. </p> <h3>1.Privacy</h3>
echo $i; ?> " id="var<?php echo $i; ?> "> <?php if ($i != 1) { echo '<option value="NONE">--------</option>'; } while ($controller->hasMoreQuestions()) { $controller->moveNext(); echo '<option value="' . $controller->getQuestionId() . '">' . $controller->getQuestionName() . '</option>'; } $controller->backToStart(); User::printPropertiesOptions(); ?> </select> <br/> <?php } ?> </fieldset> <input type="submit" class="button2" value="Publicar"/> </form> </div> </div> </div> <?php include "fragment/sidebar.php"; ?>
public function legendFor($var) { if ($this->sdao->getVarType($var) == "uVar") { return User::propertyValues($this->sdao->getVarValue($var)); } else { if ($this->sdao->getVarType($var) == "qVar") { return $this->adao->getOptionNames($this->sdao->getVarValue($var)); } } }
use Qnet\Dao\UserDAO; use Qnet\Model\User; use Qnet\Controller\LoginController; //check_logged(); session_start(); $c = new LoginController(); $dao = new UserDAO(); $validator = new Validator(); $fieldErrors = $validator->validate(); $validateCaptcha = $validator->validateCaptcha(); if ($dao->getUserIdByMail($_POST['mail']) > 0) { array_push($fieldErrors, "mail:Mail Already Exits"); } if ($validateCaptcha && empty($fieldErrors)) { $user = new User($_POST['userName'], $_POST['userLastName'], $_POST['mail'], $_POST['password'], $_POST['day'] . '-' . $_POST['month'] . '-' . $_POST['year'], null, null, null, $_POST['institutionName'], null, null); User::readProperties($user, $_POST); $dao->registerUser($user); $c->login($_POST['userName'], $_POST['password']); cleanSessionAfterLogin(); header("Location: viewprofile.php"); // header("Location: /Qnet/target/classes/php/qnet/ui/viewprofile.php"); } else { $_SESSION["completeForm"] = true; $_SESSION["userName"] = $_POST["userName"]; $_SESSION["userLastName"] = $_POST["userLastName"]; $_SESSION["mail"] = $_POST["mail"]; $_SESSION["day"] = $_POST["day"]; $_SESSION["month"] = $_POST["month"]; $_SESSION["year"] = $_POST['year']; $_SESSION["institutionName"] = $_POST['institutionName']; $_SESSION[User::$GENDER] = $_POST[User::$GENDER];
<input type="text" name="InstitutionName" id="InstitutionName" value="<?php echo $institutionName; ?> " /> </div> </fieldset> <fieldset> <legend>Other information</legend> <div> <?php User::printOptionsFor(User::$LOCATION, $country); ?> </div> <div> <?php User::printOptionsFor(User::$RELIGION, $religion); ?> </div> </fieldset> <div><input id="submitSignUpButton" type="submit"></div> </form> </div> </div> </div> <?php include "fragment/sidebar.php"; ?> <div style="clear: both;"> </div> </div> <?php include "fragment/footer.php";
<div id="filter" class="qbox" style="display: none;"> <fieldset> <div> <label class="mylabelstyle" for="filtercatX">Category:</label> <select name="filtercatX" id="filtercatX"> <?php User::printPropertiesOptions(); ?> </select> </div> <div> <label class="mylabelstyle" for="filterpopX">Population:</label> <select name="filterpopX" id="filterpopX"> <?php User::printSimpleOptionsFor(User::$FIRST_PROPERTY); ?> </select> </div> </fieldset> </div> <div id="page"> <div id="content"> <div class="post"> <h2 class="title">Make your very own online query!</h2> <div class="entry"> <?php if ($_GET['commit'] == 'ok') { echo '<p>Congratulations! Your query has been published.</p>';
value="<?php echo $DefaultInstitutionName; ?> "/> </div> </fieldset> <fieldset> <legend>Other information</legend> <div> <?php User::printOptionsFor(User::$LOCATION); ?> </div> <div> <?php User::printOptionsFor(User::$RELIGION); ?> </div> </fieldset> <fieldset id="termsArea"> <legend>Term and Conditions</legend> <div id="terms" class="terms"> <h3>Statement of Rights and Responsibilities</h3> <p> This Statement of Rights and Responsibilities (Statement) derives from the Qnet Principles, and governs our relationship with users and others who interact with Qnet. By using or accessing Qnet, you agree to this Statement. </p> <h3>1.Privacy</h3>
<?php require_once dirname(__FILE__) . '\\..\\util.php'; require_model("User"); use Qnet\Model\User; $category = $_GET["category"]; User::printSimpleOptionsFor($category);