OutFront Forums
     Home    Register     Search      Help      Login    

Sponsors
Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax
Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.
Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Follow Us
On Facebook
On Twitter
RSS
Via Email

Recent Posts
Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read
 

How to Store and Retrieve Wallpapers/path in Access Database using DRW

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP, PHP, and Database >> How to Store and Retrieve Wallpapers/path in Access Database using DRW 		Page: [1]
 
 
abdulsamikhan

 

Posts: 109
Joined: 12/23/2003
From: Pakistan
Status: offline

  		How to Store and Retrieve Wallpapers/path in Access Dat... - 12/29/2003 15:09:33   
To all the Web Developers Genius;

How can I store the Wallpapers/Path of Images to the Access Database using DRW and then Retrieve the Wallapapers in Thumbnails arrange them and then when user click on the Thumbnail it then open in the full size like 800 x 600 etc...

For further reference I want to create the site like this one: http://www.santabanta.com tell me the solution if you people can but please tell me step by step it is request because I am a new bee,

I will be greatly obliged, thanks with regards and waiting for the reply anxiously...
Spooky

 

Posts: 26723
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: How to Store and Retrieve Wallpapers/path in Access... - 12/29/2003 23:13:18   
When you enter a new record, you will just add the 'file name' of the large wallpaper (not the thumb image).

eg "wallpaper01"

You would manually upload the image "wallpaper01.jpg" AND its thumbnail "wallpaper01_thumb.jpg" to any directory you want (as long as all of the wallpaper is in one folder)

Then, when it comes time to display the image, you use the asp code to dynamically show the image file.
Using the DRW, it would be something like this :

<a href="<%FP_Field(fp_rs,"ImageName")%>.jpg"><img src = "<%FP_Field(fp_rs,"ImageName")%>_thumb.jpg"></a>

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

Sp:)ky


(in reply to abdulsamikhan)
abdulsamikhan

 

Posts: 109
Joined: 12/23/2003
From: Pakistan
Status: offline

  		RE: How to Store and Retrieve Wallpapers/path in Access... - 12/30/2003 8:37:45   
Thank you Spooky for the reply...

But I am still not in a position that:

1. How will store the path in database using DRW after copying all the wallpapers and thumbnails in the wallpaper folder.

2. How the wallpapers can be retrieved Alphbetically (Sort by A - Z)

For Example:

The display should be like this:

http://www.santabanta.com/wallpapers/parent.asp?catid=0

When click on the link, the thumbnails then be displayed and when click on the thumbnail the wallpaper should be displayed in its actual size...

Please guide me in detail...

Thanks

(in reply to Spooky)
Spooky

 

Posts: 26723
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: How to Store and Retrieve Wallpapers/path in Access... - 12/30/2003 13:19:29   
How were you wishing to record the data?
You could use web based admin forms or simply manually enter them into an access database.
The sort is simply part of the SQL string where you "ORDER BY" the wallpaper descriptive name.

Im not too sure how much youve got so far or which part youll get stuck on? Have you a simple database to use? Is the example your site or just an example?

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

Sp:)ky


(in reply to abdulsamikhan)
abdulsamikhan

 

Posts: 109
Joined: 12/23/2003
From: Pakistan
Status: offline

  		RE: How to Store and Retrieve Wallpapers/path in Access... - 12/31/2003 2:30:55   
I want to copy all the wallpapers mannually in the wallpaper directory. There will be several wallpaper categories like hollywood, bollywood, science etc. and then want to enter only the name of wallpapers and the catid in the database using form.

Then I want to retreive the wallpaper using DRW to display the thumbnails preview and when user click on the thumnail it then enlarge to its origninal size.

The link I've sent is for an example that I want to make the site like that. (That is not my site)

I've a MDB file named backend.mdb in fpdb folder with the table name wallpaper and field names ID (Autonumber), CatID (Number) and ImageName (Text).

I know if you understand my situation then you will be able to answer me very easily, I would request if you please guide me step by step, because I have no idea what to do, I've manage other db related stuff very easily, but I have no idea for retreiving and storing the path using database for wallpaper, because frequently I will upload new images/wallpaper to that folder and then I will enter the names of wallpapers, their categories ids etc.
Also suggest me the best solution if you think my Idea is wrong.

