php - Insert INTO not working -

i have problem sql syntax. have 2 tables , third table generated in sql workbench (n:m relationship).

my 3rd table has 2 columns product_id , categories_id.

i use sql in php admin add new row:

insert `products_has_categories` (`products_id`, `categories_id`)  values ('17', '1');      

if phpmyadmin, sql add new row, product_id = 17 , categories_id =1.

my problem:

i have simple php file called test.php looking like:

 $connection = mysqli_connect("andrei.local","andrei94ro","masina", "intership");  if(!$connection) {     echo 'error'; } $query =  "insert `products_has_categories` (`products_id`, `categories_id`) values ('17', '1');"; 

or

$query =  "insert `products_has_categories` (`products_id`, `categories_id`) values ('17', '1')"; 

when run test.php file, code not working, , no adding new row in sql table. can u me?

as far i'm concerned, you're not calling query().

try this:

$connection = new mysqli("andrei.local","andrei94ro","masina", "intership");  if(!$connection) {     echo 'error'; } else {     $query = $connection->query("insert `products_has_categories`     (`products_id`, `categories_id`) values ('17', '1')"); }