PHP - Sort Image Gallery With Individual Links By File Name?

how to create php gallery with pagination and also add new images that control by admin

Hi guys,

Just after a bit of advice really. I want to create an image gallery. Currently, my images (which are sourced from a DB) are brought about in a loop and set in their own div, side by side. I was just thinking though: would it be better to do this with an array? Its a bit difficult coding for this just using the basic loop. Anyone have any suggestions to make this better?

PS, here is my current code:

$sql =  "SELECT * FROM imagegal";
 if ($result = mysql_query($sql)) {
    if (mysql_num_rows($result)) {
   
while($row = mysql_fetch_array($result)){
   
   echo '<span class="imagegal">';
   echo '<span><img src="' . $row['image'] . '"</span>';
   echo '</span>';
   
}}}   

Hi All,

I am looking for a php script that i can use to create a php image gallery for a client.
The script needs to allow the client to upload an image (any image type) jpg,gif,png etc and then a thumbnail needs to be created.So there will be two images the original and the thumbnail which should be stored in separate directories.

I know that this has been done before and i did some google searches ,but cant find anything that i need.


Thanks in advance.


Kind Regards,
Nathan

hello experts ! im new to php script, hope u guys able to help. thanks in advance  . I'm following a tutorial from this site: http://www.anyexample.com/programming/php/php_mysql_example__image_gallery_(blob_storage).xml

and i run the code, error occur    (i highlighted line 27) :
Parse error: syntax error, unexpected T_STRING in C:\xampp\htdocs\testing.php on line 27

This is my php script:
 <?php
$db_host = 'localhost'; // don't forget to change
$db_user = 'root';
$db_pwd = '123456';


$database = 'test';
$table = 'ae_gallery';
// use the same name as SQL table

$password = '123';
// simple upload restriction,
// to disallow uploading to everyone



////create sql-table
CREATE TABLE 'ae_gallery' (
  'id' int(11) NOT NULL AUTO_INCREMENT,
  'title' varchar(64) character SET utf8 NOT NULL,
  'ext' varchar( 8 ) character SET utf8 NOT NULL,
  'image_time' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  'data' mediumblob NOT NULL,
  PRIMARY KEY  (`id`)
);




if (!mysql_connect($db_host, $db_user, $db_pwd))
    die("Can't connect to database");

if (!mysql_select_db($ae_gallery))
    die("Can't select database");


// This function makes usage of
// $_GET, $_POST, etc... variables
// completly safe in SQL queries
function sql_safe($s)
{
    if (get_magic_quotes_gpc())
        $s = stripslashes($s);

    return mysql_real_escape_string($s);
}

