Views: 152
Get Datas from Database using MySQLi Function & PHP to encode as jSON
<!DOCTYPE html>
<html>
<head>
<title>Webslesson Tutorial | Convert Data from Mysql to JSON Format using PHP</title>
</head>
<body>
<?php
$connect = mysqli_connect("localhost", "root", "", "testing");
$sql = "SELECT * FROM tbl_employee";
$result = mysqli_query($connect, $sql);
$json_array = array();
while($row = mysqli_fetch_assoc($result))
{
$json_array[] = $row;
}
/*echo '<pre>';
print_r(json_encode($json_array));
echo '</pre>';*/
echo json_encode($json_array);
?>
</body>
</html> References & Thanks to,
Video : https://www.youtube.com/watch?v=I4SRqAS7J8U
Code : https://www.webslesson.info/2016/05/convert-data-from-mysql-to-json-formate-using-php.html
