如何在下拉列表中仅循环以solarsystem
开头的数据库名称。
+---------------------+
| dbname |
+---------------------+
| electronics |
| vegetables |
| solarsystem_sun |
| solarsystem_mercury |
| solarsystem_venus |
| solarsystem_mars |
| fruits |
| foobar |
+---------------------+
当前它正在循环所有数据库名称
<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>
SHOW DATABASES WHERE `Database` LIKE 'solarsystem%'
或
SELECT SCHEMA_NAME
FROM information_schema.SCHEMATA
WHERE SCHEMA_NAME LIKE 'solarsystem%'
想到
的简单解决方案:
while ($dbrow = mysql_fetch_array($dbresult)) {
if (strpos($dbrow[0], 'solarsystem') === 0) {
echo "<option input value='$dbrow[0]'>" .$dbrow[0]."<br></option>";
}
}