\n"); echo(""); echo("\n

"); echo("

\n\t$name
\n"); echo("

\n"); if ($ldate != 0) { echo("(Last updated: " . ($mon + 1) . "/$mday/") ; echo(($year + 1900) . ")
\n"); } else { echo("(Last updated: Unknown)
\n"); } if ($search_userid == 0) { $url = "action=" . $_SERVER['PHP_SELF'] ; $url .= urlencode("?" . $_SERVER['QUERY_STRING']); echo("\t Please login for email addresses"); echo("
\n"); } else { echo("\t$email
\n"); } if (! preg_match("/NONE/i", $homeurl)) { echo("\t$homeurl"); echo("
"); } //echo("\tClass of $date
"); echo("\tClass of
"); if (! preg_match("/UNLISTED/i", $city)) { echo("\tCurrently living in: " ); echo(" $city, $state ($country)
\n"); } if (! preg_match("/^NONE/i", $about)) { echo("

$about
\n"); } echo("

\n\n\n"); } ?> $value) { if ($key <> "start") { $next_filter .= "&$key=$value"; } } if ($start == 0) { $start = 1; } if (preg_match("/^[A-Z]$/", $letter)) { $filter_type = 1; echo("Displaying last or maiden names starting with $letter

"); } elseif ($filter_type == 1) { $letter = $filter; echo("Displaying last or maiden names starting with $letter

"); } elseif ($letter == 1) { echo("Displaying only entries updated in the last 30 days.

"); } elseif ($filter_type == 2) { echo("Displaying entries for year $filter.

"); } elseif ($filter_type == 3) { echo("Displaying entries for city $filter.

"); } elseif ($filter_type == 4) { echo("Displaying entries for state $filter.

"); } elseif ($filter_type == 5) { echo("Displaying entries for email address $filter.

"); } elseif ($filter_type == 6) { echo("Displaying entries for key word $filter.

"); } elseif ($filter_type == 7) { $filter = decryptUserID($filter); } elseif ($filter_type == 8) { echo("Displaying entries for Country $filter.

"); } /* || Connect to DB and get Records */ try { $dbh = getDB(); $sql = "select * from users order by lname COLLATE NOCASE, mname COLLATE NOCASE, fname COLLATE NOCASE"; foreach ($dbh->query($sql) as $row) { $rowid = $row['id']; $ldate = $row['ldate']; $lname = $row['lname']; $fname = $row['fname']; $mname = $row['mname']; $date = $row['year']; $email = $row['email']; $password = $row['password']; $about = $row['about']; $homeurl = $row['homeurl']; $picturl = $row['picturl']; $city = $row['city']; $state = $row['state']; $country = $row['country']; if ($letter == 1 and ((time() - 30*24*3600) > $ldate)) { continue; /* || If filtering by letter, then skip any rows || where the last or madain name doesn't start || with the specified letter */ } elseif ($filter_type == 1 and !preg_match("/^$letter/i", $lname) and !preg_match("/^$letter/i", $mname)) { continue; } elseif ($filter_type == 2 and $filter <> $date) { continue; } elseif ($filter_type == 3 and !preg_match("/$filter/i", $city)) { continue; } elseif ($filter_type == 4 and !preg_match("/$filter/i", $state)) { continue; } elseif ($filter_type == 5 and !preg_match("/$filter/i", $email)) { continue; } elseif ($filter_type == 6 and !preg_match("/$filter/i", $about)) { continue; } elseif ($filter_type == 7 and $rowid <> $filter) { continue; } elseif ($filter_type == 8 and !preg_match("/$filter/i", $country)) { continue; } if ($i >= $start and $i < $start + $row_limit) { if ($filter_type == 7) print_row($row); // Detail for single view else userSummary($row); echo("

"); $num_rows++; } $i++; } echo (" \n"); echo ("\t\n\t\t\n\t\t

\n"); if ($start <> 1) { echo(""); echo("<<< Previous"); echo(""); } else { echo(" "); } echo ("

"); if ($num_rows == 0) { echo("No rows found matching criteria."); } else { if ($filter_type != 7) echo("Displaying rows $start - " . ($start - 1 + $num_rows)); } echo ("

"); if ($num_rows == $row_limit) { echo(""); echo ("Next >>>"); echo(""); } else { echo (" "); } echo ("

"); } catch (PDOException $e) { echo "ERROR - "; echo $e->getMessage(); } HTML_FOOTER(); ?>