5 Replies Latest reply: Jul 15, 2014 10:12 AM by Max Resnikoff

Restricting Image URLs (From MySQL Field) to a certain area/size

Max Resnikoff Jul 15, 2014 8:56 AM

Hi,

I have a database which contains an 'Image URL' field for people to input a image from the internet onto the given equipment.

The problem is that images are all sorts of different sizes, and when it is displayed on the site, there could be an image which has filled up the whole page!

I have the 'Image Field' from the Forms tab in Dreamweaver, and it is displaying the images. (As displayed below):

At the moment, the image is so large, it squashes all the text onto one side.

Is there a way for the images to be restricted and fill a certain area?

Below is an image of what I mean. (Edited image)

Any Help would be very much appreciated!

1. Re: Restricting Image URLs (From MySQL Field) to a certain area/size

Jon Fritz II Jul 15, 2014 9:11 AM (in response to Max Resnikoff)

Assuming the height and width aren't being written into the html, you could give the images within a given container on your site a class (or use an element selector based off the container the images are in), then use that class/element selector to set the max-width you want the images to all be. Leaving height/max-height out will scale the height proportionately to the max-width you set.

Without seeing the code you're working with, it's hard to give you an exact answer.
Like Show 0 Likes (0)

Actions
2. Re: Restricting Image URLs (From MySQL Field) to a certain area/size

Max Resnikoff Jul 15, 2014 9:32 AM (in response to Jon Fritz II)

Thanks for the answer.

I fixed it by creating a <div> tag and instead of inserting the Form 'Image Field' inot the Design View, I entered it while still in the Code View. This brought up a different window with many more parameters for the image. Here I placed the Desired height and the source of the image.

Thank you for your help!
Like Show 0 Likes (0)

Actions
3. Re: Restricting Image URLs (From MySQL Field) to a certain area/size

Nancy O. Jul 15, 2014 9:46 AM (in response to Max Resnikoff)

You could crop & re-size images on the server with PHP.
PHP Master | Crop and Resize Images with ImageMagick

Nancy O.
Like Show 0 Likes (0)

Actions
4. Re: Restricting Image URLs (From MySQL Field) to a certain area/size

osgood_ Jul 15, 2014 9:53 AM (in response to Max Resnikoff)

Max Resnikoff wrote:

Thanks for the answer.

This brought up a different window with many more parameters for the image. Here I placed the Desired height and the source of the image.

Thank you for your help!

But the images wont all be the same size so restricting their size WITHOUT cropping and resizing BEFORE putting them into the database will distort them once they are called into the page from the database.

What I do is have an upload form script that restricts the size i.e., the max width or max height which is allowed to keep some kind of order.
Like Show 0 Likes (0)

Actions
5. Re: Restricting Image URLs (From MySQL Field) to a certain area/size

Max Resnikoff Jul 15, 2014 10:12 AM (in response to osgood_)

In the solution I found, the height you enter applies to all the repeating database entries. so all of the forms from the database are displayed with an image with height of 300.
Like Show 0 Likes (0)

Actions