Comments on: Simple Chatbot using PHP with MySQL & jQuery (Ajax)

By: Brant Kingery

Brant Kingery — Wed, 11 Jan 2023 04:05:15 +0000

I downloaded and deployed this chatbot; the only problem is the SQL LIKE operator and how it selects results. When speaking about selecting the values, I’ve read up on how multiple different data types can determine whether rather specific criteria have been met. For example, if I search for the name %jon%, the results will show any record with the attributes Jon; the issue here is when I type in non-specific terms such as multiple values. As a result, the code will not recognize the response. I have tried to change the SQL statements to the LIKE “%search_variable%.” to:

“search_variable%” (starts with query) or “%search_variable” (ends with query)

Still, I am having issues when asking complex or multi-variable responses such as “hi, how are you?” or “I am having troubles with my account” what I am trying to achieve is when these types of queries are asked, I need to filter the question by word inside entire query such as “account” when the user is asking about the account. Currently, the results are only being displayed by specific instances such as “fun” or “funny” I cannot type in “that was funny”; I have to type in “funny” or “fun” specifically with nothing else in the query. Any help would be greatly appreciated.

By: Chema

Chema — Fri, 14 Oct 2022 21:12:31 +0000

How put users text messages questions into database? thankyou.

By: yasmin

yasmin — Thu, 25 Aug 2022 10:01:49 +0000

when i send a message it sends a message saying “error”. what can i do about it

By: Ragini

Ragini — Fri, 12 Aug 2022 01:41:41 +0000

What are the softwares I should install for using this codes?

By: CodingNepal

CodingNepal — Wed, 29 Jun 2022 10:36:00 +0000

In reply to Aldy. I've said everythingg in the video. Please, watch the complete video.

By: Aldy

Aldy — Sun, 26 Jun 2022 02:18:33 +0000

hello bro
what algorithm do you use in this chatbot?

By: parkash

parkash — Sat, 04 Jun 2022 17:07:28 +0000

provide sql file

By: eureka tidianne

eureka tidianne — Wed, 25 May 2022 16:02:20 +0000

thanks you Coding Nepal !

By: Its Deku Senpai

Its Deku Senpai — Mon, 28 Feb 2022 10:14:56 +0000

Hi, sorry but I have an question, or an error,
every time I type my queries and hit send, the bot say Error
I downloaded the code itself and its the same, when I open message.php it say “Error line 6. text undefined” as I said I even tried the source code and its the same. Error every time. what should I do?

By: CodingNepal

CodingNepal — Fri, 11 Feb 2022 12:54:51 +0000

In reply to Vai. Simply, put the success codes inside a setTimeout function:

setTimeout(() => {
  // codes that are inside success function
}, 1000); // 1000 milliseconds = 1 second