PHP - Creation Of Image Album Website

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>";
   }

}
}

?>

I am attempting to create an image and I have run into a snag.  I want to add both text and another image to the image I am making.  Here is the code so far minus unnecessary parts:

header ("Content-type: image/png");
$name = $fetch_user['username'];
$rank = $fetch_rank['rank_title'];
$img_url = 'path''. $fetch_rank['rank_image'];
$im = @imagecreatefrompng("$img_url")
or die("Cannot Initialize new GD image stream");
// try changing this as well
$font = 4;
$width = imagefontwidth($font) * strlen($string) ;
$height = imagefontheight($font) ;
$im = imagecreatefrompng("image.png");
$x = imagesx($im) - $width ;
$y = imagesy($im) - $height;
$backgroundColor = imagecolorallocate ($im, 255, 255, 255);
$textColor = imagecolorallocate ($im, 255, 255, 255);
//imagestring ($im, $font, $x, $y,  $string, $textColor);
imagestring ($im, $font, 100, 10,  $name, $textColor);
imagestring ($im, $font, 100, 22,  $rank, $textColor);
imagepng($im);

Everything works UNTIL I added in this part:

$im = @imagecreatefrompng("$img_url")
or die("Cannot Initialize new GD image stream");

Any idea what I am doing wrong? All that comes up is "Cannot Initialize new GD image stream"; and I know the URL's work.

I am trying to create a basic image with GD library, but my browser says that the image cannot be displayed because it contains errors... I have no idea why.  Here's my code:

Code: [Select]
switch($_GET['case']){

case "progressbar":

header('Content-Type: image/jpeg');

$barWidth = 6;
$barHeight = 14;
$barPadding = 2;

$imageWidth = ($barWidth * 10) + (10 * $barPadding);

$imageHeight = ($barHeight + ($barPadding * 2));

$img = @imagecreate($imageWidth, $imageHeight);
$imgBorder = imagecolorallocate($img, 0, 0, 0);

//imagefilledrectangle($img, 1, $imageHeight -1, $imageWidth - 1, $imageHeight - 1, $imgBorder);
$output = "Hello, world!";

imagestring($img, 1, 4, 4, $output, $imgBorder);
imagejpeg($img);
imagedestroy($img);

break;

}
I have a file called image.php that i use to create images and I use the URL image.php?case=progressbar.

Hey guys I have a small issue, i have an upload that resizes the image into thumbnail by max width and ratios the width based on that.

Here is my code

$width = 100; //*** Set a Fix Width & Height (Auto caculate) ***//

$size = GetimageSize($images);

$height = round($width * $size[1] / $size[0]);

$images_orig = imagecreatefromjpeg($images);

$photoX = ImagesX($images_orig);

$photoY = ImagesY($images_orig);

$images_fin = ImageCreateTrueColor($width, $height);

ImageCopyResampled($images_fin, $images_orig, 0, 0, 0, 0, $width + 1, $height + 1, $photoX, $photoY);

ImageJPEG($images_fin, $new_images);

What I am wanting to do is instead upload the image with a max height and ratio the width proportionally. What variables do I have to reverse?

This topic has been moved to Third Party PHP Scripts.

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