public function loadArrayByrelationship($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 agentrelationsid FROM agentrelations WHERE relationship {$operator} '{$searchTerm}'"; $preparedsql = "SELECT agentrelationsid FROM agentrelations WHERE relationship {$operator} ? "; if ($statement = $this->conn->prepare($preparedsql)) { $statement->bind_param("s", $searchTerm); $statement->execute(); $statement->bind_result($id); while ($statement->fetch()) { $obj = new agentrelations(); $obj->load($id); $returnvalue[] = $obj; } $statement->close(); } return $returnvalue; }
function loadAgentRelations() { $al = null; $alid = preg_replace('[^0-9]', '', array_key_exists("agentrelationsid", $_REQUEST) ? $_REQUEST["agentrelationsid"] : ""); if (strlen($alid) > 0) { $al = new agentrelations(); $al->load($alid); } else { throw new Exception("No agent relationships record specified."); } return $al; }