PHP - Obtaining Facebook Album Pictures

Hi there,

Can you guys/girls tell me if this is even possible:
- take pictures with eye-fi card in the camera, which uploads the images to a server
- on the server, automatically add a watermark, and post them on 3 different facebookpages

Hello everyone, I'm new here   My website was working fine until a few days ago, Up until then my str_replace('s130x130', 's800x800') and str_replace('_s', '_o') solved the picture thing. Now the images are broken (or very small) and I can find no documentation on how to enlarge the pictures. Thus my question: how do I retrieve larger pictures from the Facebook PHP SDK? Code

foreach($pagefeed['data'] as $post) {
if ($post['type'] == 'status' || $post['type'] == 'link' || $post['type'] == 'photo') {
if ($post['type'] == 'photo') {
echo "<div class='col-md-6 col-sm-6'>";
echo "<div class='thumbnail'>";
echo "<img src=" . str_replace('s130x130', 's800x800',
str_replace('_s', '_o', $post['picture'])) . " />";
echo "<div class='caption'>";
echo "<sup>Geplaatst op: " . date("d-m-Y, (strtotime($post['created_time']))) . "</sup>";

if (empty($post['message']) === false) {
echo "<p><span class='glyphicon glyphicon-comment'></span> " . $post['message'] . "</p>";}

echo "</div>";
echo "</div>";
echo "</div>";
$i++;
}
}
}

Thanks in advance!

i do think is a small mistake i making can u please have a look if u can
ok here's the problem i am trying to delete an album within the album should also delete the photos related to that album this what i tried gives this error
Delete image failed. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

my tables are
table albums fields album_id, album_name, album_owner, sub_album
table photos fields, photo_id, photo_name, photo_extension, photo_proper photo_owner, photo_date, photo_comments, photo_size, album_id

photo_proper is the name image stored in folder


<?php

define('ROOT_DIR', './');

define('PROPER', TRUE);

/**

* include common files

*/

include_once(ROOT_DIR. 'includes/common.inc.php');





// No album id has been selected

if (isset($_GET['albums'])) 

   // get the album name since we need to display

   // a message that album 'foo' is deleted

   $result = mysql_query("SELECT album_id, album_name, album_owner, sub_album

                          FROM albums

                          WHERE album_id = $album_id")

             or die('Delete image failed. ' . mysql_error());

   if (mysql_num_rows($result) == 1) {

      $row        = mysql_fetch_assoc($result);

      $album_id  = $row['album_id'];

      $album_name = $row['album_name'];



      // get the image filenames first so we can delete them

      // from the server

      $result = mysql_query("SELECT photo_id, photo_id

                             FROM photos

                             WHERE album_id = $album_id")

                or die(mysql_error());

      while ($row = mysql_fetch_assoc($result)) {

      

    define("GALLERY_IMG_DIR", "./photos/");



      

      unlink(GALLERY_IMG_DIR . $row['photo_proper']);

      unlink(GALLERY_IMG_DIR . 'thumbs/' . $row['photo_proper']);



      }



      $result = mysql_query("DELETE FROM photos

                             WHERE album_id = $album_id")

                or die('Delete image failed. ' . mysql_error());

      $result = mysql_query("DELETE FROM album

                             WHERE album_id = $album_id")

                or die('Delete album failed. ' . mysql_error());



      // album deleted successfully, let the user know about it

      echo "<p align=center>Album '$album_name' deleted.</p>";

   } else {

      echo "<p align=center>Cannot delete a non-existent album.</p>";

   }







?>



try 2 error line 5
<?php
define('ROOT_DIR', './');
define('PROPER', TRUE);
/**
* include common files
*/
include_once(ROOT_DIR. 'includes/common.inc.php');


// No album id has been selected
if (isset($_GET['albums'])) 
 {
   // get the image file name so we
   // can delete it from the server
   $sql = "SELECT album_id, album_name, album_owner, sub_album

           FROM albums

           WHERE album_id = {$_GET['albums']}";

   $result = mysql_query($sql)

             or die('Delete photo failed. ' . mysql_error());

   if (mysql_num_rows($result) == 1) {

      $row = mysql_fetch_assoc($result);

      // get the image filenames first so we can delete them
      // from the server
     $sql = "SELECT photo_id, photo_proper

           FROM photos

           WHERE photo_id = {$_GET['photos']}";

   $result = mysql_query($sql)

             or die('Delete photo failed. ' . mysql_error());

   if (mysql_num_rows($result) == 1) {

      $row = mysql_fetch_assoc($result);
      
define("GALLERY_IMG_DIR", "./photos/");

      // remove the image and the thumbnail from the server
      unlink(GALLERY_IMG_DIR . $row['photo_proper']);

      unlink(GALLERY_IMG_DIR . 'thumbs/' . $row['photo_proper']);
      
      // and then remove the database entry

      $sql = "DELETE FROM photos

              WHERE photo_id = {$_GET['photos']}";
      $result = mysql_query("DELETE FROM album
                             WHERE album_id = $album_id")
                or die('Delete album failed. ' . mysql_error());

      // album deleted successfully, let the user know about it
      echo "<p align=center>Album '$album_name' deleted.</p>";
   } else {
      echo "<p align=center>Cannot delete a non-existent album.</p>";
   }

}
}

?>

try {
echo "<br>";
foreach($dbh->query("SELECT * FROM test_shot WHERE sold=1 ORDER BY year ASC") as $row) {
	
						if($row['picture'] != "" && $row['picture'] != null)
						{
						echo "<div class='image-holder'><img src ='".$row['picture']."' width=300px /><br>";  
            			}
						if($row['year'] != "" && $row['year'] != null)
						{
							echo $row['year'];
						}
						if($row['description'] != "" && $row['description'] != null)
						{
							echo $row['description'];
						}
						if($row['sold'] == 1) {
							echo "<img src='images/sold1.png'><br>";//Add your image code here
							}
							elseif ($row['sold'] == 0) {
							
							echo "</div><br>";
						}
					}

	}	

catch (PDOException $e) {
  print $e->getMessage();
}

?>

 

Hi guys,

I am searching for the definitive way of obtaining the root directory of my app. I need to it to work on localhost and also on ALL platforms, NIX, Windows etc. I would like to do this as I wish to use it to locate all my sub directory files - includes, model etc.

For example, I may have this as my landing page:

http://www.mywebsite.com/index.php

The root directory might be:

html

The index.php might reside he

html/index.php

... but my includes files might be he

html/lib/includes

So I would be looking to obtain the root in an absolute kind of way to allow me to string together the includes sub directory in a relative kind of way.

In summary then:

1. How to obtain the root with 100% percent success, all of the time on all platforms.
2. How to string the sub directory together with 100% percent success, all of the time on all platforms.
3. Any comments on this as an approach, also welcome.

Many thanks in advance,

S