Get values from DBs with specific prefix - MySQL/PHP

Question

I have two tables from my DB which were retrieved with the following MYSQL SELECT statement:

SELECT table_schema AS database_name,
    table_name
FROM information_schema.tables
WHERE table_type = 'BASE TABLE'
    AND table_name LIKE 'cu%'
ORDER BY table_schema,
     table_name;

My goal is to get the values from these two tables and export them to HTML tables (one HTML table for each corresponding returned table) via PHP PDO. The tables have been returned but how can I access the rows?

Just to observe that this kind of thing is sometimes symptomatic of poor schema design — Strawberry
– Strawberry, Commented Jan 31, 2021 at 14:04
Thank you for your comment @strawberry, this let me rethink the design. — Dan
– Dan, Commented Jan 31, 2021 at 14:39

SAW Kk · Accepted Answer · 2021-01-31 14:33:26Z

1

First execute query in mysql if your query is producing your required output.

put the query in php code.

Use whileLoop to print number of rows in table. your Table html code should be ready.

put the proper column name from your schema in place of tableColumnOne,---Two,---Three. Code:

$result = mysqli_query($conn,"your query");
while($row = mysqli_fetch_assoc($result))
{
    echo '<tr><td>'.$row['tableColumnOne'].'</td>
            <td>'.$['tableColumnTwo'].'</td>
            <td>'.$['tableColumnThree'].'</td>
        </tr>';
}

answered Jan 31, 2021 at 14:33

SAW Kk

749 bronze badges

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

Collectives™ on Stack Overflow

Get values from DBs with specific prefix - MySQL/PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related