How can i read the table name while showing tables from database php mysql

Question

Hi Am trying to read the table name from the dropdown but am unable give the name option name. Here is my code.

 <div class="form-group">
          <label class="control-label col-sm-2" for="email">Enter number of titles:</label>
              <div class="col-sm-10">
                <select>
                  <?php 
                     include 'config.php';
                     $query="show tables";
                     $result_query=mysqli_query($conn,$query);
                      while($row=mysqli_fetch_array($result_query))
                       {
                          echo "<option>$row[0]</option>";
                       }
                  ?>
                 </select>
              </div>
        </div>

How can I give the option value or name as there are 10 tables I need to read the table name once the table is selected

Thank you

Hedin · Accepted Answer · 2017-02-01 06:41:12Z

1

replace

echo "<option>$row[0]</option>";

to

echo "<option value='{$row[0]}'>{$row[0]}</option>";

answered Feb 1, 2017 at 6:41

Hedin

1092 bronze badges

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

2 Comments

vicky kumar Over a year ago

Yaa I got it sorry for question but how can I store it in variable

Hedin Over a year ago

in PHP or JS? in PHP you must use FORM tag and set attr "name" to SELECT tag(<select name="table">)

Collectives™ on Stack Overflow

How can i read the table name while showing tables from database php mysql

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related