How to convert mysqli result to JSON? [duplicate]

by

Simply create an array from the query result and then encode it

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

output like this:

[
    {"id":"31","name":"product_name1","price":"98"},
    {"id":"30","name":"product_name2","price":"23"}
]

If you want another style, you can change fetch_assoc() to fetch_row() and get output like this:

[
    ["31","product_name1","98"],
    ["30","product_name2","23"]
]

More Related Contents:

  1. Converting MySQL result array to JSON [duplicate]
  2. I keep getting these kind of errors in terms of HttpUrlConnection and BackGroundTask in android
  3. mysqli or die, does it have to die?
  4. MySQL vs MySQLi when using PHP [closed]
  5. Reference: Why are my “special” Unicode characters encoded weird using json_encode?
  6. PHP error: “Cannot pass parameter 2 by reference”
  7. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  8. Processing large JSON files in PHP
  9. PHP Array to JSON Array using json_encode(); [duplicate]
  10. PHP json_encode class private members
  11. How to create a JSON object
  12. Sending JSON to PHP using ajax
  13. mysqli fetch_all() not a valid function?
  14. Headers and client library minor version mismatch
  15. Parsing JSON with PHP
  16. MySQLi Bind Param with an array for IN [duplicate]
  17. How to generate JSON data with PHP?
  18. PHP + MySql + Stored Procedures, how do I get access an “out” value?
  19. How to loop through PHP object with dynamic keys [duplicate]
  20. mysqli + xdebug breakpoint after closing statement result in many warnings
  21. INSERT query produces “Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given”
  22. php password_verify() hash and pass won’t match
  23. How to remove backslash on json_encode() function?
  24. How do I loop through JSON array
  25. How to iterate through a nested stdClass? [duplicate]
  26. Is there any way to print the actual query that mysqli->execute() makes?
  27. When should I close a database connection in PHP?
  28. Json: PHP to JavaScript safe or not?
  29. Why are escape characters being added to the value of the hidden input
  30. Read JSON Data Using PHP [duplicate]

Leave a Comment