Chatbots Project In Php

Creating a Chatbot project involves several components, including a MySQL database schema, file structure, layout design using Bootstrap 5, and complete PHP scripts for user authentication and management. Below is a comprehensive guide to help you set up your system.

Project Introduction

The Chatbot System is a web application designed to facilitate user interaction with an intelligent chatbot. This platform allows users to engage in conversations, receive responses, and manage their interactions with the chatbot. The system supports user authentication, session management, and the ability to define intents and entities for the chatbot's understanding. With a focus on enhancing user experience and providing valuable interactions, this system aims to streamline communication through automated responses.

Project Objectives

To develop a secure and user-friendly platform for users to interact with a chatbot.
To implement a comprehensive database schema that supports user management, session tracking, and interaction logging.
To allow the definition and management of intents and entities to enhance the chatbot's understanding of user inputs.
To provide functionalities for training the chatbot with various phrases to improve response accuracy.
To ensure a seamless user experience with real-time interaction capabilities.
To create a responsive design that enhances usability across different devices.

Project Modules

User Management: Handles user registration, authentication, and role assignments (admin, user).
User Sessions: Manages user sessions, including session tokens and expiration times for security.
User Interactions: Logs user inputs and chatbot responses for analysis and improvement of the chatbot's performance.
Intent Management: Allows the creation and management of intents that define the chatbot's understanding of user queries.
Training Phrases Management: Facilitates the addition of training phrases associated with each intent to improve response accuracy.
Entity Management: Manages entities that help the chatbot understand specific data points within user inputs.
Conversation Context: Maintains context data for ongoing conversations to provide more relevant responses.

1. MySQL Database Schema


CREATE DATABASE chatbot_system;
USE chatbot_system;
-- Table for users
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL UNIQUE,
    password VARCHAR(255) NOT NULL,
    email VARCHAR(100) NOT NULL UNIQUE,
    role ENUM('admin', 'user') DEFAULT 'user',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
-- Table for user sessions
CREATE TABLE user_sessions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    session_token VARCHAR(255) NOT NULL UNIQUE,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    expires_at TIMESTAMP NOT NULL,
    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);
-- Table for user interactions
CREATE TABLE user_interactions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    interaction_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    user_input TEXT NOT NULL,
    bot_response TEXT NOT NULL,
    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);
-- Table for intents
CREATE TABLE intents (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL UNIQUE,
    description TEXT
);
-- Table for training phrases
CREATE TABLE training_phrases (
    id INT AUTO_INCREMENT PRIMARY KEY,
    intent_id INT NOT NULL,
    phrase TEXT NOT NULL,
    FOREIGN KEY (intent_id) REFERENCES intents(id) ON DELETE CASCADE
);
-- Table for entities
CREATE TABLE entities (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL UNIQUE,
    entity_type VARCHAR(100) NOT NULL
);
-- Table for entity values
CREATE TABLE entity_values (
    id INT AUTO_INCREMENT PRIMARY KEY,
    entity_id INT NOT NULL,
    value TEXT NOT NULL,
    FOREIGN KEY (entity_id) REFERENCES entities(id) ON DELETE CASCADE
);
-- Table for conversation context
CREATE TABLE conversation_context (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    context_data TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);

2. File and Folder Structure


chatbot_system/
│
├── config/
│   └── db.php
│
├── public/
│   ├── index.php
│   ├── login.php
│   ├── register.php
│   ├── dashboard.php
│   ├── chat.php
│   ├── intents.php
│   ├── entities.php
│   ├── training_phrases.php
│   └── notifications.php
│
├── includes/
│   ├── header.php
│   ├── footer.php
│   └── functions.php
│
├── assets/
│   ├── css/
│   │   └── styles.css
│   ├── js/
│   │   └── scripts.js
│   └── images/
│
└── vendor/
    └── (Bootstrap and other libraries)

3. Layout Based Design with Bootstrap 5

Header (includes/header.php)


<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
    <link rel="stylesheet" href="assets/css/styles.css">
    <title>Chatbot System</title>
</head>
<body>
    <div class="container">
        <header class="my-4">
            <h1>Chatbot System</h1>
        </header>
        <nav class="navbar navbar-expand-lg navbar-light bg-light">
            <div class="container-fluid">
                <a class="navbar-brand" href="index.php">Home</a>
                <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
                    <span class="navbar-toggler-icon"></span>
                </button>
                <div class="collapse navbar-collapse" id="navbarNav">
                    <ul class="navbar-nav">
                        <li class="nav-item">
                            <a class="nav-link" href="chat.php">Chat</a>
                        </li>
                        <li class="nav-item">
                            <a class=" nav-link" href="intents.php">Intents</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="entities.php">Entities</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="training_phrases.php">Training Phrases</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="login.php">Login</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="register.php">Register</a>
                        </li>
                    </ul>
                </div>
            </div>
        </nav>
        <main class="my-4">

