public static function GetByID($id) { if (!is_numeric($id)) { return null; } global $MySQL; $query = "SELECT * FROM " . System::$Configuration["Database.TablePrefix"] . "TenantObjectInstanceMethods WHERE method_ID = " . $id; $result = $MySQL->query($query); if ($result === false) { return null; } $count = $result->num_rows; if ($count == 0) { return null; } $values = $result->fetch_assoc(); return TenantObjectInstanceMethod::GetByAssoc($values); }
/** * Retrieves all TenantObjectInstanceMethods associated with this TenantObject. * @param int $max The maximum number of TenantObjectInstanceMethods to retrieve. * @return TenantObjectInstanceMethod[] array of all TenantObjectInstanceMethods associated with this TenantObject */ public function GetInstanceMethods($max = null) { global $MySQL; $query = "SELECT * FROM " . System::$Configuration["Database.TablePrefix"] . "TenantObjectInstanceMethods WHERE method_ObjectID = " . $this->ID; if (is_numeric($max)) { $query .= " LIMIT " . $max; } $result = $MySQL->query($query); $retval = array(); if ($result === false) { return $retval; } $count = $result->num_rows; for ($i = 0; $i < $count; $i++) { $values = $result->fetch_assoc(); $retval[] = TenantObjectInstanceMethod::GetByAssoc($values); } return $retval; }