Changeset 5503 for trunk/include/dblayer
- Timestamp:
- Mar 31, 2010, 8:16:27 PM (14 years ago)
- Location:
- trunk/include/dblayer
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/include/dblayer/functions_pdo-sqlite.inc.php
r5452 r5503 51 51 $link->sqliteCreateFunction('if', 'pwg_if', 3); 52 52 53 $link->sqliteCreateAggregate('std', 'pwg_std_step', 'pwg_std_finalize');54 53 $link->sqliteCreateFunction('regexp', 'pwg_regexp', 2); 55 54 … … 567 566 return preg_match($pattern, $string); 568 567 } 569 570 function pwg_std_step(&$values, $rownumber, $value)571 {572 $values[] = $value;573 574 return $values;575 }576 577 function pwg_std_finalize(&$values, $rownumber)578 {579 if (count($values)<=1)580 {581 return 0;582 }583 584 $total = 0;585 $total_square = 0;586 foreach ($values as $value)587 {588 $total += $value;589 $total_square += pow($value, 2);590 }591 592 $mean = $total/count($values);593 $var = $total_square/count($values) - pow($mean, 2);594 595 return sqrt($var);596 }597 568 ?> -
trunk/include/dblayer/functions_sqlite.inc.php
r5236 r5503 60 60 $link->createFunction('if', 'pwg_if', 3); 61 61 62 $link->createAggregate('std', 'pwg_std_step', 'pwg_std_finalize');63 62 $link->createFunction('regexp', 'pwg_regexp', 2); 64 63 … … 579 578 return preg_match($pattern, $string); 580 579 } 581 582 function pwg_std_step(&$values, $rownumber, $value)583 {584 $values[] = $value;585 586 return $values;587 }588 589 function pwg_std_finalize(&$values, $rownumber)590 {591 if (count($values)<=1)592 {593 return 0;594 }595 596 $total = 0;597 $total_square = 0;598 foreach ($values as $value)599 {600 $total += $value;601 $total_square += pow($value, 2);602 }603 604 $mean = $total/count($values);605 $var = $total_square/count($values) - pow($mean, 2);606 607 return sqrt($var);608 }609 580 ?>
Note: See TracChangeset
for help on using the changeset viewer.