How get all values in a column using PHP

Question

I ve been searching for this everywhere  but still can t find a solution  How do I get all the values from a mySQL column and store them in an array   For eg    Table Name  Customers  Column names  ID  Name    of rows  5  I want to get an array of all the 5 names in this table  How do I go about doing that  I am using PHP  and I was trying to just   SELECT names FROM Customers   and then use the   mysql fetch array   PHP function to store those values in an array

User · Answer

Here is a simple way to do this using either PDO or mysqli

$stmt = $pdo->prepare("SELECT Column FROM foo");
// careful, without a LIMIT this can take long if your table is huge
$stmt->execute();
$array = $stmt->fetchAll(PDO::FETCH_COLUMN);
print_r($array);

or, using mysqli

$stmt = $mysqli->prepare("SELECT Column FROM foo");
$stmt->execute();
$array = [];
foreach ($stmt->get_result() as $row)
{
    $array[] = $row['column'];
}
print_r($array);

Array
(
    [0] => 7960
    [1] => 7972
    [2] => 8028
    [3] => 8082
    [4] => 8233
)

User · Answer

Since mysql   are deprecated  so here is the solution using mysqli    mysqli   new mysqli  host    username    password    database    if  mysqli- gt connect errno gt 0      die  Connection to MySQL-server failed         resultArr   array     to store results   to execute query  executingFetchQuery    mysqli- gt query  SELECT  name  FROM customers WHERE 1    if  executingFetchQuery       while  arr    executingFetchQuery- gt fetch assoc                  resultArr      arr  name     storing values into an array        print r  resultArr    print the rows returned by query  containing specified columns   There is another way to do this using PDO     db   new PDO  mysql host host name dbname db name    username    password      to establish a connection     to fetch records    fetchD    db- gt prepare  SELECT  name  FROM customers WHERE 1       fetchD- gt execute     executing the query    resultArr   array     to store results   while  row    fetchD- gt fetch              resultArr      row  name          print r  resultArr

User · Answer

PHP 5  gt   5 5 0  PHP 7 Use array column on the result array  column   array column  result   names

User · Answer

First things is this is only for advanced developers persons Who all are now beginner to php dont use this function if you are using the huge project in core php use this function  function displayAllRecords  serverName   userName   password   databaseName  sqlQuery            databaseConnectionQuery    mysqli connect  serverName   userName   password   databaseName       if  databaseConnectionQuery     false                die  ERROR  Could not connect      mysqli connect error             return false              resultQuery   mysqli query  databaseConnectionQuery  sqlQuery        fetchFields   mysqli fetch fields  resultQuery        fetchValues   mysqli fetch fields  resultQuery        if  mysqli num rows  resultQuery   gt  0                             echo   lt table class  table  gt            echo   lt tr gt            foreach   fetchFields as  fetchedField                                   echo   lt td gt                echo   lt b gt      fetchedField- gt name     lt b gt  lt  a gt                echo   lt  td gt                             echo   lt  tr gt            while  totalRows   mysqli fetch array  resultQuery                                     echo   lt tr gt                                                for  eachRecord   0   eachRecord  lt  count  fetchValues   eachRecord                                             echo   lt td gt                    echo  totalRows  eachRecord                   echo   lt  td gt                                             echo   lt td gt  lt a href    gt  lt button gt Edit lt  button gt  lt  a gt  lt  td gt                echo   lt td gt  lt a href    gt  lt button gt Delete lt  button gt  lt  a gt  lt  td gt                echo   lt  tr gt                                  echo   lt  table gt                        else             echo  No Records Found in             All set now Pass the arguments as For Example   queryStatment    SELECT   From USERS     testing   displayAllRecords  localhost   root   root 123   email   queryStatment   echo  testing   Here   localhost indicates Name of the host   root indicates the username for database  root 123 indicates the password for the database   queryStatment for generating Query  hope it helps

User · Answer

How to put MySQL functions back into PHP 7 Step 1  First get the mysql extension source which was removed in March   https   github com php php-src tree PRE PHP7 EREG MYSQL REMOVALS ext mysql  Step 2  Then edit your php ini  Somewhere either in the    Extensions    section or    MySQL    section  simply add this line   extension    usr local lib php extensions no-debug-non-zts-20141001 mysql so   Step 3  Restart PHP and mysql   functions should now be working again    Step 4  Turn off all deprecated warnings including them from mysql     error reporting E ALL   E DEPRECATED     Now Below Code Help You     result   mysql query  SELECT names FROM Customers     Data  Array    while   row   mysql fetch array  result  MYSQL ASSOC               Data       row  names          You can also get all values in column using mysql fetch assoc   result   mysql query  SELECT names FROM Customers         Data  Array        while   row   mysql fetch assoc  result                       Data       row  names                 This extension was deprecated in PHP 5 5 0  and it was removed in PHP 7 0 0  Instead  the MySQLi or PDO MySQL extension should be used     Reference    YOU CAN USE MYSQLI ALTERNATIVE OF MYSQL EASY WAY        lt  php  con mysqli connect  localhost   my user   my password   my db       Check connection if  mysqli connect errno          echo  Failed to connect to MySQL      mysqli connect error          sql  SELECT Lastname Age FROM Persons ORDER BY Lastname    result mysqli query  con  sql       Numeric array  row mysqli fetch array  result MYSQLI NUM   printf    s   s  n   row 0   row 1        Associative array  row mysqli fetch array  result MYSQLI ASSOC   printf    s   s  n   row  Lastname    row  Age         Free result set mysqli free result  result    mysqli close  con     gt

User · Answer

I would use a mysqli connection to connect to the database  Here is an example    connection   new mysqli  127 0 0 1    username    password    database name   3306     The next step is to select the information  In your case I would do    query    connection- gt query  SELECT  names  FROM  Customers        And finally we make an array from all these names by typing    array   Array    while  result    query- gt fetch assoc          array      result  names       print r  array     So what I ve done in this code  I selected all names from the table using a mysql query  Next I use a while loop to check if the  query has a next value  If so the while loop continues and adds that value to the array   array   Else the loop stops  And finally I print the array using the  print r  method so you can see it all works  I hope this was helpful

User · Answer

Note that this answer is outdated  The mysql extension is no longer available out of the box as of PHP7  If you want to use the old mysql functions in PHP7  you will have to compile ext mysql from PECL  See the other answers for more current solutions      This would work  see more documentation here   http   php net manual en function mysql-fetch-array php   result   mysql query  SELECT names FROM Customers     storeArray   Array    while   row   mysql fetch array  result  MYSQL ASSOC          storeArray       row  names           now  storeArray will have all the names

[php] How get all values in a column using PHP?

Examples related to php

Examples related to mysql

Examples related to arrays