How to Convert MySQLi Results to JSON for Mobile App Development?

Convert MySQLi Results to JSON: A Lightweight Approach

In mobile application development, representing data in a lightweight, easily consumed format is crucial. JSON, a widely adopted data format, offers a concise and flexible way to structure and transmit data. Converting MySQLi query results to JSON can be beneficial for interoperability and data exchange.

In this tutorial, we'll explore how to transform MySQLi results into a JSON format to cater to your mobile application needs.

$mysqli = new mysqli('localhost','user','password','myDatabaseName');
$myArray = array();
$result = $mysqli->query("SELECT * FROM phase1");
while($row = $result->fetch_assoc()) {
    $myArray[] = $row;
}
echo json_encode($myArray);

In this example, we execute a query on the `phase1` table and store the results in an array. The `fetch_assoc()` method is used to retrieve associative arrays, where the keys are field names and the values are field values. The `json_encode()` function then converts the array into a JSON string, providing a lightweight representation of the query results.

You can modify the `fetch_assoc()` method to `fetch_row()` to obtain numeric arrays, where the values are ordered sequentially by the field numbers.

The above is the detailed content of How to Convert MySQLi Results to JSON for Mobile App Development?. For more information, please follow other related articles on the PHP Chinese website!