25) {$errmsg = "Last Name may not exceed 25 characters";} break; case "dob": if (strlen($search_term) > 10 || !DateTime::createFromFormat('Y-m-d', $search_term)) {$errmsg = "DOB must be in YYYY-MM-DD format";} break; case "phone1": if (strlen($search_term) > 25 ) {$errmsg = "Phone number may not exceed 25 characters";} break; case "email": if (strlen($search_term) > 55 ) {$errmsg = "E-mail may not exceed 55 characters";} break; case "pc": if (strlen($search_term) > 11 ) {$errmsg = "Postal Code may not exceed 11 characters";} break; case "business": if (strlen($search_term) > 125 ) {$errmsg = "Business Name may not exceed 125 characters";} break; } } if($errmsg !=="") { echo "

" . $errmsg . ". Please try again.

"; } else { if(strlen($search_term)>0 && strlen($search_field) >0) { // instantiate database and client object $database = new Database(); $db = $database->getConnection(); $client = new Client($db); $stmt = $client->search($search_term, $search_field); // get row count from search results $total_rows=$stmt->rowCount(); } } } // END POST code here.... // END POST code here.... ?>
Search for Client
     
Add Client

Client Search Results


**Note: Clients in Red indicate client data has been flagged or has flagged transactions. Please Validate the Client record before adding a transaction.
0){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){ extract($row); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
IdNameDOBE-mail AddressAddressPostal CodePhone No.Business Name 
{$id}{$lname}" . ", " . "{$fname}{$dob}" . substr($row['email'], 0, 30) . (strlen($row['email'])>30 ? "..." : "") . "{$addr1}{$pc}{$phone1}" . substr($row['business'], 0, 20) . "..."; // edit client button echo ""; echo " "; echo "     "; echo ""; echo ""; echo "     "; // delete client button (not visible if type is admin) if ($_SESSION['usertype'] == "Admin" ) { ?> ')" alt='Remove this Client' title='Remove this Client' > "; echo ""; } echo "
"; } // or else, tell the client there are no clients to display else{ echo "
No clients found.
"; } ?>