How to get SQL query in JSON?

Question

PHP

Good evening.

How can I get a SQL response in JSON like this?

SELECT `cat_id`,`title` FROM `product`;

Answer 1

$sql = 'SELECT `cat_id`,`title` FROM `product`;';

$res = $mysqli->query($sql);
$rows = $res->fetch_all(MYSQLI_ASSOC); //ответ из базы

echo json_encode($rows); // json