récupérer résultats requete dans un tableau multidimensionnel

Version imprimable

Bonjour

j'ai la requete suivante :
Code:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 $sql = "select ana_id, sta_date, arrondi(sta_valeur, ana_id) from tbl_stat_sta "; $sql .= "where (ana_id between 1 and 2) and (sta_date between '2011-01-01' and '2011-01-31') order by ana_id, sta_date;"; echo $sql; $result = pg_query($dbconn, $sql); /*test requete*/ if (!$result) { echo "erreur."; exit; } /* execution requete */ $myarray=array(); while ($row = pg_fetch_row($result)) { $myarray[]=$row; } echo json_encode($myarray);
je voudrais récupérer un tableau de tableau en triant sur ana_id et en ayant dans chaque sous tableau toutes les valeurs et les dates pour chaque ana_id.
le but ensuite est de rappeler chaque sous tableau pour le passer dans une fontion JS pour faire des graph

merci

Code:

1
2
3
while ($row = pg_fetch_row($result)) {
	$myarray[$row['ana_id']]=$row;
	}

je me suis mal expliqué : je veux regrouper sur les valeurs de ana_id pour avoir des tableaux que je pourrais rappeler par cette même valeur :
pour ana_id = 1 et 2 j'obtiens ça

Code:

[["1","2011-01-04","44.64"],["1","2011-01-04","44.53"],["1","2011-01-05","44.90"],["1","2011-01-05","44.70"],["1","2011-01-06","45.43"],["1","2011-01-06","43.26"],["1","2011-01-07","44.02"],["1","2011-01-07","45.06"],["1","2011-01-08","43.95"],["1","2011-01-08","44.59"],["1","2011-01-11","42.71"],["1","2011-01-11","43.46"],["1","2011-01-12","43.86"],["1","2011-01-12","43.09"],["1","2011-01-13","44.15"],["1","2011-01-13","43.72"],["1","2011-01-14","43.12"],["1","2011-01-14","43.82"],["1","2011-01-15","43.67"],["1","2011-01-15","43.15"],["1","2011-01-18","43.16"],["1","2011-01-18","41.93"],["1","2011-01-19","43.36"],["1","2011-01-19","43.33"],["1","2011-01-20","42.38"],["1","2011-01-20","43.12"],["1","2011-01-21","43.09"],["1","2011-01-21","43.51"],["1","2011-01-22","44.67"],["1","2011-01-22","43.28"],["1","2011-01-25","45.45"],["1","2011-01-25","43.61"],["1","2011-01-26","43.61"],["1","2011-01-26","45.02"],["1","2011-01-27","45.01"],["1","2011-01-27","42.99"],["1","2011-01-28","43.18"],["1","2011-01-28","44.05"],["1","2011-01-29","43.50"],["1","2011-01-29","43.35"],["2","2011-01-04","37.69"],["2","2011-01-04","34.23"],["2","2011-01-05","34.20"],["2","2011-01-05","37.96"],["2","2011-01-06","33.89"],["2","2011-01-06","37.98"],["2","2011-01-07","34.03"],["2","2011-01-07","38.14"],["2","2011-01-08","37.81"],["2","2011-01-08","33.95"],["2","2011-01-11","33.60"],["2","2011-01-11","36.08"],["2","2011-01-12","36.18"],["2","2011-01-12","33.73"],["2","2011-01-13","37.22"],["2","2011-01-13","33.61"],["2","2011-01-14","33.48"],["2","2011-01-14","37.13"],["2","2011-01-15","36.60"],["2","2011-01-15","33.41"],["2","2011-01-18","36.17"],["2","2011-01-18","33.29"],["2","2011-01-19","33.33"],["2","2011-01-19","36.62"],["2","2011-01-20","33.36"],["2","2011-01-20","35.92"],["2","2011-01-21","33.23"],["2","2011-01-21","36.72"],["2","2011-01-22","37.13"],["2","2011-01-22","33.11"],["2","2011-01-25","36.74"],["2","2011-01-25","33.58"],["2","2011-01-26","33.62"],["2","2011-01-26","36.63"],["2","2011-01-27","36.69"],["2","2011-01-27","33.39"],["2","2011-01-28","36.53"],["2","2011-01-28","33.23"],["2","2011-01-29","36.26"],["2","2011-01-29","33.28"]]

et je voudrais qqc du genre :
Code:

1 2 3 [1,[[ "2011-01-04","44.64"],[ "2011-01-04","44.53"],[ "2011-01-05","44.90"],[ "2011-01-05","44.70"],[ "2011-01-06","45.43"],[ "2011-01-06","43.26"],[ "2011-01-07","44.02"],[ "2011-01-07","45.06"],[ "2011-01-08","43.95"],[ "2011-01-08","44.59"],[ "2011-01-11","42.71"],[ "2011-01-11","43.46"],[ "2011-01-12","43.86"],[ "2011-01-12","43.09"],[ "2011-01-13","44.15"],[ "2011-01-13","43.72"],[ "2011-01-14","43.12"],[ "2011-01-14","43.82"],[ "2011-01-15","43.67"],[ "2011-01-15","43.15"],[ "2011-01-18","43.16"],[ "2011-01-18","41.93"],[ "2011-01-19","43.36"],[ "2011-01-19","43.33"],[ "2011-01-20","42.38"],[ "2011-01-20","43.12"],[ "2011-01-21","43.09"],[ "2011-01-21","43.51"],[ "2011-01-22","44.67"],[ "2011-01-22","43.28"],[ "2011-01-25","45.45"],[ "2011-01-25","43.61"],[ "2011-01-26","43.61"],[ "2011-01-26","45.02"],[ "2011-01-27","45.01"],[ "2011-01-27","42.99"],[ "2011-01-28","43.18"],[ "2011-01-28","44.05"],[ "2011-01-29","43.50"],[ "2011-01-29","43.35"]], 2,[[ "2011-01-04","37.69"],[ "2011-01-04","34.23"],[ "2011-01-05","34.20"],[ "2011-01-05","37.96"],[ "2011-01-06","33.89"],[ "2011-01-06","37.98"],[ "2011-01-07","34.03"],[ "2011-01-07","38.14"],[ "2011-01-08","37.81"],[ "2011-01-08","33.95"],[ "2011-01-11","33.60"],[ "2011-01-11","36.08"],[ "2011-01-12","36.18"],[ "2011-01-12","33.73"],[ "2011-01-13","37.22"],[ "2011-01-13","33.61"],[ "2011-01-14","33.48"],[ "2011-01-14","37.13"],[ "2011-01-15","36.60"],[ "2011-01-15","33.41"],[ "2011-01-18","36.17"],[ "2011-01-18","33.29"],[ "2011-01-19","33.33"],[ "2011-01-19","36.62"],[ "2011-01-20","33.36"],[ "2011-01-20","35.92"],[ "2011-01-21","33.23"],[ "2011-01-21","36.72"],[ "2011-01-22","37.13"],[ "2011-01-22","33.11"],[ "2011-01-25","36.74"],[ "2011-01-25","33.58"],[ "2011-01-26","33.62"],[ "2011-01-26","36.63"],[ "2011-01-27","36.69"],[ "2011-01-27","33.39"],[ "2011-01-28","36.53"],[ "2011-01-28","33.23"],[ "2011-01-29","36.26"],[ "2011-01-29","33.28"]]
afin de pourvoir faire
Code:

1 2 3 echo $tab[1]; avec pour résultat [ "2011-01-04","44.64"],[ "2011-01-04","44.53"],[ "2011-01-05","44.90"],[ "2011-01-05","44.70"],[ "2011-01-06","45.43"],[ "2011-01-06","43.26"],[ "2011-01-07","44.02"],[ "2011-01-07","45.06"],[ "2011-01-08","43.95"],[ "2011-01-08","44.59"],[ "2011-01-11","42.71"],[ "2011-01-11","43.46"],[ "2011-01-12","43.86"],[ "2011-01-12","43.09"],[ "2011-01-13","44.15"],[ "2011-01-13","43.72"],[ "2011-01-14","43.12"],[ "2011-01-14","43.82"],[ "2011-01-15","43.67"],[ "2011-01-15","43.15"],[ "2011-01-18","43.16"],[ "2011-01-18","41.93"],[ "2011-01-19","43.36"],[ "2011-01-19","43.33"],[ "2011-01-20","42.38"],[ "2011-01-20","43.12"],[ "2011-01-21","43.09"],[ "2011-01-21","43.51"],[ "2011-01-22","44.67"],[ "2011-01-22","43.28"],[ "2011-01-25","45.45"],[ "2011-01-25","43.61"],[ "2011-01-26","43.61"],[ "2011-01-26","45.02"],[ "2011-01-27","45.01"],[ "2011-01-27","42.99"],[ "2011-01-28","43.18"],[ "2011-01-28","44.05"],[ "2011-01-29","43.50"],[ "2011-01-29","43.35"] etc...

Comme ça alors :

Code:

1
2
3
while ($row = pg_fetch_row($result)) {
	$myarray[$row['ana_id']][] =$row;
	}

01/04/2013, 17h20
triaguae

et ensuite pour afficher mon tableau
j'ai tenté

Code:

echo ($myarray[][1]);

ou

Code:

echo ($myarray[1][]);

mais sans succès

Code:

1
2
3
foreach ($myarray as $value) {
echo $value . '<br/>';
}

finalement j'ai fait ça :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
$tableau =array();
  	while ($row = pg_fetch_row($result)) 
	{ 
		$ligne = "['".$row[1]."', ".$row[2]."]";
		if ($row[0]===$cle) 
		{
			$tableau[$cle] .= ",".$ligne;
		}
		else{
			$cle=$row[0];
			$tableau[$cle].=$ligne;
		}  
 	} 
 
	var_dump($tableau);

Après qq jours de galère à me battre avec ces fichus tableaux, je bloque encore.

en fait je crois que mon tableau n'est pas terrible, cf mon autre post sur le même sujet
http://www.developpez.net/forums/d13...-google-chart/

quand je fais un var_dump j'ai

Code:

1
2
1 => string '['2011-01-04', 44.64],['2011-01-05', 44.70],['2011-01-06', 43.26],['2011-01-07', 44.02],['2011-01-08', 43.95],['2011-01-11', 43.46],['2011-01-12', 43.86],['2011-01-13', 43.72],['2011-01-14', 43.12],['2011-01-15', 43.15],['2011-01-18', 43.16],['2011-01-19', 43.36],['2011-01-20', 43.12],['2011-01-21', 43.09],['2011-01-22', 43.28],['2011-01-25', 43.61],['2011-01-26', 43.61],['2011-01-27', 42.99],['2011-01-28', 43.18],['2011-01-29', 43.35]' (length=439)
  3 => string '['2011-01-04', 290],['2011-01-05', 287],['2011-01-06', 293],['2011-01-07', 286],['2011-01-08', 311],['2011-01-11', 320],['2011-01-12', 312],['2011-01-13', 277],['2011-01-14', 290],['2011-01-15', 333],['2011-01-18', 299],['2011-01-19', 299],['2011-01-20', 321],['2011-01-21', 337],['2011-01-22', 361],['2011-01-25', 267],['2011-01-26', 286],['2011-01-27', 344],['2011-01-28', 293],['2011-01-29', 296]' (length=399)

ne devrais-je pas avoir plutot des array à la place des string??

05/04/2013, 21h52
sabotage

Ce que tu fais ne vas pas du tout.
Revois les bases de PHP sur les tableaux et regarde ce que je t'ai proposé.
08/04/2013, 16h52
triaguae

effectivemement c'était pas propre du tout!

résolu avec ça
http://www.developpez.net/forums/d13...-google-chart/