PHP visualize MySQL select last n values [duplicate]

Question

I'd like to visualize last 144 temperature data from MySQL database on my website. Now I have the following code:

<?php
$servername = "localhost";
$username = "_accounts";
$password = "---";
$dbname = "_accounts";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT `t` FROM `WbabZwvgf` ORDER BY `id` DESC LIMIT 144";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
  // output data of each row
  while($row = $result->fetch_assoc()) {
    $t = $row["t"];
  }
} else {
  echo "0 results";
}
$conn->close();

Now if I echo $t after i have declared in "while" like this:

while($row = $result->fetch_assoc()) {
    $t = $row["t"];
    echo $t." ";
  }

seems everything OK, but I can't save each values as php variables like $t1=t[0], $t2=t[1], $t3=t[2]...etc, even during the "while". Could you help me how to save the selected data into PHP variables?

Save the values in an array instead of a string

user8034901
– user8034901

2021-01-03 12:29:31 +00:00
Commented Jan 3, 2021 at 12:29 — user8034901
– user8034901, Commented Jan 3, 2021 at 12:29
mysqli_result::fetch_all

outis
– outis

2021-01-04 03:40:25 +00:00
Commented Jan 4, 2021 at 3:40 — outis
– outis, Commented Jan 4, 2021 at 3:40

WiatroBosy · Accepted Answer · 2021-01-03 12:31:32Z

0

Try

$t = array();
while($row = $result->fetch_assoc()) {
    $t[] = $row["t"];
    
  }
var_dump($t);

answered Jan 3, 2021 at 12:31

WiatroBosy

1,1091 gold badge8 silver badges17 bronze badges

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

Comments

raiserle · Accepted Answer · 2021-01-03 13:40:05Z

0

You should use an array. But the correct answer for your question is:

$i = 1;
while($row = $result->fetch_assoc()) {
    ${'t'.($i++)} = $row['t'];
}
echo $t1;
echo $t2;

--

Thanks for the minus. But read his question correctly. He asks for $t1, $t2 and so on. And now consider which answer is the correct one. The one with the array certainly not.

edited Jan 3, 2021 at 13:40

answered Jan 3, 2021 at 13:31

raiserle

7058 silver badges31 bronze badges

1 Comment

outis Over a year ago

The "correct" answer is not necessarily the one that simply gives what is asked for. The question might be founded on an incorrect assumption or taking the wrong approach (as this one is), in which case a correct answer is one that corrects the error in the question itself.

Collectives™ on Stack Overflow

PHP visualize MySQL select last n values [duplicate]

2 Answers 2

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Linked

Related