Create your Own ChatGPT with Custom Bots Using PHP, MySQL JS

Download the source, copy the assets (images and css) into your my chatgpt folder, merge files, replace index html with php tags, then refresh to display a single chat bot.

Create a MySQL database and a bots table to store chat messages and bot data, including name, description, and role prompts, and learn to connect it to your PHP app.

Create a PHP class using PDO to connect to a local MySQL database, define a connect method, and test the connection by including class files and invoking the method.

Create a PHP chat class that connects to the database and exposes a get_chat_bots method. Use PDO to prepare, execute, and fetch results as objects from the boats table.

Display chat bots on the index page by looping through bot data with a PHP foreach loop, incrementing an index to vary images, and echoing each bot’s name and description.

Create a dedicated chat page to display recent chats and list chat bots, assign each bot an ID, and connect the page to the chat API for user conversations.

Implement a method to fetch bot data by id via a get request, using PDO to retrieve from the database and display the bot's welcome message.

Create a new chat table in phpMyAdmin for the my chat database with five columns (id, text, author enum user or AI, bought_id, created_at) to store and display messages.

Create a get chat method to fetch messages by boat ID, query the chat table, and display user and bot messages while hiding the welcome message when messages exist.

Create a JavaScript file that detects typing in a text input and sends the value to a PHP file on enter, wiring the input and boat ID.

Create two JavaScript functions to fetch and display user messages via Ajax, retrieving JSON data from a PHP file and updating the chat window.

Learn to implement a store messages function that sends an ajax post to a php script and inserts messages, with boat id and type, into the chat database.

Create a method to display AI messages with a loader while awaiting a response, using ajax post to get_response.php and render the AI reply from a prompt.

Download a third-party repository to connect to the ChatGPT API and send and receive messages. Install with Composer, include vendor/autoload.php, and use the repository class with your API token.

Sign up for a free OpenAI account on platform.openai.com, generate a secret API key, and paste it into your PHP file to access the OpenAI API.

Test the ChatGPT API by sending a user message from your app to the OpenAI SDK using GPT-3.5-turbo, and display the response as a chat message.

Store API responses and user messages in a database, format the conversation into a memory array with author labels, so the AI remembers the chat for smarter answers.

Create a method to extract and highlight code blocks from chat messages using a regular expression for triple backticks, identify the language, and render with Prism JS in PHP.

Create a get recent chat method to fetch the latest message per boat by joining the chat and boats tables with a subquery, then display 40-character previews.

Create a JavaScript function to auto-scroll the chat to the newest message using the main div's scroll height and jQuery animate, and disable the text area during responses.

Create a JavaScript typing effect function that reveals the AI message character by character, integrating with chat.php and the GPD API to simulate typing in the chat.

Create a JavaScript function to detect and highlight code blocks as you type, using triple backticks, extracting language, wrapping in pre and code, and reloading Prism for live syntax highlighting.

Set a system message to make ChatGPT follow a defined role and answer only topic-related questions (PHP, HTML, SQL) across PHP, HTML, and SQL boards in your bot.