Welcome to WebmasterWorld Guest from 188.8.131.52
I would like to re-visit my classified system questions, and get this classified system working.
Here are my thoughts and my goals:
1. I would like to have a classified system. There would be a wanted section, and a for sale section. In each of those sections are categories like Equipment, Dogs, etc...that is the basic layout of the system.
2. On the main "hub" of the classified system all of the sections and categories will be listed with a NUMBER next to each one showing how many ads are in each category.
3. How I would like to implement this system is through MySQL, not a flat file. When someone would like to add a classified, they just use a simple form, and submit it. THEN, I would have an Admin page where I can activate or delete each classified. But I would like to be able to activate each classified before it is listed. Does this seem too complicated of a system? How could I make it easier? Maybe they could just send the classified to me through email, and then I add it to the classified?
So as you can see I don't want anything too complicated, I don't want the users to have to make an account, etc...What my question is now is what I should start working on first. I am willing to research each PHP method as long as maybe some of you can give me the names of what I should use to accomplish these ideas, and then I can go from there.
So maybe we should start with the database input page? And then maybe work with the actual output pages? And getting the information from the database?
The only other hard part will be having the "listing count" on the hub page. What code will I need to implement to have the system count how many ads are in each category and display that information?
Thank you very much for everyone's help; I really appreciate all of the help I have gained and received here thus far.
Have a wonderful day,
Create 2 tables categories and listings
Categoryid - autoincrementing field
Categoryname name of category
Listingid - autoincrementing field
Listingtitle title of listing
Listingtext description of listing
Listingemail email address used to contact owner of listing
Categoryid category the listing should appear in
Listingstatus (default to 0)
Homepage just lists all categories from the categories table with link to catlistings page e.g catlistings.php?id=2
The catlistings page shows all listings where the categoryid is the same as the query string e.g 2 and listingstatus is set to 1
Clicking on a listing title shows the full category text and an email form to contact the owner of the listing
also on category listing page is a link to add a new listing. As the form is called from the catlisting page youll know which category to add the listing into. when the listing is added in to the database by the user the default listing status is 0 meaning it wont be displayed.
Get the script to email you when a listing is sent. In the email have a link to update the listingstatus for that particular to 1 so that it appears on the site.
Set up a final script to remove/mark status as 0 any listings 6 months old by querying the listingdate field and run this daily via a cron job.