come posso creare un link che permetta il download in word o in altro formato di alcuni dati risultati da alcune statistiche e visualizzati con un echo.
$query= "SELECT
AVG(test_valence_photo1) as a1 ,
AVG(test_valence_photo1) as v1 ,
AVG(test_arousal_photo2) as a2 ,
AVG(test_valence_photo2) as v2 ,
AVG(test_arousal_photo3) as a3 ,
AVG(test_valence_photo3) as v3 ,
AVG(test_arousal_photo4) as a4 ,
AVG(test_valence_photo4) as v4 ,
AVG(test_arousal_photo5) as a5 ,
AVG(test_valence_photo5) as v5 ,
AVG(test_arousal_photo6) as a6 ,
AVG(test_valence_photo6) as v6 ,
AVG(test_arousal_photo7) as a7 ,
AVG(test_valence_photo7) as v7 ,
AVG(test_arousal_photo8) as a8 ,
AVG(test_valence_photo8) as v8 ,
AVG(test_arousal_photo9) as a9 ,
AVG(test_valence_photo9) as v9 ,
AVG(test_arousal_photo10) as a10 ,
AVG(test_valence_photo10) as v10 FROM messaggi ";
"WHERE
as v1 != '0',
as a1 != '0',
as v2 != '0',
as a2 != '0',
as v3 != '0',
as a3 != '0',
as v4 != '0',
as a4 != '0',
as v5 != '0',
as a5 != '0',
as v6 != '0',
as a6 != '0',
as v7 != '0',
as a7 != '0',
as v8 != '0',
as a8 != '0',
as v9 != '0',
as a9 != '0',
as v10 != '0 ',
as a10 != '0'";
$ris = mysql_query($query);
$rs = mysql_fetch_array($ris);
echo "
average arousal
". $rs["a1"];
echo"
" . $rs["a2"];
echo "
" .$rs["a3"];
echo"
" . $rs["a4"];
echo "
" .$rs["a5"];
echo"
" . $rs["a6"];
echo "
" .$rs["a7"];
echo"
" . $rs["a8"];
echo "
" .$rs["a9"];
echo "
" .$rs["a10"];
echo "
average valence
" . $rs["v1"];
echo "
" .$rs["v2"];
echo "
" .$rs["v3"];
echo "
" .$rs["v4"];
echo"
" . $rs["v5"];
echo"
" . $rs["v6"];
echo"
" . $rs["v7"];
echo"
" . $rs["v8"];
echo"
" . $rs["v9"];
echo"
" . $rs["v10"];
$query="SELECT
STD(test_arousal_photo1) as a1,
STD(test_valence_photo1) as v1,
STD(test_arousal_photo2) as a2,
STD(test_valence_photo2) as v2,
STD(test_arousal_photo3) as a3,
STD(test_valence_photo3) as v3,
STD(test_arousal_photo4) as a4,
STD(test_valence_photo4) as v4,
STD(test_arousal_photo5) as a5,
STD(test_valence_photo5) as v5,
STD(test_arousal_photo6) as a6,
STD(test_valence_photo6) as v6,
STD(test_arousal_photo7) as a7,
STD(test_valence_photo7) as v7,
STD(test_arousal_photo8) as a8,
STD(test_valence_photo8) as v8,
STD(test_arousal_photo9) as a9,
STD(test_valence_photo9) as v9,
STD(test_arousal_photo10) as a10,
STD(test_valence_photo10) as v10 FROM messaggi ";
$ris = mysql_query($query);
$rs = mysql_fetch_assoc($ris);
echo "
standard deviation arousal
". $rs["a1"];
echo"
" . $rs["a2"];
echo "
" .$rs["a3"];
echo"
" . $rs["a4"];
echo "
" .$rs["a5"];
echo"
" . $rs["a6"];
echo "
" .$rs["a7"];
echo"
" . $rs["a8"];
echo "
" .$rs["a9"];
echo "
" .$rs["a10"];
echo "
standard deviation valence
" . $rs["v1"];
echo "
" .$rs["v2"];
echo "
" .$rs["v3"];
echo "
" .$rs["v4"];
echo"
" . $rs["v5"];
echo"
" . $rs["v6"];
echo"
" . $rs["v7"];
echo"
" . $rs["v8"];
echo"
" . $rs["v9"];
echo"
" . $rs["v10"];
?>