open('db_photo.sqlite3'); } } $db = new MyDB(); if(!$db){ echo $db->lastErrorMsg(); } else { $ret = $db->query("SELECT * FROM photos WHERE id LIKE '$id%' AND filename LIKE '%$filename%' AND dateoriginal LIKE '%$dateoriginal%' AND speed LIKE '$speed%' AND iso LIKE '$iso%' AND aperture LIKE '$aperture%' AND correctexpo LIKE '$correctexpo%' AND model LIKE '%$model%' AND lens LIKE '%$lens%' AND focal LIKE '%$focal%' AND metering LIKE '%$metering%' AND program LIKE '%$program%' AND wb LIKE '%$wb%' AND software LIKE '%$software%' ORDER BY $column $order"); while($row = $ret->fetchArray(SQLITE3_ASSOC) ){ $thumbnail = host() . str_replace("photos/img", "photos/thumb", $row['filename']); $full = host() . $row['filename']; $lb = data_for_lightbox($row); echo ""; echo (isset($_SESSION["user"])) ? '' . '' . '' : ''; echo "".$row['id'].""; echo "" . ""; echo "".$row['filename'].""; echo "".$row['dateoriginal'].""; echo "".$row['speed'].""; echo "".$row['iso'].""; echo "".$row['aperture'].""; echo "".$row['correctexpo'].""; echo "".$row['model'].""; echo "".$row['lens'].""; echo "".$row['focal'].""; echo "".$row['metering'].""; echo "".$row['program'].""; echo "".$row['wb'].""; echo "".$row['software'].""; echo ""; } } $db->close(); }else{ header('Location: view_bdd.php'); } ?>