Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Supposedly ImageMagick is better on memory but I always have GD at my disposal and it has always done the job for me. Make sure you allocate enough memory in your php.ini</p> <p>Then use a script like this:</p> <pre><code>&lt;?php function createThumbs( $pathToImages, $pathToThumbs, $thumbWidth ) { // open the directory $dir = opendir( $pathToImages ); // loop through it, looking for any/all JPG files: while (false !== ($fname = readdir( $dir ))) { // parse path for the extension $info = pathinfo($pathToImages . $fname); // continue only if this is a JPEG image if ( strtolower($info['extension']) == 'jpg' ) { echo "Creating thumbnail for {$fname} &lt;br /&gt;"; // load image and get image size $img = imagecreatefromjpeg( "{$pathToImages}{$fname}" ); $width = imagesx( $img ); $height = imagesy( $img ); // calculate thumbnail size $new_width = $thumbWidth; $new_height = floor( $height * ( $thumbWidth / $width ) ); // create a new temporary image $tmp_img = imagecreatetruecolor( $new_width, $new_height ); // copy and resize old image into new image imagecopyresized( $tmp_img, $img, 0, 0, 0, 0, $new_width, $new_height, $width, $height ); // save thumbnail into a file imagejpeg( $tmp_img, "{$pathToThumbs}{$fname}" ); } } // close the directory closedir( $dir ); } // call createThumb function and pass to it as parameters the path // to the directory that contains images, the path to the directory // in which thumbnails will be placed and the thumbnail's width. // We are assuming that the path will be a relative path working // both in the filesystem, and through the web for links createThumbs("new_arrivals_img/","new_arrivals_img/thumbnails/",100); ?&gt; </code></pre> <p><a href="http://www.webcheatsheet.com/php/create_thumbnail_images.php" rel="nofollow">http://www.webcheatsheet.com/php/create_thumbnail_images.php</a></p>
    singulars
    1. This table or related slice is empty.
    1. POCreate Thumbnails from a folder of images using PHP
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USCode Magician
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POCreate Thumbnails from a folder of images using PHP
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COhow do i go about allocating memory in the php.ini? does this change in the case of using MAMP as it's a localhost? Lastly, will this code allow some sort of connection between the thumbnail and the image to use when creating the links dynamically?
      singulars
      1. PO
      1. USstefmikhail
    2. COthe php.ini file in MAMP is in (i think) Applications/MAMP/conf/php5/ I have MAMP, not MAMP PRO so you'll have to check the manual if you use PRO. Find `memory_limit` in your php.ini file and change it to something like 64M and restart MAMP. Also, this does a proportional resize based on your desired width (100px in the example call)
      singulars
      1. PO
      1. USCode Magician
    3. COHey, it worked! Now, one thing... the quality is really not very good. And I'm starting to think it might be a better idea to create the thumbnails with photoshop or something of the like. Eventually I would like to display the thumbnails as links to the larger image using php to create the page. Is there any benefit to using the above script over photoshop for this? Or does it have more to do with the file names being the same? I appreciate your help.
      singulars
      1. PO
      1. USstefmikhail
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload