Databases
StackOverflow2013
Postsdbo
PODisplay list of tables as drop down box
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODisplay list of tables as drop down box
    primarykey
    data
    text
    <p>I'm trying to code a drop down box that displays all table names from a database but I can't seem to figure out why it's not working. I'm getting the drop down box on the screen but it seems to be empty and my submit button isn't appearing either.</p> <p>I just can't see where I've gone wrong, here's all my relevant code:</p> <p>index.php</p> <pre><code>include_once 'db.php'; &lt;form action="&lt;?php echo $_SERVER['PHP_SELF']; ?&gt;" method="POST"&gt; &lt;select name="Tables" id="ddTables"&gt; &lt;?php $tableResults = getTableList(); if($tableResults) { if($tableResults-&gt;rowCount() &gt; 0) { $tables = $tableResults-&gt;fetchAll(PDO::FETCH_NUM); foreach($tables as $table) { $name = $table[0]; echo '&lt;option value="'.$name.'"&gt;'.$name.'&lt;/option&gt;'; } } } else { echo '&lt;option value="0"&gt;No Data&lt;/option&gt;'; } ?&gt; &lt;/select&gt; &lt;input type="submit" id="tableSubmit" value="Submit"/&gt; &lt;/form&gt; </code></pre> <p>db.php</p> <p>getConnection function:</p> <pre><code>//main database connection varaibles $DCONFIG_server = "localhost:8888"; $DCONFIG_DBUser = "root"; $DCONFIG_DBPass = "password"; $DCONFIG_DBName = "ISAD235"; try { $conn = new PDO("mysql:host=$DCONFIG_server;dbname=$DCONFIG_DBName", $DCONFIG_DBUser, $DCONFIG_DBPass); } catch (PDOException $ex) { echo $ex-&gt;getMessage(); } return $conn; function getConnection() { //main database connection varaibles $DCONFIG_server = "localhost:8888"; $DCONFIG_DBUser = "root"; $DCONFIG_DBPass = "password"; $DCONFIG_DBName = "ISAD235"; try { $conn = new PDO("mysql:host=$DCONFIG_server;dbname=$DCONFIG_DBName", $DCONFIG_DBUser, $DCONFIG_DBPass); } catch (PDOException $ex) { echo $ex-&gt;getMessage(); } return $conn; } function runSQL($sql) { $mysqlConnection = getConnection(); $ResultSet = $mysqlConnection-&gt;query($sql); return $ResultSet; } function getTableList() { $sql = "SHOW TABLES"; $ResultSet = runSQL($sql); if(!$ResultSet) { echo "Table list not found"; } return $ResultSet; } </code></pre> <p>Any help would be much appreciated!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USElliot Blackburn
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PODisplay list of tables as drop down box
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHow about a var_dump of $tables ? Also, try moving your else block up one level so it will trigger if the query succeeds but there are 0 rows returned.
      singulars
      1. PODisplay list of tables as drop down box
      1. USaviemet
    2. CO@aviemet doesn't seem to have done anything, var_dump isn't returning anything and neither is my else code. I've tried putting just some echo around the code to see what happens and it seems nothing happens in my <select name="Tables" id="ddTables"></select> for some reason. Don't know if that helps at all.
      singulars
      1. PODisplay list of tables as drop down box
      1. USElliot Blackburn
    3. CODid you do *Show source code* ? The output may not display in HTML because it is inside the select tag.
      singulars
      1. PODisplay list of tables as drop down box
      1. USLorenz Meyer
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload