Adding to the same array with two different foreach loops PHP/SQL

Question

I have seperate tables full of data and I require the same data from each table. For example the first table I am selecting from has the value 3623 and the second table has the value 3852.

I am trying to get both of these values into an array to then be plotted on a graph later down the line. The code I am using can be seen below, the issue is that on the value from the first foreach loop gets added and not the second one. so I end up with just 3623 and not the 3852 as well which is an issue.

$datay1 = array();
$yes = "not-set";
$sql = "SELECT * FROM `0530-0605` WHERE SearchTerm = :yes";
$stmt = $conn->prepare($sql);
$stmt->bindParam(":yes", $yes);
$stmt->execute();
foreach($stmt as $row) {
    $datay1[] = $row['Clicks'];
}

$sql = "SELECT * FROM `0606-0612` WHERE SearchTerm = :yes";
$stmt = $conn->prepare($sql);
$stmt->bindParam(":yes", $yes);
$stmt->execute();
foreach($stmt as $row) {
    $datay1[] = $row['Clicks'];
}

print_r($datay1);

This two queries doing the same why u cant use it in one query ? — rad11
– rad11, Commented Jul 11, 2016 at 10:24
Because I am querying two tables, and this will increase to hundrededs over time — Lewis Smith
– Lewis Smith, Commented Jul 11, 2016 at 10:24

Saty · Accepted Answer · 2016-07-11 10:27:26Z

1

You can use UNION ALL to merge result of two query as

$sql = "SELECT * FROM `0530-0605` WHERE SearchTerm = :yes
UNION ALL
SELECT * FROM `0606-0612` WHERE SearchTerm = :yes1";

$stmt = $conn->prepare($sql);
$stmt->bindParam(":yes", $yes);
$stmt->bindParam(":yes1", $yes);
$stmt->execute();
foreach($stmt as $row) {
    $datay1[] = $row['Clicks'];
}

answered Jul 11, 2016 at 10:27

Saty

22.5k7 gold badges35 silver badges52 bronze badges

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

3 Comments

Lewis Smith Over a year ago

Still doesn't work, only getting one of the two values

Saty Over a year ago

Is not-set is present in second table column value??

Lewis Smith Over a year ago

My error, database not re-written correctly, works now, thanks!

Collectives™ on Stack Overflow

Adding to the same array with two different foreach loops PHP/SQL

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related