PHP - How To Organize And Name Photos And Albums For A Photogallery

I'm trying to organize MySQL output in an HTML table based on individual states. Here is how the static HTML is currently displayed: http://www.u-s-s-a.org/breeders.html. Here is my working document: http://www.u-s-s-a.org/breeders.php. As you can see on the HTML page, each db row is organized into individual states. I'm only concerned about the US states, and not the countries outside of the US.

Following is the code I've been working on (directoryoutput.php):

Code: [Select]
<?php
require '/home/srob/public_html/u-s-s-a.org/config.php';

$connect = mysql_connect ($dbhost, $dbuser, $dbpass) or die ('Cannot connect: '.mysql_error());
mysql_select_db ($dbname);

$query = "SELECT * FROM directory ORDER BY flockname";
$result = mysql_query($query) or die ('Error, query failed.');

echo "<tr><td width='33%' class='style9'><p align='left' class='style12'><a name='AR'></a>Arkansas</p></td><td width='34%'>&nbsp;</td><td width='33%' valign='top'><div  align='right'><a href='#TOP'><img src='returnTOTOPGRAPHIC/RETURNTOTOP.gif' width='113' height='21' border='0' align='absmiddle'></a></div></td></tr>";

$cnt = 0;

while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
if ($cnt == 0){
echo "<tr><td valign='top' class='style9'><p align='center'><span class='style10'><strong>";
if($row['flockname']){ echo $row['flockname']; }
echo "</strong></span><strong></br>";
if($row['firstname']){ echo $row['firstname']." ".$row['lastname']."</br>"; }
if($row['address1']){ echo $row['address1']."</br>"; }
if($row['address2']){ echo $row['address2']."</br>"; }
if($row['city']){ echo $row['city'].", ".$row['state']." ".$row['zip']."</br>"; }
if($row['email1']){ echo "<a href='mailto:".$row['email1']."'>".$row['email1']."</a></br>"; }
if($row['email2']){ echo "<a href='mailto:".$row['email2']."'>".$row['email2']."</a></br>"; }
if($row['website1']){ echo "<a target='_blank' href='http://".$row['website1']."'>".$row['website1']."</a></br>"; }
if($row['website2']){ echo "<a target='_blank' href='http://".$row['website2']."'>".$row['website2']."</a></br>"; }
echo "</br></p></td>";
$cnt++;
} elseif ($cnt == 1){
echo "<td valign='top' class='style9'><p align='center'><span class='style10'><strong>";
if($row['flockname']){ echo $row['flockname']; }
echo "</strong></span><strong></br>";
if($row['firstname']){ echo $row['firstname']." ".$row['lastname']."</br>"; }
if($row['address1']){ echo $row['address1']."</br>"; }
if($row['address2']){ echo $row['address2']."</br>"; }
if($row['city']){ echo $row['city'].", ".$row['state']." ".$row['zip']."</br>"; }
if($row['email1']){ echo "<a href='mailto:".$row['email1']."'>".$row['email1']."</a></br>"; }
if($row['email2']){ echo "<a href='mailto:".$row['email2']."'>".$row['email2']."</a></br>"; }
if($row['website1']){ echo "<a target='_blank' href='http://".$row['website1']."'>".$row['website1']."</a></br>"; }
if($row['website2']){ echo "<a target='_blank' href='http://".$row['website2']."'>".$row['website2']."</a></br>"; }
echo "</br></p></td>";
$cnt++;
} elseif ($cnt == 2){
echo "<td valign='top' class='style9'><p align='center'><span class='style10'><strong>";
if($row['flockname']){ echo $row['flockname']; }
echo "</strong></span><strong></br>";
if($row['firstname']){ echo $row['firstname']." ".$row['lastname']."</br>"; }
if($row['address1']){ echo $row['address1']."</br>"; }
if($row['address2']){ echo $row['address2']."</br>"; }
if($row['city']){ echo $row['city'].", ".$row['state']." ".$row['zip']."</br>"; }
if($row['email1']){ echo "<a href='mailto:".$row['email1']."'>".$row['email1']."</a></br>"; }
if($row['email2']){ echo "<a href='mailto:".$row['email2']."'>".$row['email2']."</a></br>"; }
if($row['website1']){ echo "<a target='_blank' href='http://".$row['website1']."'>".$row['website1']."</a></br>"; }
if($row['website2']){ echo "<a target='_blank' href='http://".$row['website2']."'>".$row['website2']."</a></br>"; }
echo "</br></p></td></tr>";
$cnt = $cnt - 2;
}
}

mysql_close($connect);

?>
I'd appreciate any help on this code, including a more efficient way to parse out the MySQL db rows into 3 columns in the HTML table.

Thanks in advance!

Ryan

Hello, I'm new to the forum and I'm looking for advice.

