HOW DO I MAKE IMAGES DYNAMIC USING DREAMWEAVER & MySql

[Ras_Sermon]

Hi there,

   I wanted to make images dynamic in that the images would be stored in my database and then use dreamweaver to pull the images from the database using a recordset. But how do I get to store the images in MySql now that dreamweaver doesn't support BLOB and also how do I make dreamweaver pull the images from that database? PLZ somebody help

[bregent]

Storing images in a BLOB field is a practice that has fallen out of favor over the past 5 or 10 years. The current practice is to store files in the file system, and store the path to them in the database. This makes referencing them in html much easier too.

[Ras_Sermon]

Thanx for the reply. I surelly managed to create the upload scripts but here now's another problem creating a recordset to view the images on a browser. I tried creating one but when you preview the page on a browser, it's like it cant access the images. I would also want to make scripts to automatically resize the images to my desired size upon preview on the browser and also make photo thumbnails. Can somebody please advise me on this?

[www.aimiecaprice.com]

To pull the image from Database on to your page

1. Open your php page

2. put your cursor where you want the image to show on the page

3. insert>image>Select File Name From: Data Sources>select record from recordset> click ok

4. View in browser

In Mysyl the image was stored as a "longblob" type with "binary" attributes

but my system is Dreamweaver CS3.

Hope this helps. Let me know.

[joplateau]

Greetings,

How can i make dynamic image on ASP VBScript pages? I have already setup SQL Server but I couldnt get the image to show up on the view page after I uploaded the file. I went to insert >image > data source then chosed the image path that I setup in the database. What have I done wrong?

Joplateu

[www.aimiecaprice.com]

Mmmmm,

Did you try publishing the page (up loading the page to the severer) and

looking at it on the actual server?

Are you using the correct file ext?

[joplateau]

I have not uploaded the file to my web host server. I am still designing

my site and previewing it on the browser through Adobe Dreamweaver CS4.

I thought that would have been enough to check my web design. What is

the correct file extension I should use on ASP VBScript while using SQL

server for the database?

................................................................................

[www.aimiecaprice.com]

I am so sorry; I just don't have the experience to help you. I have worked

some with php, but never with asp. With php you have to install a special

server (called a wamp server) on your local server if you want to test it

locally. Sometimes in php testing the problem can be with your local testing

server. Like you did not turn on the wamp server when you started up your

computer Or you are trying to test a php script but you use an html file ext

by mistake vs a php file ext.

I think the same might be true with asp. I think you might have to install a

special server on your local server in order to test it locally.

To get around that possibility

I think you should just make a test page, try inserting just one dynamic

image, load it to the actual server to test it and see what happens. Just

experiment, do a little trial and error. You will get it trust me if I was

able to figure out php you can do this asp stuff, just don't give up

One big note is when you do the insert>image

The select image source will default to, "Select file name from: file

system." You do not want to do that. You want to do "select file name from:

Data source"

Keep trying. Let me know how it turns out.

[joplateau]

Hi,

I recall running into this message “Note: Dreamweaver does not currently support binary images stored in a database”; while I was searching for information on how to implement dynamic image on my web page so visitors can upload image and view it immediately like it is on facebook.

What do you think about that?

Joplateau

[bregent]

>have not uploaded the file to my web host server. I am still designing

>my site and previewing it on the browser through Adobe Dreamweaver CS4.

>I thought that would have been enough to check my web design.

No. If you want to run a local testing server you will need to install IIS. What operating system are you running?

[www.aimiecaprice.com]

Thanks Begret, I thought they did have to have a special server to test

pages written in that format. I just wasn't sure what the server was.

[joplateau]

Hi,

I am using windows XP Professional and the IIS server is automatically installed with windows XP Professional. I also went on to the manager to start the server and gave it auto start permission when the machine starts running. I also included the ASP VBScript test page in the server area so I could view the page on the browser.

Though you are not using ASP but let’s assume you are the one doing the setup with IIS Server; where in the IIS Server would you put the test page before uploading it to the browser for public viewing?

I uploaded the test page same place with the rest of the pages I designed for my website.

Joplateau

[www.aimiecaprice.com]

Have you defined your site in Dreamweaver with both the actual server and

the testing server?

Site>NewSite>

http://www.aimeecaprice.com

[joplateau]

Yes I have defined my site in Dreamweaver CS4 both with the actual

server and the testing server and other designs I made for my site are

working very well. Example my web search engine is great as well as my

blog site. The upload is working well as well; it will upload to the

folder but not to the image viewer page.

...................................................???????????????.......................................

[www.aimiecaprice.com]

When you are in Dreamweaver viewing your page and you hit f12 does the page

show up on the "testing Server" in a browser window?

Is the image stored on your testing server as well as your actual server or

is it just stored on the actual server?

[bregent]

>data source then chosed the image path that

>I setup in the database. What have I done wrong?

What did you insert into the database; the image file or the path to the file?

Show us the code.

[joplateau]

Below is the code as it was coming from the data source i used for the image.

Here is the code:

!!" alt="<logo_6>" />

Please let me know where might have gone wrong.

Thanks.

Joplateau