Footer (includes/footer.php)


        </main>
        <footer class="text-center my-4">
            <p>© 2023 Chatbot System. All rights reserved.</p>
        </footer>
    </div>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>

4. PHP Code for User Authentication

Registration (public/register.php)


<?php
require '../config/db.php';
require '../includes/header.php';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $username = $_POST['username'];
    $email = $_POST['email'];
    $password = password_hash($_POST['password'], PASSWORD_DEFAULT);
    $role = $_POST['role'];
    $stmt = $conn->prepare("INSERT INTO users (username, email, password, role) VALUES (?, ?, ?, ?)");
    $stmt->bind_param("ssss", $username, $email, $password, $role);
    $stmt->execute();
    $stmt->close();
    header("Location: login.php");
}
?>
<form method="POST" action="">
    <div class="mb-3">
        <label for="username" class="form-label">Username</label>
        <input type="text" class="form-control" id="username" name="username" required>
    </div>
    <div class="mb-3">
        <label for="email" class="form-label">Email</label>
        <input type="email" class="form-control" id="email" name="email" required>
    </div>
    <div class="mb-3">
        <label for="password" class="form-label">Password</label>
        <input type="password" class="form-control" id="password" name="password" required>
    </div>
    <div class="mb-3">
        <label for="role" class="form-label">Role</label>
        <select class="form-select" id="role" name="role">
            <option value="user">User </option>
            <option value="admin">Admin</option>
        </select>
    </div>
    <button type="submit" class="btn btn-primary">Register</button>
</form>
<?php require '../includes/footer.php'; ?>


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $username = $_POST['username'];
    $password = $_POST['password'];
    $stmt = $conn->prepare("SELECT * FROM users WHERE username = ?");
    $stmt->bind_param("s", $username);
    $stmt->execute();
    $result = $stmt->get_result();
    $user = $result->fetch_assoc();
    if ($user && password_verify($password, $user['password'])) {
        $_SESSION['user_id'] = $user['id'];
        $_SESSION['role'] = $user['role'];
        header("Location: dashboard.php");
    } else {
        echo "Invalid credentials.";
    }
}
?>
<form method="POST" action="">
    <div class="mb-3">
        <label for="username" class="form-label">Username</label>
        <input type="text" class="form-control" id="username" name="username" required>
    </div>
    <div class="mb-3">
        <label for="password" class="form-label">Password</label>
        <input type="password" class="form-control" id="password" name="password" required>
    </div>
    <button type="submit" class="btn btn-primary">Login</button>
</form>
<?php require '../includes/footer.php'; ?>

5. Additional PHP Scripts

Dashboard (public/dashboard.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}
$user_id = $_SESSION['user_id'];
$stmt = $conn->prepare("SELECT * FROM users WHERE id = ?");
$stmt->bind_param("i", $user_id);
$stmt->execute();
$result = $stmt->get_result();
$user = $result->fetch_assoc();
?>
<h2>Welcome, <?php echo $user['username']; ?></h2>
<p>Your role: <?php echo ucfirst($user['role']); ?></p>
<?php require '../includes/footer.php'; ?>

Chat Interface (public/chat.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}
?>
<h2>Chat with the Bot</h2>
<div id="chatbox" class="border p-3" style="height: 400px; overflow-y: scroll;">
    <!-- Chat messages will be displayed here -->
</div>
<form id="chat-form" method="POST" action="">
    <div class="input-group">
        <input type="text" class="form-control" id="user_input" name="user_input" placeholder="Type your message..." required>
        <button class="btn btn-primary" type="submit">Send</button>
    </div>
</form>
<script>
document.getElementById('chat-form').onsubmit = function(e) {
    e.preventDefault();
    const userInput = document.getElementById('user_input').value;
    document.getElementById('chatbox').innerHTML += `<div>User: ${userInput}</div>`;
    document.getElementById('user_input').value = '';
    // Here you would send the user input to the server and get the bot response
    // For demonstration, we will simulate a bot response
    setTimeout(() => {
        const botResponse = "This is a simulated response.";
        document.getElementById('chatbox').innerHTML += `<div>Bot: ${botResponse}</div>`;
        document.getElementById('chatbox').scrollTop = document.getElementById('chatbox').scrollHeight;
    }, 1000);
};
</script>
<?php require '../includes/footer.php'; ?>

