/** * Given an id for an agent, return the list of agent names associated with that agent. * * @param agentid the agentid for the agent to find names for. * @return an array of agentnames containing the names for the specified agent. */ public function findAgentNamesByAgentId($agentid) { $result = array(); $sql = "select agentnamesid from agentnames where agentid = ? "; if ($statement = $this->conn->prepare($sql)) { $statement->bind_param("i", $agentid); $statement->execute(); $statement->bind_result($agentnameid); while ($statement->fetch()) { $an = new agentnames(); $an->load($agentnameid); $result[] = $an; } $statement->close(); } else { throw new Exception("Query preparation failed for '{$sql}'"); } return $result; }
/** * Obtain agentid or uuid from request and lookup agent. * @return agent found, or null. */ function loadAgentName() { $agentname = null; $agentnameid = preg_replace('[^0-9]', '', array_key_exists("agentnamesid", $_REQUEST) ? $_REQUEST["agentnamesid"] : ""); if (strlen($agentnameid) > 0) { $agentname = new agentnames(); $agentname->load($agentnameid); } else { throw new Exception("No agent name specified."); } return $agentname; }