31 lines
1.1 KiB
PHP
31 lines
1.1 KiB
PHP
<?php
|
|
header('Content-Type: application/json');
|
|
require_once('../Connections/cmctrfdb.php');
|
|
require_once('../webassist/mysqli/rsobj.php');
|
|
|
|
try {
|
|
$conn = new mysqli($servername, $username, $password, $dbname);
|
|
if ($conn->connect_error) {
|
|
throw new Exception("Connection failed: " . $conn->connect_error);
|
|
}
|
|
|
|
$idtrf = $_GET['idtrf'];
|
|
$additionalphotoslist = new WA_MySQLi_RS("additionalphotoslist", $cmctrfdb, 0);
|
|
$additionalphotoslist->setQuery("SELECT * FROM additionalphotos WHERE additionalphotos.idtrf='$idtrf'");
|
|
$additionalphotoslist->execute();
|
|
|
|
$photos = [];
|
|
while (!$additionalphotoslist->atEnd()) {
|
|
$photos[] = [
|
|
'filename' => $additionalphotoslist->getColumnVal("filenameadditionalphotos"),
|
|
'description' => $additionalphotoslist->getColumnVal("descriptionadditionalphotos"),
|
|
'id' => $additionalphotoslist->getColumnVal("idadditionalphotos")
|
|
];
|
|
$additionalphotoslist->moveNext();
|
|
}
|
|
|
|
echo json_encode($photos);
|
|
} catch (Exception $e) {
|
|
echo json_encode(['error' => $e->getMessage()]);
|
|
}
|