insert data with spaces from database into an array

Question

Is it possible to insert this kind of data from database into an array?

Mouse
Keyboard  //Saved from a Textarea box 
Monitor

The whole table looks like this;

id  ||   Owner  ||  Items
--------------------------
1   ||   John   || Mouse
    ||          || Keyboard //This is in a single row
    ||          || Monitor
--------------------------

How to assign each line of the data from field "Items" into an array (let's say $items)?

So that it will be like:

  $items[0] = "Mouse";
  $items[1] = "Keyboard";
  $items[2] = "Monitor";

So you want it to appear as though John is the owner of the mouse, keyboard, and monitor, or that they keyboard and mouse have no owner? or just have a list of items? — Anthony
– Anthony, Commented May 23, 2012 at 4:48
All those three items are Johns but nevermind. I got my answers already. Thanks to Vishal — Hafiz Abdullah
– Hafiz Abdullah, Commented May 23, 2012 at 5:00

Vishal · Accepted Answer · 2012-05-23 04:51:57Z

4

Try:

$items = explode("\n", $string_from_db);

answered May 23, 2012 at 4:51

Vishal

2,18114 silver badges25 bronze badges

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

Comments

Roman Newaza · Accepted Answer · 2012-05-23 03:50:13Z

0

You can use mysql_fetch_assoc()

Or PDOStatement::fetchAll()

Or mysqli_result::fetch_assoc()

answered May 23, 2012 at 3:50

Roman Newaza

11.8k12 gold badges65 silver badges94 bronze badges

2 Comments

Hafiz Abdullah Over a year ago

Sorry, I think you misunderstand my question.

Anthony Over a year ago

@HafizAbdullah - I think we are all misunderstanding your question. What do you want the final PHP array to look like?

user1299518 · Accepted Answer · 2012-05-23 03:53:19Z

0

something like this?

$arr = explode("\n",$data);   // split into lines
$categories = explode("||",$arr[0]);
unset($arr[0]); array_values($arr[0]);  // dont want categories anymore
array_walk($categories,create_function('&$v','$v = trim($v);'));   // trim space from categories
$data = array();   // holds info
foreach((array)$arr as $key=>$val) {
   if (substr($val,0,5)=="-----") { continue; }   // ignore "-----..." lines
   $row = explode("||",$val);
   foreach((array)$row as $key2=>$val2) {
      $data[ $categories[$key2] ][] = trim($val2);
   }
}

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

your example with the above code gives:

Array
(
    [id] => Array
        (
            [0] => 1   
            [1] =>     
            [2] =>     
        )

    [Owner] => Array
        (
            [0] =>    John   
            [1] =>           
            [2] =>           
        )

    [Items] => Array
        (
            [0] =>  Mouse
            [1] =>  Keyboard
            [2] =>  Monitor
        )

)

answered May 23, 2012 at 3:53

user1299518

1 Comment

Hafiz Abdullah Over a year ago

Thanks for your answer but why are you include the lines in your code? The table that I show you is the table in the mysql database. It has nothing to do with my problem.Sorry if you misunderstand.

Anthony · Accepted Answer · 2012-05-23 04:55:00Z

0

If I'm reading the last line correctly, you want:

  $results = $db -> query("SELECT Items FROM table");

  while($row = $results -> fetch_assoc()) {
        $items[] = $row['Items'];
  }

answered May 23, 2012 at 4:55

Anthony

37.2k26 gold badges103 silver badges167 bronze badges

1 Comment

Anthony Over a year ago

If you are wanting the entire table as an array, you'll need to normalize your data to make it clear the ownership and id of each item.

Collectives™ on Stack Overflow

insert data with spaces from database into an array

4 Answers 4

Comments

2 Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related