Discussion :

[triaguae]

Bonjour

j'ai la requete suivante :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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

[sabotage]

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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

[triaguae]

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 :

Sélectionner tout - Visualiser dans une fenêtre à part

[["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 :

Sélectionner tout - Visualiser dans une fenêtre à part

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 :

Sélectionner tout - Visualiser dans une fenêtre à part

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...

[sabotage]

Comme ça alors :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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

[triaguae]

et ensuite pour afficher mon tableau
j'ai tenté

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

echo ($myarray[][1]);

ou

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

echo ($myarray[1][]);

mais sans succès

[sabotage]

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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