public function loadArrayByagentid($searchTerm) { $returnvalue = array(); $operator = "="; // change to a like search if a wildcard character is present if (!(strpos($searchTerm, "%") === false)) { $operator = "like"; } if (!(strpos($searchTerm, "_") === false)) { $operator = "like"; } $sql = "SELECT agentnumberpatternid FROM agentnumberpattern WHERE agentid {$operator} '{$searchTerm}'"; $preparedsql = "SELECT agentnumberpatternid FROM agentnumberpattern WHERE agentid {$operator} ? "; if ($statement = $this->conn->prepare($preparedsql)) { $statement->bind_param("s", $searchTerm); $statement->execute(); $statement->bind_result($id); while ($statement->fetch()) { $obj = new agentnumberpattern(); $obj->load($id); $returnvalue[] = $obj; } $statement->close(); } return $returnvalue; }
function loadAgentNumberPattern() { $np = null; $npid = preg_replace('[^0-9]', '', array_key_exists("agentnumberpatternid", $_REQUEST) ? $_REQUEST["agentnumberpatternid"] : ""); if (strlen($npid) > 0) { $np = new agentnumberpattern(); $np->load($npid); } else { throw new Exception("No agent number pattern specified."); } return $np; }