Array to list/or other array in php

Question

I need some help with my SQL queries from php.

Here is my PHP code:

$sql = "SELECT * FROM datab WHERE  (`datestamp` BETWEEN '$date' AND '$date') AND (`timestamp` BETWEEN '08:00:01' AND '20:00:00')";
$result = $conn->query($sql);
while($list = mysqli_fetch_array($result))
 {
 //echo "$list[0]</br>";
 echo "$list[1]</br>";  //this is the column from MySQL corresponding to temperatures
 //echo "$list[2]</br>"; //this is the column from MySQL corresponding to other entries (humidity)
 //echo "$list[3]</br>";
 // echo "$list[4]</br>";
 // echo "$list[5]</br>";
 //echo "$list[6]</br>";
 // echo "$list[7]</br>";
}

So, I need to access my each temperature like an array or a list element and I don't know how to do it. I think the solution is to add each $list[1] element into another array inside that while.

Basicaly I want to access the element like temp[2] (or smth like that) to be the second element from the printed $list[1].

Can anyone help me?

it's already answered here. stackoverflow.com/a/14456661/5857047 — Codingalien
– Codingalien, Commented Jun 11, 2016 at 12:02

Dhara Parmar · Accepted Answer · 2016-06-11 11:42:00Z

1

Create another array for temperature:

$temperature = array();
while($list = mysqli_fetch_array($result))
{
 $temperature[] = $list[1]; // so now you will be able to acess the temperature array from anywhere outside this loop
}

answered Jun 11, 2016 at 11:42

Dhara Parmar

8,1231 gold badge19 silver badges27 bronze badges

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

1 Comment

dany Over a year ago

many thanks! it works great. This is what I need it. sorry that I'm dumb with php but I have a project which needs to be done.

Collectives™ on Stack Overflow

Array to list/or other array in php

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related