mysql php insert query

Asked Nov 28 '17 at 02:29

Active Nov 28 '17 at 02:36

Viewed 18 times

I am beginner in php & mysql.

I want query to gabia DB. I have an error 1064 and I do not know the cause.

this is my query

$sql = "insert into FileList_PK_DB(PK_CorpName,PK_Code,up_date,username,Null) 
values ('".trim($_POST[corpname])."', '".trim($_POST[corpcode])."',  '".trim($_POST[FDDate])."', '".trim($_POST[FDmember])."', '".trim($_POST[workcont])."')";

this is my result

insert into FileList_PK_DB(PK_CorpName,PK_Code,up_date,username,Null) values ('TEAM', 'h0002', '2017-11-28', 'C0001', 'qwer')

1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Null) values ('TEAM', 'h0002', '2017-11-28', 'C0001', 'qwer')' at line 1

i find google but... i could not solve it

please help me

edited Nov 28 '17 at 02:36

Saumini Navaratnam

8,439
3
42
70

asked Nov 28 '17 at 02:29

MIKE

2

do you have `Null` name column? – Shadow Fiend Nov 28 '17 at 02:33
oh my god thanks genius – MIKE Nov 28 '17 at 02:36
`NULL` is reserved keyword in Mysql. To escape it use back tick (`) character. – Saumini Navaratnam Nov 28 '17 at 02:43
You are open to SQL injections, parameterize the query. – chris85 Nov 28 '17 at 03:04

mysql php insert query

0 Answers0