// If user pressed submit in one of the forms
if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
    // cleaning title field
    $title = trim(sql_safe($_POST['title']));

    if ($title == '') // if title is not set
        $title = '(empty title)';// use (empty title) string

    if ($_POST['password'] != $password)  // cheking passwors
        $msg = 'Error: wrong upload password';
    else
    {
        if (isset($_FILES['photo']))
        {
            @list(, , $imtype, ) = getimagesize($_FILES['photo']['tmp_name']);
            // Get image type.
            // We use @ to omit errors

            if ($imtype == 3) // cheking image type
                $ext="png";   // to use it later in HTTP headers
            elseif ($imtype == 2)
                $ext="jpeg";
            elseif ($imtype == 1)
                $ext="gif";
            else
                $msg = 'Error: unknown file format';

            if (!isset($msg)) // If there was no error
            {
                $data = file_get_contents($_FILES['photo']['tmp_name']);
                $data = mysql_real_escape_string($data);
                // Preparing data to be used in MySQL query

                mysql_query("INSERT INTO {$table}
                                SET ext='$ext', title='$title',
                                    data='$data'");

                $msg = 'Success: image uploaded';
            }
        }
        elseif (isset($_GET['title']))      // isset(..title) needed
            $msg = 'Error: file not loaded';// to make sure we've using
                                            // upload form, not form
                                            // for deletion


        if (isset($_POST['del'])) // If used selected some photo to delete
        {                         // in 'uploaded images form';
            $id = intval($_POST['del']);
            mysql_query("DELETE FROM {$table} WHERE id=$id");
            $msg = 'Photo deleted';
        }
    }
}
elseif (isset($_GET['show']))
{
    $id = intval($_GET['show']);

    $result = mysql_query("SELECT ext, UNIX_TIMESTAMP(image_time), data
                             FROM {$table}
                            WHERE id=$id LIMIT 1");

    if (mysql_num_rows($result) == 0)
        die('no image');

    list($ext, $image_time, $data) = mysql_fetch_row($result);

    $send_304 = false;
    if (php_sapi_name() == 'apache') {
        // if our web server is apache
        // we get check HTTP
        // If-Modified-Since header
        // and do not send image
        // if there is a cached version

        $ar = apache_request_headers();
        if (isset($ar['If-Modified-Since']) && // If-Modified-Since should exists
            ($ar['If-Modified-Since'] != '') && // not empty
            (strtotime($ar['If-Modified-Since']) >= $image_time)) // and grater than
            $send_304 = true;                                     // image_time
    }


    if ($send_304)
    {
        // Sending 304 response to browser
        // "Browser, your cached version of image is OK
        // we're not sending anything new to you"
        header('Last-Modified: '.gmdate('D, d M Y H:i:s', $ts).' GMT', true, 304);

        exit(); // bye-bye
    }

    // outputing Last-Modified header
    header('Last-Modified: '.gmdate('D, d M Y H:i:s', $image_time).' GMT',
            true, 200);

    // Set expiration time +1 year
    // We do not have any photo re-uploading
    // so, browser may cache this photo for quite a long time
    header('Expires: '.gmdate('D, d M Y H:i:s',  $image_time + 86400*365).' GMT',
            true, 200);

    // outputing HTTP headers
    header('Content-Length: '.strlen($data));
    header("Content-type: image/{$ext}");

    // outputing image
    echo $data;
    exit();
}
?>
<html><head>
<title>MySQL Image Gallery Example</title>
</head>
<body>
<?php
if (isset($msg)) // this is special section for
                 // outputing message
{
?>
<p style="font-weight: bold;"><?=$msg?>
<br>
<a href="<?=$PHP_SELF?>">reload page</a>
<!-- I've added reloading link, because
     refreshing POST queries is not good idea -->
</p>
<?php
}
?>
<h1><i>Image gallery</i></h1>
<h2>Uploaded images:</h2>
<form action="<?=$PHP_SELF?>" method="post">
<!-- This form is used for image deletion -->

<?php
$result = mysql_query("SELECT id, image_time, title FROM {$table} ORDER BY id DESC");
if (mysql_num_rows($result) == 0) // table is empty
    echo '<ul><li>No images loaded</li></ul>';
else
{
    echo '<ul>';
    while(list($id, $image_time, $title) = mysql_fetch_row($result))
    {
        // outputing list
        echo "<li><input type='radio' name='del' value='{$id}'>";
        echo "<a href='{$PHP_SELF}?show={$id}'>{$title}</a> &ndash; ";
        echo "<small>{$image_time}</small></li>";
    }

    echo '</ul>';

    echo '<label for="password">Password:</label><br>';
    echo '<input type="password" name="password" id="password"><br><br>';

    echo '<input type="submit" value="Delete selected">';
}
?>

</form>
<h2>Upload new image:</h2>
<form action="<?=$PHP_SELF?>" method="POST" enctype="multipart/form-data">
<label for="title">Title:</label><br>
<input type="text" name="title" id="title" size="64"><br><br>

<label for="photo">Photo:</label><br>
<input type="file" name="photo" id="photo"><br><br>

<label for="password">Password:</label><br>
<input type="password" name="password" id="password"><br><br>

<input type="submit" value="upload">
</form>

Hi, I have a game image gallery using arrays to hold the current images, and when you go to a new location, like "newLocation=2" , it goes to a new array of background images. The problem is, when I try it in my browser, and I put in a new array of image for like, "location 2", The image doesn't show up, the images from location 1 show up. This is driving me nuts because I want to start adding content to the zones of my game already.LOL!. If anyone can help please I'd be very grateful. Thank you. Derek

ok, here is the code to the page, I only included the parts of the page that are relevant to what I am talking about.

Code: [Select]
<?php

session_start();




 
 
//$currentBackground='';
$echoLocation='';
$player='';
$monsters='';
$_SESSION['player'] = $player;// set this right after they log in, run this once, eventually in database.
$_SESSION['monsters']=$monsters;

$currentMonsterLevel='';//get rid of this eventually and put in session variable cuz we use it on other pages.
$currentPlayerLevel='';
$error='';
$playerHp='';//get rid and make session var.
$monsterHp='';
$echoPlayerMana='';
$echoMonster='';
$echoSpell='';
$player='';
$monsters='';
$playerMessage='';
$monsterMessage='';
$currentPLayerLevel ='';  
}
}
 

  




 //////////////////////////////////////////////////////////////////////////////////
 /////////////////////////////GAME NAVIGATION AND MONSTER SEARCH CODE NOT FINISHED//////////////////////////////////
 
$locations[0] = array();
$locations[1] = array(
'background_images' => array(
"<img src='sundragon_environments/ocean/ocean1_FRAME.jpg'/>",
"<img src='sundragon_environments/ocean/ocean1_FRAME2.jpg'/>",
"<img src='sundragon_environments/ocean/ocean1_FRAME3.jpg'/>",
"<img src='sundragon_environments/ocean/ocean1_FRAME4.jpg'/>",
"<img src='sundragon_environments/ocean/ocean1_FRAME5.jpg'/>"
),
'monster_images' => array(
"<img src='sundragon_monsters_source/water/goldfish/goldfish.png'/>",
"<img src='sundragon_monsters_source/water/eel/eel_transp_FRAME.png '/>",
"<img src='sundragon_monsters_source/water/shark/shark_transp_FRAME.png'/>",
"<img src='sundragon_monsters_source/water/octalisk/octalisk_transp_FRAME.png'/>",
"<img src='sundragon_monsters_source/water/teardrop_ocean_protector/teardrop_ocean_protector.png'/>"
)
);
$locations[2] = array(
'backgroundImages' => array(
"<img src='sundragon_environments/shore/teardrop_shore/teardrop_shore.jpg'/>"
),
'monster_images' => array(
"<img src='sundragon_monsters_source/water/goldfish/goldfish.png'/>" 
)
);

