<? //db connection info; insert your database information here
$host = 'localhost';
$db   = 'YOUR DATABASE NAME'; 
$user = 'YOUR DATABASE USER';
$pass = 'YOUR DATABASE PASSWORD'; 
$charset = 'utf8';

$dsn = "mysql:host=$host;dbname=$db;charset=$charset";
$opt = [
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    PDO::ATTR_EMULATE_PREPARES   => false,
];
$pdo = new PDO($dsn, $user, $pass, $opt);//Preventing Sql Injection with prepared statements https://phpdelusions.net/pdo
$stmt = $pdo->prepare("SELECT * FROM search ORDER BY category ASC");  //can update table name and field names to match your database info
$stmt->execute();
$json_response = array();

//put database fields into JSON object
foreach ($stmt->fetchAll() as $row) {		
	$json_response['photographs'][] = [
		'name' => $row['name'],
		'filename' => $row['filename'],
		'desc' => $row['description'],
		'category' => $row['category'],
	];
}
echo 'callback('.json_encode($json_response).');';?>