0

I'm new for AngularJS but it seems like I can't insert any data to my database. I have followed few instructions but seem likes it doesn't work. When I click on submit button, nothing happen and no data has inserted to my database. Please help.

Thanks a lot guys.

view2.html

    <div ng-app="register" >
      <form name="form1" ng-controller="registerInsert" align="center">
        <ul>
                    <li class="err" ng-repeat="error in errors"> {{ error}} </li>
                </ul>
                <ul>
                    <li class="info" ng-repeat="msg in msgs"> {{ msg}} </li>
                </ul>
        <div class="form-group col-md-6 col-xs-12 col-md-offset-3" >
        <label for="InputName" ><h1>Please fill your informations</h1></label>
          <input type="text" class="form-control" ng-model="fName"  placeholder="Firstname" >
        </div>
        <div class="form-group col-md-6 col-xs-12 col-md-offset-3">
          <input type="text" class="form-control" ng-model="lName"  placeholder="Lastname" >
        </div>
        <div class="form-group col-md-6 col-xs-12 col-md-offset-3">
          <input type="text" class="form-control"  ng-model="eMail"  placeholder="E-Mail" >
        </div>
        <div class="form-group col-md-6 col-xs-12 col-md-offset-3">
          <input type="text" class="form-control" ng-model="userName"  placeholder="Username" >
        </div><div class="form-group col-md-6 col-xs-12 col-md-offset-3">
          <input type="password" class="form-control" ng-model="passWord"  placeholder="Password" >
        </div>
        <div class="form-group col-md-6 col-xs-12 col-md-offset-3">
          <input type="text" class="form-control" ng-model="tel"  placeholder="Telephone Number" >
        </div>

        <div class="form-group col-md-6 col-xs-12 col-md-offset-3">
        <button  ng-click='SignUp();' class="btn btn-default" >Submit</button>
</div>
      </form>
</div>        

      <script type="text/javascript">
            function registerInsert($scope, $http) {
                $scope.errors = [];
                $scope.msgs = [];

                $scope.SignUp = function() {

                    $scope.errors.splice(0, $scope.errors.length); // remove all error messages
                    $scope.msgs.splice(0, $scope.msgs.length);

                    $http.post('save_register.php', {'fName':$scope.fName,'lName':$scope.lName,'eMail':$scope.eMail,
  'userName':$scope.userName,'passWord':$scope.passWord,'tel':$scope.tel}
                    ).success(function(data, status, headers, config) {
                        if (data.msg != '')
                        {
                            $scope.msgs.push(data.msg);
                        }
                        else
                        {
                            $scope.errors.push(data.error);
                        }
                    }).error(function(data, status) { // called asynchronously if an error occurs
// or server returns response with an error status.
                        $scope.errors.push(status);
                    });
                }
            }
        </script>


  save_register.php

    <?php
$data = json_decode(file_get_contents("php://input"));

$userName = mysqli_real_escape_string($con,$data->userName);
$passWord = mysqli_real_escape_string($con,$data->passWord);
$fName = mysqli_real_escape_string($con,$data->fName);
$lName = mysqli_real_escape_string($con,$data->lName);
$eMail = mysqli_real_escape_string($con,$data->eMail);
 $tel = mysqli_real_escape_string($con,$data->tel);
$accountStat = mysqli_real_escape_string($con,$data->accountStat);
$verifyCode = mysqli_real_escape_string($con,$data->verifyCode );
$verifyStat = mysqli_real_escape_string($con,$data->verifyStat);

$con = mysql_connect('localhost', 'root', '');
mysql_select_db('MiddleWork', $con);

$qry_em = 'select count(*) as cnt from UserTest where Username ="' . $userName . '"';
$qry_res = mysql_query($qry_em);
$res = mysql_fetch_assoc($qry_res);

if ($res['cnt'] == 0) {
    $qry = 'INSERT INTO UserTest (Username,Password,Firstname,Lastname,Email,Tel) 
    values ("' . $userName . '","' . $passWord . '","' . $fName . '""' . $lName . '","' . $eMail . '","' . $tel . '")';
    $qry_res = mysql_query($qry);
    if ($qry_res) {
        $arr = array('msg' => "User Created Successfully!!!", 'error' => '');
        $jsn = json_encode($arr);
        print_r($jsn);
    } else {
        $arr = array('msg' => "", 'error' => 'Error In inserting record');
        $jsn = json_encode($arr);
        print_r($jsn);
    }
} else {
    $arr = array('msg' => "", 'error' => 'User Already exists with same email');
    $jsn = json_encode($arr);
    print_r($jsn);
}

1 Answer 1

2

Turn on error reporting or take a look at server log. You are obviously missing a comma in INSERT statement between fName and lName.

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

6 Comments

oh thanks I didn't see that comma mistake I putted it but still nothing anything happen. In my terminal its seems like website can't call php file. Did I do anything wrong ?
Take a look at the log or add this to your PHP: ini_set('display_errors', 'On'); error_reporting(-1);
I got a message angular.js:13920 Error: [ng:areq] Argument 'registerInsert' is not a function, got undefined errors.angularjs.org/1.5.8/ng/… at localhost:8000/bower_components/angular/angular.js:68:12 at assertArg
Then it's a JS issue. You're probably calling registerInsert() somewhere it is not defined (yet).
didn't it defined in <script> tag ? sir? im so sorry about dumb question but its dark everyway :(
|

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.