How to convert MySQL data to JSON using PHP

<?php // Initialize variable for database credentials $dbhost = ‘hostname’; $dbuser = ‘username’; $dbpass = ‘password’; $dbname = ‘sakila’; //Create database connection $dblink = new mysqli($dbhost, $dbuser, $dbpass, $dbname); //Check connection was successful if ($dblink->connect_errno) { printf(“Failed to connect to database”); exit(); } //Fetch 3 rows from actor table $result = $dblink->query(“SELECT * FROM actor … Read more