How to create an array of columns from a database result?

nasse

Would you please help me in how to get the remaining column values so that I will be able to echo each value in my pages. Right now, my function is set to return just to return one field's value (line 13) but I want to do the same for all the remaining fields. How do I write loopings like foreach ....

Expand|Select|Wrap|Line Numbers

 
class Setting extends Domain

{

  function __construct()

  {

    parent::__construct( 'Settings', array 'Settings_id', 'webSite', 'Slogan', 'Title'));

  }

  function Sett()

   {

    global $db;

    $SS = $db->query('SELECT * FROM Settings where webSite = "'.$this->domain().'"');

    while ($SS->fetchInto($row, DB_FETCHMODE_ASSOC)) {

      return $row[webSite];

    }

  }

}
 
$Set = new Setting();

echo $Set->Sett($row[webSite]);

Atli

Hi.

Please post your code inside [code] tags! It is almost impossible to read without them.

Also, please give your threads descriptive titles. They help our other members finding threads they are likely to be able to help with, thus increasing your chances of getting an answer.

All this, and more, can be read in the Posting guidelines, which all members are required to follow.

Thank you :)

As to your question.

Not knowing exactly which database system you are using, or even how your class handles the database results, I will assume you are using MySQL.

Try something like:

Expand|Select|Wrap|Line Numbers

 
$result = mysql_query("SELECT * FROM tbl");

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

  $data[] = $row

}

return $data;

nasse

Hi, thank you for the help very much. When I tried that, I get array output. When I tried this:

[PHP] $data[] = $row;[/PHP]
[PHP] foreach ($row as $data) {return $data;}[/PHP]

I get the value of the first field. So how do I print the values for the remaining fields from this code. Any idea?

Quote:

Originally Posted by Atli

Hi.

Please post your code inside [code] tags! It is almost impossible to read without them.

Also, please give your threads descriptive titles. They help our other members finding threads they are likely to be able to help with, thus increasing your chances of getting an answer.

All this, and more, can be read in the Posting guidelines, which all members are required to follow.

Thank you :)

As to your question.

Not knowing exactly which database system you are using, or even how your class handles the database results, I will assume you are using MySQL.

Try something like:

Expand|Select|Wrap|Line Numbers

 
$result = mysql_query("SELECT * FROM tbl");

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

  $data[] = $row

  return $data;

}

Atli

I'm afraid I made a small error in my previous post. I put the return keyword inside the while loop, which will of course only return the first row of data. I've fixed my previous post.

As to your problem, I think you may be misunderstanding how the return keyword works.
Once you call the return keyword, the function is immediately terminated, returning the value you specify.

So, calling return inside any loop will always terminate the loop and it's parent function on it's first run. In your case, this will always leave you with a single field or row, depending on your code.

Consider this code. It will simply print all fields of all rows:

Expand|Select|Wrap|Line Numbers

 
$result = mysql_query("SELECT * FROM tbl");

$rowIndex = 0;

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

  echo "Row {$rowIndex}: <br />";

  foreach($row as $_key => $_value) {

    echo "  - {$_key} = {$_value}";

  }

}

How to create an array of columns from a database result?

re: How to create an array of columns from a database result?

re: How to create an array of columns from a database result?

re: How to create an array of columns from a database result?

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about