Shopping Site Help

tha_ripmasta

Hi,

I hope someone can help me, I'm new to php.

I am building a art shopping site , where users can purchase art.
In the admin section of the site, i will like to activate or deactivate a art (product).
So that the users of the site can only see the active arts (products) on the main page.

How do i go about doing this????

thnx in advance.

LordShryku

How are you displaying the art? Is it contained in a database? Flat file? Are you hard coding it to the pages? Have you made the admin section yet?

AstroTeg

I would think a simple flag that allows your code to identify if an image is available or not would work. Trick is how are you storing and retrieving the info?

tha_ripmasta

Yes I have made the admin section already.
When the administrator adds a art (product) to the site he is then ask if he would like to add an image for the art.

The art is stored on the server with a with Php and a Mysql database.

This is the code to add the art

<?php
if (isset($insertme))
{
$flag=1;
$errorcounter=1;

if($flag)
{
$result=mysql_query("
insert into arts(
artID,
name,
desc,
price,
size,
photo,
categoryID
)
values (
null,
'$name',
'$description',
'$price',
'$size',
'nothing',
$category
)") or die (mysql_error(). " : ".mysql_errno());

if ( ($result) != 1)
print "Sorry, Bad";
else
{
print "Art is added ";

$lastid=mysql_insert_id(); //upload image
if ($if_upload=="yes")
{
require "upload.php";

}
exit;
}
}

else //if $flag==0 it means we have errors
{
print " ".($errorcounter-1)." Wrong. Try Again";
}

}

Weedpacket

I guess there would be a checkbox on the relevant admin page so that the administrator could say whether that item is active or not.

Store whether or not that checkbox is checked in a boolean field alongside the item as AstroTeg suggests. Then, when you display the artwork, only select those WHERE that field is true.

ice_berg16

in my opinion i think add a field named 'show'(or other name you want to set )for the art table;
in the admin section you can change the value of this field through accessing the dababase.

and the foreground code only show the art where show ='true'
you can set this in you sql string

on this way ,the foreground code and the admin section are sepreated. so you wont rewrite too many code