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/>';
}

[triaguae]

finalement j'ai fait ça :

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
$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);

[triaguae]

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 :

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

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

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

[triaguae]

effectivemement c'était pas propre du tout!

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