AngularJS and PHP entering blank rows in database

Question

I'm trying to figure out why my data is not being collected by my PHP files. This is my index.html

<!DOCTYPE html>
<html lang="en" ng-app="gemStore">
<head>
    <meta http-equiv='Content-Type':'application/x-www-form-urlencoded; charset=UTF-8' />
    <title>Angular</title>
    <link rel="stylesheet" href="css/bootstrap.min.css">
    <link rel="stylesheet" href="css/style.css">
</head>
<body>
<div ng-controller="custController">
        <form>
            First Name: <input type="text" ng-model="firstname"><br>
            Last Name: <input type="text" ng-model="lastname"><br>
            Choose Username: <input type="text" ng-model="username"><br>
            Choose Password: <input type="text" ng-model="password"><br>
            Address 1: <input type="text" ng-model="address1"><br>
            Address 2: <input type="text" ng-model="address2"><br>
            City: <input type="text" ng-model="city"><br>
            State: <input type="text" ng-model="state"><br>
            Zip: <input type="number" ng-model="zip"><br>
            <input type="button" value="Submit" ng-click="insertdata()"><br>
        </form>
    </div>

    <script src="js/angular.min.js"></script>
    <script src="js/script.js"></script>
    <script src="js/products.js"></script>
</body>
</html>

This is my script.js

(function(){
    var app = angular.module('gemStore', ['store-products']);
    app.controller('StoreController', ['$http', function($http){
        var store = this;
        store.products = [];
        $http.get('/store-products.json').success(function(data){
            store.products = data;
        });
    }]);

    app.controller('custController', function($scope,$http){
        $scope.insertdata = function(){
            $http.post('insert.php',{'firstname':$scope.firstname,'lastname':$scope.lastname,'address1':$scope.address1,'address2':$scope.address2, 'city':$scope.city,'state':$scope.state,'zip':$scope.zip,'username':$scope.username,'password':$scope.password})
            .success(function(data,status,headers,config){
                console.log('data inserted successfully. First Name: ' + $scope.firstname);
            });
        }
    });
})();

And finally my PHP file

<?php

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

    $firstname = mysql_real_escape_string($data->firstname);
    $lastname = mysql_real_escape_string($data->lastname);
    $username = mysql_real_escape_string($data->username);
    $address1 = mysql_real_escape_string($data->address1);
    $address2 = mysql_real_escape_string($data->address2);
    $city = mysql_real_escape_string($data->city);
    $state = mysql_real_escape_string($data->state);
    $zip = mysql_real_escape_string($data->zip);
    $password = mysql_real_escape_string($data->password);

    mysql_connect("localhost","root","");
    mysql_select_db("mydatabase");
    mysql_query("INSERT INTO users (`firstname`, `lastname`, `username`, `password`, `address1`, `address2`, `city`, `state`, `zip`)VALUES('" . $firstname . "','" . $lastname . "','" . $username . "','" . $password . "','" . $address1 . "','" . $address2 . "','" . $city . "','" . $state . "','" . $zip . "')");

?>

I am thinking it has something to do with headers, but I'm not sure where I should add it or what needs to be changed. Any help would be appreciated. Thanks.

Also, I am using angular 1.3.16, but I doubt that makes a difference.

well data are not inserted to db? which erros you have in php log or mysql log? — venca
– venca, Commented Jun 11, 2015 at 5:29
There are no errors in my console, it actually says it succeeded. It creates a new row in the DB, just blank information. It returns the console.log correctly from the custController with the $scope.firstname that was entered — Kyle
– Kyle, Commented Jun 11, 2015 at 5:41
i didnt ask on your console, but on php log. and i suppose you have in development error_reporting(E_ALL);. btw. mysql is deprecated. move to pdo or mysqli — venca
– venca, Commented Jun 11, 2015 at 5:44
PHP Warning: mysql_real_escape_string() [<a href='function.mysql-real-escape-string'>function.mysql-real-escape-string</a>]: Access denied for user 'root'@'localhost' (using password: NO) is the PHP error Im getting — Kyle
– Kyle, Commented Jun 11, 2015 at 5:56

Nisarg Pujara · Accepted Answer · 2015-06-11 05:33:28Z

1

try this in your insertdata function.

$scope.insertdata = function(){

var data = {'firstname':$scope.firstname,'lastname':$scope.lastname,'address1':$scope.address1,'address2':$scope.address2, 'city':$scope.city,'state':$scope.state,'zip':$scope.zip,'username':$scope.username,'password':$scope.password};
    $http({
             url:'insert.php', 
             method: 'post',
             headers: {'Content-Type': 'application/x-www-form-urlencoded'},
             transformRequest: function(obj) {
                    var str = [];
                    for(var p in obj)
                    str.push(encodeURIComponent(p) + "=" + encodeURIComponent(obj[p]));
                    return str.join("&");
               },
             data :data
            }).success(function(data,status,headers,config){
            console.log('data inserted successfully. First Name: ' + $scope.firstname);
            });

}

answered Jun 11, 2015 at 5:33

Nisarg Pujara

431 gold badge1 silver badge10 bronze badges

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

1 Comment

Kyle Over a year ago

Still getting a blank row inserted when i substituted that in, thanks though

Collectives™ on Stack Overflow

AngularJS and PHP entering blank rows in database

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related