turn this into a database

Anon

Write now I have this listing as a static webpage:

http://www.hypertheory.com/geo2.html

However, I would like to turn it into a database driven page. I'd like to keep the same look and color scheme, but I'd also like to add features like 'adding', 'deleting' or 'editing' one of the people listed on the page.

Any ideas where to start? Thanx!

Chris

Anon

Hey

I think the best place to start is to template your site with php3 so that way you can add features any time you want with out re doing your pages

Then I guess the rest is how you feel comfortable on how you want to distribute your info

Anon

Richards,

I'm little confused by what you mean when you say," template your site with php3..." Any info would be greatly appreciated.

Thanks!
Chris

Anon

Ok most of if not all your information is going to be tored in a database so you make a template i.e

<?php
require('connection');
$result = mysql_query("SELECT * FROM table WHERE page_id=$page_id",$db);
while ($myrow = mysql_fetch_array($result)) {
printf<table><tr><td>Wwelcome to my link page<br></td></tr><tr><td><a href=\"viewlinks.%s?page_id=%s\">Veiw My Links</a></td><a href=\"addlink.%s?page_id=%s\">Add your Link</a></td></tr></table>\n",

php3, $myrow["page_id"],

php3, $myrow["page_id"]);

}

Like this you can add features and not have to recode your whole page unless you want to change the look.

🙂 hehe hope this helps

Anon

Richard,

Thanks for the code. How would I get the alternating table colors?

Thanks,
Chris

Anon

Try this -- I did a quick cut-and-paste (not tested). Notice the function, and PARTICULARLY the order of the HTML:

<?php

function row_color($cnt,$even,$odd) {
print ($cnt%2) ? "<tr bg color=\"$odd\">" : "<tr bgcolor=\"$even\">";
}

echo "<table width='100%' cellspacing='2' cellpadding='2'>\n";
echo "<tr>\n<th align='left'>ID#:</th>\n<th align='left'>Column 1</th>\n<th align='left'>Column 2</th>\n</tr>\n";

require('connection');
$result = mysql_query("SELECT * FROM table WHERE page_id=$page_id",$db);
while ($myrow = mysql_fetch_array($result)) {

$cnt=0;

php3, $myrow["page_id"],
php3, $myrow["page_id"]);

row_color($cnt++,"#F8F8F0","#FFFFFF");
echo "\n<td valign='top'><a href=\"viewlinks.%s?page_id=%s\">Veiw My Links</a></td>\n<td valign='top'><a href=\"addlink.%s?page_id=%s\">Add your Link</a></td>\n</tr>";

}

echo "\n</table>";

Anon

Just the same as if you were doing HTML just make sure you use the slash like this

so that PHP can defind what is HTML and what is PHP easly said if you generating a HTML the cross the quaots if it's php the leave it

Hope you understand that

Anon

I noticed a couple issues with your original -- here's a cleaner version that should show you the way:
<?php

function row_color($cnt,$even,$odd) {
print ($cnt%2) ? "<tr bg color=\"$odd\">" : "<tr bgcolor=\"$even\">";
}

echo "<table width='100%' cellspacing='2' cellpadding='2'>\n";
echo "<tr>\n<th align='left'>ID#:</th>\n<th align='left'>Column 1</th>\n<th align='left'>Column 2</th>\n</tr>\n";

require('connection');
$result = mysql_query("SELECT column1, column2 FROM table WHERE page_id=$page_id",$db);
while ($myrow = mysql_fetch_array($result)) {

$cnt=0;

$first=$row[0];
$second=$row[1];

row_color($cnt++,"#F8F8F0","#FFFFFF");
echo "\n<td valign='top'>$first</td>\n<td valign='top'>$second</td>\n</tr>";

}

echo "\n</table>";

BTW, I have a bad habit of single-quoting tag attributes inside PHP -- It is probably better to do escaped double-quotes -- <td valign=\"top\"> -- whatever your preference, I guess.