PHP将mysql结果集数据转化为json格式

下面的代码经过测试能正常工作

<?php

  $con=mysqli_connect(\"localhost\",$username,$password,data Name);

  // Check connection
  if (mysqli_connect_errno())
  {
   echo \"Failed to connect to MySQL: \" . mysqli_connect_error();
  }

  $query = \"the query here\";

  $result = mysqli_query($con,$query);

  $rows = array();
  while($r = mysqli_fetch_array($result)) {
    $rows[] = $r;
  }
  echo json_encode($rows);

  mysqli_close($con);
?>