How do I get column name by row in MysQLI?

Question

How do I return the column name in mysqli by row?

...
$result = $mysqli->query("SELECT * FROM `xtdf` WHERE posterid='bike'"); 
$rows=mysqli_fetch_array($result); 

foreach($rows as $column => $value) {
    echo $column . " " . $value;
}
...

This code above will return all columns name and values, but I want only the column name by the value. I have tried this code below but returns nothing.

...
$result = $mysqli->query("SELECT * FROM `xtdf` WHERE posterid='bike'"); 
$rows=mysqli_fetch_array($result); 

foreach($rows as $column => $value) {
if ($value == "bike") {
    echo $column;
    }
}

Edit: I don't want put the result in array, or bring all results. Only return one value. PHP version: 5.5.15
What should I do?

Possible duplicate of [MySQL query to get column names?](https://stackoverflow.com/questions/4165195/mysql-query-to-get-column-names) — Ahmet Zeybek, Apr 13 '18 at 21:15
It isn't. I don't want return ALL tables to array. I want only one without array. — John Wiky, Apr 13 '18 at 21:20
if I understand you correctly you want to know in which column you have the value 'bike'. But in the query you ask already for `posterid` to be 'bike' - so this would be the column, right? This sounds like an XY Problem to me. What is the actual goal you wanna achieve? — Jeff, Apr 13 '18 at 21:57
At this moment I still practicing, but in the future I'll use a loop, so is this the main reason for get the column name — John Wiky, Apr 13 '18 at 22:01

score 2 · Answer 1 · answered Apr 13 '18 at 21:15

2

This should do the trick

while($row=mysqli_fetch_array($result)) {
    foreach($row as $column => $value) {
       if ($value == "bike") {
          echo $column;
       }
    }
}

You need to iterate through all values that you fetch from database.

answered Apr 13 '18 at 21:15

Felippe Duarte

14,901
2
25
29

Unfortunately it still returns nothing – John Wiky Apr 13 '18 at 21:19
Could you show us the SQL query? And are you sure that you have a value = "bike", lowercase and trimmed? – Felippe Duarte Apr 13 '18 at 21:21
http://prntscr.com/j4ysep At this moment I still practicing, but in the future I'll use a loop, so is this the main reason for get the column name – John Wiky Apr 13 '18 at 21:25
You have two lines with `mysql_fetch_array` .. remove the line outside the `while` – Felippe Duarte Apr 13 '18 at 21:30
Already did it, also, I have changed the _$row_ of your code to another name just for test it – John Wiky Apr 13 '18 at 21:32
1

Could you update your question with the **actual** code? – Felippe Duarte Apr 13 '18 at 21:33

How do I get column name by row in MysQLI?

1 Answers1