Code dynamic webpages using php, css and mysql?

I have a website that has many photos. I actually hard coded all the webpages to display the photos (icons) in a column based view using excel and notepad, lol. Anyway, I have another set of photos about 532 to be exact. I was thinking of creating some dynamic pages. Will php and mysql do this? I guess when I building the page I could use CSS then where the page would change, like in picture file names, then this could be represented by a variable of some sort. Do I even make sense or am I off on my thinking? Example of my past code is below..
 
<html>
<head>
<title>Picture I</title>
</head>
<body>
 
 
<h1><center>Picture I</center></h1>
<br>
<center>Page 1 of 33</center>
 <center><a href="16.html"><img src="Bnext.jpg"/></a><a href="2.html"><img src="Fnext.jpg"/></a></center>
 
<table border="1" width="400px" align="center" opacity: 0.5>
 <tr>
 
 
</tr>
<tr>
<td bgcolor="white"><center><a href="picture/1.jpg"><img src="icon/1.jpg"/></a></center></td>
 <td bgcolor="white"><center><a href="picture/2.jpg"><img src="icon/2.jpg"/></a></center></td>
<td bgcolor="white"><center><a href="picture/3.jpg"><img src="icon/3.jpg"/></a></center></td>
 <td bgcolor="white"><center><a href="picture/4.jpg"><img src="icon/4.jpg"/></a></center></td>
</tr>
<tr>
<td bgcolor="white"><center><a href="picture/5.jpg"><img src="icon/5.jpg"/></a></center></td>
 <td bgcolor="white"><center><a href="picture/6.jpg"><img src="icon/6.jpg"/></a></center></td>
<td bgcolor="white"><center><a href="picture/7.jpg"><img src="icon/7.jpg"/></a></center></td>
 <td bgcolor="white"><center><a href="picture/8.jpg"><img src="icon/8.jpg"/></a></center></td>
</tr>
<tr>
<td bgcolor="white"><center><a href="picture/9.jpg"><img src="icon/9.jpg"/></a></center></td>
 <td bgcolor="white"><center><a href="picture/10.jpg"><img src="icon/10.jpg"/></a></center></td>
<td bgcolor="white"><center><a href="picture/11.jpg"><img src="icon/11.jpg"/></a></center></td>
 <td bgcolor="white"><center><a href="picture/12.jpg"><img src="icon/12.jpg"/></a></center></td>
</tr>
<tr>
<td bgcolor="white"><center><a href="picture/13.jpg"><img src="icon/13.jpg"/></a></center></td>
 <td bgcolor="white"><center><a href="picture/14.jpg"><img src="icon/14.jpg"/></a></center></td>
<td bgcolor="white"><center><a href="picture/15.jpg"><img src="icon/15.jpg"/></a></center></td>
 <td bgcolor="white"><center><a href="picture/16.jpg"><img src="icon/16.jpg"/></a></center></td>
</tr>
<tr>
<td bgcolor="white"><center><a href="picture/17.jpg"><img src="icon/17.jpg"/></a></center></td>
 <td bgcolor="white"><center><a href="picture/18.jpg"><img src="icon/18.jpg"/></a></center></td>
<td bgcolor="white"><center><a href="picture/19.jpg"><img src="icon/19.jpg"/></a></center></td>
 <td bgcolor="white"><center><a href="picture/20.jpg"><img src="icon/20.jpg"/></a></center></td>
</tr>
</table>
 
 
<center><a href="16.html"><img src="Bnext.jpg"/></a><a href="2.html"><img src="Fnext.jpg"/></a></center>
 <center>Page 1 of 16</center>
<br>
<br>
<td colspan="3">
</td>

----------------------------------------------------------------------------------------------------
*****************************    Second WebPage    ****************************************************
----------------------------------------------------------------------------------------------------

<html>
<head>
<title>Picture II </title>
</head>
<body>
 
 
<h1><center>Picture II</center></h1>
<br>
<center>Page 2 of 16</center>
 <center><a href="1.html"><img src="Bnext.jpg"/></a><a href="3.html"><img src="Fnext.jpg"/></a></center>
<table border="1" width="400px" align="center" opacity: 0.5>
 <tr>
 
 
</tr>
<tr>
<td bgcolor="white"><center><a href="picture/21.jpg"><img src="icon/21.jpg"/></a></center></td>
 <td bgcolor="white"><center><a href="picture/22.jpg"><img src="icon/22.jpg"/></a></center></td>
<td bgcolor="white"><center><a href="picture/23.jpg"><img src="icon/23.jpg"/></a></center></td>
 <td bgcolor="white"><center><a href="picture/24.jpg"><img src="icon/24.jpg"/></a></center></td>
</tr>
<tr>
<td bgcolor="white"><center><a href="picture/25.jpg"><img src="icon/25.jpg"/></a></center></td>
 <td bgcolor="white"><center><a href="picture/26.jpg"><img src="icon/26.jpg"/></a></center></td>
<td bgcolor="white"><center><a href="picture/27.jpg"><img src="icon/27.jpg"/></a></center></td>
 <td bgcolor="white"><center><a href="picture/28.jpg"><img src="icon/28.jpg"/></a></center></td>
</tr>
<tr>
<td bgcolor="white"><center><a href="picture/29.jpg"><img src="icon/29.jpg"/></a></center></td>
 <td bgcolor="white"><center><a href="picture/30.jpg"><img src="icon/30.jpg"/></a></center></td>
<td bgcolor="white"><center><a href="picture/31.jpg"><img src="icon/31.jpg"/></a></center></td>
 <td bgcolor="white"><center><a href="picture/32.jpg"><img src="icon/32.jpg"/></a></center></td>
</tr>
<tr>
<td bgcolor="white"><center><a href="picture/33.jpg"><img src="icon/33.jpg"/></a></center></td>
 <td bgcolor="white"><center><a href="picture/34.jpg"><img src="icon/34.jpg"/></a></center></td>
<td bgcolor="white"><center><a href="picture/35.jpg"><img src="icon/35.jpg"/></a></center></td>
 <td bgcolor="white"><center><a href="picture/36.jpg"><img src="icon/36.jpg"/></a></center></td>
</tr>
<tr>
<td bgcolor="white"><center><a href="picture/37.jpg"><img src="icon/37.jpg"/></a></center></td>
 <td bgcolor="white"><center><a href="picture/38.jpg"><img src="icon/38.jpg"/></a></center></td>
<td bgcolor="white"><center><a href="picture/39.jpg"><img src="icon/39.jpg"/></a></center></td>
 <td bgcolor="white"><center><a href="picture/41.jpg"><img src="icon/41.jpg"/></a></center></td>
</tr>
</table>
<center><a href="1.html"><img src="Bnext.jpg"/></a><a href="3.html"><img src="Fnext.jpg"/></a></center>
 <center>Page 2 of 16</center>
<br>
<br>
<td colspan="3">
</td>

Open in new window

RoodonaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ray PaseurCommented:
Yes, you can do this with PHP and MySQL, plus the use of the server file system to store the photos.  There are some pre-made galleries (Coppermine is well-thought-of).  If you want to learn how to do this yourself, start here:
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_11769-And-by-the-way-I-am-new-to-PHP.html
0
Daniel WilsonCommented:
+1 on the pre-made galleries.  I've used http://galleryproject.org/ successfully.  Next time I need one I'll have a look at Coppermine if that's Ray's recommendation.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
COBOLdinosaurCommented:
Withe Ray's help you should nail down how to do this from the server side, but you will also want to look at the clent side as well.  The markup you posted is the way things were done in the last century.

Much of what you are using includes obsolete attributes that most browsers will still recognize but they are not included in the latest standards.  Plus as written it will have cross-browser issues and could be difficult to maintain.

You might need to look at some of the HTML5 and CSS3 tutorials you will find on the internet with a search.  For the kind of basic presentation you are doing, it is not hard to learn how to do it well, and the time spent will pay dividends down the road.

Cd&
0
RoodonaAuthor Commented:
thank you padas :)
0
RoodonaAuthor Commented:
COBOLdinosaur: Thanks for your honesty. You saved me from a potential embarrassing interview.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Languages and Standards

From novice to tech pro — start learning today.