function get_subjects($con, $args) { $subjects = array(); if (isset($args["sid"])) { $sid = $args["sid"]; $sql = $con->prepare("SELECT sname,`order` FROM subject WHERE sid=?"); $sql->bind_param("i", $sid); $sql->bind_result($sname, $order); $sql->execute(); $sql->fetch(); $sql->close(); if (isset($sname) && isset($order)) { $tmp = new Subject(); $tmp->populate($sid, $sname, [], $order); $subjects[] = $tmp->expose(); } } else { if (isset($args["sname"])) { $sname = $args["sname"]; $sql = $con->prepare("SELECT sid,`order` FROM subject WHERE sname=?"); $sql->bind_param("s", $sname); $sql->bind_result($sid, $order); $sql->execute(); $sql->fetch(); $sql->close(); if (isset($sid) && isset($order)) { $tmp = new Subject(); $tmp->populate($sid, $sname, [], $order); $subjects[] = $tmp->expose(); } } else { $sql = $con->prepare("SELECT sid,sname,`order` FROM subject ORDER BY `order` ASC"); $sql->bind_result($sid, $sname, $order); $sql->execute(); while ($sql->fetch()) { if (isset($sid) && isset($sname) && isset($order)) { $tmp = new Subject(); $tmp->populate($sid, $sname, [], $order); $subjects[] = $tmp->expose(); } } $sql->close(); } } return $subjects; }