PHP MySQL dropdown menu with DB's Tables

Question

So, I have the following code using PDO method to get all the tables from my DB.
But I need to put it inside a dropdown menu (the ideia it's to display all the records of the selected table so the user can export that records from the table that he selected to an .csv file)
Can anyone help me please?

$pdo = Database::connect();
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$query = $pdo->prepare('Show Tables from filecleaner');
$query->execute();

while($rows = $query->fetch(PDO::FETCH_ASSOC)){
     var_dump($rows);
}

but this will show u only tables Show Tables from filecleaner all tables. ??? — devpro
– devpro, Commented Mar 18, 2019 at 14:57
@formador3 if you can provide the results of your var_dump we could easy help u — Masivuye Cokile
– Masivuye Cokile, Commented Mar 18, 2019 at 15:17

devpro · Accepted Answer · 2019-03-18 15:20:56Z

1

You can display all tables name from filecleaner in a select box like

$allTables = array(); // initialize your array
while($rows = $query->fetch(PDO::FETCH_BOTH)){ 
    $allTables[] = $rows[0]; // store all table name in an array. $rows[0] index will give you table name from filecleaner
}

then, display like:

<select>
    <option>Select Table</option>
    <?php
    foreach ($allTables as $key => $value) {
    ?>
        <option><?=$value?></option>
    <?php
    }
    ?>
</select>

Edit:

i think you are not getting $rows[0] due to FETCH_ASSOC, you need to use FETCH_BOTH here to get 0 indexed column number.

Issue in your code is: FETCH_ASSOC returns an array indexed by column name, and you are trying to display with 0 indexed column number.

Reference

edited Mar 18, 2019 at 15:20

answered Mar 18, 2019 at 15:13

devpro

16.1k3 gold badges29 silver badges39 bronze badges

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

3 Comments

formador3 Over a year ago

It displays an empty select and the error Undefined offset: 0 x.x

devpro Over a year ago

@formador3: glad to help u, actually i run a test script with my database, and get the idea, what actually happening. :)

formador3 Over a year ago

I should take some time to really learn about all the syntax and debugging hahaha, Thanks ! :)

Collectives™ on Stack Overflow

PHP MySQL dropdown menu with DB's Tables

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related