How to put all table values ​​in one array?

Question

PHP

php. I have a table with many fields. The fields consist of id and name. It is necessary to bring the name value of all fields into one large array. How to do it?

Answer 1

$host = ""; //Хост бд
$name = ""; // Имя бд
$user = ""; // Имя пользователя
$password = ""; // Пароль пользователя
$query = ""; // Запрос

try {
  $database = new PDO("mysql:host=$host;dbname=$name;charset=utf8", $user, $password);
  $database->EXEC("SET NAMES utf8");
} catch(PDOException $e) {
  die("Подключение не удалось: ". $error -> getMessage());
  exit;
}

$query = $database->prepare($query);
$query->execute();
$result = $sequery->fetchAll();

echo var_dump($result);

Answer 2

This is the name of one line. And you need all in one array :)