Eco-$mart Contacts

<<<<Restricted Area>>>>" . "
Sorry, you must Log In to view this Page

"); exit(); } $usrn = $_GET['usrn']; if($usrn == ""){ $usrn = $_POST['usrn']; } if($usrn == ""){ echo("

<<<<Restricted Area>>>>" . "
Problem with your username. Please Log In again.

"); exit(); } $dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1'); mysql_select_db('ecosmar_contacts', $dbcnx); $srchit = $_POST['srchit']; $searchby = $_POST['searchby']; $quest = "Off"; if($searchby == "Name"){ $namo = explode(" ", $srchit); $namcount = count($namo); if($namcount == 2){ $name0 = $namo[0]; $name1 = $namo[1]; }elseif($namcount == 3){ $name0 = $namo[0]." ".$namo[1]; $name1 = $namo[2]; } $getit = mysql_query("SELECT ID,first_Name,Name,Company,Phone,email FROM con_main WHERE usrn='$usrn' AND first_Name='$name0' AND Name='$name1'"); if(!$getit){ echo("

Error searching for $srchit by Name.
Please go back and check your input.

"); exit(); }else{ $row = mysql_fetch_array($getit); $nCID = $row[0]; if($nCID != ""){ $redirect = "ecocontact_edit.php?ID=".$nCID."&fr=".$dnum."&usrn=".$usrn; header("Location: $redirect"); }else{ if($namcount == 1){ $getitb = mysql_query("SELECT ID,first_Name,Name,Company,Phone,email FROM con_main WHERE usrn='$usrn' AND first_Name='$srchit' OR Name='$srchit'"); if(!$getitb){ echo("

Could not match name using these parameters.

"); }else{ $emnumb = mysql_num_rows($getitb); if($emnumb < 1){ $warn = "On"; $messo = "Could not find similar instances of ".$srchit."."; }else{ $quest = "On"; $messo = "No Exact Match. Similar instances displayed below."; while($row = mysql_fetch_array($getitb)){ $qCID[] = $row['ID']; $qfirst_Name[] = $row['first_Name']; $qName[] = $row['Name']; $qCompany[] = $row['Company']; $qPhone[] = $row['Phone']; $qemail[] = $row['email']; } }//ifemnumbisoner }//ifgotitb }//ifnamcountisone }//ifnCIDreallydoesequalemptystring }//ifgotit }//ifsearchbyisname if($searchby == "Company"){ $getit = mysql_query("SELECT ID,first_Name,Name,Company,Phone,email FROM con_main WHERE usrn='$usrn' AND Company='$srchit'"); if(!$getit){ echo("

Error searching for $srchit by Company.
Please go back and check your input.

"); exit(); }else{ $comnum = mysql_num_rows($getit); if($comnum == 1){ $row = mysql_fetch_array($getit); $rCID = $row[0]; if($rCID != ""){ $redirect = "ecocontact_edit.php?ID=".$rCID."&fr=".$dnum."&usrn=".$usrn; header("Location: $redirect"); } } if($comnum < 1){ $getitb = mysql_query("SELECT ID,first_Name,Name,Company,Phone,email FROM con_main WHERE Company LIKE '%$srchit%' AND usrn='$usrn'"); if(!$getitb){ echo("

Could not get Company using these parameters. ".mysql_error()."

"); }else{ $comnumb = mysql_num_rows($getitb); if($comnumb < 1){ $warn = "On"; $messo = "Could not find similar instances of ".$srchit."."; }else{ $quest = "On"; $messo = "No Exact Match. Similar instances displayed below."; while($row = mysql_fetch_array($getitb)){ $qCID[] = $row['ID']; $qfirst_Name[] = $row['first_Name']; $qName[] = $row['Name']; $qCompany[] = $row['Company']; $qPhone[] = $row['Phone']; $qemail[] = $row['email']; } }//if$comnumbisgreaterthanone }//ifgotitb }//ifcomnumislessthanone }//ifgotit }//ifsearchbyisCompany if($searchby == "Email"){ $getit = mysql_query("SELECT ID,first_Name,Name,Company,Phone,email FROM con_main WHERE usrn='$usrn' AND email='$srchit'"); if(!$getit){ echo("

