Using *Dreamweaver* (webdesign)

Woa! wat a thread, i will learn from here, wayback thread!

I said I will be back in a minute but  its almost an hour, I think I underestimated what it takes to prepare a tutorial.

Before I start, I need to add here that there are other ways of doing this but I will stick to Dreamweaver, afterall thats what the topic suggests.

I will assume that:

1. you know how to create recordsets in dreamweaver and,
2. you know how to display image from the recordset. (displaying image is different from displaying other data in DW)
3.you are not a moron.

Let me help a bit with displaying image assuming you have created a recordset for returning it.

We assume that
1. the recodset you created is named: 'rspics' without the quotes.
2. the database field which holds the name of your uploaded files is named: 'filename' again without the quotes.
3. the picture was uploaded to a folder named 'files'  (no more quotes blah blah blah unless you are a retard. )

Go to 'Insert' >> 'Image'
On the dialogue box that pops up check the 'Data Sources' and your recordset(s) will appear inside the dialogu box.

Expand the recordset which holds your pic and locate the the field that holds the filename.
Click on the filename field and click OK,
There it is, the code for your Picture will be inserted into your cursor position.

The code that will appear asumming you are using the previously mentioned rescordset name will be:

code1:
 <img src="<?php echo $row_rspics['filename']; ?>"

The code above returns the picture as if it resides in your main web folder but that is not likely. (who does a stpid thing like that anyway)
Now you have to make the code link the full path of the image which we have agreed was uploaded to the folder named 'files'
go to the code1 above and add " files/ " to make it become code2 below:

code2:
 <img src="files/<?php echo $row_rspics['filename']; ?>"
 
If you have a picture file in that folder that is referenced in the Databse with the 'filename' then  you have displayed your image!  Run your page on a live apache server if you doubt me. i think I deserve a bottle of Gulder for this 

Now dont get excited, you only displayed a picture, any PHP fool can do that.

Showing and Hiding the image under certain Conditions

This is the fun part.
This is where the Dreamweaver Sho/Hide Region Server Behaviour comes handy (after editing the original DW code  of course)

Lesson Continued,

If you switch to Design View of your Dreamweaver, you will see what they call image placeholder in place of the code for displaying image. Common sense name abi?
Now use your mouse and select this image placeholder and while it is still highlighted,
Go to ' Application' pane on your far right of DW window, Click on the Server behaviour Tab and click on the + button>>
Go to 'Show region' >> 'Show if recordset is not empty' at this point, a small dialogue box opens showing you the list of your created recordsets. Select your image recordset which in this case is rspics.

When you have clicked ok, DW will pum in the following codes (code3) before and after code2. Code1 will sit in between the two lines of code below.

Code3:
<?php if ($totalRows_rspics > 0) { // Show if recordset not empty ?>

<?php } // Show if recordset not empty ?>


when you place code2: inside them you have:
code4:
<?php if ($totalRows_rspics > 0) { // Show if recordset not empty ?>

<img src="files/<?php echo $row_rspics['filename']; ?>"

<?php } // Show if recordset not empty ?>


We now have to tell the code to obey us and not DW authors ( it feels nice to know you can actually do that)

We now edit code4: and we will have:

Code5:

<?php if ($row_rspics['filename'] != ' ') { // Show if recordset not empty ?>

<img src="files/<?php echo $row_rspics['filename']; ?>"

<?php } // Show if recordset not empty ?>

We have just told PHP or is it apache to
show the picture if (the database field filename is not equal to empty)

That is to say that the picture must be shown as long as there is a text inside the filename field.
This can get tricky if you have designed your database to takee a default text when nothing was inserted to it.
But I hope you wouldnt,


How to Display a Default Image when the field is Empty

This is getting too long so let me continue in another post,