Thanks

(in reply to Spooky)
Spooky

 

Posts: 26723
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: How to Store and Retrieve Wallpapers/path in Access... - 12/31/2003 13:51:09   
I think the best thing to do, is just start it.
Itll be easier to show you what to do with some sample code.

eg - add a couple of records to the database.

image1 : "bollywood/wallpaper1"
image2 : "bollywood/wallpaper2"
image3 : "science/wallpaper3"

Leave out the "jpg" extension, we can add that later

I assume catid relates to the directory?

Then make a simple DRW page that displays all records (as text). Dont wory about images for now, but post the DRW code that is produced and Ill show you how to modify it for images.

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

Sp:)ky


(in reply to abdulsamikhan)
abdulsamikhan

 

Posts: 109
Joined: 12/23/2003
From: Pakistan
Status: offline

  		RE: How to Store and Retrieve Wallpapers/path in Access... - 1/1/2004 2:08:40   
Done! Upto the instructions given by you... Now?

(in reply to Spooky)
Spooky

 

Posts: 26723
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: How to Store and Retrieve Wallpapers/path in Access... - 1/1/2004 4:43:20   
Post the source code ;-)

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

Sp:)ky


(in reply to abdulsamikhan)
abdulsamikhan

 

Posts: 109
Joined: 12/23/2003
From: Pakistan
Status: offline

  		RE: How to Store and Retrieve Wallpapers/path in Access... - 1/1/2004 9:30:33   
<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="keywords" content="Islam and Quran, Education, Cook Book, Recipe, Beauty Tips, Health Tips, Tips, Tricks, Newspapers, Pakistan, Dialing Codes, Horoscopes, ISP Index, Flight Schedule, Railway Timings, About Hazara, Wallpapers, Downloads, Chatting, IRC, eGreetings, Web, Web2SMS, Classifieds, Email, Telephone Directory of Pakistan, Lollywood, Bollywood, Hollywood, Islamic, Animals, About Mansehra, Scenic, Cars, Bikes, Celebrities, Abdul Sami Khan, JICS, Mansehra, Jinnah Institute of Computer Sciences, Mansehra, NWFP, Pakistan, Others, JiXoft.com, Jixoft">
<meta name="description" content="The Internet Portal">
<link rel="stylesheet" type="text/css" href="css/jics.css">
<link rel="stylesheet" type="text/css" href="css/MSEducation.css">
<SCRIPT language=JavaScript>
function winopen(url)
{
window.open(url,'','scrollbar=no,toolbar=no,width=467,height=444,top=1,left=1');
}

function doSubmit() {
if(document.frmSE.se.selectedIndex<1)
alert("Select a search engine");
else
window.open(document.frmSE.se.options[document.frmSE.se.selectedIndex].value+document.frmSE.word.value);
}
</SCRIPT>

<title>Welcome to DabClub.Com :: The Internet Portal</title>

</head>

<body topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0" bgcolor="#FFCC00">

<div align="center">
<table border="0" cellpadding="0" cellspacing="0" width="100%" id="table1" height="713">
<tr>
<td align="left" bgcolor="#4070B0" height="19">
<font color="#FFFF00" face="Arial"><b>  <a href="index.asp">
<font color="#FFFF00">Home</font></a>  | <a href="htm/sitemap.htm"><font color="#FFFF00"> Site
Map</font></a>  |  <a href="htm/contacts.htm">
<font color="#FFFF00">Contact</font></a></b></font></td>
</tr>
<tr>
<td align="left" valign="top" height="63">
<table border="1" cellpadding="0" cellspacing="0" width="100%" id="table3" bordercolor="#3E6BA8">
<tr>
<td width="167" bgcolor="#5F8AC5" align="left" valign="top">
<!--webbot bot="Include" U-Include="include/topdabclublogo.htm" TAG="BODY" --></td>
<td bgcolor="#5F8AC5" align="left" valign="top">








