how to create an image gallery using a SQL database. I placed the images in the sql database and I want to display the image and then a caption under the image? Can anyone help me! I can only get it to display the first picture and the first caption? I want it to display all the images with a categoryID of 1.
View Replieswhat i want to do is create an image gallery, that when u click on a picture it opens in a pop up with the images caption and name there also. I've stored the captions and image names in a database - images.mdb table - Images
I just need a page now that sorts it all out to display the correct image, caption and title in the pop up. The images are stored in folder images and the database in the website root directory.
i've read a couple of articles on various websites, and played with the image gallery wizard on Frontpage but the websites dont explain my problem, and i cant adapt the gallery on frontpage. I'm a bit of a novice in ASP so I would really appreciate it if you could some how make the bits of the script I need to change standout.
I would like to be able to have an image gallery that i can upload photo's to. It would have to resize the image to say 1024x768 and also make a small thumbnail, then add the neccessary data to a database so that i can easily display it.
What is the best way to go about this without spending any money?
I want to create an image gallery using ASP and JavaScript.The JavaScript is for the image effects, and ASP is required for selecting images from an image folder,to display it.How do I go about the asp part of it? And is it possible for me to embed a javascript within an ASP code?
View Replies View Relatedis there any tutorial links on image gallery with database (SQL) on Classic ASP. Where the image record display horizontaly 4 image columns in a row, it also has brief description and the record id displays.
View Replies View RelatedI need some advice as to how to create thumbernail gallery page. Has anyone got any tutorials online or anything? As I'm lost as to:
a) uploading the images
b) requesting the correct set of pictures via a ReviewID
c) Outputting the images
The platform is Win03, Access and SQL is available, along with all the
normal image components (aspjeg, etc..).
I have searched and I could spend several days looking for something. I was
hoping to get some recommendations based on experience. I would like to
stay under 100 if I was to purchase something.
Goals:
Autothumbnail for the viewer.
Let the user manage their gallery
Admin area for uploading, categorizing, captions, and deleting.
I am using ASP code to auto-generate a gallery based on files within a directory structure and I got it to work a while back. Lately I've been consistently receiving "Out of Memory" errors when I access that module. I haven't made any drastic changes to my system so I can't exactly figure out what subtle changes if not inherent in the code flaw is causing this ...
View Replies View RelatedI want a page where I will have an image gallery. The page when loaded goes and grabs all the picutres in the directory and puts them into an array, creating thumbnails for them as well (found this part in my search).
After the thumbnails are loaded, I want the pictures to be loaded in the same window, in a section underneath the thumbnails. Also Can I scroll the thumbnails left or right on mouseover? not in a full circle but left until the first one is encountered and right until the last picuture is showed?
i'm looking for a free image gallery generator in ASP 3 on ASP+. I've already looked on sourceforge.net but no one seems to fit my needs which include:
- admin area to create/destroy galleries,
- upload/remove images,
- placing comments on images.
I'm looking to do an incredibly simple image gallery... I need to show all images in a specific folder. Preferably in a table (say, 4 columns or so), so that each image occupies a cell.
I don't want to code all image names into the page, I just want all images that exist in a specific folder to be shown. Anyone know how to do this, or can point me to a tutorial? I don't need to resize, link the pictures or anything else. Just show the images.
does anyone know a good ASP script that presents a decent image gallery from a DIR? I want it to display thumbnails of an image, but not to just simply load the whole image, and resize it (because that would use up a lot of bandwidth!). I know there is a PHP script that can do this - think its called Anphin or something like that?
Anyway, does anyone know any decent, free ASP photo galleries? (p.s. It cant require server-side objects either, because I am not allowed to install them on my shared server).
I have to create an image gallery that reads from a directory on our server and posts the pictures in sequential order based on the title of the image that shows up in the directory. The images can not be stored in a database, just in a directory that employees can access and add new images. The titles will all start with numbers like 1employeename, 2employeename, 3employeename. The images should be listed on the page in order by number. I really don't know how to do this in classic ASP. If it were ASP.net I would at least know where to begin. Does anyone have any suggestions on where I could start, or find information on how to do this?
View Replies View RelatedCurrently i have setup a form that takes the users information and drops the info into an access database and displays the info out the way i want it to.
After i take the info, i setup a seperate form to take in the users images of there choice that drops into a directory on my server, which works fine as well. What i am looking for though is a way to take the location of the image and drop that into another database or the same one so i can use it as a link when displaying the information.
I have two tables. ALPHA; fields
id (a text field, that contains a string)
image (a text field, that contains an url path for a file)
and BETA
id (a text field, that contains a string)
image (a field to insert an image)
I need to insert in BETA the information of field 'id' and the file that the field 'image' is pointing to. The url path of that file may me inside or outside my domain. For example, if the 'image' field says "pepe.com/image1.jpg", even if the ASP file is not in www.pepe.com domain.
Is there a way to do that?
if any of you know any powerful open source asp gallery. In php there is one really good one that allows you to upload batch images and customize the size, etc
View Replies View RelatedI would like to be able to update an image I have stored in a database by uploading it through a form. The current pages I have now will only add a new entry to the database. I would like the customer to be able to change the image on their index page through the form. How can I change the following code to do that?
showPicture.asp ....
I want to upload my images in the database instead of storing them on the server.
View Replies View RelatedI want 2 upload a image and some text to the sql server database. and in anothere page i will retrieve all the fields . so can anybody help me.i am giving u the html source....
View Replies View RelatedI m trying to set up a form so that a user can isert a gif or jpeg image into a table in the database.
1) Can you please show me how to create a table in the database so that it accepts the images
2) I need to know how to actually browse to an image in hard drive and then insert it in the table
I'm building a path making tool, that is i have a network of paths for a park and each section of the path is its own image.
What i need to do is, when a certain piece of the path is clicked, it querys my path database and returns the information for that section of the path to a table.
Im designing in ASP VBscript and database is connected n all but im a beginner, is it feasable?
As well as this i need to be able to add to the table each time a piece of path is clicked, and also take away, like a stack.
AND aswell as this i need a seperate table which adds up the length of all the paths selected (length is in the database).
What is the best method to insert and retrive image to and from the database?
View Replies View Relatedi wanna check one cell value from database and then if cell value is 0 than put this image in the dynamic table, if it's 1 than put other image to dynamic table, and so on Code:
View Replies View RelatedI have created a website where users can place advertisements and upload complementing photos. I have elected to place the advertiser's contact details and advertisement in 1 table in an Access database and the corresponding photo and Account ID in a second linked table.
Once the photo is inserted as a BLOB, the advertiser is forwarded to the payments page. The upload page has a form with a file field and a hidden field with the Account ID which as been passed on the previous page by a session variable. The website is hosted on a remote server by my web host.
My problem is that the image and the Account ID are not inserted into the database even though the processing page successfully redirects to the payments page. I am new to web programming so I am unsure where my problem lies. Code:
I AM NOT ABLE TO DISPLAY IMAGES FROM ACCESS DATABASE JUST 11 BLACK IMAGE BOXES OF SIZE 400 X 250
Code:
sql="SELECT [IMAGES] FROM ITEMS"
rsAuthors.open sql, cnnNorthWind, 3, 3
%>
<%Set rsAuthors = cnnNorthWind.Execute(sql)
IF rsAuthors.EOF then 'No records found
Response.End
ELSE 'Display the contents
DO WHILE NOT rsAuthors.EOF
'Response.BinaryWrite(rsAuthors("IMAGES"))
%>
<img src="image/<%=rsAuthors("IMAGES")%>" height="400" width="250">
<%rsAuthors.MOVENEXT
LOOP
END IF
%>
how to upload image into the database ?
View Replies View Relatedi have a database..(pics.mdb)
1 table
pics(table name)
id,file,display(3 fields)
4 records..
1,pic1.jpg,yes
2,pic2.jpg,no
3,pic3.jpg,yes
4,pic4.jpg,yes
what line of code do i use on my asp page to display the picture where display is yes?
How do I take an image from <IMG SRC>? Meaning I can not insert the image with the Upload method, I have to take it directly from the <IMG SRC>. Is there a possible way to do that?
View Replies View RelatedI need to upload image into a database. Can someone suggest where i can get sample codes or tutorial or any sort of assistance ?
View Replies View Relatedi am developing an application using ASP.I have to get product picture from user and store it in to database. i am getting the file path of the picture.
How to read this image and store it in database and retrieve it back for display in another page ?
Anyone there can help suggest to me where i can find out more about Inserting image into a database.
View Replies View RelatedI want to make a gallery, in which the images are hosted on the same server, the images' names are not ordered in a/decending order (old1,old2,old3 etc.) , and i want an ASP page, that will automatically create space in a table for every picture existing on a specific folder (the folder probably won't contain only images...not quite sure yet).. i can't remember how it's done...,
View Replies View RelatedI am trying to add an option on a form to upload an image to an access database, but I can't seem to get it working. I am able to upload regular text fields to the database with no problem, but got stuck at uploading image.
I don't want to upload the name of image, just the actual jpeg/gif image. I've searched many websites and forums, but codes aren't working. Can someone help me with this? Here are the codes: