SQL语法错误。 请我检查MariaDB服务器的手册

I'm getting the error stating that

Error inserting RecordYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''arcade',123)' at line 1"

if (isset($_POST['name'])) {

    //code to insert new record into DB
    $insQuery = "insert into inventory values(NULL,"
    ."'". $_POST['name'] ."',"
    . $_POST['price'] .","
    . $_POST['rating'] .","
    . $_POST['console'] .","
    ."'". $_POST['genre'] ."',"
    . $_POST['quantity'] .")";

if (isset($_POST['name'])) {

//code to insert new record into DB
$insQuery = "insert into inventory(name, price,rating, console,gender,quantity) values(NULL, '". $_POST['name'] ."','"
. $_POST['price'] ."','"
. $_POST['rating'] ."','"
. $_POST['console'] ."','"
."','". $_POST['genre'] ."','"
. $_POST['quantity'] ."')";

U forgot some comma (,) and ' in ur query and also forgot table field name in inventory(name, price,rating, console,gender,quantity).... put it ut table field name there...