Need some programming done

[Jace]

my regular guy is way busy right now and I need a backend done for a site

i already have one guy about to get me a quote, but I need some people on the backburner if it doesn't pan out.

basically,

part 1

i need a normal admin done.....i have a site that has about 5 pages full of cars...each page is called new.php, classic.php, used.php etc...and I need a backend for the site that allows my client to enter in a car, select what section (i.e. New Cars) and what options are available on that car, and it adds the car to the site with all the options specified and in the section specified

part 2

I need a master admin done for the site that allows the master user to go in and create the options for the normal admin to choose when adding new cars

so, the master admin creates the fields and options for the normal user to select when adding cars

this isn't a huge job, i know...but I need it done in the next week

post here or hit me up jacexxx @ comcast dot net

[sarettah]

Hey Jace...

It sounds like maybe you already have a database in place that the front end php pages are pulling from ?

It doesn't sound like a major effort by any means.

If you want, I can take a look at it and let you know what I think it would take. Just send a bit more detail, database structure if there is one already in place, that sort of stuff. Meanwhile I can whip up a little mockup...

sarettah at hatterasdesigns.com

[gonzo]

2 weeks

[sarettah]

Originally posted by gonzo@Mar 18 2005, 08:41 PM
2 weeks
Sheez, in two weeks I can rewrite the entire internet...































all 20 pages of it :okthumb:

[Jace]

Originally posted by sarettah@Mar 18 2005, 05:03 PM
Hey Jace...

It sounds like maybe you already have a database in place that the front end php pages are pulling from ?

It doesn't sound like a major effort by any means.

If you want, I can take a look at it and let you know what I think it would take. Just send a bit more detail, database structure if there is one already in place, that sort of stuff. Meanwhile I can whip up a little mockup...

sarettah at hatterasdesigns.com
there is nothing there now except template pages

this is all in my head what needs done

i think i found someone though...we will see

[sarettah]

Originally posted by JaceXXX@Mar 18 2005, 06:39 PM
part 1

i need a normal admin done.....i have a site that has about 5 pages full of cars...each page is called new.php, classic.php, used.php etc...and I need a backend for the site that allows my client to enter in a car, select what section (i.e. New Cars) and what options are available on that car, and it adds the car to the site with all the options specified and in the section specified

part 2

I need a master admin done for the site that allows the master user to go in and create the options for the normal admin to choose when adding new cars

so, the master admin creates the fields and options for the normal user to select when adding cars

**********************************

this is all in my head what needs done

i think i found someone though...we will see
Cool that you may have found someone...

Now, just to clarify what I meant by more detail:

you have pages full of cars as you say. Are you selling them ? Just showing them off ? This would matter to whoever designed the database...

If you are selling them then you probably want price for example.

You say the normal admin guy "adds a car".. That can mean various things depeending on the context. It might mean just pointing to an image or some such or it might mean that the normal admin selects the various manufacturers/models/etc that are set up.

Your master admin you have defined as "the options". What do you consider options ? In my mind, options on a car are A/C, CD Player, Sunroof , all that stuff and I assume you mean the same. But if those are the options then where is the main car defined ?

Now, I know a little about cars so I could off the top of my head design a little database that probably would do everything that you want to do. But, another programmer might not know anything about cars and is dependent on you (the client) to provide the definition of what the data being stored will be.

The definition of the database is key in something like this and is why some of us spend long times in the design phase of any project including the ones that the client thinks is "quick and easy".

In this case, I would go after this with several tables in a database:

1. Manufacturers a unique id and name for any manufacturers that you may want to carry

2. Models a ubique id, a manufacturers id and a name for any models.. The manufacturers id provides the relation between model and manufacturer

3. Options table - this would be a vertically positioned table that simply had a unique id and a name for each option you might want to check off

4. A "Conditions" table (could be hard coded to poor, fair, good, etc but would be batter if it was table driven)

5. A Categories table (again could be hardcoded to New, Used, Vintage but again would offer more flexibility if table driven)

6. (Finally) The Car table. This would contain the various information for each car you would want to show so it might look like this:

Unique id
Manufacturer id
Model Id
year
price
conditionid
imagename
(possibly a location field if you are selling stuff from various cities)
(possibly coost and vin number fields etc if you want to track)

and the last table I see in a quick view would be the car-options table. This would be a vertically positioned table that would consists of a unique id, a car id and an option id and would allow for multiple records for each car record.

Now, my assumptions in this were that you are trying to sell cars, that you might want to easily add more categories later (muscle cars, antique, foreign, etc etc etc) and that you would want to be able to just add the category and have the proggy create the new page(s)

I would also assume that you would want to control the number of cars per page and that you may or may not want to display pictures of the cars.

As I said, this assessment was based on your description and is the kind of information someone really needs before they can make any kind of realistic quote on something.

Just imho of course.

[Jace]

wow, that was a lot of type :)

i decided to scratch the master admin part of it, and just have a admin panel to add new cars...

the site is basically a portal for overseas people to come and check out cars they might want to own in europe, but can't normally get cause they are cars that are only sold in america...basically, the site owner sells american cars to overseas people

i just need a admin section where the owner can go in and add in additions to his car inventory, and it update on the site...
here is a good example:
http://www.magicmotorcars.co.uk

click on our current stock, then view our current stock

