Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $conn = new mysqli($db_host, $db_usuari, $db_contrasenya, $db_nomBBDD);
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $consulta = "SELECT avg(edad) as 'mediaEdad' FROM encuesta";
- //amb la funcio mysqli_query() rebem els resultats de la consulta
- $resultat = mysqli_query($conn, $consulta);
- $mediaEdad = 0;
- while($fila = mysqli_fetch_array($resultat))
- {
- $mediaEdad = $fila['mediaEdad'];
- }
- $consulta = "SELECT count(edad) as 'medianaEdad' FROM encuesta";
- $resultat = mysqli_query($conn, $consulta);
- $contEdad = 0;
- while($fila = mysqli_fetch_array($resultat))
- {
- $contEdad = $fila['medianaEdad'];
- }
- $consulta = "SELECT edad as 'edad' FROM encuesta";
- $resultat = mysqli_query($conn, $consulta);
- $edades = array();
- while($fila = mysqli_fetch_array($resultat))
- {
- array_push($edades, $fila['edad']);
- /*$edades = array_merge($a_usuaris, $fila['edad']);*/
- }
- sort($edades);
- $medianaEdad = 0;
- if($contEdad % 2 == 0){
- $medianaEdad = ($edades[($contEdad/2)-1] + $edades[($contEdad/2)])/2;
- }else{
- $medianaEdad = $edades[($contEdad/2)];
- }
- $moda = array_count_values($edades);
- arsort($moda);
- $valorAnterior = 0;
- $modaEdad = 0;
- foreach ($moda as $key => $valor){
- if($valor < $valorAnterior){
- break;
- } else {
- $modaEdad = $key;
- $valorAnterior = $valor;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement