PHP add rows to MySQL table?

Question

PHP

The essence of the question is this, here is the code, and the table in mysql, when you click on the submit button, the page pretends to send (blinks) and then remains on the same page but with empty forms.

Answer 1

The table name must be quoted in the form ` (backtick), not '.
INSERT INTO `vacancies` VALUES ...

Answer 2

Use prepared statements and bind param , you have mysqli, 2016 is in the yard.

Answer 3

Apostrophes were missing in the string with the mysql query when accessing the elements of the "$_POST" array. Also, it's better to pass NULL rather than an empty string as the value for the incremental id.
It should be something like this:

<?php
mysqli_query($CONNECT, "INSERT INTO 'vacancies' VALUES (NULL, '{$_POST['title']}', '{$_POST['wysiwig-area']}', NOW()");