Insert in sql server database using form

Question

Error while inserting name and password using a form to sql server using php. Can anyone help me?

$name = $_POST['add_name'];
$password =$_POST['add_pass'];

$query = "INSERT INTO zTest(user, password) VALUES ('".$name."','".$password."');";
$params = array();
$options =  array( "Scrollable" => SQLSRV_CURSOR_KEYSET );
$stmt = sqlsrv_query($conn, $query, $params, $options ); 
if($stmt === false){
die ( print_r (sqlsrv_errors(), true));
}

Error Message:

Array ( [0] => Array ( [0] => 42000 [SQLSTATE] => 42000 [1] => 156 [code] => 156 [2] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'user'. [message] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'user'. ) )

jonju · Accepted Answer · 2016-08-04 08:28:36Z

1

user is a reserved keyword in Sql-Server. use as square bracket like [user]

answered Aug 4, 2016 at 8:28

jonju

2,7561 gold badge15 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert in sql server database using form

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related