homepage Welcome to WebmasterWorld Guest from 54.227.160.102
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
Classified System
Where do I start? willing to work hard....lol
naitsirhc26

5+ Year Member



 
Msg#: 3516577 posted 9:07 pm on Nov 29, 2007 (gmt 0)

Hello,

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,

Christian

 

ZeroFunk

10+ Year Member



 
Msg#: 3516577 posted 4:47 am on Dec 2, 2007 (gmt 0)

Perhaps you should hire a freelancer:D

A lot of info you are asking for.

Habtom

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 3516577 posted 4:58 am on Dec 2, 2007 (gmt 0)

You can look for an open source classifieds script and modify it to include the extra requirements you have.

Hotscripts [hotscripts.com] has got a few of classifieds open source scripts.

yandos

5+ Year Member



 
Msg#: 3516577 posted 12:07 pm on Dec 6, 2007 (gmt 0)

Off the top of my head I would do something like this for a BASIC setup:

Mysql

Create 2 tables – categories and listings

Categories table

Categoryid - autoincrementing field
Categoryname – name of category

Listings table

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)
Listingdate

page setup

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 you’ll 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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved