473,569 Members | 2,691 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Htaccess and mysql photo album.

Hi there,

I've posted the following question elsewhere,
but got no response, and there seems to be no
special htaccess-group, so i took the liberty
to post it here. Hope y'all dont mind.

I have a site with a photo album on it.
Albums are stored in a MySQL db.
I use a site with a standard layout, with
an iframe in it, where the content is presented.

To the visitor albums appear to have the
following url:
site.com/photos/album_id/album_name/page_no
The last three parts are variable,
and it's translated to
site.php?album= album_id&page=p age_no

That's the url of the main layout. The page
in the iframe has the same, except then index.html
behind it. (site.com/photos/album_id/album_name/page_no/index.html)
Hope it's still clear.

Because the album name is variable i use the following
in the htaccess file:
RewriteRule ^photos/([0-9]+)/(.*)/([0-9]+)(/)?$
site\.php\?albu m=$1&page=$3

BUT!! because of the '(.*)' part, it keeps looping when i call
the iframe's url because photos/5/bla AND photos/5/bla/index.html 'are
both (.*)'.
Does anyone know how to prevent this? Does it make a difference if i
put
the *.index.html rule before the other in the htaccess?

Sounds rather complicated i guess, but i don't really know how to
explain it different.

Thanks in advance!

Jul 17 '05 #1
3 2134
On Tue, 21 Jun 2005 02:09:28 -0700, frizzle wrote:
Hi there,

I've posted the following question elsewhere, but got no response, and
there seems to be no special htaccess-group, so i took the liberty to post
it here. Hope y'all dont mind.

I have a site with a photo album on it. Albums are stored in a MySQL db.
I use a site with a standard layout, with an iframe in it, where the
content is presented.

To the visitor albums appear to have the following url:
site.com/photos/album_id/album_name/page_no The last three parts are
variable,
and it's translated to
site.php?album= album_id&page=p age_no

That's the url of the main layout. The page in the iframe has the same,
except then index.html behind it.
(site.com/photos/album_id/album_name/page_no/index.html) Hope it's still
clear.

Because the album name is variable i use the following in the htaccess
file:
RewriteRule ^photos/([0-9]+)/(.*)/([0-9]+)(/)?$
site\.php\?albu m=$1&page=$3

BUT!! because of the '(.*)' part, it keeps looping when i call the
iframe's url because photos/5/bla AND photos/5/bla/index.html 'are both
(.*)'.
Does anyone know how to prevent this? Does it make a difference if i put
the *.index.html rule before the other in the htaccess?

Sounds rather complicated i guess, but i don't really know how to explain
it different.

Thanks in advance!


RewriteRule ^photos/([0-9]+)/(.[^/])/([0-9]+)(/)?$

or similar any use?
Jul 17 '05 #2
I'm sorry, i don't quite understand what you mean ...
And what does '(.[^/])' do?

Thanks!

Jul 17 '05 #3
*** frizzle wrote/escribió (23 Jun 2005 08:20:27 -0700):
I'm sorry, i don't quite understand what you mean ...
And what does '(.[^/])' do?


One character (any) plus one character (any except /).

--
-- Álvaro G. Vicario - Burgos, Spain
-- http://bits.demogracia.com - Mi sitio sobre programación web
-- Don't e-mail me your questions, post them to the group
--
Jul 17 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2984
by: Nick | last post by:
I am building a photo album webpage and am not sure exactly how I should organize the database. Here's where Im at so far... I have one table called 'images' which contains the columns 'albumID', 'url', 'title', and 'description'. Then another table called 'albums' which contains the column 'name'. The part where I am having the most...
5
6530
by: Joseph Ellis | last post by:
Hello all. I have a family website that I have been maintaining for the past year and a half or so. It includes a photo album that has grown quite large. So far I've displayed the photo album using frames, with thumbnails on the left side of the screen and full-size images displayed on the right. But now I'm sick of frames and I'd like...
5
4188
by: fraser | last post by:
Hi, I have a photo gallery with cat photos here http://mouserspage.cjb.net From the beginning, I have been making each page of thumbnails, with a separate page for each photo, entirely in plain html. Since the number of photos I have has increased greatly, it becomes a long and tedious process to go through all the pages to edit the links...
2
1959
by: Tony WONG | last post by:
i am not sure that this subject can be discussed here. i have many photos. they are stored according to the name of the EVENT and YEAR. i will set up a database (sql or access) to store information of the photo and set up a folder to store the "PHOTOs". and design a web page to show. My question is how to put the photo on the web page.
3
2623
by: Ben Cartwright | last post by:
I'd like to create an ASP.NET-based photo album. Rather than creating a bunch of HTML pages as in a typical photo album, I'd like to leverage the dynamic capabilities of ASP.NET. Any suggestions for getting started, samples, or articles would be greatly apprecated... I'm particularly interested in knowing which controls to use to display...
2
3187
by: Linda | last post by:
Hey all, I'm not too sure if this is the right place to post my question - or if I should go to a JSP group. Anyway here is my question. I am looking at finding/ making an online dynamic photo album which uses JSP. I've seen a lot of examples using PHP and a few online albums using Javascript, however those albums using JavaScript are...
2
3161
by: David Griffiths | last post by:
Hi All Using VB 2005 I have been tasked with creating simple Photo Album page on our local intranet server that can display Thumbnails and then the full picture once the thumbnail is clicked in a new window, if the full picture is open I would like to be able to move forward or backwards through the pictures without returning to the...
1
1301
by: w33d5 | last post by:
I'm looking for a little help in making an index file to read the subdirectories in the same folder and display the links in a table. i am loading photo galleries using google's picasa onto my host and since picasa exports the albums as folders (I am using a simpleviewer template) i would like to use a script to read the subdirectories in the...
0
7698
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7612
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7924
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8122
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7673
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
1
5513
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3640
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1213
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
937
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.