Question

How to fetch one column from MySQL table into array using PDO and PHP

Answer 1

$result = conn->query("SELECT english FROM multi_lang");  
$row = $result->fetchAll(PDO::FETCH_COLUMN);
$set[] = $row;

echo "<pre>";
print_r($set);
echo "</pre>";

/*
run: 
  
Array
(
    [0] => Array
        (
            [0] => Login
            [1] => Username
            [2] => E-mail
            [3] => Password
            ...
        )
)
    
*/

 

70+ SQL courses for beginners and professionals