public static function search($allArgs, $con)
{
$terms = array();
$class = get_called_class();
$pre = strtolower($class) . "_";
$objProps = $class::$classProps["objProps"];
$fkeys = explode(",", $class::$classProps["fkeys"]);
$tableCols = dbObject::getCols($class);
foreach ($objProps as $objProp) {
if (in_array($objProp, $fkeys)) {
$col = $objProp;
} else {
$col = strtolower($class) . "_" . $objProp;
}
if (dbObject::propInArgs($col, $allArgs)) {
$term = Member::makeSearchTerm($col, $allArgs);
if ($term != false) {
$terms[] = $term;
}
}
}
$sql = "SELECT * FROM `" . Member::$classProps["tableName"] . "`";
$i = 0;
foreach ($terms as $term) {
if ($i == 0) {
$i = 1;
$sql .= " WHERE ";
} else {
$sql .= " AND ";
}
$sql .= $term[0];
if ($term[3] == true) {
if ($term[1] != "") {
$sql .= ">=\"" . $term[1] . "\"";
}
if ($term[2] != "") {
if ($term[1] != "") {
$sql .= " AND ";
}
$sql .= $term[0] . "<=\"" . $term[2] . "\"";
}
} else {
$sql .= "=\"" . $term[1] . "\"";
}
}
if ($result = mysqli_query($con, $sql)) {
return $result;
} else {
return false;
}
}