if(isset($_GET['newLocation']))
{
$_SESSION['current_location']=$_GET['newLocation'];
}
 
if(!isset($_SESSION['current_location']) && !isset($_SESSION['current_background']) && !isset($_SESSION['currentMonster']))
{
$_SESSION['current_location'] = 0;
$_SESSION['current_monster'] = 0;
    $_SESSION['current_background'] = 0;
}

if($_SESSION['current_location'] != 0) {
if(!isset($_SESSION['current_background']) && !isset($_SESSION['current_monster']))
{
$_SESSION['current_monster'] = 0;
$_SESSION['current_background'] = 0;
}

if(isset($_GET['further']))
{ //below is- inside the locations array, teardrop ocean (1) the background image is 4(example)+1 is set, then 
//do this
if(isset($locations[$_SESSION['current_location']]['background_images'][$_SESSION['current_background']+1])) {
$_SESSION['current_background']+=1;
}
if(isset($locations[$_SESSION['current_location']]['monster_images'][$_SESSION['current_monster']+1])) {
$_SESSION['current_monster']+=1;
}
}
elseif(isset($_GET['back']))
{
if(isset($locations[$_SESSION['current_location']]['background_images'][$_SESSION['current_background']-1])) {
$_SESSION['current_background']-=1;
}
if(isset($locations[$_SESSION['current_location']]['monster_images'][$_SESSION['current_monster']-1])) {
$_SESSION['current_monster']-=1;
}
} 

$currentBackground=$_SESSION['background'][$_SESSION['current_background']];
$currentMonster=$_SESSION['monster'][$_SESSION['current_monster']];
} else {
//?newLocation=1 means set it to Teardrop ocean.
$currentBackground = '
<img src="aradia.jpg" width="256" height="328" border="0" usemap="#Map" />
<map name="Map" id="Map">
   <area shape="rect" coords="5,176,81,249" href="?newLocation=1"/> 
</map>';
$currentMonster = '';
}
 
 


 

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

 
 
<title>Realm of the Sun Dragon</title>

<link rel="stylesheet" type="text/css" href="css/gamestyles.css">
<style type="text/css">
body {

 margin-top:-32px;
 padding:0;
 
color: gold;
}
table {
color: black;
}
.style8 {color: #000000}
</style>
</head>

<body oncontextmenu="return false;"> 

 

<div id="container">

<div id="monster_message"> <?php  echo "this is the monster battle and NPC talk window";?> </div>

 
 
 
 
 
 
<div id="currentWeapon">
   <img src="sundragon_interface_template/items/swords/sword_shrunk.png" width="190" height="65" /> </div>
   
 <div id="iframe_player_top_lft"  >
  <div id="left_player_stats"><table align="center" width="30" border="0">
    <tr>
     
      <td><strong>HP</strong></td>
      <td><strong><font color="red"><?php echo $playerHp;?></font></strong></td>
    </tr>
    <tr>
     
      <td><strong>MANA</strong></td>
      <td><strong><font color="green"><?php echo $echoPlayerMana;?></font></td>
    </tr>
    <tr>
     
      <td><strong>EXP</strong></td>
      <td><strong><font color="blue">999</font></strong></td>
    </tr>
    <tr>
     
      <td><strong>PLAT</strong></td>
      <td><strong><font color="white">999</font></strong></td>
    </tr>
  </table></div>
 
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p align="center"><strong><br />
      <span class="style8">Octalisk (Level <?php echo $currentMonsterLevel;?>) </span></strong>
      <br/>
       <strong><span class="style8">HP</span><font color="red"> <?php echo $monsterHp;?></font></strong> </p>
       
       
     
       
       
  <div id="spelleffectsleft" >
           
            <div class="divcenter">
              <div align="center">
                <div class="inline">
                <div align="center">spell</div>
                </div>
               
                <div class="inline">
                <div align="center">spell</div>
                </div>
               
                <div class="inline">
                <div align="center">spell</div>
                </div>
            </div>
            </div> <!--end divcenter-->
    </div><!--end spell effects-->
   
 
   
    <div id="bottomspellsleft" >
        <div class="divcenter">
            <div class="inline">
            <div align="center">spell</div>
            </div>
           
            <div class="inline">
            <div align="center">spell</div>
            </div>
           
            <div class="inline">
            <div align="center">spell</div>
            </div>
             
        </div> <!--end div center-->
 
  </div><!--end bottomspells-->
 
 
 
  </div><!-- end player div-->

 


<div id="iframe_spell_foreground"><?php echo $echoSpell;?></div>

<div id="iframe_monster_background"><?php echo $currentBackground;?></div>

<div id="iframe_transparent_monster"><?php echo $currentMonster;?></div>
 
 <!--not here-->
 

<div id="iframe_player_top_right"   >
  <table width="160" height="64" border="0" align= "center">
    <tr>
      <td width="160"><div align="center">
        <p><strong><br />
          Silverglade (Level: <?php echo $currentPLayerLevel;?>)<br />
        </strong></p>
        </div></td>
    </tr>
  </table>
 
 
 
    <div class="spelleffects" >
           
      <div class="divcenter">
           
                <div class="inline">
                <div align="center">spell</div>
                </div>
               
                <div class="inline">
                <div align="center">spell</div>
                </div>
               
                <div class="inline">
                <div align="center">spell</div>
                </div>
           
      </div>
    </div>
   
 
   
    <div class="bottomspells" >
      <div class="divcenter">
            <div class="inline">
            <div align="center">spell</div>
            </div>
           
            <div class="inline">
            <div align="center">spell</div>
            </div>
           
            <div class="inline">
            <div align="center">spell</div>
            </div>
             
      </div>
 
  </div>
 
</div>
 
 
 
 
<div id="iframe_chat_right">
the data from the chat message box will be output to this div</div>
 
  <!--not  here-->
 

 <div id="iframe_player_center_bottom" align="center" ><div style="display: inline;">
<form style="display: inline; margin: 0;" ...>
 <form style="display: inline; margin: 0;" action='gamestart_NEWEST.php' method='post'><input type='submit' name='attack' value='Attack'/><input type="submit" name="search" value="search" /><input type="submit" value="cast spell" name="spell" /><input type="submit" name="inventory" value="Inventory"/></form>
   
    <form style="display: inline; margin: 0;" method="get" action=""><input type="submit" value="go further" name="further" /> <input type="submit"value="Go back" name="back"/></form>
</form>
</div>
   
<div id="chat">
       
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">

    <strong>Message:</strong> &nbsp; &nbsp; &nbsp;
    <textarea name="message"></textarea>
    &nbsp; &nbsp; &nbsp; &nbsp;
    <input type="submit" name="submit" value="Chat">
    <input type="hidden" name="ip" value="<?php echo $_SERVER['REMOTE_ADDR']; ?>">


</form>   </div></div></div>
 
 

 <!--not here-->
 
 
<div id="log_off"> <a href="logout.php"><strong>LOG OFF</strong></a> </div>

 



<!--not here-->








</div>
</body>
</html>

The code below works well and shows all the images in a folder in reverse chronological order. But I want to limit it to a certain number of images .   This would enable me to have several pages of images.

So the first page would display the latest 50 images, the second page would show 50-100, and the third, 100-150.

Any helps on how to modify? I can create the pages manually. I just want to know how to limit the current page to a certain range.
Code: [Select]
<?php

//Your folder
$files = glob("images/*.*");

function sortnewestfilesfirst($a, $b) {
    return filemtime($b) - filemtime($a);
}
usort($files, "sortnewestfilesfirst");

$colCnt=0;
echo '<table border="0" style="width:1000px;">';

for ($i=0; $i<count($files); $i++)
  {
  $colCnt++;
  if ($colCnt==1)
  echo '<tr>';
  echo '<td width="20%" style="font-size:8.5px; font-family:arial">';

  $num = $files[$i];
   
echo ' 
  <div class="ImgBorder">
   <div class="clipout">
    <div class="clipin"> <a href="' . $num . '" rel="lightbox[all]"><img class="thumb ImgBorder" src="'.$num.'">  
</a> </div>
   </div></div>'."&nbsp;&nbsp;";


  echo '</td>';

  if ($colCnt==6)
    {
    echo '</tr>';
    $colCnt=0;
    }
  }

echo '</table>';
?>

Lets say ive got a function like this one
Code: [Select]
function getPictures() {
global $max_width, $max_height;
if ( $handle = opendir(".") ) {
$lightbox = rand();
echo '<ul id="pictures">';
while ( ($file = readdir($handle)) !== false ) {
if ( !is_dir($file) ) {
$split = explode('.', $file);
$ext = $split[count($split) - 1];
if ( ($type = getPictureType($ext)) == '' ) {
continue;
}
if ( ! is_dir('thumbs') ) {
mkdir('thumbs');
}
if ( ! file_exists('thumbs/'.$file) ) {
if ( $type == 'jpg' ) {
$src = imagecreatefromjpeg($file);
} else if ( $type == 'png' ) {
$src = imagecreatefrompng($file);
} else if ( $type == 'gif' ) {
$src = imagecreatefromgif($file);
}
if ( ($oldW = imagesx($src)) < ($oldH = imagesy($src)) ) {
$newW = $oldW * ($max_width / $oldH);
$newH = $max_height;
} else {
$newW = $max_width;
$newH = $oldH * ($max_height / $oldW);
}
$new = imagecreatetruecolor($newW, $newH);
imagecopyresampled($new, $src, 0, 0, 0, 0, $newW, $newH, $oldW, $oldH);
if ( $type == 'jpg' ) {
imagejpeg($new, 'thumbs/'.$file);
} else if ( $type == 'png' ) {
imagepng($new, 'thumbs/'.$file);
} else if ( $type == 'gif' ) {
imagegif($new, 'thumbs/'.$file);
}
imagedestroy($new);
imagedestroy($src);
}
echo '<li><a href="'.$file.'" rel="lightbox['.$lightbox.']">';
echo '<img src="thumbs/'.$file.'" alt="" />';
echo '</a></li>';
}
}
echo '</ul>';
}
}What it does is:
It checks for files(images) in a directory, check for file types jpg, png or gif cuz I work on gd library and it supports only these 3 type of images and make thumbnails. My problem is I cant change the directory of images, after I do that I just got error or it doesnt read images at all. I tried

Code: [Select]
$dir = "/galerija/";
if ( $handle = opendir($dir) )
But nothing happens, it just leaves me blank space(as I said above it doesnt read images at all)

Hi ,
I got "High Slide Script" for making photogallery ..
The problem is that code has no admin panel to upload images and their description .
All you make that you write image path into html code of its index page..

I thought to make admin panel by a small database you enter the image path uploaded and description .

and the code has a loop to read this data throught a php code .

I attached what I made .

The problem is : why my images doesn't appear ???

NB:
the original script in the file named : highslide-custom-example.htm

my code is in the file : highslide-custom-example.php

I attached the DB also..

Here is the attachments :

http://www.seed-share.com/6mghkdpg0ywj

Thanks

I'm tired and just about given up. Can anybody help me?


Code: [Select]
<?php
$objConnect = mysql_connect("localhost","","root") or die(mysql_error());
$objDB = mysql_select_db("sdf");
$pic2 = "SELECT * FROM images";
if (!isset($_GET['Page'])) $_GET['Page']='0';
$pic1 = mysql_query($pic2);
$Num_Rows = mysql_num_rows($pic1);
$Per_Page = 16;   // Per Page
$Page = $_GET["Page"];
if(!$_GET["Page"])
{$Page=1;}
$Prev_Page = $Page-1;
$Next_Page = $Page+1;
$Page_Start = (($Per_Page*$Page)-$Per_Page);
if($Num_Rows<=$Per_Page)
{$Num_Pages =1;}
else if(($Num_Rows % $Per_Page)==0)
{$Num_Pages =($Num_Rows/$Per_Page) ;}
else
{$Num_Pages =($Num_Rows/$Per_Page)+1;
$Num_Pages = (int)$Num_Pages;}
$pic2 .=" order  by thumbnailID ASC LIMIT $Page_Start , $Per_Page";
$pic1  = mysql_query($pic2);
$cell = 0;
$link1 = "SELECT * FROM images";
$result_link1 = mysql_query($link1);
$link = mysql_fetch_array($result_link1);
$alt1 = "SELECT * FROM images";
$alt = mysql_fetch_array(mysql_query($alt1));
echo '
    <div id="tablediv">
      <table border="0" cellpadding="17" cellspacing="0" class="table">
        <tr>';

  while($pic = mysql_fetch_array($pic1)) {

    if($cell % 4 == 0) {
      echo '</tr><tr>';
    }

    if($cell == 2) {
      echo '
        <td>
          fillerspace
        </td>';
    } elseif ($cell == 3) {
      echo '
        <td>
Fillerspace2
        </td>';
    } else {
      echo '
        <td>
          <a href="/' . $link["link"] . '.php">
            <div class="image">
              <img src="https://s3.amazonaws.com/image/' . $pic["pic"] . '.png" 
                   alt="' . $alt["alt"] . '" 
                   height="200" 
                   width="200" 
              />
            </div>
          </a>
        </td>'; 
    }
    $cell++;
  }
  echo '</tr></table></div>';
?>
Basically, there are a couple of faults with this code. I didn't include the pagination part, but there is, for simplicity. But right now, when I insert a new record such as this:
INSERT INTO `images` VALUES (' ', 'blog', 'yo', '6', 'hello', '2011-02-15T07:24:17Z')
The columns go in order  of thumbnailID, folder, link, pic, alt, and time.^^^^^^^^

several problem arises. One, the new record is not displayed as the newest entry on my site. So the record is actually placed in one of the paginated pages. How can I reverse the order? The other thing is, it seems like my pic column is the only thing being understood. You see, when I inserted the above record, I checked my site and saw the pic 6, but the link wasn't 'yo', and the alt wasn't 'hello'. Why is that?

By the way, my host is awfully terrible. Maybe it's just having a major delay in reading the link and alt? I don't know. That would be the only reasonable answer, unless my code is off.

Thank you, and I'll check 10hours from now.

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=332275.0

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=348417.0

I have a very simple piece of code to create a grid based gallery. The thumbnails are loaded from a single directory and are name 1.jpg... 2.jpg... 3.jpg etc

At the moment the images appear to be loaded in randomly. I want them to load in numerically in terms of their filename. I know I may need to use 'sort' or 'natsort' but where in the code?

Thanks for any help you can give me

Code: [Select]
<?

$images = "Images/Bag Thumbs/"; # Location of small versions

$big    = "ruxxwomens.php?id="; # Location of big versions (assumed to be a subdir of above)

$cols   = 4; # Number of columns to display

if ($handle = opendir($images)) {
   while (false !== ($file = readdir($handle))) {
       if ($file != "." && $file != ".." && $file != rtrim($big,"/")) {
          $files[] = $file;
       }
   }
   closedir($handle);
}



$colCtr = 0;
echo '<table width="800" cellspacing="0" cellpadding="0" border="0"><tr>';
foreach($files as $file)
{
  if($colCtr %$cols == 0)

    echo '</tr><tr>';

  echo '<td align="center"><a href="' . $big . $file . '"><img src="' . $images . $file . '" cellspacing="0" cellpadding="0" border="0"></a></td>';

  $colCtr++;
}
echo '</table>' . "\r\n";

?>

Hi the file file upload whenever i upload an image to main directory it saves one image into photos folder and copy another into thumbs folder but whenever i upload image to a different album (not main directory) it doesnt copy the other image to thumbs folder what i'm i doing wrong

this is the line that i chose the folder...

function make_locations ($locs)
{
$html = '<select name="locations" class="input"><option value="0">-- Main Directory --</option>';
foreach ($locs AS $key => $value)
{
$html .= '<option value="' .$value['album_id']. '">' .addslashes($value['album_name']). '</option>';
}
$html .= '</select>';

return $html;
}


this is the whole code

<?php
/**
* create a sub album directory for photos
* to be stored in
*/
function create_album ($album_name, $sub_album = 0)
{
global $db;

$sql = "INSERT INTO " .ALBUMS_TABLE. "
(
album_name,
sub_album
)
VALUES
(
'" .addslashes($album_name). "',
" .intval($sub_album). "
)";

if ($db->query($sql))
{
return TRUE;
}
else
{
return FALSE;
}
}

/**
* get a list of sub albums
*/
function get_albums ($sub_album = 0)
{
global $db;

$sql = "SELECT *
FROM " .ALBUMS_TABLE. "
WHERE sub_album = " .intval($sub_album);

$db->query($sql);

// initialise album storage
$albums = array();
while ($row = $db->fetch())
{
$albums[] = $row;
}

return $albums;
}

/**
* get a list of photos within an album
*/
function get_photos ($album = 0)
{
global $db;

$sql = "SELECT *
FROM " .PHOTOS_TABLE. "
WHERE album_id = " .intval($album). "
ORDER BY photo_id ASC";

$db->query($sql);

// initialise album storage
$photos = array();
while ($row = $db->fetch())
{
$photos[] = $row;
}

return $photos;
}

/**
* get a large version of a particular photo
*/
function get_large ($photo, $album = 0, $next = '')
{
global $db, $template, $account_details;

// shall we get the next / previous photo
switch ($next)
{
case "next" :

$next_sql = "AND photo_id > " .intval($photo). " ORDER BY photo_id ASC";
break;

case "previous" :

$next_sql = "AND photo_id < " .intval($photo). " ORDER BY photo_id DESC";
break;

default :

$next_sql = "AND photo_id = " .intval($photo);
break;
}

$sql = "SELECT *
FROM " .PHOTOS_TABLE. "
WHERE album_id = " .intval($album). "
" .$next_sql. "
LIMIT 1";

$db->query($sql);
if ($db->num_rows() == 0)
{
return '';
}
else
{
$photo_info = $db->fetch();

// note the total directory
$location = 'photos/' .$photo_info['photo_proper'];

// now we need to resize
list($width, $height) = getimagesize($location);
if ($width < 300)
{
$new_width = $width;
$new_height = $height;
}
elseif ($width > $height)
{
$new_width = 300;
$new_height = $height * ($new_width / $width);
}
elseif ($width < $height)
{
$new_width = $width * ($new_height / $height);
$new_height = 300;
}

// work out the next link
$next = '<a href="portfolio.php?p=' .$photo_info['photo_id']. '&a=' .$photo_info['album_id']. '&next=next">Next</a>';
$previous = '<a href="portfolio.php?p=' .$photo_info['photo_id']. '&a=' .$photo_info['album_id']. '&next=previous">Previous</a>';

return '<div id="largephoto"><img src="' .$location. '" height="' .$new_height. '" width="' .$new_width. '" class="large"><br /><div id="prevnext">' .$previous. ' :: ' .$next. '</div></div>';
}
}

/**
* get an array of locations
*/
function get_locations ()
{
global $db;

// initialise array
$locations = array();

// select albums
$sql = "SELECT

album_id,
album_name

FROM " .ALBUMS_TABLE;

$db->query($sql);
while ($row = $db->fetch())
{
$locations[] = $row;

}

return $locations;
}

/**
* make the locations table
*/
function make_locations ($locs)
{
$html = '<select name="locations" class="input"><option value="0">-- Main Directory --</option>';
foreach ($locs AS $key => $value)
{
$html .= '<option value="' .$value['album_id']. '">' .addslashes($value['album_name']). '</option>';
}
$html .= '</select>';

return $html;
}

/**
* delete an album from the database
* does not delete the photos in it
*/
function delete_albums ($album_ids)
{
global $db;

if (sizeof($album_ids) > 0)
{
$sql = "DELETE FROM " .ALBUMS_TABLE. "
WHERE album_id IN (" .implode(',', $album_ids). ")";

if ($db->query($sql))
{
return TRUE;
}
}

return FALSE;
}

/**
* delete a set of photos
*/
function delete_photos ($photo_ids)
{
global $db;

if (sizeof($photo_ids) > 0)
{
// select photo names for deletion
$sql = "SELECT photo_proper
FROM " .PHOTOS_TABLE. "
WHERE photo_id IN (" .implode(',', $photo_ids). ")";

$db->query($sql);

$unlink_ids = array();
while ($row = $db->fetch())
{
$unlink_ids[] = $row['photo_proper'];
}

// now delete the photos
if (sizeof($unlink_ids) > 0)
{
$sql = "DELETE FROM " .PHOTOS_TABLE. "
WHERE photo_id IN (" .implode(',', $photo_ids). ")";

if ($db->query($sql))
{
// remove photo from directory
for ($i = 0; $i < sizeof($unlink_ids); $i++)
{
unlink("photos/" .$unlink_ids[$i]);
unlink("photos/thumbs/" .$unlink_ids[$i]);
}
return TRUE;
}
}
}

return FALSE;
}

/**
* upload a set of files
*/
function upload_files ($save_dir = '', $album = 0)
{
global $db;

// check the save dir is writable
if (!is_writable($save_dir))
{
return FALSE;
}

// specify allowed file types
$allowed_types = array (

'image/jpg',
'image/jpeg',
'image/pjpeg',
'image/gif'

);

// keep a list of uploaded files
$uploaded = array();

// store bytes uploaded
$total_bytes = 0;

// go through the list of files
while (list($key, $value) = each($_FILES['userfile']['name']))
{
// check file has been passed
if (!empty($value))
{
// find extension
$extension = substr($_FILES['userfile']['name'][$key], strpos($_FILES['userfile']['name'][$key],".") + 1);

// time + $key for name
$name = time(). "_" .$key. "." .$extension;

// save url
$add = $save_dir. "/" .$name;

if (move_uploaded_file($_FILES['userfile']['tmp_name'][$key], $add))
{
chmod($add, 0777);

// add photo to database
create_photo($_FILES['userfile']['name'][$key], $name, $album);
}
}
}

return TRUE;
}

/**
* insert photo details into the database
*/
function create_photo ($photo_name, $key_name, $album = 0)
{
global $db;

// get the filesize
if (!$size = filesize("photos/" .$key_name))
{
$size = 0;
}

// insert the photo in the database
$sql = "INSERT INTO " .PHOTOS_TABLE. "
(
photo_name,
photo_date,
photo_proper,
photo_size,
album_id
)
VALUES
(
'" .addslashes($photo_name). "',
" .time(). ",
'" .addslashes($key_name). "',
" .intval($size). ",
" .$album. "
)";

if ($db->query($sql))
{
return TRUE;
}
else
{
return FALSE;
}
}

/**
* get a complete raw copy of the directory
*/
function get_dir_contents ($dir)
{
// declare content array
$contents = array();

// check gallery exists
if (is_dir($dir))
{
if ($handle = opendir($dir))
{
while (FALSE !== ($file = readdir($handle)))
{
if ($file != '.' && $file != '..' && $file != 'thumbs')
{
if (file_exists($dir. '/thumbs/' .$file) || thumbnail($file, $dir. '/' .$file, $dir. '/thumbs'))
{
$contents[] = $dir. '/thumbs/' .$file;
}
else
{
$contents[] = 'no_image.gif';
}
}
}
}
}

return $contents;
}

/**
* create a thumbnail of a photo and store it
* in the thumbs directory
*/
function thumbnail ($filename, $source_file, $destination, $new_h = 75, $new_w = 75)
{
if (!is_file($source_file))
{
return FALSE;
}

// get the image details
list($old_w, $old_h, $type) = getimagesize($source_file);

// create source image
switch($type)
{
case 1:

$source = @imagecreatefromgif($source_file);
break;

case 2:

$source = @imagecreatefromjpeg($source_file);
break;

case 3:

$source = @imagecreatefrompng($source_file);
break;

default :

return FALSE;
}

// work out dimensions
if ($old_w < $old_h)
{
$thumb_w = $new_w;
$thumb_h = $old_h * ($new_h / $old_w);
}
elseif ($old_w > $old_h)
{
$thumb_w = $old_w * ($new_w / $old_h);
$thumb_h = $new_h;
}
elseif ($old_w == $old_h)
{
$thumb_w = $new_w;
$thumb_h = $new_h;
}
$thumb = @imagecreatetruecolor($thumb_w, $thumb_h);

// create image
imagecopyresized($thumb, $source, 0, 0, 0, 0, $thumb_w, $thumb_h, $old_w, $old_h);

// check we have a proper destination
if (!is_dir($destination))
{
mkdir($destination, 0777);
}

// save image
switch ($type)
{
case 1:
case 2:

imagejpeg($thumb, $destination. '/' .$filename);
break;

case 3:

imagepng($thumb, $destination. '/' .$filename);
break;
}

// memory saving
imagedestroy($thumb);
imagedestroy($source);

// thumbnail created successfully
return TRUE;
}

/**
* make the table to show the directories and photos
*/
function make_table ($list, $type, $row = 3)
{
// initialize gallery html array
$gallery_html = array();

// check if we have a list > 0
if ($size = sizeof($list))
{
switch ($type)
{
case "GALLERIES" :

$gallery_html[] = '<div id="galleries">';
break;

case "PHOTOS" :
case "RAW" :

$gallery_html[] = '<div id="photos">';
break;
}

// loop through list
for ($i = 0; $i < sizeof($list); $i++)
{
// shall we open a new list
if ($i % $row == 0)
{
$gallery_html[] = '<ul>';
}

// add to list
switch ($type)
{
case "GALLERIES" :

// create the delete link
$delete_link = '';
if ($_SESSION['logged_in'])
{
$delete_link = '[ <a href="admin.php?mode=deletealbum&a=' .$list[$i]['album_id']. '">Delete</a> ]';
}


$gallery_html[] = '<a href=portfolio.php?albums='.$list[$i]['album_id'].'><img src="folder.gif" class="directory"><br />' .addslashes($list[$i]['album_name']). '</a><br />' .$delete_link. '</li>';
break;

case "PHOTOS" :

// construct photo name
$name = $list[$i]['photo_proper'];

// construct location
$location = "photos/";

// create thumbnail
if (!file_exists($location. "/thumbs/" .$name))
{
thumbnail($name, $location. "/" .$name, $location. "/thumbs/");
}

// construct date
$date = '<div class="date">' .date("d/m G:ia", $list[$i]['photo_date']). '</div>';

// create the delete link
$delete_link = '';
if ($_SESSION['logged_in'])
{
$delete_link = '[ <a href="admin.php?mode=deletephoto&p=' .$list[$i]['photo_id']. '">Delete</a> ]';
}

// image information
list($width, $height) = getimagesize($location . $list[$i]['photo_proper']);

// add to the html
$gallery_html[] = '<li><a href="' .$location . $list[$i]['photo_proper']. '" rel="lightbox[racing]" title="Photos"><img src="' .$location. "/thumbs/" .$name. '" class="picture"><br />View</a><br />' .$delete_link. '</li>';
break;

case "RAW" :

$gallery_html[] = '<li><img src="' .$list[$i]. '" class="picture"></li>';
break;
}

// shall we close the list
if ( ($i + 1) % $row === 0 || ($i + 1) == $size)
{
$gallery_html[] = '</ul>';
}
}

$gallery_html[] = '</div>';
}

return implode('', $gallery_html);
}
?>

How can I use an include file that has a list of links in any directory at my website without breaking those links?

You can see it in action here...

The links in this directory work...

https://www.billelgin.com/primary-directory/

The links in this directory (being created from the same include file) do not work...

https://www.billelgin.com/primary-directory/subsection-one/

Obviously the problem is the include file is being called from different directories, so it's breaking the relative path links in the include file, but what can I do to fix it?

You can download the example directory structure here...

https://www.billelgin.com/EXAMPLE.zip

Hi.. been a while since I have touched php and need some help. What I am trying to do is have my links pull text from separate php files, and load them into main table. Here is my old php code..used to work..
I had my index.php with my website template on it. In the table I want my info to appear i put this code.

<?php /* START MAIN AREA HERE */
if($news) include("news.php");
elseif($bio) include("bio.php");
elseif($draw) include("draw.php");
elseif($pic) include("pic.php");
else include("news.php");
/* END HERE */?>

My link looks like this.

<A HREF="?news=x"
            ONMOUSEOVER="changeImages('home', 'images/home-over.gif'); return true;"
            ONMOUSEOUT="changeImages('home', 'images/home.gif'); return true;">
            <IMG NAME="home" SRC="images/home.gif" WIDTH=69 HEIGHT=31 BORDER=0 ALT=""></A>

Any help much appreciated!