如何在每个JSON编码行上打破新行?
例如
header('Content-Type: application/json');
// Specify your sqlite database name and path //
$dir = 'sqlite:testDB.sqlite3';
// Instantiate PDO connection object and failure msg //
$dbh = new PDO($dir) or die("cannot open database");
// Define your SQL statement //
$query = "SELECT * FROM users";
// Iterate through the results and pass into JSON encoder //
foreach ($rows as $row) {
//var_dump($row);
echo json_encode($row);
}
result(所有行在一行),
{"ID":"1","NAME":"Paul","AGE":"32","ADDRESS":"California","SALARY":"20000.0"}{"ID":"2","NAME":"Allen","AGE":"25","ADDRESS":"Texas","SALARY":"15000.0"}{"ID":"3","NAME":"Teddy","AGE":"23","ADDRESS":"Norway","SALARY":"20000.0"}{"ID":"4","NAME":"Mark","AGE":"25","ADDRESS":"Rich-Mond ","SALARY":"65000.0"}{"ID":"5","NAME":"David","AGE":"27","ADDRESS":"Texas","SALARY":"85000.0"}{"ID":"6","NAME":"Kim","AGE":"22","ADDRESS":"South-Hall","SALARY":"45000.0"}
但是我在后面(将每一行分成一行),
{"ID":"1","NAME":"Paul","AGE":"32","ADDRESS":"California","SALARY":"20000.0"}
{"ID":"2","NAME":"Allen","AGE":"25","ADDRESS":"Texas","SALARY":"15000.0"}
{"ID":"3","NAME":"Teddy","AGE":"23","ADDRESS":"Norway","SALARY":"20000.0"}
{"ID":"4","NAME":"Mark","AGE":"25","ADDRESS":"Rich-Mond ","SALARY":"65000.0"}
{"ID":"5","NAME":"David","AGE":"27","ADDRESS":"Texas","SALARY":"85000.0"}
{"ID":"6","NAME":"Kim","AGE":"22","ADDRESS":"South-Hall","SALARY":"45000.0"}
有可能吗?
这取决于你想做什么。如果您只是想要将JSON的echo
,只需在echo
的末尾添加一个<br/>
。
类似:
echo json_encode($row) . "<br/>";
或者只是添加一个换行符'n
和双引号。
echo json_encode($row) . "'n";
或者甚至用<p></p>
echo "<p>" . json_encode($row) . "</p>";