getting tables in database and store it in string

Question

I am using this code to show list of tables to the database i am connected to but I cant place them in a string. What i would like to happen is to get the list of tables from the database and store them in a string

$result = mysql_query("show tables"); // run the query and assign the result to $result

while($table = mysql_fetch_array($result)) { // go through each row that was returned in $result
    if ($table) {
        $aw = array();
        $count= 0;                              
        $aw[$count] = $table[0];
        echo $string = array($aw[$count]);

        $count++;
    }
}

score 0 · Answer 1 · edited May 23 '17 at 11:58

0

Why do you use echo $string = array($aw[$count]);.

In my opinion this should solve it too:

echo $string = $aw[$count];

As you commented you would like to have it in a CSV format, you can take a look at fputcsv for example if you want to put it to a file directly. Otherwise here is a function which produce a CSV string.

edited May 23 '17 at 11:58

Community

1
1

answered Jun 21 '15 at 14:13

Ionic

3,884
1
12
33

thanks but i would also like to make the data in a csv format – VicGomez Jun 21 '15 at 14:32
i cant quite understand how the function which produce a CSV string works could you please help me – VicGomez Jun 21 '15 at 14:55

getting tables in database and store it in string

1 Answers1