public function match(Subject $subject)
{
$em = $this->getEntityManager();
$query = $em->createQuery('Select IDENTITY(s.user)
From SubwayBuddyUserBundle:Subject s
WHERE s.subject = ?1
AND s.user != ?2');
$query->setParameter(1, $subject->getSubject());
$query->setParameter(2, $subject->getUser());
return $query->getResult();
}
$bool_str2 = $isBlocked2 ? "true" : "false";
printf("User is blocked: %s\n", $bool_str2);
unset($user);
unset($user2);
////////////////////////////
//Subject UNIT TESTS
////////////////////////////
printf("/////////////////////////////////\n");
printf("STARTING Subject UNIT TESTS\n");
printf("/////////////////////////////////\n");
//construct subject
$subject = new Subject();
//add subject
$subject->addSubject("Math");
//get subject
$subject_string = $subject->getSubject();
printf("Got Subject: %s\n", $subject_string);
//get AZSubjectArray
$orderedArray = $subject->getAZSubjects();
printf("Ordered Subjects: \n");
foreach ($orderedArray as $subject_val) {
printf("%s\n", $subject_val);
}
////////////////////////////
//Classes UNIT TESTS
////////////////////////////
printf("/////////////////////////////////\n");
printf("STARTING Classes UNIT TESTS\n");
printf("/////////////////////////////////\n");
//construct empty class
$class = new Classes();
static function getSubjectById($subject_id)
{
//clear the result
$subject = '';
$connection = Database::getConnection();
$query = 'SELECT subject FROM subject WHERE id=' . $subject_id;
//echo $query;
//Run the query
$result_obj = $connection->query($query);
try {
//I COULD USE A FOR AND IT WOULD BE BETTER
//BUT IT DOESN'T WORK AND I HAVE NO TIME TO
//FIND THE PROBLEM :)
//SHOULD BE ONLY ONE RESULT
$i = 0;
while ($result = $result_obj->fetch_array(MYSQLI_ASSOC)) {
$subject = new Subject($result);
$i++;
}
//pass back the result
return $subject->getSubject();
} catch (Exception $e) {
$_SESSION['message'] = $e->getMessage();
//Not properly good for safety
}
}