PHP - Need Code For An Average Of Numbers

Hi,

I'm trying to get out the average of records stored in a mysql table

This is the code im using right now
Code: [Select]
mysql_query("SELECT DATE(dato) , COUNT( dato ) AS counted FROM dekodere GROUP BY date(dato)", $link);
$ave = mysql_num_rows($ave);
This is getting out the average, but i need to exclude weekends because there is not stored anything during the weekend so it's making the average go off..

any tips?

Could someone please advise the best way to determine the average of a DATE field in a SELECT query?    

hi all!
i have 2 tables:

PRODUCTS
id_prod, id_cat, date, prod_name

CATEGORIES
id_cat, cat_name

My goal is obtain the average (day and month) of all products inserted by users in this format:

category Hardwa avg daily 20, month 100
category Components: avg daily 2, month 15
and so on.

PS: the 'date' field is unix timestamp (int 10).

Can you help me?

Hi,   I have a blog which records the amount of views on each article. I now want to be able to work out the average number of views per hour.   How can I work out the number of hours passed from a datetime format?   From there I can just do views divided by hours passed.   Thanks in advance!    

Hi,

Firstly, these are my tables:

CLASS
class_id                class_name
1                           Donkeys
2                           Monkeys
4                           Classic
9                           Humans

COURSES
class_id                courses_number
9                           6
9                           2
1                           3
2                           2


I would like to print average course_number for each class_name.
So for class_name Donkeys would have average course_number 3.
And for clasS_name Humans, average course_number is 4.

Do you get my point?

I have a "Users" table. I would like to find out the average users sign up in total. This table has a "joined date" column so I can track how many users sign up in a single day.

For e.g.

August 16 - 10 users

August 17 - 20 users

Auguest 18 - 30 users

The total average of user sign ups would be 20 users based on the above results.

So I am wondering how can I create this function?

This is my starting query.

$get_users = $db->prepare("SELECT user_id FROM users");
$get_users->execute();
$result_users = $get_users->fetchAll(PDO::FETCH_ASSOC);
if(count($result_users) > 0) {
  foreach($result_users as $row) {
    $user_id = $row['user_id'];
  }
}

 

I manage to display data using below query that will show value for each month. How to calculate average value starting july onwards(based on user selection).   Let say the value for element 'A'  are Jul=80, Aug= 80, Sep=90. If user select Aug then the average is 80 and if user select Sep then the average is 83.   Query:

$sql2 = "Select element,
	SUM(CASE WHEN Month = 'Jan' THEN total ELSE 0 END ) AS Jan,
	SUM(CASE WHEN Month = 'Feb' THEN total ELSE 0 END ) AS Feb,
	SUM(CASE WHEN Month = 'Mac' THEN total ELSE 0 END ) AS Mac,
	SUM(CASE WHEN Month = 'Apr' THEN total ELSE 0 END ) AS Apr,
	SUM(CASE WHEN Month = 'May' THEN total ELSE 0 END ) AS May,
	SUM(CASE WHEN Month = 'Jun' THEN total ELSE 0 END ) AS Jun,
	SUM(CASE WHEN Month = 'Jul' THEN total ELSE 0 END ) AS Jul,
	SUM(CASE WHEN Month = 'Aug' THEN total ELSE 0 END ) AS Aug,
	SUM(CASE WHEN Month = 'Sep' THEN total ELSE 0 END ) AS Sep,
	SUM(CASE WHEN Month = 'Oct' THEN total ELSE 0 END ) AS Oct,
	SUM(CASE WHEN Month = 'Nov' THEN total ELSE 0 END ) AS Nov,
	SUM(CASE WHEN Month = 'Dec' THEN total ELSE 0 END ) AS Dis
	FROM tbl_ma GROUP BY element";
	$rs2 = mysql_query($sql2);
	$getRec2 = mysql_fetch_assoc($rs2);

Below is how print the data:

<?php 
while ($row = mysql_fetch_assoc($rs2)) {
?>
<tr>
<td style="color:black;background-color:#f5efef"><div align="left"><?php echo $row['element']; ?></div></td>
<?php if( $year != '2014' ){ ?>
<?php if( 1 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Jan']; ?></div></td><?php endif; ?>
<?php if( 2 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Feb']; ?></div></td><?php endif; ?>
<?php if( 3 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Mac']; ?></div></td><?php endif; ?>
<?php if( 4 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Apr']; ?></div></td><?php endif; ?>
<?php if( 5 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['May']; ?></div></td><?php endif; ?>
<?php if( 6 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Jun']; ?></div></td><?php endif; ?>
<?php } ?>
<?php if( 7 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Jul']; ?></div></td><?php endif; ?>
<?php if( 8 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Aug']; ?></div></td><?php endif; ?>
<?php if( 9 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Sep']; ?></div></td><?php endif; ?>
<?php if( 10 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Oct']; ?></div></td><?php endif; ?>
<?php if( 11 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Nov']; ?></div></td><?php endif; ?>
<?php if( 12 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Dis']; ?></div></td><?php endif; ?>
<td><div align="center" style="color:black"><?php //echo average; ?></div></td>
</tr>                                  
<?php } ?>

 

I have a table of restaurant menu items called menu_items.  This table has a float row(3,2) called price.  I have a query that looks like this:

$query = mysql_query("SELECT * FROM menu_items WHERE restaurant = '".$restaurantid."'");

How would I find the average of the price row from that query?  Basically I want to find the average item price for a restaurants menu.

Hello,

I'm trying to calculate the square root of X values in an array minus the average of the array, but the first half of the values are negative, so I'm using the abs(); function to change them to positives first, but I'm still getting "NAN" as the result for the negative values that 'should' be positive.
        $x = array(7,3,4,6,4,2,7);
        $sqrt = true;
        $x = sort($x);
        $mean = 4.71; // average
        $XminA = array();
        foreach($x as $val) {
            ($sqrt == true) ? $XminA[] = round(sqrt(abs($val) - $mean),2) : $XminA[] = round($val - $mean,2);
        }
        echo "<pre>";
        print_r($XminA);
        echo "</pre>";

and my result is...
Quote

[XminA] => Array
        (
            => NAN [1] => NAN
            [2] => NAN
            [3] => NAN
            [4] => 1.14
            [5] => 1.51
            [6] => 1.51
        )

Not sure what I'm doing wrong, any help is appreciated. Thank you!

Kind Regards,
Ace

EDIT: stupid mistake, need it to the power of 2 not square root. Using the wrong function sorry:
 ($sqrt == true) ? $XminA[] = round(pow((abs($val) - $mean),2) : $XminA[] = round($val - $mean,2); // pow() not sqrt()
Quote

[XminA] => Array
        (
            => 7.34 [1] => 2.92
            [2] => 0.5
            [3] => 0.5
            [4] => 1.66
            [5] => 5.24
            [6] => 5.24
        )

can you have something like..

echo $whatever;

this putput
1.2

can you split this number so the first integer will be in $val"(1)" or whatever and the second integer after the "." will be in $val2"(2)"

I need to be able to add all the numbers together collected from the database with mysql_fectch_array
Code: [Select]
public function gradeQuery(){
$id = $this->idQuery();
$sql = "SELECT*FROM grades WHERE moviesID = '$id'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$num_rows = mysql_num_rows($result);


}

Hey,

I have checkbox and with these I am setting an exam. I want the questions to contain numbers. So for each question a number would be displayed. So far I am Only getting the question and the choices to display.


<html>

<?php
session_start();
include '../Database/connection.php';

$Value22 = mysql_real_escape_string(trim($_POST['myselects'])); 

$_SESSION['myselect23'] = $Value22;

//echo $_SESSION['myselect23'];
?>
<body>
<form action="Staff_Menu.php" method="post">
<?php

include '../Database/previous_q.php';

 while($info = mysql_fetch_array( $sql ))
 {
 
echo "{$info['Que_Question']} <br />\n";
echo "<input type=\"checkbox\" name=\"choice1[]\" value=\"{$info['Que_Choice1']}\" /> ";
echo "{$info['Que_Choice1']} <br />\n";
echo "<input type=\"checkbox\" name=\"choice2[]\" value=\"{$info['Que_Choice2']}\" /> ";
echo "{$info['Que_Choice2']} <br />\n";
echo "<input type=\"checkbox\" name=\"choice3[]\" value=\"{$info['Que_Choice3']}\" /> ";
echo "{$info['Que_Choice3']} <br />\n";
echo "<input type=\"checkbox\" name=\"choice4[]\" value=\"{$info['Que_Choice4']}\" /> ";
echo "{$info['Que_Choice4']} <br />\n";


 }


 ?>
 <input type="submit" value="submit"/>
 </body>
 
 </html>

 </body>
 
 </html>

I have a cards array, and I have this function which will shuffle the cards for me. How can I edit this to 'deal' 12cards (6 & 6) until all the cards are a specific 6 & 6 I pick out?

Code: [Select]
   function ShuffleCards(&$cardsArray, $times)
   {
    // Randomizes where to split within center (-3 to +3 from dead center)
(MINIMUM 10 CARDS IN DECK)
    // Splits into two array. Randomizes how many cards from left and how
many cards from right (between 1 and 3)
    // Alternates sides. Continues until both arrays are empty.
    $arraySize = count($cardsArray);

    if($arraySize<10)
     return;

    $deadCenter = $arraySize/2;

    for($i=0;$i<$times;$i++)
    {
     reset($cardsArray);

     $cutVariant = rand(-3, 3);
     $cutLocation = $deadCenter+$cutVariant;

     $firstArray = array();
     $secondArray = array();

     for($z=0;$z<$arraySize;$z++)
     {
      if($z<$cutLocation)
       array_push($firstArray, $cardsArray[$z]);
      else
       array_push($secondArray, $cardsArray[$z]);
     }

     $bottomFirst = rand(0, 1);
     $cardsArray = array();

     while(count($firstArray) && count($secondArray))
     {
      $leftNewCards = array();
      $rightNewCards = array();

      $leftVariant = rand(1, 3);
      if($leftVariant>count($firstArray))
       $leftVariant = count($firstArray);

      $rightVariant = rand(1, 3);
      if($rightVariant>count($secondArray))
       $rightVariant = count($secondArray);


      for($x=0;$x<$leftVariant;$x++)
      {
       array_push($leftNewCards, array_shift($firstArray));
      }

      for($y=0;$y<$rightVariant;$y++)
      {
       array_push($rightNewCards, array_shift($secondArray));
      }

      if($bottomFirst==0)
      {
       $newCardsArray = array_merge($leftNewCards, $rightNewCards);
       $bottomFirst = 1;
      }
      else
      {
       $newCardsArray = array_merge($rightNewCards, $leftNewCards);
       $bottomFirst = 0;
      }

      reset($newCardsArray);

      while(count($newCardsArray))
      {
       array_push($cardsArray, array_shift($newCardsArray));
      }
     }

     if(count($firstArray))
     {
      while(count($firstArray))
       array_push($cardsArray, array_shift($firstArray));
     }
     if(count($secondArray))
     {
      while(count($secondArray))
       array_push($cardsArray, array_shift($secondArray));
     }
    }
   }

Sorry if this has already been solved. Also, I apologize if this is an amateur question...

I have a simple form and a script to do some validating of user data, among other tasks.

One part of the script is intended to verify a birthday.

Code: [Select]
$x = $_POST['x'];
$x = trim($x);
According to the php.net manual, trim() is supposed to remove whitespace before and after a string. My intent by using trim() is to determine if someone tried to skip the birthday field. I have other validation running on the value of $x, but I wanted trim() to remove whitespace.

However, the value of x, which in this case is expected to be numeric, such as 12 for a month, ends up being 1. This happens with any 2-digit number that a user might enter into the form field for x. The second number is always removed.

Any insight into why trim() removes the second number, 2 in the above example, leaving only a "1" as the value of $x, would be very greatly appreciated.

Thanks in advance.

Hello,

Example X = 50

I have been trying to find a way so that I can loop a foreach to insert into a database X and every other number below X unless X already exists.

is this possible?

-John