Issue handling array JQuery to PHP/MySQL

Question

I am getting no response with the following, i am trying to split the array into blocks of 7 values. Although this is not responding whatsoever. I have verified this against the reference: http://www.php.net/manual/en/function.array-chunk.php however cannot get it working. Any advice?

$array = $_POST['myarray'];
$chunked = array_chunk($array, 7);

    foreach ( $chunked as $row ) {
        foreach ( $row as $value ) {
           echo $value;
        }
        echo "\r\n" ;       

}else{

}

You must show how you are sending the array to the server and how you are trying to insert it into MySQL. — Bradley Trager
– Bradley Trager, Commented Apr 29, 2014 at 14:12
@BradleyTrager Edited the question to show the ajax sending the array to the php. The array reaches the php, and i can echo the array showing all values in the entire array. The issue is i need to somehow split the values to the 7 value blocks. And then each block needs to insert to a row of the mysql. — Derple
– Derple, Commented Apr 29, 2014 at 14:15
Aren't you splitting the array up in your foreach loop? You can do the inserts to the database there if you need to. — Jay Blanchard
– Jay Blanchard, Commented Apr 29, 2014 at 14:20
Thats what i thought, however all the values are in one chunk. I need the first 7 values to be respective to one row in the mysql, then the next 7 to the next row etc. Currently, the foreach will place values in the table respective of only one row. @JayBlanchard — Derple
– Derple, Commented Apr 29, 2014 at 14:28

Jay Blanchard · Accepted Answer · 2014-04-29 15:28:05Z

1

If all you need to do is insert every 7 items from the array into the table then use array_chunk to divide up the array -

$array = $_POST['myarray'];
$chunked = array_chunk($array, 7);

Then you loop through $chunked and do your database inserts in that loop.

http://www.php.net/manual/en/function.array-chunk.php

EDIT: Here is a demo of how to loop through each chunk and get the values -

for($i = 0; $i < count($chunked); $i++) {
    foreach($chunked[$i] as $value) {
        echo $value;
    }
}

It's too bad that PHP Fiddle is down at the moment, it would be easier to show you.

edited Apr 29, 2014 at 15:28

answered Apr 29, 2014 at 14:41

Jay Blanchard

34.5k17 gold badges82 silver badges130 bronze badges

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

9 Comments

Derple Over a year ago

I have edited the question as this is indeed what im trying to achieve but even using the reference and attempting this, it does not work for me. Any advice?

Jay Blanchard Over a year ago

What is not working? Is it not outputting the array like you expect?

Derple Over a year ago

its actually not working, as in php page is failing. I am expecting an alert, of which is not occuring due to an error in th php page.

Jay Blanchard Over a year ago

Let me try something on my local server. In the mean time check your server error logs to see what the failure is, or turn on all error reporting options.

Derple Over a year ago

ok, have managed to get the values returning with another foreach finally! thankyou so much for your patience.

|

Collectives™ on Stack Overflow

Issue handling array JQuery to PHP/MySQL

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related