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