用php+MySQL做网站往数据库插入数据时发现如下错误:
注册失败!Unknown column ‘TEST’ in ‘field list’
–往user表(user和pass列)插入数据,
s q l = " I N S E R T I N T O u s e r ( u s e r , p a s s ) v a l u e s ( sql="INSERT INTO user(user,pass) values( sql="INSERTINTOuser(user,pass)values(user,$pass)";
int型数据时间,sql在数据库执行的是
insert into user(user,pass) values(001,001);
然而当执行char型号数据时,SQL语句变成了:
insert into user(user,pass) values(abc,abc);
将SQL语句改为:
s q l = " I N S E R T I N T O u s e r ( u s e r n a m e , p a s s w o r d ) v a l u e s ( ′ " . sql="INSERT INTO user(username,password) values('". sql="INSERTINTOuser(username,password)values(′".username."’,’".$password."’)";
即在字符串变量两边加上’".$string."’