Error searching for $srchit by Company.
Please go back and check your input.

"); exit(); }else{ $emcount = mysql_num_rows($getit); if($emcount == 1){ $row = mysql_fetch_array($getit); $rCID = $row[0]; if($rCID != ""){ $redirect = "ecocontact_edit.php?ID=".$rCID."&fr=".$dnum."&usrn=".$usrn; header("Location: $redirect"); } if($emcount > 1){ $warn = "On"; $messo = "Similar Instances found."; while($row = mysql_fetch_array($getit)){ $qCID[] = $row['ID']; $qfirst_Name[] = $row['first_Name']; $qName[] = $row['Name']; $qCompany[] = $row['Company']; $qPhone[] = $row['Phone']; $qemail[] = $row['email']; } } if($emcount < 1){ $emstart = explode('@' ,$srchit); $getitb = mysql_query("SELECT ID,first_Name,Name,Company,Phone,email FROM con_main WHERE email LIKE '$emstart[0]%' AND usrn='$usrn'"); if(!$getitb){ echo("

Could not get Email using these parameters. ".mysql_error()."

"); }else{ $emnumb = mysql_num_rows($getitb); if($emnumb < 1){ $warn = "On"; $messo = "Could not find similar instances of ".$srchit."."; }else{ $quest = "On"; $messo = "No Exact Match. Similar instances displayed below."; while($row = mysql_fetch_array($getitb)){ $qCID[] = $row['ID']; $qfirst_Name[] = $row['first_Name']; $qName[] = $row['Name']; $qCompany[] = $row['Company']; $qPhone[] = $row['Phone']; $qemail[] = $row['email']; } }//if$comnumbisgreaterthanone }//ifgotitb }//ifemcountislessthanone }//ifgotit }//ifsearchbyisEmail if($searchby == "Phone"){ $getit = mysql_query("SELECT ID,first_Name,Name,Company,Phone,email FROM con_main WHERE usrn='$usrn' AND Phone='$srchit'"); if(!$getit){ echo("

Error searching for $srchit by Phone Number.
Please go back and check your input.

"); exit(); }else{ $emcount = mysql_num_rows($getit); if($emcount == 1){ $row = mysql_fetch_array($getit); $rCID = $row[0]; if($rCID != ""){ $redirect = "ecocontact_edit.php?ID=".$rCID."&fr=".$dnum."&usrn=".$usrn; header("Location: $redirect"); } if($emcount > 1){ $warn = "On"; $messo = "Found Multiple instances."; while($row = mysql_fetch_array($getit)){ $qCID[] = $row['ID']; $qfirst_Name[] = $row['first_Name']; $qName[] = $row['Name']; $qCompany[] = $row['Company']; $qPhone[] = $row['Phone']; $qemail[] = $row['email']; } } if($emcount < 1){ $out = array(); $out[] = "."; $out[] = "-"; $out[] = "("; $out[] = ")"; $out[] = "_"; $in = array(); $in[] = " "; $in[] = " "; $in[] = " "; $in[] = " "; $in[] = " "; $nn = str_replace($out, $in, $srchit); $nnn = trim($nn); $phonstart = explode(' ' ,$nnn); $getitb = mysql_query("SELECT ID,first_Name,Name,Company,Phone,email FROM con_main WHERE Phone LIKE '$phonstart[0]%' AND usrn='$usrn'"); if(!$getitb){ echo("

Could not get Phone using first parameter. ".mysql_error()."

"); }else{ $emnumb = mysql_num_rows($getitb); if($emnumb < 1){ $warn = "On"; $chk1 = 1; }else{ $quest = "On"; $messo = "No Exact Match. Similar instances displayed below."; while($row = mysql_fetch_array($getitb)){ $qCID[] = $row['ID']; $qfirst_Name[] = $row['first_Name']; $qName[] = $row['Name']; $qCompany[] = $row['Company']; $qPhone[] = $row['Phone']; $qemail[] = $row['email']; } }//ifcomnumbisgreaterthanone }//ifgotitb }//ifemcountislessthanone $getitc = mysql_query("SELECT ID,first_Name,Name,Company,Phone,email FROM con_main WHERE Phone LIKE '%$phonstart[1]%' AND usrn='$usrn'"); if(!$getitc){ echo("

