Page 1 of 1
Products website
Posted: Mon Dec 13, 2004 9:58 am
by losse
Hi there
I need some direction. I want to launch a site about stamps. I recently inherited an expensive collection and want to sell it off since I have no desire to upkeep the collection. Instead of creating a table and updating it all the time, I want to post the stamps using some form of database technology. That way I only have to update the master "database" and make sure the files are on the server.
Could anyone point me to a language/software that would allow me to do this?
Thanks
Posted: Mon Dec 13, 2004 10:05 am
by kettle_drum
PHP and MySQL would be perfect for this kind of project. PHP being the language you would write the page in and then MySQL as the database. This is a pretty standard sort fo request - maybe not with stamps, but with other items - so im sure you could find a pre-written solution at somewhere like hotscripts.com or by browsing this forum.
Posted: Mon Dec 13, 2004 10:10 am
by losse
Thanks Kettle drum.
You'll have to excuse my ignorance as I am just putting my speedo on to dive into this new language... So, in terms of page structure and the "layout" of the page, PHP would dictate that and within the page, there would be MySQL requests to pull up all the different products (stamps).
So as I add or remove stamps, all I have to update is the database and I can lay off the php or web files?
I'll search hotscripts and see if I can find something.
Posted: Mon Dec 13, 2004 10:42 am
by patrikG
Maybe worth looking into CMS and Online Shops: easy and out-of-the-box is something like Mambo (
http://www.mamboserver.com )
They have an eCommerce component called phpShop (needs seperate installation which is very simple):
http://www.mambophpshop.com (I think)
Do note: if you want to ever modify the code of PHP Shop: you're in for a nightmare. From a developer's point of view it's a very, very unclean and buggy implementation and not worth the development time.
However, if you want a quick, out of the box solution, it should be something you might want to explore as it will work (i.e. sell things).
Posted: Mon Dec 13, 2004 10:46 am
by losse
I took a look at some of the scripts I think they offer a lot more than what I am looking for. What I basically want to have is a table with say, 4 colums. In column 1 I would put the image of the stamp, column 2, the country, column three, the year and column 4 the price.
As I get more stamps, and as I sell these stamps, I would update a file that would expand/shrink that table according to the amount of records on the "datasheet"
Does that make sense? Should I clarify a little more?
Posted: Tue Dec 14, 2004 12:16 pm
by losse
hi gang
I figured out the answer to the previous post. It's just a matter of plugging into mysql and updating records.
Now my challenge is to figure out how to lay out the table on my website. So how do I table a table that's in a database and display it on a webpage?
Tahnks
Posted: Tue Dec 14, 2004 10:41 pm
by kettle_drum
Something like:
Code: Select all
$result = mysql_query("SELECT * FROM table WHERE something = 'this'");
if(mysql_num_rows($result)){
echo "
<table>
<tr>
<td>
Col 1
</td>
<td>
Col 2
</td>
</tr>
";
while($row = mysql_fetch_assoc($result)){
echo "
<tr>
<td>
{$row['field_1']}
</td>
<td>
{$row['field_2']}
</td>
</tr>
";
}
echo "</table>";
}
Runs the sql query. Checks to see if there are any results. If there are it prints the table header with coloumn names. Then it loops through each result and prints them.
Posted: Wed Dec 15, 2004 8:13 am
by losse
Thanks drum!!
So Col 1 and Cold 2 are the titles for the columns right?
And 'field_1' and 'field_2' is where the results of the table will populate? All I have to do is replace the name 'field_1' with the name of the column in my database?