I use a bunch of classes in namespaces that are I'm attempting to organize for autoloading. In other words, a class called \Foo\Package\Class is loaded from the file at Foo\Package\Class.php. I'm using spl_autoload for this. (If I were on 5.2 I could be using underscore-delimited pseudo-namespaces just as well; the implementation detail isn't important)

Now, I want to have multiple separate apps that use a single common library. Each app also has some classes that are local to it. How should I solve the autoloading problem?

I thought of the following approach. Is it any good?
Try autoloading from the common class library If it fails, try autoloading from the app's own local library
Part 2 of the question:

Within my apps, though, there are two types of classes: library ("vendor") classes that are only being used in that particular app so they don't need to be in the shared library, and app-specific classes that are the core of the app (so they, by definition, don't need to be in any shared library). I'd probably like to keep these two separate, so I'd need to add point #3 to the list above: search in the "core" class hierarchy of the local app. This gives 3 separate locations, and the problem is that they negate the advantages namespaces since there can be overlap. In which case one class will override the other during autoloading. So order of the above list would matter. And time would be wasted looking for a class in the first two places if it's more often in the third.

A solution I was considering is sticking to just one central library of classes (and dumping all app-local libraries there). Then, the core classes that belong to one app would be under an \AppName namespace.

I'm looking forward to some insights from the experts. How do you guys organize your class libraries?

 

Hi!

I am creating a small project somewhat like a photo gallery as my first practice page. I just would like to know how can I alter photos or file in php. Or should I just do a delete and then upload a new one?

Thanks in advance...

How should I go about keeping track of photos that a user has rated, since I only want the user to rate the photo once? Can I store arrays in a mysql database?

thanks,
George

I have some thousands of photos about nature
I ll let visitors/members to see them one by one,
but I dont want to show them the same photo again after they visit 1 week later

How can I do this ?

What I think as a solution is;
For members;
I can store the ids (like "everest01") of the photos that member has visited , and show user the most visited photos that he/she has not see for next visit. But what I m wondering is, how will I take the photos from DB ?

select * from photos WHERE id not in ( $thousandsofvisitedphotoids ) ??
I m stuck here ?

For visitors ( not members ) ;
I can set a cookie that keeps the ids of visited photos.. when visitor visits the website again, I take the cookie and sent to $thousandsofvisitedphotoids and make a query again ?

I m stuck here, How you guys do this ? what's the logic of this ?

Hello.  My website has a photo gallery of thumbnails that is created by reading all photo files in a specified directory.

Here is my function that builds the array which is ultimately displayed in the gallery...

	<?php
    function getPhotoFilesArray($photoPath){
        /**
         * Takes path to photo-directory, and returns an array containing photo-filenames.
         */
	    // Initialize Array.
    $photoFiles = array();
	    // Check for Photo-Directory.
    if (is_dir($photoPath)){
      // Photo-Directory Found.
      // Open Directory-Handle.
      $handle = opendir($photoPath);
	      // Open Photo-Directory.
      if($handle){
        // Initialize Key.
        $i = 1001;
	        // Iterate through Photo-Directory items.
        while(($file = readdir($handle)) !== FALSE){
          // Return next Filename in Directory.
          
          // Define fullpath to file/folder.
          $fullPath = $photoPath . $file;
	          // Populate Array.
	          if(!is_dir($fullPath)
              && preg_match("#^[^\.].*$#", $file)){
            // Not Directory.
            // Not Hidden File.
            // Add to array.
            $photoFiles[$i] = $file;
	            $i++;
          }//End of POPULATE ARRAY.
          
        }//End of ITERATE THROUGH PHOTO-DIRECTORY ITEMS
	        closedir($handle);
        
      }//End of OPEN PHOTO-DIRECTORY
	    }else{
      // Photo-Directory Not Found.
      // Redirect to Page-Not-Found.
      header("Location: " . BASE_URL . "/utilities/page-not-found");
	      // End script.
      exit();
	    }//End of CHECK FOR PHOTO-DIRECTORY
	        return $photoFiles;
	    }//End of getPhotoFilesArray
	?>
	

 

Everything works fine locally in DEV, but when I uploaded my website (and photos) onto a webserver, the photos are appearing in a backwards order in PROD.

This is annoying, because I want the photos displayed chronologically from oldest (first) to newest (last).

I'm not sure where the problem is happening, because each photo was taken with my camera and by nature of the camera, photo names are incremented by one, so IMG_001.jpg would have been taken FIRST, followed by IMG_002.jpg, IMG_003.jpg, and so on.

How can I fix things so the photos are displayed in the order they were physically taken AND match how things display locally in DEV?

Thanks!

 

 

I have a page for image uploads and I just realized it will only work if a user already has on picture uploaded.
If they don't it won't work.
The ones that do fail some photos anyway which is probably that they don't pass the image check but when I put echoes in there to trace what happens any user with an empty gallery can't upload a photo because the page says there is no file in the $_FILES['image']['name'] variable.

Here are the initial conditions and the form (leaving out the image processing etc since that works):
Code: [Select]
if (!isset($_SESSION['user']))
die("<br /><br /> You need to log in to view this page");