Intents Management (public/intents.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id']) || $_SESSION['role'] !== 'admin') {
    header("Location: login.php");
    exit();
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $name = $_POST['name'];
    $description = $_POST['description'];
    $stmt = $conn->prepare("INSERT INTO intents (name, description) VALUES (?, ?)");
    $stmt->bind_param("ss", $name, $description);
    $stmt->execute();
    $stmt->close();
    header("Location: intents.php");
}
$stmt = $conn->prepare("SELECT * FROM intents");
$stmt->execute();
$result = $stmt->get_result();
$intents = $result->fetch_all(MYSQLI_ASSOC);
?>
<h2>Manage Intents</h2>
<form method="POST" action="">
    <div class="mb-3">
        <label for="name" class="form-label">Intent Name</label>
        <input type="text" class="form-control" id="name" name="name" required>
    </div>
    <div class="mb-3">
        <label for="description" class="form-label">Description</label>
        <textarea class="form-control" id="description" name="description" required></textarea>
    </div>
    <button type="submit" class="btn btn-primary">Add Intent</button>
</form>
<h3>Existing Intents</h3>
<ul>
    <?php foreach ($intents as $intent): ?>
    <li><?php echo $intent['name']; ?> - <?php echo $intent['description']; ?></li>
    <?php endforeach; ?>
</ul>
<?php require '../includes/footer.php'; ?>

Entities Management (public/entities.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id']) || $_SESSION['role'] !== 'admin') {
    header("Location: login.php");
    exit();
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $name = $_POST['name'];
    $entity_type = $_POST['entity_type'];
    $stmt = $conn->prepare("INSERT INTO entities (name, entity_type) VALUES (?, ?)");
    $stmt->bind_param("ss", $name, $ entity_type);
    $stmt->execute();
    $stmt->close();
    header("Location: entities.php");
}
$stmt = $conn->prepare("SELECT * FROM entities");
$stmt->execute();
$result = $stmt->get_result();
$entities = $result->fetch_all(MYSQLI_ASSOC);
?>
<h2>Manage Entities</h2>
<form method="POST" action="">
    <div class="mb-3">
        <label for="name" class="form-label">Entity Name</label>
        <input type="text" class="form-control" id="name" name="name" required>
    </div>
    <div class="mb-3">
        <label for="entity_type" class="form-label">Entity Type</label>
        <input type="text" class="form-control" id="entity_type" name="entity_type" required>
    </div>
    <button type="submit" class="btn btn-primary">Add Entity</button>
</form>
<h3>Existing Entities</h3>
<ul>
    <?php foreach ($entities as $entity): ?>
    <li><?php echo $entity['name']; ?> - <?php echo $entity['entity_type']; ?></li>
    <?php endforeach; ?>
</ul>
<?php require '../includes/footer.php'; ?>

Training Phrases Management (public/training_phrases.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id']) || $_SESSION['role'] !== 'admin') {
    header("Location: login.php");
    exit();
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $intent_id = $_POST['intent_id'];
    $phrase = $_POST['phrase'];
    $stmt = $conn->prepare("INSERT INTO training_phrases (intent_id, phrase) VALUES (?, ?)");
    $stmt->bind_param("is", $intent_id, $phrase);
    $stmt->execute();
    $stmt->close();
    header("Location: training_phrases.php");
}
$stmt = $conn->prepare("SELECT * FROM training_phrases");
$stmt->execute();
$result = $stmt->get_result();
$phrases = $result->fetch_all(MYSQLI_ASSOC);
$stmt = $conn->prepare("SELECT * FROM intents");
$stmt->execute();
$result = $stmt->get_result();
$intents = $result->fetch_all(MYSQLI_ASSOC);
?>
<h2>Manage Training Phrases</h2>
<form method="POST" action="">
    <div class="mb-3">
        <label for="intent_id" class="form-label">Select Intent</label>
        <select class="form-select" id="intent_id" name="intent_id" required>
            <?php foreach ($intents as $intent): ?>
            <option value="<?php echo $intent['id']; ?>"><?php echo $intent['name']; ?></option>
            <?php endforeach; ?>
        </select>
    </div>
    <div class="mb-3">
        <label for="phrase" class="form-label">Training Phrase</label>
        <input type="text" class="form-control" id="phrase" name="phrase" required>
    </div>
    <button type="submit" class="btn btn-primary">Add Phrase</button>
</form>
<h3>Existing Training Phrases</h3>
<ul>
    <?php foreach ($phrases as $phrase): ?>
    <li><?php echo $phrase['phrase']; ?> (Intent ID: <?php echo $phrase['intent_id']; ?>)</li>
    <?php endforeach; ?>
</ul>
<?php require '../includes/footer.php'; ?>