hello,
I need a script to manage a domain name portfolio. It must be in PHP/HTML/CSS using MySQL so i can manually add/edit/display/delete/query the database
the Db must be multi-tabled as follows
TABLE domain
domain_name
domain_type
TABLE dates
date_registered
date_expires
TABLE admincontact
admin_first
admin_last
admin_address
admin_phone
admin_email
TABLE techcontact
tech_first
tech_last
tech_address
tech_phone
tech_email
TABLE type
type_1
type_2
type_3
type_4
TABLE category
category_art
category_business
category_entertainment
category_internet
category_services
category_multimedia
TABLE location
registrar
main_ip
secondary_ip
main_name
secondary_name
TABLE access
access_host
access_username
access_password
TABLE money
money_id
domain_id
TABLE purchased
money_id
purchased_date
purchased_price
purchased_where
TABLE offers
money_id
offer_date
offer_price
offer_who
TABLE sold
money_id
sold_date
sold_price
sold_who
TABLE notes
notes
the forms/reports don't have to look pretty (but there will be bonus if they do)
attached is a rough SQL file, probably very wrong, but is a Very good start (has recommended attributes, keys etc) and worth the look.
required search functions:
1. QuickList (list domain name and expiry date only)
2. Sort domains alphabetically, by price and expiry date (high -> lowest, vice-versa etc)
3. list domains by category, type and location (IP address)
4. Search for keyword in "domain_name" and "notes"
would like this done within 2 days and there will be a bonus if it is! definitely needs to be completed within 5 days.
thanks in advance!
PS: if you do not show an example of similar work or don't have a decent rating I can't choose you.
my preferred budget is about $200