include("dbopen.inc");
include("checkcookie.inc");
if (!isset($search)) {
echo("
Search your addressbook\n");
} else {
echo("Search results for $sstring\n");
}
?>
if(!isset($search)) {
if(!isset($stype)) {
?>
} /*foo*/ else {
switch($stype) {
case name:
?>
Search for a name:
break;
case phone:
?>
Search for a phone number:
break;
case email:
?>
Search for an email address or domain :
break;
case state:
?>
Search for a state:
break;
case postcode:
?>
Search for a zip code:
break;
}
}
} else {
// doin' the search
$slower=strtolower($sstring);
switch ($stype) {
case name:
$people=pg_exec($conn, "select pid, fname, minit, lname from person where uid=$addressbook_user and ( lower(fname) like '%$slower%' or lower(lname) like '%$slower%')");
break;
case email:
$people=pg_exec($conn, "select person_id, first_name, middle, last_name from email_addresses where user_id=$addressbook_user and lower(email) like '%$slower%'");
break;
case phone:
$people=pg_exec($conn, "select person_id, first_name, middle, last_name from phone_numbers where user_id=$addressbook_user and phone_num like '%$sstring%'");
break;
case state:
$people=pg_exec($conn, "select person_id, first_name, middle, last_name from post_addresses where user_id=$addressbook_user and sid=$sstring group by pid");
break;
case state:
$people=pg_exec($conn, "select person_id, first_name, middle, last_name from post_addresses where user_id=$addressbook_user and lower(postal_code) like '%$slower%' group by pid");
break;
}
$pcurrow=0;
$pnumrows=pg_numrows($people);
if ($pnumrows==0) {
echo("\nNo matches to your query
\n");
} else {
echo("\n");
while($pcurrow<$pnumrows)
{
if(($pcurrow%2)==1)
{
echo("\n\n");
}
else
{
echo(" |
\n\n");
}
$row=pg_fetch_array($people, $pcurrow);
echo("$row[1] $row[2] $row[3]");
echo(" | \n
\n");
$pcurrow++;
}
echo("
");
?>
}
}
?>