prepare('SELECT * FROM lander_client WHERE clientID = ?'); $search->execute(array($id)); if($search){ $client = $search->fetch(PDO::FETCH_OBJ); if(!empty($client)){ $name_parts = array(); $first = htmlentities($client->fname, ENT_COMPAT, 'UTF-8'); if($first){ $name_parts[] = $first; } $last = htmlentities($client->lname, ENT_COMPAT, 'UTF-8'); if($last){ $name_parts[] = $last; } $name = implode(' ', $name_parts); $address_parts = array(); $address = htmlentities($client->address, ENT_COMPAT, 'UTF-8'); if($address){ $address_parts[] = $address.'
'; } $city = htmlentities($client->city, ENT_COMPAT, 'UTF-8'); if($city){ $address_parts[] = $city.','; } $state = htmlentities($client->state, ENT_COMPAT, 'UTF-8'); if($state){ $address_parts[] = $state.','; } $country = htmlentities($client->country, ENT_COMPAT, 'UTF-8'); if($country){ $address_parts[] = $country; } $address = implode(' ', $address_parts); $type = client_type($client->type); $box_folder = htmlentities($client->box_folder, ENT_COMPAT, 'UTF-8'); $notes = htmlentities($client->notes, ENT_COMPAT, 'UTF-8'); $loans = ''; $content .= << Name $name Address $address Client Type $type EOT; if($box_folder){ $content .= << Box & Folder $box_folder EOT; } if($notes){ $content .= << Notes $notes EOT; } $content .= << EOT; // Close the cursor to allow a new query. $search->closeCursor(); $SQL = << prepare($SQL); $loan_search->execute(array($id)); if($loan_search){ $results = $loan_search->fetchall(PDO::FETCH_OBJ); foreach($results as $r){ $loanID = $r->loanID; $loan_number = $r->loan_number? '#'.$r->loan_number : 'Unnumbered'; $issued = isset($r->issued)? $r->issued : 'Date unknown'; $foreclosed = isset($r->foreclosed)? $r->foreclosed: 'No foreclosure date on record'; $county = htmlentities($r->county, ENT_COMPAT, 'UTF-8'); $state = htmlentities($r->state, ENT_COMPAT, 'UTF-8'); $amount = $r->amount; // RE number means "Real Estate" number, issued in the case of properties repossessed after a default. $renumber = $r->renumber != 0? $r->renumber : ''; $rebox_folder = $r->rebox_folder; $loan_box_folder = $r->loan_box_folder; $city_lot = isset($r->city_lot)? $r->city_lot: ''; $acres = $r->acres? $r->acres : 'Unknown'; $size_category = $r->size_category? $r->size_category : 'unknown size category'; $loan_notes = htmlentities($r->loan_notes, ENT_COMPAT, 'UTF-8'); $loans .= << Loan $loan_number ($issued)

EOT; } $content .= $loans; } } } } else { } ?> ***PHP REMOVED***