'how to fetch specific number of rows (6 rows) from database and get average of those values , then output average to an integer [duplicate]

i am creating php script to take input from a data base containing [id,value,date] , there are many rows (increasing every minute using an api) . I want to fetch 6 rows everytime like 1to6 , then perform their average(val1+2+3+4+5+6/6) and store that average into a variable. This whole process is continuous, means 1to6->average->outputin variable then 6to12->average->outputin variable and like that

i am using php and i did

$var=1;
$raw = "SELECT id, value, date FROM db";
$result = $conn->query($raw);

$row_cnt = $result->num_rows;

printf("Result set has %d rows.\n", $row_cnt);

if ($result->num_rows < $var) {
  // output data of each row
  while($row = $result->fetch_assoc()) {
    
    echo nl2br("\n");
    echo "price: " . $row["value"];
    echo nl2br("\n");
  }
$var++;

please give me solution to my problem, ❤php

phpmysqlarraysmysqli


Solution 1:[1]

instead of fetching data from sql to php script , i averaged the data itself on the sql server using this query

SELECT AVG(table) FROM (SELECT table FROM db ORDER BY id DESC LIMIT 0, 6) items;

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Ashutosh_7i

Related Questions