How is dynamically created array in jquery is accessed in PHP

Question

I have created a script that adds items on click into an array.

$(document).ready(function()
    {
        var array_ids = [];
        $('.add').click(function()
        {
            array_ids.push($(this).parent().siblings('.row_id').html().trim());
            alert(array_ids);    
        });
    });

Items are coming from mysql database so I am storing primary keys of items. keys are stored in array like this manner

1,2,3,4,5

Now I want to access this array in php so that I could store in database one by one.

I thought to doing some ajax and this is my code

$('.show').click(function(e)
        {
            //e.preventDefault();

            $.ajax(
            {
               method: 'POST',
               url: 'createsale.php',
               data: {items: array_ids},
               success: function()
               {
                    alert('done'); 
               } 
            });
        });

I get the done alert but couldn't manage to get it stored in database. Can anyone tell how do I insert those items in mysql?

I couldn't think of how to get the sent array! I though $result = $array_id; would work but nope. — Alexis
– Alexis, Commented Oct 19, 2016 at 2:19
Data sent to php through GET/POST are stored in the super globals $_GET and $_POST — Patrick Evans
– Patrick Evans, Commented Oct 19, 2016 at 2:20
Do you already have the query / rows where the IDs are stored? — L. Herrera
– L. Herrera, Commented Oct 19, 2016 at 2:36
Yess! And When ever I click add an id gets stored in array! I do not know to access the array now — Alexis
– Alexis, Commented Oct 19, 2016 at 2:38

user3502626 · Accepted Answer · 2016-10-19 02:18:28Z

1

Send the value from Javascript by using Json {"key":value} or array [1,2,3]. While getting them to use them in PHP, you can use json_decode() to convert the Json or array from Javascript to PHP.

If you want your information from PHP to Javascript, Just use the funtion json_encode() that will send a json string.

Ref: json_encode, json_decode

answered Oct 19, 2016 at 2:18

user3502626

83813 silver badges36 bronze badges

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

2 Comments

Alexis Over a year ago

stackoverflow.com/questions/40121432/… please see this question

isawk Over a year ago

This answer is correct, json_encode, json_decode are the methods for deal with array/Jason data to and from php into JavaScript/HTML

Mamdouh Saeed · Accepted Answer · 2016-10-19 09:46:20Z

0

your createsale.php file should has something like this below code to receive array Data & dont forget to escape your data using mysql_real_escape_string before doing any mysql query

    <?php
          if(isset($_POST["items"]) && $_POST["items"] !=""){
            $arr = $_POST["items"];
            //convert JS array to PHP array
            $arr = json_decode($arr,true);
            //then you have your PHP array => new array(1,2,3,...);

            /*  use for/forEach loop
         for($i=0;$i<count($arr);$i++){
            do the task
         }
            */
        }
   ?>

answered Oct 19, 2016 at 9:46

Mamdouh Saeed

2,3231 gold badge12 silver badges11 bronze badges

Collectives™ on Stack Overflow

How is dynamically created array in jquery is accessed in PHP

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related