public function getUsersByPartialString($partialName) { $connector = new DBConnector(); $connection = $connector->createConnection(); $partialNameAux = mysql_real_escape_string($partialName); $query = 'SELECT name,lastname FROM users u WHERE u.alive=1 AND u.name LIKE "' . $partialNameAux . '%"'; $result = mysql_query($query); if (mysql_num_rows($result) == 0) { return -1; } $answer = array(); $i = 0; while ($row = mysql_fetch_row($result)) { $answer[$i] = $row[0] . " " . $row[1]; $i++; } mysql_free_result($result); mysql_close($connection); return $answer; }
<?php require_once dirname(__FILE__) . '\\src\\main\\resources\\php\\qnet\\util.php'; require_db(); use Qnet\dao\DBConnector; $connector = new DBConnector(); $connection = $connector->createConnection(); $phpdate = date_create("last Wednesday"); //'10 April 2010' function getNextDate($phpdate) { $phpdate->add(new DateInterval("PT6H15M")); return date('Y-m-d H:i:s', $phpdate->getTimestamp()); } // Inser users function insertUser($id, $name, $lastName, $password, $alive, $dateOfBirth, $gender, $maritalSt, $studies, $institution, $location, $religion, $photo) { $mail = $name . "_" . $lastName . "@mailinator.com"; $user = "******"; mysql_query($user) or die("Error in query: {$user}. " . mysql_error()); $userinfo = "INSERT INTO userinfo (FK_users, dateOfBirth, gender, maritalSt, studies, InstitutionName, currentLocation, religion, photo)\r\n VALUE ({$id}, '{$dateOfBirth}','{$gender}','{$maritalSt}','{$studies}','{$institution}','{$location}','{$religion}', '{$photo}');"; mysql_query($userinfo) or die("Error in query: {$userinfo}. " . mysql_error()); } insertUser(1, 'Daniel', 'Gimenez', 'dg', 1, '14-11-1940', 'Male', 'Single', 'University', 'UA', 'Argentina', 'Catholic', 'img08'); insertUser(2, 'Tomas', 'Alabes', 'ta', 1, '15-11-1945', 'Female', 'Single', 'University', 'UA', 'Argentina', 'Musulman', 'img08'); insertUser(3, 'Mariano', 'Claveria', 'mc', 1, '16-11-1988', 'Male', 'Single', 'University', 'UA', 'Argentina', 'Musulman', 'img08'); insertUser(4, 'Agustin', 'Miura', 'am', 1, '17-11-2002', 'Female', 'Single', 'University', 'UA', 'Argentina', 'Catholic', 'img08'); insertUser(5, 'Daniel', 'Grane', 'dag', 1, '20-11-1990', 'Male', 'Single', 'University', 'UA', 'Argentina', 'Catholic', 'img08'); insertUser(6, 'Damian', 'Minniti', 'dm', 1, '20-11-1990', 'Male', 'Single', 'University', 'UA', 'Argentina', 'Catholic', 'img08'); insertUser(7, 'Martin', 'Sanchez', 'ms', 1, '20-11-1990', 'Male', 'Single', 'University', 'UA', 'Argentina', 'Catholic', 'img08'); insertUser(8, 'Pablo', 'Celentano', 'pc', 1, '20-11-1990', 'Male', 'Single', 'University', 'UA', 'Argentina', 'Catholic', 'img08');
public function getUserIdByMail($mail) { $connector = new DBConnector(); $connection = $connector->createConnection(); $mailAux = mysql_real_escape_string($mail); $query = 'SELECT id FROM users u WHERE u.mail="' . $mailAux . '" AND u.alive=1'; $result = mysql_query($query) or die("Error in query: {$query}. " . mysql_error()); if (mysql_num_rows($result) == 0) { return -1; } $row = mysql_fetch_row($result); $uid = $row[0]; mysql_free_result($result); mysql_close($connection); return $uid; }
public function getQueryDateById($qid) { $connector = new DBConnector(); $connection = $connector->createConnection(); $result = mysql_query('SELECT date FROM queries WHERE id=' . $qid) or die("Error 7"); $row = mysql_fetch_row($result); mysql_free_result($result); mysql_close($connection); return $row[0]; }