how to create matrix in PHP with data from mysql?

Question

I have this table in mysql, table "distance":

  id  | distance |          
  1   |    8     |  
  2   |    5     |    
  3   |    7     |

I want output such as:

8    5   7
8    5   7
8    5   7

How do I code it in php? Thanks, I'm a newbie in PHP.

2

you just echo the distance 3 times – Mar 28 '15 at 03:56

ashkufaraz · Accepted Answer · 2015-03-28T04:22:09.700

0

try like this

$tableRows[0]=array("id"=>1,"distance"=>8);
$tableRows[1]=array("id"=>2,"distance"=>5);
$tableRows[2]=array("id"=>3,"distance"=>7);
$counter=0;
foreach($tableRows as $tableRow)
{
    foreach($tableRows as $tableRow)
    {
        echo $tableRow["distance"]."\t";
    }
    echo "\n";
}

Online demo

edited Mar 28 '15 at 04:22

answered Mar 28 '15 at 04:14

ashkufaraz

5,179
6
51
82

your well come,you can accept this answer if it is correct ;} – ashkufaraz Mar 28 '15 at 07:56
mr. ashkufaraz can you help me again. I found problem again. – user4716022 Mar 31 '15 at 03:57
I have a question and I alrady post in stackoverflow. this is my link : http://stackoverflow.com/questions/29329040/how-to-create-dynamic-matrix-in-php/. But, I not found answer for my question. Please help me – user4716022 Mar 31 '15 at 04:04
thank's for respond mr.ashkufaraz. I am sorry. How combine your code with my code using for. And How to connect your code with database mysql? hee.. :) – user4716022 Mar 31 '15 at 06:24
I've compile/run this code ,. end result become array : 1 2 3 1 0 8 6 2 8 0 9 3 6 9 0 . – user4716022 Mar 31 '15 at 06:33
this is correct?instead `$tableRow` use $citry from database – ashkufaraz Mar 31 '15 at 07:03
no, this is sir. I want end result in matrix, this result in array. :) – user4716022 Mar 31 '15 at 07:06
so use this `$from = $cityDist['id_city_a']; $to = $cityDist['id_city_b']; $dist = $cityDist['distance']; $distMatrix[$from][$to] = $dist;` – ashkufaraz Mar 31 '15 at 07:07
Iam sory,.. I can't data above connect to mysql. it's difficult, I am newbie in php – user4716022 Mar 31 '15 at 08:05

how to create matrix in PHP with data from mysql?

1 Answers1