array_chunk

E_Rider · May 10, 2014

Hi,

I am trying to split an array with array_chunk and having no luck.

I can call the array, display the array, but not as two or more just not working as I understand it .

I am pulling the array from MYSQL and have used count() to count arrays to debug this problem but get strange results.

mysqli_query returns a value of one as expected, and this is where things get strange as mysqli_fetch_array variable counts as two before I even change or try to chunk, and chunk always returns two and will echo the whole array not chunks $array[0] echos but $array[1] is null.

I am either trying to do something that cannot be done or my understanding is wrong. I have read the documentation over and over and anything else I could find with no luck.

Any help would be appreciated.

Ch0cu3r · May 10, 2014

mysqli_query returns a value of one as expected

mysql_query returns a result set

nd this is where things get strange as mysqli_fetch_array variable counts as two

the mysql_fetch_* functions is used to get the next row from the result set, eg the first time it is called the first row is returned from the results, the second call will return the second row and so on.

I'm confused where you're using array_chunk. Can you post your code and the output you are trying to achieve

Edited May 10, 2014 by Ch0cu3r

E_Rider · May 10, 2014

I have cut this down and get each row but no new keys.

if  (!$result=mysqli_query($con,$sql))
{
die('Could not get data: ' . mysqli_error($sql));
}



echo "result_count".count($result)."<br/>";
while( $row=mysqli_fetch_array($result) ) 
{ 
echo "row_count".count($row)."<br/>";
   $rowt = array_chunk( $row, 1); 
	
    print_r($rowt);
		echo "rowt_count".count($rowt)."<br/>";
		echo "<br/><br/>";
}

and this is output

and is expected but with new keys and less base arrays for lack of a better term.

E_Rider · May 10, 2014

Is the fact that the $result is a multidimensional array causing this. I tested the base code from php.net and I am getting it to work.

$input_array = array('a', 'b', 'c', 'd', 'e');
print_r(array_chunk($input_array, 1));
print_r(array_chunk($input_array, 2, true));

Ch0cu3r · May 10, 2014

mysqli_fetch_array returns an numerically indexed and associative indexed array for each field returned from your query. Because you are using array chunk it is removing the associative keys from the associative array. if you set the 3rd argument for array_chunk to true the keys will be preserved.

What I do not understand is why you are using array_chunk? if you dont want your data to be listed in different arrays then use either mysqli_fetch_row or mysqli_fetch_assoc

E_Rider · May 10, 2014

I am begining to see this and what I am trying to do is insert a delimiter in the middle of the mysqli_fech_array($result) so I can split it between two sections of a page. ie: split the $result so it can be called like $result[0] and $result[1]. I am hesitant to sat it cannot be done , but see I am doing it the wrong way.

E_Rider · May 10, 2014

I see why I was getting double arrays from the fetch and according to 3schools , wich I know to be wrong at times, fetch calls an associative array. Got to stop relying on 3schools to be correct and read the right manual.

E_Rider · May 10, 2014

Thanks for the help the final solution seems to be mysqli_fetch_all($result , MYSQLI_ASSOC) "is the type". I have not tested this fully yet but the print_r call seems fine.

Sign In

array_chunk

Recommended Posts

E_Rider

Link to comment

Share on other sites

Ch0cu3r

Link to comment

Share on other sites

E_Rider

Link to comment

Share on other sites

E_Rider

Link to comment

Share on other sites

Ch0cu3r

Link to comment

Share on other sites

E_Rider

Link to comment

Share on other sites

E_Rider

Link to comment

Share on other sites

E_Rider

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information