$user = sanitizeString($_SESSION['user']);
$view = sanitizeString($_GET['view']);
$dir = './grafik/users/'.$user.'/big/';
$files = scandir($dir);
$len = count($files);
$nr= $len-1;
$maxPhotos = 8;

if ($view == $user) {
echo "view is user";
if(!file_exists("grafik/users/$user")) {
mkdir("grafik/users/$user");
mkdir("grafik/users/$user/big/");}
}

if (!isset($_FILES['image']['name']))
    echo "There is no file <br />$dir - $user - $nr";
if (isset($_FILES['image']['name'])) {
echo "<br />...is a file <br />$dir - $user - $nr";
$photoName="$dir$user$nr.jpg";
move_uploaded_file($_FILES['image']['tmp_name'], $photoName);
$typeok = TRUE;

....


<form method='post' action='gallery.php?view=$user' enctype='multipart/form-data'>
Upload another photo: <br /> Max $maxPhotos allowed, max filesize 2Mb <br />
<input type='file' name='image' size='10' /><br />
<input type='submit' value='Upload' />
</form>

I can't see why it wouldn't let me but I have a feeling someone here knows why.

I was thinking of a board where you can bookmark the photos from Facebook.   It may require an App and a "Facebook Login" for the website, so one can bookmark photos from Facebook. The website would have additional features for the photos.   I thought of an "Add to ..." function.   Is this possible with the Facebook API?
Edited by glassfish, 07 October 2014 - 02:31 PM.

My photo files are not being displayed in my table?

They get sent to the mySQL database, then the server and it does grab all the other variables in the table and displays them, but the .jpg's are not shown, instead theres just the file name??

Code: [Select]
<?php 
 error_reporting(E_ALL);
 ini_set("display_errors", 1);
 echo '<pre>' . print_r($_FILES, true) . '</pre>';

 
 //This is the directory where images will be saved 
 $target = "/home/users/web/b109/ipg.removalspacecom/images/COMPANIES"; 
 $target = $target . basename( $_FILES['upload']['name']); 
 
 //This gets all the other information from the form 
 $company_name=$_POST['company_name']; 
 $basicpackage_description=$_POST['basicpackage_description']; 
 $location=$_POST['location']; 
 $postcode=$_POST['postcode'];
 $upload=($_FILES['upload']['name']); 
 
 // Connects to your Database 
 mysql_connect("server****", "username***", "password****") or die(mysql_error()) ; 
 mysql_select_db("DB") or die(mysql_error()) ; 
 
 //Writes the information to the database 
 mysql_query("INSERT INTO `Companies` (company_name, basicpackage_description, location, postcode,  upload) VALUES ('$company_name', '$basicpackage_description', '$location', '$postcode',  '$upload')") ; 
 echo mysql_error();
 
 //Writes the photo to the server 
 if(move_uploaded_file($_FILES['upload']['tmp_name'], $target)) 
 { 
 
 //Tells you if its all ok 
 echo "The file ". basename( $_FILES['upload']['name']). " has been uploaded, and your information has been added to the directory"; 
 } 
 else { 
 
 //Gives and error if its not 
 echo "Sorry, there was a problem uploading your file."; 
 } 
 ?>

"upload" is the variable that isnt displaying in my table how i want it to? Have you guys any ideas how to get it displayed correctly?

This topic has been moved to Third Party PHP Scripts.

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

Hi friends,

I have two mysql db tables, photos and album, I would like to list photos by album how do i do that ?


CREATE TABLE `album` (
 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 `album_name` varchar(95) NOT NULL,
 `album_desc` text NOT NULL,
 PRIMARY KEY (`id`)
);



CREATE TABLE `photos` (
 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 `album_id` int(11) NOT NULL,
 `thumb_name` varchar(255) NOT NULL,
 `photo_name` varchar(250) NOT NULL,
 PRIMARY KEY (`id`)
) 

I have users becoming members and allowed them to upload their own photos. But when they try to upload 5MB photos, it takes time to upload the photo, and sometimes server gives a timeout error.

I have searched and found javascripts that uploads to the server but I have noticed that it has security problems.

So how do you let users to upload photos ?

Does anyone know of a good tutorial on uploading a picture file to a folder using php and copying the name to the database in mysql?  Resizing photos on upload is helpful also...If you know it works...some I have tried do not work.

Not asking for someone to write code for me but info or tutorial would be nice.  Or maybe a code that has worked for you that is similar that I could learn from and edit...

I can upload the actual photo into the database but it slows it way down.  I have heard of loading the name only and resizing the photo and sending the actual photo to a file folder on the server.  The few codes I have tried were not successful. 

Thanks for any guidance.  I appreciate it.

I'm talking like /uploads at the main folder where index.php or index.html goes   These photos theoretically are meant to be publicly viewed anyway so what is bad about that?   Let's say profile pictures.   I mean couldn't anyone scrape facebook and "steal" profile pictures? I don't know why but I'm just wondering.