- json_encode: documentation ( source)
<?php
$host= '185.30.146.120';
$username = 'arenssql1';
$pwd= 'Arensi';
$db='arenssql1';
$con=mysqli_connect($host,$username,$pwd,$db) or die('Unable to connect');
if(mysqli_connect_error($con))
{
echo "Failed to connect";
}
$query=mysqli_query($con, "SELECT * FROM news");
if($query)
{
while($row-mysqli_fetch_array($query))
{
$flag[] =$row;
}
print(json_encode($flag));
}
mysqli_close(con);
?>