There is an error in inserting post data into PHP code. Please give me some advice.

Question

$mql="insert into user(uname,uage,passwd) value('"$uname"','"$uage"','"$passw"')" ;

Browser The feedback error is syntax error, unexpected T_VARIABLE. What is the error? What is the correct way to write it?

Answer 1

Correct grammar:

$mql = "INSERT INTO `user` (`uname`, `uage`, `passwd`) VALUES ('{$uname}', {$uage}, '{$passwd}')";

or:

$mql = "INSERT INTO `user` SET `uname` = '{$uname}',  `uage` = {$uage}, `passwd` = '{$passwd}'";