1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
|
<?php
//---- DATABASE
define('DB_HOST', '127.0.0.1');
define('DB_NAME', 'tests');
define('DB_USER', 'root');
define('DB_PWD' , '');
$bdd = new PDO('mysql:host='.DB_HOST.'; dbname='.DB_NAME,DB_USER,DB_PWD, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
$query = "SELECT zipcode, id, texte FROM `lcp` order by zipcode, id";
$prepared = $bdd->prepare($query);
$prepared->execute();
//----- En mémoire
$liste = array();
while ($row = $prepared->fetch(PDO::FETCH_ASSOC)) {
if (!isset($liste[$row['zipcode']])) {
$liste[$row['zipcode']] = array();
}
$liste[$row['zipcode']][] = $row['texte'];
}
foreach ($liste as $key => $sousListe) {
$json = json_encode(array_merge(["$key"],$sousListe));
file_put_contents("fichier$key.json",$json);
}
//------ Directement sur l'ensemble des résultats
$liste = array();
$zipcode = "";
$prepared->execute();
$row = $prepared->fetch(PDO::FETCH_ASSOC);
while ($row) {
if ($zipcode != $row['zipcode']) {
$zipcode = $row['zipcode'];
$liste = array();
}
$liste[] = $row['texte'];
$row = $prepared->fetch(PDO::FETCH_ASSOC);
if ($zipcode != $row['zipcode'] || $row === false) {
$json = json_encode(array_merge([$zipcode],$liste));
file_put_contents("fichier2$zipcode.json",$json);
}
} |
Partager