public static function getExpressions($crit)
{
if ($crit != "") {
$query = "select * from expression\n where (lower(name) like lower('%{$crit}%')) or\n (lower(description) like lower('%{$crit}%')) or\n (lower(content) like lower('%{$crit}%')) or\n (lower(formula) like lower('%{$crit}%'))\n order by popularity desc, ts desc limit 70";
} else {
$query = "select * from expression order by ts desc limit 70";
}
//echo $query;
return Mdb::sqlTableQuery($query);
}
public static function getAll()
{
include_once '../model/Mlogin.php';
$accid = Mlogin::getId($_SESSION['mathmlusr']);
$query = "select * from expression where accid={$accid} order by ts desc";
$res = Mdb::sqlTableQuery($query);
foreach ($res as $row) {
if (Mmy::isAdded($accid, $row['id']) == 1) {
$value = "BRIŠI IZ FORMIRANIH IZRAZA";
} else {
$value = "DODAJ U FORMIRANE IZRAZE";
}
echo "<div class='side' style='width:auto;height:150px;'>";
echo "<a href='../view/Vexpression.php?id=" . $row['id'] . "'>" . $row['name'] . "<div class='formula'>`" . $row['formula'] . "`</div></a>";
echo "<input type='submit' id='" . $row['id'] . "' value='{$value}' class='user' />\n </div>";
}
}
public static function getForType($type)
{
$query = "select * from bexpression where type='{$type}'";
return Mdb::sqlTableQuery($query);
}
public static function getAllPinned()
{
include_once '../model/Mlogin.php';
$accid = Mlogin::getId($_SESSION['mathmlusr']);
$query = "select * from expression e join pinned p on e.id=p.fid where p.accid={$accid}";
return Mdb::sqlTableQuery($query);
}
