PHP กับ MySQLi การสร้าง JSON จาก MySQL Database ด้วยฟังก์ชั่น (function) ของ mysqli

CREATE TABLE IF NOT EXISTS `customer` (
  `CustomerID` varchar(4) NOT NULL,
  `Name` varchar(50) NOT NULL,
  `Email` varchar(50) NOT NULL,
  `CountryCode` varchar(2) NOT NULL,
  `Budget` decimal(18,2) NOT NULL,
  `Used` decimal(18,2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `customer`
--

INSERT INTO `customer` (`CustomerID`, `Name`, `Email`, `CountryCode`, `Budget`, `Used`) VALUES
('C001', 'Win Weerachai', '[email protected]', 'TH', '1000000.00', '600000.00'),
('C002', 'John  Smith', '[email protected]', 'UK', '2000000.00', '800000.00'),
('C003', 'Jame Born', '[email protected]', 'US', '3000000.00', '600000.00'),
('C004', 'Chalee Angel', '[email protected]', 'US', '4000000.00', '100000.00');

<?php
	ini_set('display_errors', 1);
	error_reporting(~0);

	$serverName = "localhost";
	$userName = "root";
	$userPassword = "root";
	$dbName = "mydatabase";

	$conn = mysqli_connect($serverName,$userName,$userPassword,$dbName);
	$sql = "SELECT * FROM customer";
	$query = mysqli_query($conn,$sql);
	if (!$query) {
		printf("Error: %s\n", $conn->error);
		exit();
	}
	$resultArray = array();
	while($result = mysqli_fetch_array($query,MYSQLI_ASSOC))
	{
		array_push($resultArray,$result);
	}
	mysqli_close($conn);

	echo json_encode($resultArray);
?>

<?php
	ini_set('display_errors', 1);
	error_reporting(~0);
	
	function createJSON()
	{
		$serverName = "localhost";
		$userName = "root";
		$userPassword = "root";
		$dbName = "mydatabase";

		$conn = mysqli_connect($serverName,$userName,$userPassword,$dbName);
		$sql = "SELECT * FROM customer";
		$query = mysqli_query($conn,$sql);
		if (!$query) {
			printf("Error: %s\n", $conn->error);
			exit();
		}
		$resultArray = array();
		while($result = mysqli_fetch_array($query,MYSQLI_ASSOC))
		{
			array_push($resultArray,$result);
		}
		mysqli_close($conn);

		return json_encode($resultArray);
	}

	// Read JSON Decode
	$jsonCode = createJSON();
	$jsonDecode = json_decode($jsonCode, true);

	foreach ($jsonDecode as $result)
	{
		echo $result['CustomerID']." ";
		echo $result['Name']." ";
		echo $result['Email']." ";
		echo $result['CountryCode']." ";
		echo $result['Budget']." ";
		echo $result['Used']." ";
		echo "<br>";
	}
?>

<?php
	ini_set('display_errors', 1);
	error_reporting(~0);

	$serverName = "localhost";
	$userName = "root";
	$userPassword = "root";
	$dbName = "mydatabase";
	
	$strCustomerID = "C001";

	$conn = mysqli_connect($serverName,$userName,$userPassword,$dbName);
	$sql = "SELECT * FROM customer WHERE CustomerID = '$strCustomerID' ";
	$query = mysqli_query($conn,$sql);
	if (!$query) {
		printf("Error: %s\n", $conn->error);
		exit();
	}
	$result = mysqli_fetch_array($query,MYSQLI_ASSOC);
	mysqli_close($conn);

	echo json_encode($result);
?>

<?php
	ini_set('display_errors', 1);
	error_reporting(~0);
	
	function createJSON()
	{
		$serverName = "localhost";
		$userName = "root";
		$userPassword = "root";
		$dbName = "mydatabase";
		
		$strCustomerID = "C001";

		$conn = mysqli_connect($serverName,$userName,$userPassword,$dbName);
		$sql = "SELECT * FROM customer WHERE CustomerID = '$strCustomerID' ";
		$query = mysqli_query($conn,$sql);
		if (!$query) {
			printf("Error: %s\n", $conn->error);
			exit();
		}
		$result = mysqli_fetch_array($query,MYSQLI_ASSOC);
		mysqli_close($conn);

		return json_encode($result);
	}

	// Read JSON Decode
	$jsonCode = createJSON();
	$jsonDecode = json_decode($jsonCode, true);

	echo $jsonDecode['CustomerID']."<br/>";
	echo $jsonDecode['Name']."<br/>";
	echo $jsonDecode['Email']."<br/>";
	echo $jsonDecode['CountryCode']."<br/>";
	echo $jsonDecode['Budget']."<br/>";
	echo $jsonDecode['Used']."<br/>";
?>