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];
}