that is pretty much what he needs, an admin where he can go in and add cars and they will show up on the site like that other site I just pasted

i was really making it out to be harder in my mind than it really is
i got calmlikeabomb to do it for me, and he is almost done...in less than 5 hours :)

[sarettah]

Cool...

are you covering the detail pages too ?

Meaning where you go when you clieck the thumb... http://www.magicmotorcars.co.uk/current_stocklist.htm

[sarettah]

http://www.partyafterdark.com/car_site/cgi...s/adminform.php (http://www.partyafterdark.com/car_site/cgi-bin/scripts/adminform.php)

(about 2 hours total from scratch on the master admin panel...just for fun)

[Jace]

Originally posted by sarettah@Mar 19 2005, 05:46 AM
Cool...

are you covering the detail pages too ?

Meaning where you go when you clieck the thumb... http://www.magicmotorcars.co.uk/current_stocklist.htm
yeah, when someone clicks on more info they come to the big info page for the car

[Jace]

Originally posted by sarettah@Mar 19 2005, 07:49 AM
http://www.partyafterdark.com/car_site/cgi...s/adminform.php (http://www.partyafterdark.com/car_site/cgi-bin/scripts/adminform.php)

(about 2 hours total from scratch on the master admin panel...just for fun)
ha...very cool....damn, now that i know about you, i will hit you up from now on for my scripting needs :)

[Trev]

Originally posted by JaceXXX+Mar 20 2005, 01:32 AM--></div><table border='0' align='center' width='95%' cellpadding='3' cellspacing='1'><tr><td>QUOTE (JaceXXX @ Mar 20 2005, 01:32 AM)</td></tr><tr><td id='QUOTE'> <!--QuoteBegin-sarettah@Mar 19 2005, 05:46 AM
Cool...

are you covering the detail pages too ?

Meaning where you go when you clieck the thumb... http://www.magicmotorcars.co.uk/current_stocklist.htm
yeah, when someone clicks on more info they come to the big info page for the car [/b][/quote]
Oh fuck your hard work...

[Trev]

Originally posted by sarettah@Mar 19 2005, 04:49 PM
http://www.partyafterdark.com/car_site/cgi...s/adminform.php (http://www.partyafterdark.com/car_site/cgi-bin/scripts/adminform.php)
Goddamn your good :wnw: :wnw:

[Trev]

Sar mail me please

or icq 113565138

:)

[Jace]

Originally posted by Trev+Mar 19 2005, 04:34 PM--></div><table border='0' align='center' width='95%' cellpadding='3' cellspacing='1'><tr><td>QUOTE (Trev @ Mar 19 2005, 04:34 PM)</td></tr><tr><td id='QUOTE'> Originally posted by JaceXXX@Mar 20 2005, 01:32 AM
<!--QuoteBegin-sarettah@Mar 19 2005, 05:46 AM
Cool...

are you covering the detail pages too ?

Meaning where you go when you clieck the thumb... http://www.magicmotorcars.co.uk/current_stocklist.htm
yeah, when someone clicks on more info they come to the big info page for the car
Oh fuck your hard work... [/b][/quote]
haha, if THAT is hard work then you have terrible ethics :)

[sarettah]

Originally posted by JaceXXX+Mar 19 2005, 08:09 PM--></div><table border='0' align='center' width='95%' cellpadding='3' cellspacing='1'><tr><td>QUOTE (JaceXXX @ Mar 19 2005, 08:09 PM)</td></tr><tr><td id='QUOTE'> Originally posted by Trev@Mar 19 2005, 04:34 PM
Originally posted by JaceXXX@Mar 20 2005, 01:32 AM
<!--QuoteBegin-sarettah@Mar 19 2005, 05:46 AM
Cool...

are you covering the detail pages too ?

Meaning where you go when you clieck the thumb... http://www.magicmotorcars.co.uk/current_stocklist.htm
yeah, when someone clicks on more info they come to the big info page for the car
Oh fuck your hard work...
haha, if THAT is hard work then you have terrible ethics :) [/b][/quote]
Hey, they got me befuddled... How do they make that leetle pic grow like that ?? :blink:





:yowsa:


Trev, I will fire up my icq in just a minute.... :okthumb:

[sarettah]

Originally posted by JaceXXX+Mar 19 2005, 07:33 PM--></div><table border='0' align='center' width='95%' cellpadding='3' cellspacing='1'><tr><td>QUOTE (JaceXXX @ Mar 19 2005, 07:33 PM)</td></tr><tr><td id='QUOTE'> <!--QuoteBegin-sarettah@Mar 19 2005, 07:49 AM
http://www.partyafterdark.com/car_site/cgi...s/adminform.php (http://www.partyafterdark.com/car_site/cgi-bin/scripts/adminform.php)

(about 2 hours total from scratch on the master admin panel...just for fun)
ha...very cool....damn, now that i know about you, i will hit you up from now on for my scripting needs :) [/b][/quote]
That should have been quicker but I haven't been keeping my hands in php lately (been doing a shitload of asp crap lately) So I just decided to see what led to what and handcoded the whole mess. Didn't even pull in any of my libraries :)

It was a fun little exercise and helped me workout some interactions I've been trying to figure out on another project :)



thanx to both you and Trev for the comps :okthumb:

[Dravyk]

Sare, I do believe you're getting faster! Nice stuff! :okthumb: