Hvor skal 'SQL' indsættes ???
Følgende script finder/henter billeder ved at læse i et bib (images). Ved udskrivning af de fundne billeder skal jeg have placeret nedenstående 'SQL-søgning', men jeg kan ikke finde det rigtige sted at sætte den ind, samt kan jeg heller ikke hitte ud af hvilken variabel, som er lig filnavnet.Jeg mener at SQL skal stå ved de linier, hvor THUMBS bliver listet...
include ("../sql.php");
$result = mysql_query("select * from billeder where filnavn='**hvilken variabel skal der stå her**'");
$number = mysql_num_rows($result);
while ($row = mysql_fetch_array($result)) {}
// NUMBER OF <TD> PER <TR> ( IN ENGLISH: COLUMNS IN THE PAGE :-) )
$td='7';
// BACKGROUND COLOR OF THE PAGE
$bg='white';
// SHOW THE NAME OF THE FILE?
$name='1'; // 1 = yes, 0 = no
// TITLE OF YOUR PAGE
$pagetitle='Klik på det enkelte billede for forstørrelse.';
### --- CHANGE NOTHING BELOW THIS LINE UNLESS YOU ARE OK WITH PHP --- ###
// DIRECTORY NAME
$handle=opendir('.');
// GO
$piccy=array();
$count=0;
// SCAN THE DIR
while (($filename = readdir($handle))!==false) {
// ADD IN EXTRA FILE TYPES HERE
if (substr($filename,-4) == ".jpg" || substr($filename,-4) == ".gif" || substr($filename,-4) == ".png" || substr($filename,-4) == ".JPG" || substr($filename,-4) == ".GIF" || substr($filename,-4) == ".PNG" || substr($filename,-4) == ".BMP" || substr($filename,-4) == ".bmp"){
if (substr($filename,0,6) == "thumb_"){
$piccy[$count] = $filename;
$count++;
}}}
// CLOSE DIR
closedir($handle);
// SORT THE FILES
sort($piccy);
reset($piccy);
// DISPLAY LARGE IMAGE
if ($large){
echo "<html><head><title>FVBK billedgalleri :: " .$large. "</title></head><body bgcolor=" . $bg . ">";
echo '<div align="center">';
// IS NAME SELECTED TO SHOW?
if ($name=="1") {
if (!(file_exists($large))){
echo "Ingen billeder ved dette navn.";
exit;
}
echo '<br><font face="verdana" size="1">Valgt billede: ' . $large . '</font>';}
// SHOW THE PICTURE
echo '<table width="100%" border=0 cellpadding=0 cellspacing=0>';
echo '<tr>';
echo '<td valign="middle" align="center"><a href=java script:history.back(-1)><img src="'.$large.'" alt="'.$row[beskrivelse].'" border=0></a></td>';
echo '<br>';
echo '</tr></table>';
echo '<br><br>';
echo '<a href=java script:history.back(-1)>';
echo '<font face="verdana" size="1">Tilbage til FVBK billedgalleri.</font></a>';
}
// NO LARGE PICCY, CREATE TABLE FOR THUMBNAILS:
else{
// start table, if you want cellpadding, cellspacing, colors, set them here
echo '<html><head><title> ::// FVBKs billedgalleri //::</title>';
echo '<head>';
echo "<body bgcolor=" . $bg . ">";
echo '<div align="center"><font face="verdana" size="1">' . $pagetitle . '</font><br>';
echo '<br><table width="100%" border=0 cellpadding=0 cellspacing=0>';
echo '<tr>';
// BECAUSE THE <TD> IS SET BY USER, WORK OUT THE PERCENTAGES:
$divider=ceil(100/$td);
if (($divider*$td)>100) $divider--;
// GRAB THE IMAGES
for ($l=0;$l<=sizeof($piccy)-1;$l++){
$isend = strpos((($l)/$td),".");
if (!$isend && ($l!=0)){echo "</tr>\n<tr><td colspan=$td><br></td></tr>\n<tr>\n";}
if ($l==0){echo "\n";}
// START THE <TD>
echo '<td width="'.$divider.'%" valign="middle" align="center">';
// GET THE LARGER PICTURE (IF SELECTED)
echo "<a href=\"$PHP_SELF?large=".substr($piccy[$l],6)."\">";
// DISPLAY THE THUMBNAILS
echo '<img src="'.$piccy[$l].'" alt="'.$piccy[$l].'" border=1 width="60" height="80"></a><br><br>';
// IS NAME SELECTED TO SHOW?
if ($name=="1") {
echo '<font face="verdana" size="1">'. substr($piccy[$l],6) .'</font>';}//
echo '</td>';
echo"\n";}
echo '</tr></table></div>';}
