printing array containing date php

Question

Not as simple as it sounds I believe, but I have the following and trying to print the month name from date provided.

public function convertEngDateToAr($engDate)
    {
        //SELECT MONTHNAME('2009-05-18');
        $connectionInstance = new ConnectionClass();
        $connection = $connectionInstance->connectToDatabase();
        $monthResult = $connection->query("SELECT MONTHNAME('$engDate')");
        //echo "Month: " . $monthResult;
        while($row = $monthResult->fetch_assoc())
        {
            print_r($row);
        }

    }

The above gets me this output:

Array ( [MONTHNAME('2012-08-21')] => August )

How can I get August alone out of the array and store it in variable? The only weird thing here is that the index in the array is just strange.

Thank

Fluffeh · Accepted Answer · 2012-08-09 11:20:44Z

3

Try changing SELECT MONTHNAME('$engDate')" to SELECT MONTHNAME('$engDate') as monthName"

Then you should see:

Array ( monthName => August )

Then you can use:

    while($row = $monthResult->fetch_assoc())
    {
        $myMonth=$row['monthName'];
    }

answered Aug 9, 2012 at 11:20

Fluffeh

33.6k16 gold badges69 silver badges80 bronze badges

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

Comments

Geoffrey · Accepted Answer · 2012-08-09 11:35:10Z

1

You can either use SELECT MONTHNAME(xxxx) AS monthName or you could return an indexed array instead of an associative one:

while($row = $monthResult->fetch_row())
  echo $row[0] . "\n";

edited Aug 9, 2012 at 11:35

answered Aug 9, 2012 at 11:24

Geoffrey

11.4k3 gold badges37 silver badges50 bronze badges

Collectives™ on Stack Overflow

printing array containing date php

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related