How to add one specific row to an array in PHP, after the array gets populated from a PDO query?

Question

My code creates an array like this

$stmt = $pdo->prepare("SELECT uniqueid, firstname, lastname, email, notify FROM information WHERE userid = ? AND notify = 'yes'");
    $stmt->execute([$userid]);
    foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
        //get emails
        $notifyemailsarray[$row['email']]=$row;
    }

After that query runs (or possibly even before it runs), I would like to add one specific set of data to that array, but only email, firstname and lastname. So I tried this...

$specificemail="[email protected]";
$specificfirstname="Bob";
$specificlastname="Jones";

    $notifyemailsarray[$specificemail] = array('firstname' => $specificfirstname, 'lastname' => $specificlastname);

But when I print_r that array afterwards, I don't see the "specific" info that I added separately. I do see the data that was populated from the PDO query, just not the "specific" stuff. What am I doing wrong?

That should work, so there's most likely some code here we're not seeing. Can you show the full code concerning this, and in what order it comes? Does the email [email protected] appear in the database too, perhaps? — Qirel
– Qirel, Commented Aug 8, 2017 at 16:45
Nothing wrong with what you are doing. Only issues would be A) the email already exists and so you are just overwriting an existing email, not adding one to the end. B) you are not including the email in the array (not really an issue if you don't need it, but it is in the original data you are building the array with). Or C) shot in the dark, but possibly a scope or reference issue. e.g. adding that last row inside of a function, but building the original array outside the function. Inside the function would only have a copy of the original data so changes won't affect outside the function. — Jonathan Kuhn
– Jonathan Kuhn, Commented Aug 8, 2017 at 16:49
@Jonathan Kuhn It was scenario A :(. I didn't realize the "specific" email I was adding was already in the database and already a part of the array, my apologies. But thanks for saying that and leading me to find it. — user3304303
– user3304303, Commented Aug 8, 2017 at 17:18

Jonathan Kuhn · Accepted Answer · 2017-08-08 18:02:11Z

1

Nothing wrong with what you are doing. Only issues would be:

The email already exists and so you are just overwriting an existing email, not adding one to the end.
You are not including the email in the array (not really an issue if you don't need it, but it is in the original data you are building the array with).
Shot in the dark, but possibly a scope or reference issue. e.g. adding that last row inside of a function, but building the original array outside the function. Inside the function would only have a copy of the original data so changes won't affect outside the function.

answered Aug 8, 2017 at 18:02

Jonathan Kuhn

15.3k3 gold badges34 silver badges43 bronze badges

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

Collectives™ on Stack Overflow

How to add one specific row to an array in PHP, after the array gets populated from a PDO query?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related