Selecting and Displaying MYSQL Column Name using PHP

Question

I want to select and display the Column Name of my table. I used SHOW SQL Command to display the data to my select box. The problem is I want to omit Two(2) columns, ID and Image column to be exact. I have no problem with displaying all the column names. Please refer to my code below for more details.

PHP Code:

<?php 
    require "connect.php";

    $sql = "SHOW columns FROM tblLocation";
    $result = mysqli_query($conn,$sql);

    while ($row = mysqli_fetch_array($result)) {
        echo "<option value='".$row['Field']."'>".ucfirst($row['Field'])."</option>";
    }
?>

@TarangP "to be exact" is an idiom meaning "specifically". Those are the two columns he wants to omit. — Barmar
– Barmar, Commented Feb 13, 2018 at 5:58
make a array of the columns you want to show, compare it and show only matched — Sanjit Bhardwaj
– Sanjit Bhardwaj, Commented Feb 13, 2018 at 5:58

Barmar · Accepted Answer · 2018-02-13 05:58:22Z

1

use an if statement:

if ($row['Field'] != 'ID' && $row['Field'] != 'Image') {
    echo "<option value='".$row['Field']."'>".ucfirst($row['Field'])."</option>";
}

answered Feb 13, 2018 at 5:58

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

2 Comments

midway CCA Over a year ago

I worked, I just have one more question. How can I omit Two columns if i do not know what is the name of that column?

Barmar Over a year ago

If you don't know their names, what criteria do you want to use to omit them?

Collectives™ on Stack Overflow

Selecting and Displaying MYSQL Column Name using PHP

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