Convert MySQL result to an array strings

Question

I am selecting names of my products from products table in MySQL then I want to present these names to something like
$names = array(name1, name2, ...)
Where name1, ... are the names of the products from MySQL. I have gone through suggested similar cases but none seems to solve my problem. I am a newbie and just trying to learn.

Eugen Rieck · Accepted Answer · 2012-02-04 16:07:23Z

5

$result = mysql_query("SELECT name FROM products");
$names=array();
while ($row = mysql_fetch_row($result)) $names[]=$row[0];
mysql_free_result($result);

You need the loop, as there is no way to directly get all rows of the complete result set.

answered Feb 4, 2012 at 16:07

Eugen Rieck

65.6k10 gold badges75 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

NeverPhased · Accepted Answer · 2012-02-04 16:08:29Z

-1

$result = mysql_query("

SELECT `productname` FROM `products`

")or die($result."<br/><br/>".mysql_error());

    $numrows  = mysql_num_rows($result);  

    while ($row = mysql_fetch_assoc($result))
    {

    $productname[$i] = $row['productname'];

            // to print out use the following
             echo $productname[$i];
            $i++;

    }

answered Feb 4, 2012 at 16:08

NeverPhased

1,5763 gold badges18 silver badges32 bronze badges

Comments

Naltharial · Accepted Answer · 2012-02-04 17:42:07Z

-1

Well, from an academic point of view, I suppose there's a "viable" alternative in doing something like

$names = explode('<|>', mysql_result(mysql_query(
    "SELECT GROUP_CONCAT(name separator '<|>') FROM products GROUP BY 'name'"
), 0));

All the power of loops and arrays in single line, for the low, low price of making baby Jesus cry. And yes, you should probably use a loop. Unless you have a phobia ever since a loop waited for you outside your school when you were little and beat you up, I guess.

answered Feb 4, 2012 at 17:42

Naltharial

2,15215 silver badges21 bronze badges

5 Comments

Your Common Sense Over a year ago

from academic point of view one have to create a function. But it seems no PHP user (at least on this site) ever heard of such a feature.

Naltharial Over a year ago

Only if you intend to reuse the code. Otherwise functions themselves will lead to code bloat.

Your Common Sense Over a year ago

..otherwise oneliner will make no sense. (Note that this case is among most reusable ones)

Naltharial Over a year ago

That depends on the application purpose. Functions are not a silver bullet. If you think it won't make sense, that falls under the comment your code appropriately clause of programming. Not that I advocate the use of this kind of code, just stating an opinion on practices.

Your Common Sense Over a year ago

this practice indeed requires an advocate

Your Common Sense · Accepted Answer · 2012-02-04 17:52:19Z

-1

Dunno why everione sticked to one-liner but anyway it's always good idea to make your code less bloated

create a function

  function dbGgetCol($sql) {
    $ret = array(); 
    $res = mysql_query($sql) or trigger_error(mysql_error()." in ".$sql); 
    if ($res) {
      while ($row = mysql_fetch_row($result)) {
        $ret[] = $row[0]; 
      }
      mysql_free_result($res); 
    }
    return $ret;
  }

place it in some config file included into each script
and then get your array with this simple code

$names = dbGetCol("SELECT name FROM products");

answered Feb 4, 2012 at 17:52

Your Common Sense

158k42 gold badges226 silver badges373 bronze badges

Collectives™ on Stack Overflow

Convert MySQL result to an array strings

4 Answers 4

Comments

Comments

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related