How to pull in an array to a PHP MySQL output?

Question

I am trying to pull in this date for each part of my database, but I am missing some element to make it work and not sure what I am missing?

 $modified[] = array(date("m/d/y", strtotime($row[audit_modify_date]))."<br />".date("g:i a", strtotime($row[audit_modify_date])),);

//query
 for ($i=0; $i < count($result); $i++) {
        echo "<tr>";
            echo "<td>$modified</td>";
        echo"<tr>";
 }

They output just says Array.

why are you using an array anyways? that looks like you're generating a single string anyways, which can go into $modified directly, not need to be turned into a single element array. — Marc B
– Marc B, Commented Jun 9, 2016 at 21:06
It gets pulled many times for multiple rows, But what would be a better way then? — DDJ
– DDJ, Commented Jun 9, 2016 at 21:23
doesn't matter. why have a double array in the first place? for(...) { $modified = date(...strtotime(...)); echo " blah blah $modified "; } no need for an array at all. — Marc B
– Marc B, Commented Jun 9, 2016 at 21:44

Tyler Sebastian · Accepted Answer · 2016-06-09 21:05:10Z

1

You are printing the array, not the elements in the array

echo "<td>$modified</td>";

either

for ($i=0; $i < count($result); $i++) {
    echo "<tr>";
    echo "<td>".$modified[$i]."</td>";
    echo"<tr>";
}

or

foreach ($modified as $m) {
    echo $m;
}

edit actually what? I don't understand what you're doing

answered Jun 9, 2016 at 21:05

Tyler Sebastian

9,5887 gold badges42 silver badges64 bronze badges

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

4 Comments

DDJ Over a year ago

It still says array, and I know you are right. Must be some other little thing

Tyler Sebastian Over a year ago

are you sure you don't mean $modified = ... instead of $modified[] = ...?

georaldc Over a year ago

@SDJ it's because you are putting another array inside your $modified array.

DDJ Over a year ago

I was because of the 1st modified[], should have been without the [] brackets

Ravinder Reddy · Accepted Answer · 2016-06-09 21:27:19Z

1

Since you are using $modified[ ] = array(....), it becomes multidimensional array. Use below code

for ($i=0; $i < count($result); $i++) {
    echo "<tr>";
        echo "<td>$modified[0][$i]</td>";
    echo"<tr>";
}

Or just

echo "<td>$modified[0][0]</td>";

Other thing is instead of creating a array, make it a variable like shown below

$modified=date("m/d/y", strtotime($row[audit_modify_date]))."<br />".date("g:i a", strtotime($row[audit_modify_date]));

//query
   for ($i=0; $i < count($result); $i++) {
    echo "<tr>";
        echo "<td>$modified</td>";
    echo"<tr>";
 }

Note: use the appropriate according to your requirement.

edited Jun 9, 2016 at 21:27

answered Jun 9, 2016 at 21:22

Ravinder Reddy

3,8791 gold badge16 silver badges24 bronze badges

1 Comment

DDJ Over a year ago

Great idea! This code keeps looking better. Thanks!

Collectives™ on Stack Overflow

How to pull in an array to a PHP MySQL output?

2 Answers 2

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related