imagetrouble

[oaskedal]

Hi!

I use this code trying to resample (using GD lib) all the images (only path is stored) in my database. BUT it only resamples the newest picture, and not all of the images in my database. How can I make this happen calling a single file createnewimage.php in my <img src> tag.

here is my code:

 include "function.inc.php";
    $connection = connect("my_database"); 
    $sql = "SELECT imagename, date_publicated, date_finished, newsid FROM newstable
    WHERE date_publicated <= now() 
                        AND ( date_finished >= now() OR date_finished = '0000-00-00' )
                        ORDER BY date_publicated DESC, newsid DESC";


$result = mysql_query($sql, $connection);





$row = mysql_fetch_array($result);



    $anImage = "images/webimages/intern/" . $rad['imagename'];

    if ( strstr($anImage, 'jpg')) {

    $mainImage = imagecreatefromjpeg($anImage); 

    $width = 135;
    $height = 75;

    $mainWidth = imagesx($mainImage);
    $mainHeight = imagesy($mainImage);

    $image_p = imagecreatetruecolor($width, $height);

    imagecopyresampled($image_p, $mainImage, 0, 0, 0, 0, $width, $height, $mainWidth, $mainHeight);

// Output
    imagejpeg($image_p, null, 100);


}

else if ( strstr($anImage, 'jpeg')) {

    $mainImage = imagecreatefromjpeg($anImage); 

    $width = 135;
    $height = 75;

    $mainWidth = imagesx($mainImage);
    $mainHeight = imagesy($mainImage);

    $image_p = imagecreatetruecolor($width, $height);

    imagecopyresampled($image_p, $mainImage, 0, 0, 0, 0, $width, $height, $mainWidth, $mainHeight);

// Output
    imagejpeg($image_p, null, 100);
    }


else if ( strstr($anImage, 'gif')) {

    $mainImage = imagecreatefromgif($anImage); 

    $width = 135;
    $height = 75;

    $mainWidth = imagesx($mainImage);
    $mainHeight = imagesy($mainImage);

    $image_p = imagecreatetruecolor($width, $height);

    imagecopyresampled($image_p, $mainImage, 0, 0, 0, 0, $width, $height, $mainWidth, $mainHeight);

// Output
    imagegif($image_p, null, 100);



}




if ( strstr($anImage, 'png')) {

    $mainImage = imagecreatefrompng($anImage); 

    $width = 135;
    $height = 75;

    $mainWidth = imagesx($mainImage);
    $mainHeight = imagesy($mainImage);

    $image_p = imagecreatetruecolor($width, $height);

    imagecopyresampled($image_p, $mainImage, 0, 0, 0, 0, $width, $height, $mainWidth, $mainHeight);

// Output
    imagepng($image_p, null, 100);



}
else {

    echo "unknown imagefile";

}

Monday, December 18 2006 05:42 PM

[ClarkF1]

You need do use a while loop so it loops through each of the results so you use:

while ($row = mysql_fetch_array($result))

and then you need every else within this loop

[oaskedal]

Hi!

Thanks for answering. Would you be kind to show me in a bit more detail, as I'm all new into this. How and where do I put this while loop..?

Again thank you!

[ClarkF1]

A lot of your code was repetition so I've tidied it up.

If the image type is not found it should print "unknown imagefile" followed by the image name and move on to the next image in the database

include "function.inc.php";
    $connection = connect("my_database");
    $sql = "SELECT imagename, date_publicated, date_finished, newsid FROM newstable
    WHERE date_publicated <= now()
                        AND ( date_finished >= now() OR date_finished = '0000-00-00' )
                        ORDER BY date_publicated DESC, newsid DESC";

$result = mysql_query($sql, $connection);

while ($row = mysql_fetch_array($result))
{
  $anImage = "images/webimages/intern/" . $rad['imagename'];

  if ( strstr($anImage, 'jpg') || strstr($anImage, 'jpeg')) { $mainImage = imagecreatefromjpeg($anImage); }
  elseif ( strstr($anImage, 'gif')) { $mainImage = imagecreatefromgif($anImage); }
  elseif ( strstr($anImage, 'png')) { $mainImage = imagecreatefrompng($anImage); }    
  else { echo "unknown imagefile: $anImage"; continue; }

  $width = 135;
  $height = 75;

  $mainWidth = imagesx($mainImage);
  $mainHeight = imagesy($mainImage);

  $image_p = imagecreatetruecolor($width, $height);

  imagecopyresampled($image_p, $mainImage, 0, 0, 0, 0, $width, $height, $mainWidth, $mainHeight);

// Output
  if ( strstr($anImage, 'jpg' || strstr($anImage, 'jpeg'))) { imagejpeg($image_p, null, 100); }  
  elseif ( strstr($anImage, 'gif')) { imagegif($image_p, null, 100); }
  elseif ( strstr($anImage, 'png')) { imagepng($image_p, null, 100); }
}

[oaskedal]

Ok, almost there.... now I get this error code:
'mysql_fetch_array(): supplied argument is not a valid MySQL result resource'
also the script always stops on the png files always telling they are not valid.

I'm using the script to preview images in a newssystem. The news should appear with their right image. Is it enough to just use the html tag <img src='createnewimage.php'> in my output list of news (will createnewimage.php sort the right picture out for me..??)

Thank you so much for all help!