<div align="right">
<!--webbot bot="Include" U-Include="include/topad.htm" TAG="BODY" --></div>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="left" bgcolor="#B40000" height="18">
<div align="center">
<!--webbot bot="Include" U-Include="include/topstrip.htm" TAG="BODY" --></div>
</td>
</tr>
<tr>
<td align="left" valign="top" width="100%" height="573">
<p align="center"> </p>
<p align="center"><img border="0" src="wallpapers/hollyw1.jpg"><table width="100%">
<thead>
<tr>
<th ALIGN="LEFT" width="7%">cat</th>
<th ALIGN="LEFT"><b>ImageThumb</b></th>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,ImageName,ImageThumb,Cat,SubCat" s-columntypes="3,202,202,3,3" s-dataconnection="dabclub" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice="Cat" s-menuvalue="Cat" b-tableborder="FALSE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="wallpapers" s-displaycolumns="Cat,ImageThumb" s-criteria="{Cat} EQ {Cat} +" s-order s-sql="SELECT * FROM wallpapers WHERE (Cat = ::Cat::)" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="Cat=" s-norecordsfound="Currently there is no wallpaper available for this category. New wallpapers will be added soon!" i-maxrecords="256" i-groupsize="6" botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.</font></td></tr>" b-UseDotNET="FALSE" CurrentExt sa-InputTypes="3" b-DataGridFormat="FALSE" b-DGridAlternate="TRUE" sa-CritTypes="3" b-WasTableFormat="TRUE" startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM wallpapers WHERE (Cat = ::Cat::)"
fp_sDefault="Cat="
fp_sNoRecords="<tr><td colspan=2 align=""LEFT"" width=""100%"">Currently there is no wallpaper available for this category. New wallpapers will be added soon!</td></tr>"
fp_sDataConn="dabclub"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=6
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="Cat"
fp_sMenuValue="Cat"
fp_sColTypes="&ID=3&ImageName=202&ImageThumb=202&Cat=3&SubCat=3&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="40250" --><tr>
<td width="7%"><font color="#FFCC00">
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,ImageName,ImageThumb,Cat,SubCat" s-column="Cat" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Cat<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Cat")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="1481" --></font></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,ImageName,ImageThumb,Cat,SubCat" s-column="ImageThumb" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>ImageThumb<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"ImageThumb")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="28832" --><font color="#FFCC00"><br>
</font></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="6" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr><TR><TD VALIGN=MIDDLE COLSPAN=64><NOBR><INPUT TYPE=Button VALUE=" |< "><INPUT TYPE=Button VALUE=" < "><INPUT TYPE=Button VALUE=" > "><INPUT TYPE=Button VALUE=" >| "> [1/6]</NOBR><BR></td></tr>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
</table>
<p align="center">w</td>
</tr>
<tr>
<td width="107%" bgcolor="#B40000">
<p align="center"><span style="font-size: 8pt">
<font color="#FFFFFF">Copyrighted © 2003 All rights reserved |
</font><a target="_blank" href="http://www.jixoft.com">
<font color="#FFFFFF">Designed and Maintained by JiXoft.Com</font></a></span></td>
</tr>
</table>
</div>

</body>

</html>

(in reply to Spooky)
Spooky

 

Posts: 26723
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: How to Store and Retrieve Wallpapers/path in Access... - 1/1/2004 10:52:30   
This is the basic change :

<td width="7%">
<%=FP_FieldVal(fp_rs,"Cat")%></td>
<td>
<a href="<%=FP_FieldVal(fp_rs,"ImageThumb")%>.jpg"><img src="<%=FP_FieldVal(fp_rs,"ImageThumb")%>[thumb extension].jpg"></a><br>
</td>


Note the red code, each thumb should have a different name than the parent. eg picture_small.jpg
The "_small" is the identifier for the thumb so that the same 'name' can be used to display 2 different images.

With this code, you can use it to point to the right directory by modifying the href and src tags.

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

Sp:)ky


(in reply to abdulsamikhan)
Page:   [1]

All Forums >> Web Development >> ASP, PHP, and Database >> How to Store and Retrieve Wallpapers/path in Access Database using DRW 		Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Copyright © 2009 Thomas Brunt's OutFront Inc. All Rights Reserved.