MySQLi Insert Record

I am running MAMP Pro PHP Version 7.4.33 and suddenly I cannot insert a record into my database using MySQLi Insert Record.

I have created a dumbed down version of my php page (attached).

I am getting a "There is an error in your SQL syntax" unless I use the 'current page submit' Trigger. Even when it is not giving an error, the data is not written to the table in the database. I have seen that the place where the error is thrown, is at $InsertQuery->execute();

I hope you can help, as it is driving me nuts.

Regards

Willem

Hi Willem:
Suggestion: Instead of putting the php page in private, use public to post the top lines of the page publicly so others can see it. There are a lot of peeps on this list who may be able to help. (I can't spot any issues when I viewed it. The right php is on the top of the page. I am merely a user on the forum and granted access in order to remove spam.)
If you are not up to date on the forum's status, Ray has passed away and we are all trying to help one another now until WA is sorted out with Ray's family and former colleagues.

Thanks, Patrice.

I'll check your suggestion out.

I am shocked to hear of Ray's passing. I was not aware of that.

Regards

Willem

I am so sorry to hear about Ray.........My condolences to his family and friends.......He did a Great Thing here with his life!!!