PHP - Facebook Api Bookmarking Photos?

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`)
) 

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?

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 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 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 have a php page that creates a photo gallery with thumbnails.  It is populated by code that reads all photo files from a specified photo directory.

This was working fine in DEV, but now that I have uploaded to my test web server, the pictures are in reverse order.

Not the end of the world, yet annoying, because they should be in chronological order.

Files names are straight off my iPhone (e.g. IMG_2203.jpg, IMG_2204.jpg, IMG_2207.jpg)

What is happening, and how can I fix this?

Thanks!

Hello:

I am trying to figure out how to do an UPDATE SET for a photo gallery based on the "photo_id" ... not working to well ...

Currently, it just uploads a photo but updates everything.

This is the code:
Photo_Edit.php
Code: [Select]
<?php

$photo_id = $_REQUEST['photo_id'];

?>

...


<?php


$query=mysql_query("SELECT * FROM gallery_photos WHERE photo_id = $photo_id") or die("Could not get data from db: ".mysql_error());

while($result=mysql_fetch_array($query))
{
  $photo_id=$result['photo_id'];
  $photo_filename=$result['photo_filename'];
  $photo_caption=$result['photo_caption'];
}

?>

<form enctype="multipart/form-data" action="a_Photo_Upload2.php" method="post" name="upload_form">

<input type='hidden' name='photo_id' value='<?php echo $photo_id; ?>' />


<table width='600' border='0' id='tablepadding' align='center'>


<tr>
<td width='50'>
  Photo:
<td width='550'>     
    <input name='photo_filename[]' id='my_photo' type='file' />
    <div style='clear: both;'></div>
    Current photo:
    <div style='clear: both;'></div>
    <img src="../gallery/tb_<?php echo $photo_filename; ?>" width="100px" class='imgCenter' />
    <div style='clear: both;'></div>
    <a href="javascript:void(0);" onmouseover="tooltip.show('<img src=../gallery/tb_<?php echo $photo_filename; ?> width=500 />');" onmouseout="tooltip.hide();">Larger view</a>
</td>
</tr>

<tr>
<td>
     Description:
</td>
<td>
    <textarea name='photo_caption[]' cols='100' rows='10'><?php echo $photo_caption; ?></textarea>
</td>
</tr>

<tr>
<td>
        <input type='submit' name='submit' value='Edit Product' />
</td>
</tr>
</table>
</form>


Goes to this page, where I am having the problems:

a_Photo_Upload2.php
Code: [Select]
<?php echo $photo_id; ?>

<?php
// initialization
$result_final = "";
$counter = 0;

// List of our known photo types
$known_photo_types = array( 
'image/pjpeg' => 'jpg',
'image/jpeg' => 'jpg',
'image/gif' => 'gif',
'image/bmp' => 'bmp',
'image/x-png' => 'png'
);

// GD Function List
$gd_function_suffix = array( 
'image/pjpeg' => 'JPEG',
'image/jpeg' => 'JPEG',
'image/gif' => 'GIF',
'image/bmp' => 'WBMP',
'image/x-png' => 'PNG'
);

// Fetch the photo array sent by preupload.php
$photos_uploaded = $_FILES['photo_filename'];

// Fetch the photo caption array
$photo_caption = $_POST['photo_caption'];

while( $counter <= count($photos_uploaded) )
{
if($photos_uploaded['size'][$counter] > 0)
{
if(!array_key_exists($photos_uploaded['type'][$counter], $known_photo_types))
{
$result_final .= "File ".($counter+1)." is not a photo<br />";
}

else
{

$new_id = mysql_insert_id();
$filetype = $photos_uploaded['type'][$counter];
$extention = $known_photo_types[$filetype];
$filename = $new_id.".".$extention;

mysql_query( "UPDATE gallery_photos SET photo_filename='".addslashes($filename)."' WHERE photo_id='".addslashes($new_id)."'" );

// Store the orignal file
copy($photos_uploaded['tmp_name'][$counter], $images_dir."/".$filename);

// Let's get the Thumbnail size
$size = GetImageSize( $images_dir."/".$filename );
if($size[0] > $size[1])


//{
//$thumbnail_width = 100;
//$thumbnail_height = (int)(100 * $size[1] / $size[0]);
//}
//else
//{
//$thumbnail_width = (int)(100 * $size[0] / $size[1]);
//$thumbnail_height = 100;
//}



{
//$thumbnail_width = 690;
//$thumbnail_height = (int)(500 * $size[1] / $size[0]);



$old_width = $size[0];
$old_height = $size[1];

$thumbnail_width = 690;
$thumbnail_height = ($old_height * $thumbnail_width / $old_width);





}
else
{
$thumbnail_width = (int)(690 * $size[0] / $size[1]);
$thumbnail_height = 500;
}



// Build Thumbnail with GD 1.x.x, you can use the other described methods too
$function_suffix = $gd_function_suffix[$filetype];
$function_to_read = "ImageCreateFrom".$function_suffix;
$function_to_write = "Image".$function_suffix;

// Read the source file
$source_handle = $function_to_read ( $images_dir."/".$filename ); 

if($source_handle)
{
// Let's create an blank image for the thumbnail
      //$destination_handle = ImageCreate ( $thumbnail_width, $thumbnail_height );
     
    $destination_handle = imagecreatetruecolor( $thumbnail_width, $thumbnail_height ); 
     
     

// Now we resize it

       ImageCopyResized( $destination_handle, $source_handle, 0, 0, 0, 0, $thumbnail_width, $thumbnail_height, $size[0], $size[1] );


}

// Let's save the thumbnail
$function_to_write( $destination_handle, $images_dir."/tb_".$filename );
ImageDestroy($destination_handle );
//

$result_final .= "<img src='".$images_dir. "/tb_".$filename."' style='margin-right: 20px; width: 100px;' />";


}
}
$counter++;
}

// Print Result
echo <<<__HTML_END

$result_final

__HTML_END;
?>


Can anyone show me how to make this work, OR show me a way to do this ...

Thank you.

I am looking at making a photogallery system for an online community based site. I know that we need to have unique id's , photo names and albums.

What i am looking for is:

Would it be recommended to create a directory for each user once they are registerd?
How would you go about naming and sorting photogralleries?
How would you go about naming you photos?
How would you do it?

I was thinking about a uuid kind of code: ( from php.net)

  Code: [Select]
class UUID {
  public static function v3($namespace, $name) {
    if(!self::is_valid($namespace)) return false;

    // Get hexadecimal components of namespace
    $nhex = str_replace(array('-','{','}'), '', $namespace);

    // Binary Value
    $nstr = '';

    // Convert Namespace UUID to bits
    for($i = 0; $i < strlen($nhex); $i+=2) {
      $nstr .= chr(hexdec($nhex[$i].$nhex[$i+1]));
    }

    // Calculate hash value
    $hash = md5($nstr . $name);

    return sprintf('%08s-%04s-%04x-%04x-%12s',

      // 32 bits for "time_low"
      substr($hash, 0, 8),

      // 16 bits for "time_mid"
      substr($hash, 8, 4),

      // 16 bits for "time_hi_and_version",
      // four most significant bits holds version number 3
      (hexdec(substr($hash, 12, 4)) & 0x0fff) | 0x3000,

      // 16 bits, 8 bits for "clk_seq_hi_res",
      // 8 bits for "clk_seq_low",
      // two most significant bits holds zero and one for variant DCE1.1
      (hexdec(substr($hash, 16, 4)) & 0x3fff) | 0x8000,

      // 48 bits for "node"
      substr($hash, 20, 12)
    );
  }

  public static function v4() {
    return sprintf('%04x%04x-%04x-%04x-%04x-%04x%04x%04x',

      // 32 bits for "time_low"
      mt_rand(0, 0xffff), mt_rand(0, 0xffff),

      // 16 bits for "time_mid"
      mt_rand(0, 0xffff),

      // 16 bits for "time_hi_and_version",
      // four most significant bits holds version number 4
      mt_rand(0, 0x0fff) | 0x4000,

      // 16 bits, 8 bits for "clk_seq_hi_res",
      // 8 bits for "clk_seq_low",
      // two most significant bits holds zero and one for variant DCE1.1
      mt_rand(0, 0x3fff) | 0x8000,

      // 48 bits for "node"
      mt_rand(0, 0xffff), mt_rand(0, 0xffff), mt_rand(0, 0xffff)
    );
  }

  public static function v5($namespace, $name) {
    if(!self::is_valid($namespace)) return false;

    // Get hexadecimal components of namespace
    $nhex = str_replace(array('-','{','}'), '', $namespace);

    // Binary Value
    $nstr = '';

    // Convert Namespace UUID to bits
    for($i = 0; $i < strlen($nhex); $i+=2) {
      $nstr .= chr(hexdec($nhex[$i].$nhex[$i+1]));
    }

    // Calculate hash value
    $hash = sha1($nstr . $name);

    return sprintf('%08s-%04s-%04x-%04x-%12s',

      // 32 bits for "time_low"
      substr($hash, 0, 8),

      // 16 bits for "time_mid"
      substr($hash, 8, 4),

      // 16 bits for "time_hi_and_version",
      // four most significant bits holds version number 5
      (hexdec(substr($hash, 12, 4)) & 0x0fff) | 0x5000,

      // 16 bits, 8 bits for "clk_seq_hi_res",
      // 8 bits for "clk_seq_low",
      // two most significant bits holds zero and one for variant DCE1.1
      (hexdec(substr($hash, 16, 4)) & 0x3fff) | 0x8000,

      // 48 bits for "node"
      substr($hash, 20, 12)
    );
  }

  public static function is_valid($uuid) {
    return preg_match('/^\{?[0-9a-f]{8}\-?[0-9a-f]{4}\-?[0-9a-f]{4}\-?'.
                      '[0-9a-f]{4}\-?[0-9a-f]{12}\}?$/i', $uuid) === 1;
  }
}

// Usage
// Named-based UUID.

$v3uuid = UUID::v3('1546058f-5a25-4334-85ae-e68f2a44bbaf', 'SomeRandomString');
$v5uuid = UUID::v5('1546058f-5a25-4334-85ae-e68f2a44bbaf', 'SomeRandomString');

// Pseudo-random UUID

$v4uuid = UUID::v4();

If you goto http://www.actionfx.net/bfd/photos.php you will see that im trying to show an rss feed from http://picasaweb.google.com/data/feed/base/user/114565750484201639035?alt=rss&kind=album&hl=en_US&access=public

My code works well if its just text on the rss but it does not work on this particular rss. I want the photos to show up on my page also. Im hoping someone here can be so kind to help me out with this coding. Below is my code.
Code: [Select]
<?php  
 
$feed_url = "http://picasaweb.google.com/data/feed/base/user/114565750484201639035?alt=rss&kind=album&hl=en_US&access=public";

// INITIATE CURL. 
$curl = curl_init(); 

// CURL SETTINGS. 
curl_setopt($curl, CURLOPT_URL,"$feed_url"); 
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); 
curl_setopt($curl, CURLOPT_CONNECTTIMEOUT, 0); 

// GRAB THE XML FILE. 
$xmlTwitter = curl_exec($curl); 

curl_close($curl); 

// SET UP XML OBJECT.
// Use either one of these, depending on revision of PHP.
// Comment-out the line you are not using.
//$xml = new SimpleXMLElement($xmlTwitter);
$xml = simplexml_load_string($xmlTwitter); 

// How many items to display 
$count = 10; 

// How many characters from each item 
// 0 (zero) will show them all. 
$char = 100; 

foreach ($xml->channel->item as $item) { 
if($char == 0){ 
$newstring = $item->description; 
} 
else{ 
$newstring = substr($item->description, 0, $char); 
} 
if($count > 0){ 
//in case they have non-closed italics or bold, etc ... 
echo"</i></b></u></a>\n"; 
echo" 
<div style='font-family:verdana; font-size:.12;'>  
<b>{$item->title}</b><br />
$newstring ...  <span class='redlink' id='redlink' style='redlink'> <a href='{$item->guid}'>read more</a> </span>
<br /><br /> 
</div> 
";  
} 
$count--; 
}  
?>

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.

Hi there,   Apologies if this is in the wrong section, not sure what would cover it aha     I have a client who would like to be able to update her photos in the gallery weekly, and possibly update any text on the site herself (description etc). What is the best way to go about this? She used a site builder to get it up and running, but I don't have access to the host, so I don't have access to databases or know if they allow PhP.   Would an admin panel be the best way about this?   If so, would anyone mind talking me through a rough step-by-step of the process?

I am trying to return all  the photos in the database that has the albumid associated with that table info. I can echo the $album->id (albumid) no problem, but my query it think is somewhat off. Please anyone.

Code: [Select]
<div id="photo-items" class="photo-list-item">
<?php
echo $album->id.'<br>';

// fetch album photos and ids
$database    =& JFactory::getDBO();
$query  = "SELECT * FROM jos_photos where albumid  = ".$album->id." ORDER BY ASC";
$photos = mysql_query($query);  //This returns and array of photos, but then needs to display all the photos in loop below, but it not retuning none, even if there is 100 photos in table and in the folder directory

if($photos)
{
for( $i=0; $i<count($photos); $i++ ){
$row =& $photos[$i];
?>
<div class="photo-item" id="photo-<?php echo $i;?>" title="<?php echo $this->escape($row->caption);?>">
<a href="<?php echo $row->link;?>"><img class="" src="<?php echo $row->getThumbURI();?>" alt="<?php echo $this->escape($row->caption);?>" id="photoid-<?php echo $row->id;?>" /></a>
<?php
if( $isOwner )
{
?>
<div class="photo-action">
<a href="javascript:void(0);('<?php echo $row->id;?>');" class="remove"><?php echo JText::_('CC REMOVE');?></a>
</div>
<?php
}
?>
</div>
<?php
}
}
else
{
?>
<div class="empty-list"><?php echo JText::_('CC NO PHOTOS UPLOADED YET');?>   <button class="button button-upload" href="javascript: void(0);&amp;userid=88" id="upload-photos-button">Start Uploading</button></div>
<?php
}
?>
</div>

This topic has been moved to Miscellaneous.

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

I'm working on a dating website for tablets, pretty simple stuff, mostly the purpose on my end aside from hoping to make money from traffic / photos is learning about sockets, dragging and in this case automatic payment system.   The ideal plan is that a person is limited to their verification photo and a free photo file upload (fake women haha), and then for just a meager price of $0.20 each, an extra photo slot. Ideally they are not limited to how many photos they can post hence I created a table of just photos with a username, then incrementing number of photos.   Anyway, the plan is (despite how absurd it might seem), the person buys a photo slot, which they can freely modify, it's just a photo slot, for $0.20 and this is done through paypal and their credit card information is "stored" (yeah sketchy) for future purchase convenience.   I'm just looking for some input about this, you don't have to write the code, I haven't gotten to this part yet but if anyone has experience with automatic payment system and php/sql database cause-and-effect sort of automation...   If this thread is deleted I'll understand.   I did say absurd like "Who is going to buy a photo slot?" but it's not about that, the site isn't about "how many photos" you have or "profiles" really it's a lazy dating site, just skip, skip, skip, ooohhh, message, sort of thing and additionally if a person is so inclined, sees that there are more photos of this person... I think it's a pretty good idea having a mandatory selfie that people have to take to prove they are not a bot.   This is also useful for people to "verify" this person, so they see the mandatory photo selfie then compare it to the uploaded photos which may have obviously been altered. Yeah it doesn't sound like a sound "business plan" like who wants to "be themselves" but as I said, it is primarily a learning experience on my part. And an excuse to use my tablet that I recently purchased.