Z1Zbill Z1Zbill - 3 months ago 5
PHP Question

PHP/SQL array access error

I'm trying to make a new column with results from an SQL query in PHP:

$someArray= array(array('match'=>'123'), array('match'=>'456'), array('match'=>'789')); //arbitrary number of elements
foreach($someArray as $key=>$item){
$someArraysDouble[]=$item;
}
$someQuery="select count(*) as somecount from sometable";
$probe1=array();
$probe2="0";
$probe3="0";
$probe4="0";
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";//myDB uses MySQL
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
foreach($someArray as $key=>$item) {
$someQuery.=" where somecolumn like "%$item['match']%";
$blahblah=$conn->query($someQuery);
if ($blahblah->num_rows > 0) {
while($row = $result->fetch_assoc()) {
$row['match']=$item['match'];
$probe1[]=$row;
}
}
$conn->close();
}
foreach($someArraysDouble as $key1=>$item1) {
foreach($probe1 as $key2=>$item2) {
if($item2['match']==$item1['match']) {
$probe2=$item1['somecount'];
$probe3=$item2['somecount'];
$item1['somecount']=$item2['somecount'];
$probe4=$item1['somecount'];
}
}
}


The output HTML looks like this:

<html>
<head></head>
<body>
{$probe2}<br>{$probe3}<br>{$probe4}<br><br>
{loop $probe1 $key1 $item1}
{$item1['somecount']}<br><br>
{/loop}
<br><br>
{loop $someArraysDouble $key2 $item2}
{$item2['somecount']}<br><br>
{/loop}
</body>
</html>


Result is... something I don't understand:

-
$probe2
is null, which is expected.

-
$probe3
is the count value for last element, which is expected.

-
$probe4
is the count value for last element, which is expected.

- The first
loop
with
$probe1
produces the count value for each element, which is expected.

- The second
loop
with
$someArraysDouble
produces nothing, which is NOT expected. HOW can this happen?

For some reason that I'm not sharing in order to keep this question concise, I need to have the count value for each element outputted via
$someArraysDouble
.

Answer

Turns out it was me not understanding how foreach in PHP works.

function array_generate(){
return array(array('match'=>'123'), array('match'=>'456'), array('match'=>'789')); //arbitrary number of elements
}
$someArray=array_generate();
var_dump($someArray);
foreach($someArray as $heavy=>$load)
{
    $load['addedvalue']="newvalue";
    $test1[$heavy]="newvalue";
    $test2[$heavy]=$load['addedvalue'];
    var_dump($someArray);
}
var_dump($someArray);
var_dump($test2);

The n+2 var_dump($someArray)s (where n==count($someArray)) all show the same.

array(3) { [0]=> array(1) { ["match"]=> string(3) "123" } [1]=> array(1) { ["match"]=> string(3) "456" } [2]=> array(1) { ["match"]=> string(3) "789" } }

But var_dump($test2) shows:

array(3) { [0]=> string(8) "newvalue" [1]=> string(8) "newvalue" [2]=> string(8) "newvalue" }

This means the addedvalue of each element of $someArray does not persist once $key changes. So my solution is to use a new array, which is synced with the original array, length-wise.

Comments