Take info from database to array

Question

Hello stackowerflow people, i need to get array from database, that my variable would look like this $TaskArray['task_id']['task_start_date'] but i dont know how. Maby you guys can help me. Here is the picture of my database

Ive tried doing this, but that ddnt worked. Help please.

  $query1 = mysql_query("SELECT task_id, task_start_date FROM dotp_tasks");
  if ($query1) {
      while ($row = mysql_fetch_assoc($query1)) {
        $TaskArray['dbc'] = $row['task_id'];
        $TaskArray['dbc']['task_start_date'] = $row['task_start_date'];
      }
  } else {

What exactly should the result be? An array with the task ID as the key and the date as value? — t.h3ads
– t.h3ads, Commented Jul 23, 2015 at 12:02

Pupil · Accepted Answer · 2015-07-23 12:03:42Z

2

You need to have multi-dimensional array with an array of each task.

...
$query1 = mysql_query("SELECT task_id, task_start_date FROM dotp_tasks");
  if ($query1) {
      while ($row = mysql_fetch_assoc($query1)) {            
        $TaskArray[$row['task_id']]['task_start_date'] = $row['task_start_date'];
      }
  } else {
...

Here, we are generating a multi-dimensional array with task_id as key to each array and that array should contain task details.

Try printing the newly generated array using:

<?php echo '<pre>'; print_r($TaskArray);echo '</pre>';?>

answered Jul 23, 2015 at 12:03

Pupil

24k6 gold badges50 silver badges71 bronze badges

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

Comments

t.h3ads · Accepted Answer · 2015-07-23 12:03:30Z

1

If I understood your question, this should work:

$query1 = mysql_query("SELECT task_id, task_start_date FROM dotp_tasks");
if ($query1) {
    while ($row = mysql_fetch_assoc($query1)) {
      $TaskArray[$row['task_id']] = $row['task_start_date'];
    }
} else {

answered Jul 23, 2015 at 12:03

t.h3ads

1,87610 silver badges18 bronze badges

Collectives™ on Stack Overflow

Take info from database to array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related