Loop mysql database names that starts with selected prefix in php

Question

How do i loop only the database names that starts with solarsystem inside a dropdown list.

+---------------------+
|       dbname        |
+---------------------+
| electronics         |
| vegetables          |
| solarsystem_sun     |
| solarsystem_mercury |
| solarsystem_venus   |
| solarsystem_mars    |
| fruits              |
| foobar              |
+---------------------+

Currently it is looping all the database names

<div class="select">
    <?php
        $sdbhost = 'localhost';
        $sdbusername = 'root';
        $sdbpassword = '';
        $dbcnx = mysql_connect ($sdbhost, $sdbusername, $sdbpassword);

        $dbresult = mysql_query("SHOW DATABASES");
            echo "<select name='dbselect'>";
                while ($dbrow = mysql_fetch_array($dbresult)) {
                    echo "<option input value='$dbrow[0]'>" .$dbrow[0]."<br></option>";
                }
            echo "<select>";
    ?>
</div>

Paul Spiegel · Accepted Answer · 2018-03-10 18:27:06Z

3

SHOW DATABASES WHERE `Database` LIKE 'solarsystem%'

Or

SELECT SCHEMA_NAME
FROM information_schema.SCHEMATA
WHERE SCHEMA_NAME LIKE 'solarsystem%'

answered Mar 10, 2018 at 18:27

Paul Spiegel

31.9k5 gold badges48 silver badges56 bronze badges

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

Comments

u_mulder · Accepted Answer · 2018-03-10 18:26:56Z

2

Simple solution that comes in mind:

while ($dbrow = mysql_fetch_array($dbresult)) {
    if (strpos($dbrow[0], 'solarsystem') === 0) {
        echo "<option input value='$dbrow[0]'>" .$dbrow[0]."<br></option>";
    }
}

answered Mar 10, 2018 at 18:26

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

Collectives™ on Stack Overflow

Loop mysql database names that starts with selected prefix in php

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related