Loop problem...in prepared statement

PHP
1

I am using this loop to bring more than one row from a table:

  while ($stmt->fetch()) {
      $holidays[]= ['holid_date'=>$holid_date,'holid_name'=>$name];
    }

the problem with the above is that it creates a multi-dimensional array…the key names represent table cols.
Can the multidimensional array be avoided…is it possible?By altering the syntax.

2

What is it that you are trying to achieve?
Do you want an associative array where the results represent key/value?

Like this?:

while ($stmt->fetch()) {
    $holidays[$holid_date] = $name;
}

{Disclaimer: it has been years since I have actually written PHP code. This is ‘from memory’}

3

this is less a question whether it is possible, but what you want the final array to look like.

4

I just want it to look like a non-multidimensional/associative array…parkinT 's code is the solution…I just want to do something more before closing the topic

5

in PDO you’d use the PDO::FETCH_KEY_PAIR option for that. which reduces the code to

$holiddays = $stmt->fetchAll(PDO::FETCH_KEY_PAIR);

(note that this is a PDO-only solution, it won’t work with MySQLi!)

6

That is great to hear.
Thanks for making an old man feel good. As I said, it has been quite a long time since I did anything serious with PHP. My memory is not quite as bad as I thought!

7

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.