Unable to update database with PHP MySQL where data is coming from AngularJS1.2 service -

i new in angularjs , in php mysql.

i trying update php database.

for first form have inserted data name, email, phone number , password. after when login want update specific table country, city, state, pincode , address.

but getting error

update user_table set (country = 'india', state = 'west bengal', city = 'kolkata', pincode = '700028', fulladdress = '4/6,aswiny dutta road') email ='wri@gmail.com'appointment not updatederreur de syntaxe pr�s de '(country = 'india', state = 'west bengal', city = 'kolkata', pincode = '700028',' � la ligne 1

here code below.

controller:

angular.module('cartapp.userprofile.controller', []).controller('userprofilecontroller', ['$scope','loginfactory','signupfactory',function($scope,loginfactory,signupfactory){   $scope.userlistary = [];  $scope.userlistfn = function(){     loginfactory.fetchsingledatatoserverfn()         .then(function(singleuser){             console.log('singleuser',singleuser)             $scope.userlistary = singleuser.data;             console.log('user profile controller data: '+json.stringify($scope.userlistary));         },function(){             console.log('data cannot retrieved');         }) } $scope.userlistfn();   $scope.submitaddress = function(country,city,state,pincode,address){     console.log('country: '+country+' city: '+city+' state: '+state+' pincode: '+pincode+' address: '+address)     var useremail = $scope.userlistary.email;     signupfactory.loginaddressfn(country,city,state,pincode,address,useremail); } }]); 

service:

 'use strict'; angular.module('cartapp.signup.services', []).factory('signupfactory',['$http','$q',function($http,$q){      var signupobj = {         setsignupformfn : setsignupformfn,         getsignupformfn : getsignupformfn,         signuparray : [],         fetchdatatoserverfn : fetchdatatoserverfn,         loginaddressfn : loginaddressfn     };      function setsignupformfn(username,userphno,useremail,userpass,userconfirmpass){         var signupvalueobj = {};          signupvalueobj.username = username;         signupvalueobj.userphno = userphno;         signupvalueobj.useremail = useremail;         signupvalueobj.userpass = userpass;         signupvalueobj.userconfirmpass = userconfirmpass;          signupobj.signuparray.push(signupvalueobj);          $http({             url : 'data/form.php',             method : 'post',             data: {                 'username': username,                 'userphno': userphno,                 'useremail': useremail,                 'userpass': userpass,                 'userconfirmpass': userconfirmpass,             },         }).success(function(data, status, headers, config){             alert(username);             signupobj.fetchdatatoserverfn();         }).error(function(){             alert('no insert')         });      }      function getsignupformfn(){         return signupobj.signuparray;     }  function fetchdatatoserverfn(){      var defer = $q.defer();      $http({         url : 'data/fetchformdata.php',         method : 'get',     }).success(function(data){         signupobj.fetchformdata = data;         defer.resolve(data);     }).error(function(){         defer.reject('data can\'t retained');     });     return defer.promise; }    function loginaddressfn(country,city,state,pincode,address,useremail){     var defer = $q.defer();     $http({         url : 'data/updateform.php',         method : 'put',         data :{             'useremail' : useremail,             'country' : country,             'city' : city,             'state' : state,             'pincode' : pincode,             'address' : address         }     }).success(function(data){         defer.resolve(data);         console.log('data: '+data);     }).error(function(){         defer.reject('data can\'t retrieved');     });     return defer.promise; } return signupobj; }]); 

php code:

<?php  $connect = mysqli_connect('localhost','root','','signup_form'); $data = json_decode( file_get_contents('php://input') );  $email = mysqli_real_escape_string($connect, $data->useremail); $country = mysqli_real_escape_string($connect, $data->country); $state = mysqli_real_escape_string($connect, $data->state); $city = mysqli_real_escape_string($connect, $data->city); $pincode = mysqli_real_escape_string($connect, $data->pincode); $address = mysqli_real_escape_string($connect, $data->address);  $abc = "update user_table set (country = '".$country."', state = '".$state."', city = '".$city."', pincode = '".$pincode."', fulladdress = '".$address."') email ='".$email."'";  mysqli_query($connect, $abc);  if(mysqli_affected_rows($connect) > 0){     echo "<span style='display: block; padding: 10px 15px; color: #2e6a00; border: 2px solid #2e6a00;'>appointment updated</span>"; }else{     echo "<span style='display: block; padding: 10px 15px; color: #d32f00; border: 2px solid #d32f00;'>appointment not updated</span>";     echo mysqli_error($connect); }  ?> 

thank in advance

$abc = "update user_table set (country = '".$country."', state = '".$state."', city = '".$city."', pincode = '".$pincode."', fulladdress = '".$address."') email ='".$email."'"; 

the bracket should not here, due problem occurring. correct code should be

$abc = "update user_table set country = '".$country."', state = '".$state."', city = '".$city."', pincode = '".$pincode."', fulladdress = '".$address."' email ='".$emailid."'";