Could not get Phone using second parameter. ".mysql_error()."

"); }else{ $emnumb = mysql_num_rows($getitc); if($emnumb < 1){ $warn = "On"; $chk2 = 1; }else{ $quest = "On"; $messo = "No Exact Match. Similar instances displayed below."; while($row = mysql_fetch_array($getitc)){ $qCID[] = $row['ID']; $qfirst_Name[] = $row['first_Name']; $qName[] = $row['Name']; $qCompany[] = $row['Company']; $qPhone[] = $row['Phone']; $qemail[] = $row['email']; } }//ifcomnumbisgreaterthanone }//ifgotitb }//ifemcountislessthanone $getitd = mysql_query("SELECT ID,first_Name,Name,Company,Phone,email FROM con_main WHERE Phone LIKE '%$phonstart[2]' AND usrn='$usrn'"); if(!$getitd){ echo("

Could not get Phone using second parameter. ".mysql_error()."

"); }else{ $emnumb = mysql_num_rows($getitd); if($emnumb < 1){ $warn = "On"; $chk3 = 1; }else{ $quest = "On"; $messo = "No Exact Match. Similar instances displayed below."; while($row = mysql_fetch_array($getitd)){ $qCID[] = $row['ID']; $qfirst_Name[] = $row['first_Name']; $qName[] = $row['Name']; $qCompany[] = $row['Company']; $qPhone[] = $row['Phone']; $qemail[] = $row['email']; } }//ifcomnumbisgreaterthanone }//ifgotitb }//ifemcountislessthanone $messchk = $chk1 + $chk2 + $chk3; if($messchk == 3){ $messo = "Could not find similar instances of ".$srchit."."; } }//ifgotit }//ifsearchbyisPhone if($searchby == "ZipCode"){ $getit = mysql_query("SELECT ID,first_Name,Name,Company,Phone,email FROM con_main WHERE usrn='$usrn' AND ZipCode='$srchit'"); if(!$getit){ echo("

Error searching for $srchit by Zip Code.
Please go back and check your input.

"); exit(); }else{ $emcount = mysql_num_rows($getit); if($emcount > 1){ $quest = "On"; $messo = "Found Multiple instances of ".$srchit."."; while($row = mysql_fetch_array($getit)){ $qCID[] = $row['ID']; $qfirst_Name[] = $row['first_Name']; $qName[] = $row['Name']; $qCompany[] = $row['Company']; $qPhone[] = $row['Phone']; $qemail[] = $row['email']; } } if($emcount < 1){ $zipstart = substr($srchit, 0, 3); $getitb = mysql_query("SELECT ID,first_Name,Name,Company,Phone,email FROM con_main WHERE email LIKE '$zipstart%' AND usrn='$usrn'"); if(!$getitb){ echo("

Could not get Zip Code using these parameters. ".mysql_error()."

"); }else{ $emnumb = mysql_num_rows($getitb); if($emnumb < 1){ $warn = "On"; $messo = "Could not find similar instances of ".$srchit."."; }else{ $quest = "On"; $messo = "No Exact Match. Similar instances displayed below."; while($row = mysql_fetch_array($getitb)){ $qCID[] = $row['ID']; $qfirst_Name[] = $row['first_Name']; $qName[] = $row['Name']; $qCompany[] = $row['Company']; $qPhone[] = $row['Phone']; $qemail[] = $row['email']; } }//if$comnumbisgreaterthanone }//ifgotitb }//ifemcountislessthanone }//ifgotit }//ifsearchbyisZipCode ?>

Eco-$mart, Inc. Eco-$mart Contacts

"); } if($quest == "On"){ echo(""); $i = 0; $qcount = count($qCID); while($i < $qcount){ echo("" . "" . ""); $i = $i + 1; } } ?>

Contact List for			Print List New Contact
Manage	Name	Company	Phone	Email
$messo [BACK]
$messo
[ View/Edit ]" . " [ REMOVE ]	$qfirst_Name[$i] $qName[$i]	$qCompany[$i]	$qPhone[$i]	$qemail[$i]

Your Contacts	New Contact	Search Your Contacts
Get CSV	Help	Return to Your Page