mysql无法插入包含8列的表中

Question

i'm trying to insert datas in a table of 8 columns but it's doesn't work . i'm using mysql version 5.7.11 . however it works when i reduce it to 6 columns 7 columns refuse to work as well .

please find the tables and their php code below

1. 6 columns mysql/php

1.1 php

$res=$pdo->prepare('INSERT INTO '.$table.'(title,description,image,city,price) VALUES(:titl,:decri,:img,:cty,:prce)');

$res->bindParam(':titl',$title);
     $res->bindParam(':decri',$decri);
     $res->bindParam(':img',$item_img);
     $res->bindParam(':cty',$city);
     $res->bindParam(':prce',$price);

1.2 mysql

 CREATE TABLE `mobiles` 
 (`id` int(11) NOT NULL,
 `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 `description` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`image` longblob NOT NULL,
`city` varchar(20) NOT NULL,
`price` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

1. 8 columns tables

2.1 mysql code

  CREATE TABLE `mobiles` (
 `id` int(11) NOT NULL,
`title` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`description` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT   NULL,
 `image` longblob NOT NULL,
`city` varchar(20) NOT NULL,
`price` int(11) NOT NULL,
`user_id` int(10) NOT NULL,
`date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

2.2 php code

$res=$pdo->prepare('INSERT INTO'.$table.'(title,description,image,city,price,user_id,date)    VALUES(:titl,:decri,:img,:cty,:prce,:user_id,:dte)');
     $res->bindParam(':titl',$title);
     $res->bindParam(':decri',$decri);
     $res->bindParam(':img',$item_img);
     $res->bindParam(':cty',$city);
     $res->bindParam(':prce',$price);
     $res->bindParam(':user_id',$user_id);
     $res->bindParam(':dte',$date);

i have executed right after , the six columns works but the 8 columns one

why is that more than 6 columns mysql can't insert while the number limit of columns can reach 255.

is there any issue in my code ? i echoed all the entries and they all work fine.

any help please ?

Answer 1

You have no space between 'INSERT INTO' and $table in second query, so query fails because of syntax error.