Quick Question

[Clarkie]

Hey there,

I'm looking to build a website based on PHP but before I start I want to have the following answered.

I'm going to have multiple DIVs next to each other and the content in the DIVs will need to load from a database. The content will be:

1. Image Link

2. Image Source

3. Alternative Text

4. Title

The DIVs are currently all using the same class so that they are the same width/height/background.

Can I simply identify each DIV by an ID which then allow the image source etc to be read from the database or do I have to have each option (shown in the list) linked directly to the html code for that specific bit of content?

I'm confusing myself now so I'll see if anyone understands that.... :L

If this doesn't make sense I'm working on a project to teach me PHP and so far I have a HTML version of the main site. I want to make the project open source but not until a working first version is made.

If someone wanted to teach me how to write the website in PHP, rather than doing it for me then that would also work.

Thanks,
Clarkie

[jamesjohnson88]

You can do it many ways, you should be able to get all the data you need in one query, assuming the image has its src, link, alt and title in the same row.

So, you'd query the db.

$myArray = mysql_query("SELECT * FROM Blah WHERE Blah = '$blah' LIMIT 1");

fetch the array.

$myRow = mysql_fetch_array($myArray);

assign the variables.

$link = $myRow['link'];
$src = $myRow['src'];
etc.

Then, in the html part, you can simply open up a php snippet where needed.

e.g.

<a href="<?php echo $link; ?>"> Link Here </a>

Using the same method for the other fields.

Hope that helps.

• James

[Clarkie]

So could I do this?

<a href="<?php echo $link; ?>"><img src="<?php echo $src; ?>" alt="<?php echo $alt; ?>" title="<?php echo $title; ?>" /></a>

Thanks,
Clarkie

[jamesjohnson88]

Yup, that should work, so long as there's no conflicting code. If it doesn't, just come back here with the errors, etc.

[Clarkie]

What about the fact there are 32 times where this has to appear on a page. :L

[jamesjohnson88]

Are they all in row? Same product or different product?

You could create a function to make things easier...

function productData($product)
{
// Generate the html for $product in here.
// Echo it out.
}

or you could use a foreach to effectively do the same thing, it's up to you really. Depends on your skill level I guess. Neither are particularly hard though.

[Clarkie]

No, there are currently 5 rows of 4 and 4 rows of 8. Different image in each.

[Clarkie]

I would link you to the current progress (HTML Version) of the site but my host is down... :@

[cretaceous]

you could write the long "echo" line as this - less typing:

echo "<a href='". $link."'><img src='".$src."' alt='".$alt."' title='".$title."'/></a>";

[jamesjohnson88]

Are they all in the same table, what exactly is the data and how is it used?

[Clarkie]

No they are all separate DIVs. I'll link you to what I've done by PM.

[Clarkie]

I may as well just post a link here.
Any thoughts?

[Clarkie]

Nobody?

[Clarkie]

echo "<a href='". $link."'><img src='".$src."' alt='".$alt."' title='".$title."'/></a>";

How would I sort this in the db etc?