StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POerror in my PHP code drop down list to select item from MYSQL
primarykey
Id
18369437
data
AcceptedAnswerId
0
AnswerCount
3
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2013-08-21T23:44:59.813
FavoriteCount
0
LastActivityDate
2013-08-23T16:11:45.860
LastEditDate
LastEditorUserId
0
OwnerUserId
2676607
ParentId
0
PostTypeId
1
Score
-1
ViewCount
564
LastEditorDisplayName
text
Body
<p>i have interface which have drop down list, you have to select an item and click on submit button to view the database in mysql but doesn't work, it give error "Table 'balhaf.$table' doesn't exist"</p> <p>here is my code the interface</p> <pre><code><html> <body> <form method="post" action="list_files.php"> <input name="go" type="submit" value="submit" / > <?php $dbname = 'balhaf'; if (!mysql_connect('localhost', 'sqldata', 'sqldata')) { echo 'Could not connect to mysql'; exit; } $sql = "SHOW TABLES FROM $dbname"; $result = mysql_query($sql); if (!$result) { echo "DB Error, could not list tables\n"; echo 'MySQL Error: ' . mysql_error(); exit; } echo '<select name="dropdown" style="width:150px">'; echo '<option value="">Select</option>'; while ($row = mysql_fetch_row($result)) { echo '<option value="'.$row[0].'">'.$row[0].'</option>'; } echo '</select>'; echo '</form>'; mysql_free_result($result); ?> </body> </html> </code></pre> <p>my second code "list_files.php"</p> <pre><code><?php if(isset($_POST["dropdown"])) { echo "ok"; } $table = $_POST['dropdown']; // Connect to the database $dbLink = new mysqli('localhost', 'sqldata', 'sqldata', 'balhaf'); if(mysqli_connect_errno()) { die("MySQL connection failed: ". mysqli_connect_error()); } // Query for a list of all existing files $sql = 'SELECT `id`, `name`, `mime`, `size`, `created` FROM $table'; $result = $dbLink->query($sql); // Check if it was successfull if($result) { // Make sure there are some files in there if($result->num_rows == 0) { echo '<p>There are no files in the database</p>'; } else { // Print the top of a table echo '<table border="1" align="center"> <H2 align="center"> Report Table</H> <tr> <td><b>Name</b></td> <td><b>Mime</b></td> <td><b>Size (bytes)</b></td> <td><b>Created</b></td> <td><b>Download</b></td> </tr>'; // Print each file while($row = $result->fetch_assoc()) { echo " <tr> <td>{$row['name']}</td> <td>{$row['mime']}</td> <td>{$row['size']}</td> <td>{$row['created']}</td> <td><a style='text-decoration:none;' href='get_file.php?id= {$row['id']}'>Download</a></td> </tr>"; } // Close table echo '</table>'; } // Free the result $result->free(); } else { echo 'Error! SQL query failed:'; echo "<pre>{$dbLink->error}</pre>"; } // Close the mysql connection $dbLink->close(); ?> </code></pre>
Tags
<php>
Title
error in my PHP code drop down list to select item from MYSQL
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. UShadi
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
3. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POerror in my PHP code drop down list to select item from MYSQL
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTDownMod
CommentsPostId
1. COWell... does the table exist?
  singulars
  PostPostId
  POerror in my PHP code drop down list to select item from MYSQL
  UserUserId
  USCodecat
2. COThe table should likely be existing. The problem is a syntax error, since the Server is not able to read the value of $table;
  singulars
  PostPostId
  POerror in my PHP code drop down list to select item from MYSQL
  UserUserId
  USSasanka Panguluri

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.