🏠 Home Buying Assistant
💰 Down Payment
📋 Pre-Approval
🏠 Closing Costs
🔍 Inspection
💬
find_best_response($user_input);
// Optional: Log conversation
$this->log_conversation($user_input, $response);
wp_send_json_success(array(
‘response’ => $response,
‘timestamp’ => current_time(‘g:i A’)
));
}
private function find_best_response($input) {
$input_lower = strtolower($input);
$best_match = null;
$best_score = 0;
foreach ($this->knowledge_base as $topic => $data) {
$score = 0;
foreach ($data[‘keywords’] as $keyword) {
if (strpos($input_lower, strtolower($keyword)) !== false) {
$score += strlen($keyword);
}
}
if ($score > $best_score) {
$best_score = $score;
$best_match = $data[‘response’];
}
}
if ($best_match) {
return $best_match;
}
// Default response if no match
return “I’d be happy to help with your home buying question! I can provide information about pre-approval, down payments, finding homes, inspections, closing costs, and more. Could you be more specific about what you’d like to know?”;
}
private function create_conversations_table() {
global $wpdb;
$table_name = $wpdb->prefix . ‘chatbot_conversations’;
$charset_collate = $wpdb->get_charset_collate();
$sql = “CREATE TABLE $table_name (
id mediumint(9) NOT NULL AUTO_INCREMENT,
user_message text NOT NULL,
bot_response text NOT NULL,
user_ip varchar(45) DEFAULT ”,
timestamp datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) $charset_collate;”;
require_once(ABSPATH . ‘wp-admin/includes/upgrade.php’);
dbDelta($sql);
}
private function log_conversation($user_message, $bot_response) {
global $wpdb;
$table_name = $wpdb->prefix . ‘chatbot_conversations’;
$wpdb->insert(
$table_name,
array(
‘user_message’ => $user_message,
‘bot_response’ => $bot_response,
‘user_ip’ => $_SERVER[‘REMOTE_ADDR’]
)
);
}
public function add_admin_menu() {
add_options_page(
‘Chatbot Settings’,
‘Home Buyer Chatbot’,
‘manage_options’,
‘home-buyer-chatbot’,
array($this, ‘admin_page’)
);
}
public function admin_page() {
global $wpdb;
$table_name = $wpdb->prefix . ‘chatbot_conversations’;
// Get recent conversations
$conversations = $wpdb->get_results(
“SELECT * FROM $table_name ORDER BY timestamp DESC LIMIT 50”
);
?>
Need Help?
Home Buyer Chatbot
Recent Conversations
| Date | User Question | Bot Response | IP Address |
|---|---|---|---|
| timestamp)); ?> | user_message, 0, 100)); ?>user_message) > 100 ? ‘…’ : ”; ?> | bot_response, 0, 100)); ?>bot_response) > 100 ? ‘…’ : ”; ?> | user_ip); ?> |
Knowledge Base Topics
- Pre-approval & Financing: Mortgage pre-approval, credit scores, down payments
- Home Search: Finding agents, searching for homes, making offers
- Inspections & Appraisals: Home inspections, appraisal process
- Closing Process: Closing costs, title insurance, final walkthrough
- First-Time Buyer Programs: FHA, VA, USDA loans, assistance programs
- Market Conditions: Timing, market trends, buyer vs seller markets