PHP website development

leahmo

Hi All,

I am trying to build a photography studio website using PHP, MySQL, and Apache. I am new to the language though. I went through a book and worked through all the examples but it still isn't totally clear. Anyway I need to make a pretty decent site. So far I have really basic things on it and it seems to be ok but the question I have right now is that I am trying to build albums on the site and I need to use the different tables in the database. I am just wondering if there is a way to use the photo names that I put into the database in my code...as in is there anyway to retrieve the photos from there after I link the PHP script and MySQL together or do I always have to put the photo location into the script?

There is so much that I want to do with the site and I have tried looking at different sites and tutorials online but it is difficult for me to understand them as the language is still so new to me.

Thanks a million!

Leah

dagon

with respect, you will not be able to build a "pretty decent site" with out experience. Just like I wouldn't photograph a wedding (my dad was a pro, when they still used glass plates), I suggest you hire a professorial web developer, if you want a professional website.

leahmo

I never said I needed to build a professional site. I just said that I needed to build a site and that I want to learn how to make it pretty decent. What is the point in learning a new computer language if I am just going to hire someone else to build it???

dagon

leahmo;11000364 wrote:
Anyway I need to make a pretty decent site.

leahmo;11000364 wrote:
I never said I needed to build a professional site.

Ok, we have different definitions of professional and decent, but I stand by my suggestions. Best of luck.

traq

leahmo;11000364 wrote:
I never said I needed to build a professional site. I just said that I needed to build a site and that I want to learn how to make it pretty decent. What is the point in learning a new computer language if I am just going to hire someone else to build it???

I think this begs the question: Do you want...
a) a "pretty decent" (and/or "professional-looking," whatever) website?
b) a "learning experience"?

Your first attempt is not going to produce both.

leahmo

I am a quick learner ok? And pretty decent as in it will work and the it will do the little things that I want it to do. When using code to create things it is a learning experience.

dagon

leahmo;11000370 wrote:
I am a quick learner ok? And pretty decent as in it will work and the it will do the little things that I want it to do. When using code to create things it is a learning experience.

ok great, your original question is un answerable because it's to vague, you need to be far more specific, there are dozens of way to put things in to and out of a db; some code would be very helpful.

leahmo

ok what I am trying to do is build a website for a photography studio (its a project I am working on...not for an actual studio or anything ok) and I am currently trying to build a client page where they can see a bunch of different albums. They log into their album and there is their photos. I have the login part working the thing is that I can't figure out how to

have it so that they can only view their album.
i want to know if there is anyway that i can pull the photos from the database itself. As in, that I have a database set up for the studio and I have a table for albums and a table for photos etc. I am wondering if from the table called albums or photos or whatever can i take the photos from there or do I always have to type in the name of the photo ie. <img src="location.jpeg> etc.

Is that clear?

traq

What does your existing code look like? Code examples would be helpful.

to limit users to individual albums, you'll need to build a login system.
you can store the photos in the DB, but there's no real reason to. the typical approach is to store the metadata (file name, etc.) in the DB and then you can just insert it into your HTML markup.

Derokorian

Basically, to limit users to their images only, you would only select their images from the DB. One way to do this is to store the userid in the session, and store images with the user_id of the person it belongs to, then construct a query along the lines of:

$sql = 'SELECT filename FROM images WHERE user_id = '.$_SESSION['user_id'].' LIMIT '.$offset.','.$limit;

leahmo

Ok I will send my two codes in two different posts. Right now I have two seperate pages, 1 for galleries, and 1 for client login. Now with the galleries and stuff I have only posted like one or two photos for each gallery as a bit of practice etc. So here is the code for the galleries.

<html>
<head>

<style type="text/css">
ul
{
list-style-type:none;
margin:0;
padding:0;
overflow:hidden;
}
li
{
float:left;
}
a:link,a:visited
{
display:block;
width:120px;
font-weight:bold;
color:#FFFFFF;
background-color:#98bf21;
text-align:center;
padding:4px;
text-decoration:none;
text-transform:uppercase;
}
a:hover,a:active
{
background-color:#7A991A;
}

</style>
</head>

<body>
<body bgcolor=#A00000>

