Cannot put string into array in PHP

Question

I try to put a string to $qDateTime and print it out. I expect the result is Array ( [0] => 2013-12-16 08:38:33 [1] => 2013-12-16 08:44:58 ). But it print Array ( [0] => 2013 [1] => 2013 ). And the $temp can print out correctly like 2013-12-16 08:38:332013-12-16 08:44:58.

    $qDateTime = array();

    $query = "SELECT joinDateTime FROM queueItem WHERE uid = '".$uid."' AND isValid = true;";
    $result = mysql_query($query) or die("Fail");
    while($array = mysql_fetch_array($result)){
        $temp = $array['joinDateTime'];
        $qDateTime[] += $temp;
        echo $temp;

    }
    print_r($qDateTime);

Correct syntax for pushing into array is $qDateTime[] = $temp; — sybear
– sybear, Commented Dec 16, 2013 at 16:12

andrewsi · Accepted Answer · 2013-12-16 16:12:30Z

3

    $temp = $array['joinDateTime'];
    $qDateTime[] += $temp;
    echo $temp;

You're assigning data to the array wrongly:

    $qDateTime[] += $temp;

Should be:

    $qDateTime[] = $temp;

Because you're using += in your code, PHP is converting the date string to an integer, and using that for the result; so your 2013-12-16 08:38:332013-12-16 is becoming just 2013.

answered Dec 16, 2013 at 16:12

andrewsi

10.7k132 gold badges37 silver badges52 bronze badges

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

Comments

Krish R · Accepted Answer · 2013-12-16 16:13:11Z

0

You should use $qDateTime[] = $temp; instead of $qDateTime[] += $temp;

    while($array = mysql_fetch_array($result)){
        $temp = $array['joinDateTime'];
        $qDateTime[] = $temp;
        echo $temp;

    }

    var_dump($qDateTime);

answered Dec 16, 2013 at 16:13

Krish R

22.7k7 gold badges54 silver badges60 bronze badges

Comments

dev1234 · Accepted Answer · 2013-12-16 16:40:03Z

0

The way of data assignment to array is incorrect. it should be,

$qDateTime[] = $temp; instead of $qDateTime[] += $temp;

print_r($qDateTime);

So the correct code must be,

  $qDateTime = array();

    $query = "SELECT joinDateTime FROM queueItem WHERE uid = '".$uid."' AND isValid = true;";
    $result = mysql_query($query) or die("Fail");
    while($array = mysql_fetch_array($result)){
        $temp = $array['joinDateTime'];
        $qDateTime[] = $temp;
        echo $temp;

    }
    print_r($qDateTime);

answered Dec 16, 2013 at 16:40

dev1234

5,75617 gold badges62 silver badges118 bronze badges

Collectives™ on Stack Overflow

Cannot put string into array in PHP

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related