php连接mysql数据库

<?php
   //跨域
   header('Access-Control-Allow-Origin: *');
   //UTF-8
   header("Control-type:application/json;charset='utf-8'");
   //连接数据库
   $con = mysqli_connect("localhost","root","123456","Pos");
   $con->query("set names utf8"); 
   //连接是否成功判断
	if (!$con)
	  {
	  die('Could not connect: ' . mysqli_error());
	  }
	  
	//查询语句
	$sql = "select *  from  goods";
	
	//查询结果返回
	$result = $con->query($sql);
	
	
	//设置新数组
	$arr = array();
	
	//遍历循环查询的数据
	while($row = mysqli_fetch_assoc($result))
	{
		$arr[] = $row;
	}
	
	//返回相应的数据。。。。注意：用echo返回数据
	echo json_encode($arr);
	
?>