Passing Array to PHP using angularjs

Question

Warning : mysqli_real_escape_string() expects parameter 2 to be string, array given in C:\xampp\htdocs\nav\php\pinsert.php

I get the above error when I try to post array to php using http.post in angularjs. What is the code to send array to php and insert it into database.

app.js

     $scope.saveRecord = function (newProduct)
    {
      $scope.albumNameArray = []; 

    angular.forEach($scope.check, function(album){

            if (album.select)  $scope.albumNameArray.push(album.name);

        });

       $http.post("php/pinsert.php",{
                     'names' : $scope.newProduct.name,
                     'catg' : $scope.newProduct.catg,
                     'stat' : $scope.newProduct.stat,
                      'tag' : $scope.albumNameArray
              })

PHP

     <?php 


   $connect = mysqli_connect("localhost", "root", "","user");
   $data = json_decode(file_get_contents("php://input"));


  $p_name = mysqli_real_escape_string($connect, $data->names);
  $p_catg = mysqli_real_escape_string($connect, $data->catg);
  $status = mysqli_real_escape_string($connect, $data->stat);
  $tag = mysqli_real_escape_string($connect, $data->tag);
   $query = "INSERT INTO products(pname,pcatg,status,tag)  VALUES ('$p_name','$p_catg','$status','$tag')";

    $result = mysqli_query($connect, $query) ;

  if($result == TRUE) 
   {  
       echo "Data Inserted...";  
  }  
  else  
  {  
       echo 'Error';  
  }  

  ?>

The error says that you passing an array as second parameter to mysqli_real_escape_string() instead of a String. — Juan
– Juan, Commented May 26, 2017 at 10:22
tats my queestion.. what is the code to send array to php using angularjs — user8012497
– user8012497, Commented May 26, 2017 at 10:24
If you are passing an array to the function, it means that you received an array. That is why I thought you didn't understand the error message. — Juan
– Juan, Commented May 26, 2017 at 10:29

Manikandan Velayutham · Accepted Answer · 2017-05-26 10:40:21Z

0

try with json data.

var data = { 'names' : $scope.newProduct.name, 'catg' : $scope.newProduct.catg, 'stat' : $scope.newProduct.stat, 'tag' : $scope.albumNameArray };
 $http({ url: 'php/pinsert.php',
            method: "POST",
            data: JSON.stringify(data),
            headers: {'Content-Type': 'application/json'}
        }).then(function(reponse){
          })

edited May 26, 2017 at 10:40

answered May 26, 2017 at 10:35

Manikandan Velayutham

2,2281 gold badge17 silver badges22 bronze badges

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

Comments

Florin · Accepted Answer · 2018-10-23 12:08:47Z

0

I am using this way

$scope.myArray = [14742,  14744,  22781,  15540 ];

And $http request need to look like this: as you can see 'parameter[]' ... is array type. Else you need to JSOM.strignify(data) ... then json_decode in php.

$scope.saveSomething = function(){
        $http({
            method: 'post',
            url: '/some-url',
            params:{
                'parameter[]': $scope.myArray,
            }
        });
    };

answered Oct 23, 2018 at 12:08

Florin

6,2282 gold badges24 silver badges32 bronze badges

Collectives™ on Stack Overflow

Passing Array to PHP using angularjs

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related