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 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61
|
<?php
// on se connecte à notre base pour recuperer les data
$base = mysql_connect ('localhost', 'root', '');
mysql_select_db ('bonjour', $base);
$req = "SELECT name FROM salut WHERE age = 2";
$req1 =mysql_query($req);
$reqbis = "SELECT statut FROM voila WHERE longueur =4"
$reqbis1 = mysql_query($reqbis)
while ($row = mysql_fetch_array($req1)) {
$output[] = $row;
//ce qui suit est le code (JSON)
if (!function_exists('json_encode'))
{
function json_encode($a=false){
if (is_null($a)) return 'null';
if ($a === false) return 'false';
if ($a === true) return 'true';
if (is_scalar($a)){
if (is_float($a)){
// Always use "." for floats.
return floatval(str_replace(",", ".", strval($a)));
}
if (is_string($a)){
static $jsonReplaces = array(array("\\", "/", "\n", "\t", "\r", "\b", "\f", '"'), array('\\\\', '\\/', '\\n', '\\t', '\\r', '\\b', '\\f', '\"'));
return '"' . str_replace($jsonReplaces[0], $jsonReplaces[1], $a) . '"';
} else
return $a;
}
$isList = true;
for ($i = 0, reset($a); $i < count($a); $i++, next($a)){
if (key($a) !== $i){
$isList = false;
break;
}
}
$result = array();
if ($isList){
foreach ($a as $v) $result[] = json_encode($v);
return '[' . join(',', $result) . ']';
}else {
foreach ($a as $k => $v) $result[] = json_encode($k).':'.json_encode($v);
return '{' . join(',', $result) . '}';
}
}
}
}
//on encode en JSON
print(json_encode ($output));
mysql_free_result ($req1);
?> |
Partager