How to select all columns in the database

Question

How to select all columns in the database with the names 'name' and 'date' I have the code

<?php
    $sql = "??";
    if ($rs = $bd->query($sql)) {
      while ($row = $rs->fetch_assoc()) {
        echo $row['data'];
        echo $row['nome'];
      }
    }
    ?>

I need then to select in all tables the columns with these names. I don’t know if this is possible, or I’ll have to do it one by one?

Answer 1

You can do the SELECT selecting only the fields date and name:

SELECT nome,data FROM sua_tabela

And also you can select all table columns

SELECT * FROM sua_tabela

If you want to select these same columns from all the tables you have in the database and display all the results at once, try this way:

PDO

$query = $bd->query("SHOW TABLES");
while ($result = $query->fetch(PDO::FETCH_NUM)){

  $tabela = $result[0];

  $sql = "SELECT nome, data FROM ".$tabela;
  if ($rs = $bd->query($sql)) {
      while ($row = $rs->fetch_assoc()) {
        echo $row['data'];
        echo $row['nome'];
      }
    } 
  echo '<hr>';//Separa o resultado de cada coluna selecionada
}

Mysqli

$query = mysqli_query($this->conn, "SHOW TABLES");
while($result = mysqli_fetch_array($query)){

  $tabela = $result[0];

  $sql = mysqli_query("SELECT nome,data FROM ".$tabela);

  while($row = mysqli_fetch_array($sql)){

    echo $row['data'];
    echo $row['nome'];
  }
}