<h1><p align="center">L. Mo's Photography</p></h1>
<body>
<ul>
<li><a href="home.html">Home</a></li>
<li><a href="maingallery.html">Galleries</a></li>
<li><a href="about.html">About</a></li>
<li><a href="contact.html">Contact</a></li>
<li><a href="clients.html">Clients</a></li>
</ul>
<h1><p align="center">Galleries</p></h2>
<ul>
<a href="kidsgallery.html"/><font size="4" color="white">Kids</font></a href>
<a href="kidsgallery.html"/><img src="kidslinkphoto.php" width="191" height="127"/></a href><br>
<a href="animalsgallery.html"/><font size="4" color="white">Animals</font></a href>
<a href="animalsgallery.html"/><img src="animalslinkphoto.php" width="191" height="127"/></a href><br>
</ul>
</body>
</body>
</html>

leahmo

Here is the code for the client login so far.

<html>
<head>

<style type="text/css">
ul
{
list-style-type:none;
margin:0;
padding:0;
overflow:hidden;
}
li
{
float:left;
}
a:link,a:visited
{
display:block;
width:120px;
font-weight:bold;
color:#FFFFFF;
background-color:#98bf21;
text-align:center;
padding:4px;
text-decoration:none;
text-transform:uppercase;
}
a:hover,a:active
{
background-color:#7A991A;
}

</style>
</head>

<body>


<body bgcolor=#A00000>

<h1><p align="center">L. Mo's Photography</p></h1>

<body>
<ul>
<li><a href="home.html">Home</a></li>
<li><a href="maingallery.html">Galleries</a></li>
<li><a href="about.html">About</a></li>
<li><a href="contact.html">Contact</a></li>
<li><a href="clients.html">Clients</a></li>
</ul>
<h1><p align="center">PhotoShoot Albums</p></h2>
<ul>
<style type="text/css">
div.img
{
  margin: 2px;
  border: 1px solid #0000ff;
  height: auto;
  width: auto;
  float: left;
  text-align: center;
}	
div.img img
{
  display: inline;
  margin: 3px;
  border: 1px solid #ffffff;
}
div.img a:hover img {border: 1px solid #0000ff;}
div.desc
{
  text-align: center;
  font-weight: normal;
  width: 120px;
  margin: 2px;
}
</style>
</head>
<body>

</ul>


<p align="center"><table border="8">
<tr>
<td>
<form method="post" action="userlogin.php">
<p><strong>username:</strong><br/>
<input type="text" name="username"/></p>
<p><strong>password:</strong><br/>
<input type="password" name="password"/></p>
<p><input type="submit" name="submit" value="login"/></p>
</form>
</td>
</tr>
</p>
</table>
</body>
</body>
</html>

leahmo

In both the codes I have a navigation bar at the top as this is for a photography studio.

dagon

I would start by learning to write valid html, and you did not post the php, which is what you where asked for.

traq

It would also be a good idea to separate out your CSS into an external stylesheet.

chrisguk

Okay Im gonna add my 2 cents to this post as I still regard myself as a newbie at PHP although I can develop sites using PHP now.

There are literally thousands of places with code snippets and completed open source applications available on the internet. Most of the applications produced are for those that wish to make a website solution but have limited knowledge. I started out this way and used respective code snippets and applications to understand how they were built.

Everybody has their own style but in general the principles are the same and usually so is the end objective. I started developing sites in pure "html" first so I was 100% confident I understood nearly every aspect of basic html. Without this grounding I felt it was impossible to understand what I was trying to achieve in PHP. As I progressed I started adding little bits of PHP for example 'includes' and compiling a config file etc. It worked for me because I could see the things in action and it gave me the confidence to add more and more.

So now im at the stage where around 80% of my sites are written in PHP and the other 20% is a mixture between javascript and html. It feels great when you finally have an application running built from the ground up. This took me a year by the way, didnt see the point in rushing.

trafacs

Hi Friend,

first you learn c,c++ and Basic PHP. than you create your site, without you know anything you don't to do anything. i know Php is not hard but it's more important to you have to knowledge about php,

So First you growth your knowledge about php, some practical to do, than you create your site, id u want to learn abt PHP, online many site's Available, like W3Schools,

chrisguk

Not sure why it's relevant to know C or C++ I know both and don't see the relation to PHP. PHP is a server side programming code and C and C++ are standalone application languages.

Bonesnap

chrisguk;11001065 wrote:
Not sure why it's relevant to know C or C++ I know both and don't see the relation to PHP. PHP is a server side programming code and C and C++ are standalone application languages.

I think what he's saying is having prior programming knowledge, but of course it's not required for PHP or any language (though it certainly does help).