php

<?php
header('Content-Type: application/json');
$con=mysqli_connect("localhost", "USER", "PASSWORD", "DB");
// Check connection
if (mysqli_connect_errno())
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
else
  echo "connected";

  $sql="SELECT id,url,glasses FROM DB";
  $result=mysqli_query($con,$sql);

//$row=mysqli_fetch_array($result);


$stu = array();
while( $row=mysqli_fetch_array($result,MYSQLI_ASSOC))
{
$stu[] = $row;
}


echo "{allurls : ".json_encode($stu,JSON_UNESCAPED_SLASHES | JSON_PRETTY_PRINT)."}";

?>