get_gallery.php

get_gallery.php

<?php

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

$host = 'localhost';
$username = 'lizard';
$password = "adidas88";
$dbname = 'gallery_database';

$conn = new mysqli($host, $username, $password, $dbname);

//check connection
if($conn->connect_error) {

	  http_response_code(500);
	  echo json_encode(['error' => 'Databased connection failed: ' . $conn->connect_error]);
	  exit;
}

//extragem datale din tabel 
$SQL = "SELECT id, filename, title, size, price, caption FROM gallery ORDER BY id";

$result = $conn->query( $SQL );

if( $result ) {

      $galleryData = [];

      while($row = $result->fetch_assoc()) {

      	    $galleryData[] = $row;
      }

      header('Content-Type: application/json');

      echo json_encode($galleryData);

} else {

	  http_response_code(500);	  

	  echo json_encode(['error' => 'Query failed:' . $conn->error]);
}


//inchidem conectiunea la baza de date
$conn->close();


?>