Anyone wanna help (Database)

[alteraudiousa 10+ year member]

i'll take pics of what i have

 

[Jdizzle 10+ year member]

thats word

 

[Raven 10+ year member]

Finished product?!? I just started today. I'm going to see if I can accomplish basic input/output today. So far so good, I guess.

EDIT: What is PHP Nuke?

EDIT2 : It is now 10 to 3. Nearly 3 and a half hours after starting, I've nearly finished with the applet that puts stuff into the database. Yippee. I was lucky enough to start this project with Flakko's "ever expansive Web Site" work ethic, and I'm glad I did. 4 hours into it I realized I'd have to add 2 more tables and mod 3 others. The app didn't stumble a bit. I don't even get PHP notices. =)

 

[Raven 10+ year member]

Five past four:

After 15 tries, I've learned 14 ways not to properly move and rename an uploaded image. Before today, I hadn't actually used PHP in at least half a year. I guess it's not exactly riding a bike. =\

However, this completes basic functionality of putting data into the database! W00t! It's not the prettiest looking code, or the most user friendly one (Although it is pretty easy to use, just little nuances I passed up along the way), but for 5 hours of work I'm pretty proud of what I accomplished. I leave for work at about quarter til. I'll try to pretty it up by then.

 

[flakko 5,000+ posts]

omarvelous hasnt been on and keny is waitin for you hehe

 

[Omarvelous 10+ year member]

I kind of like CADB.com.

Also about the DB, streetprice?? i think MSRP would be better.

Also maybe include year of model, might be differences amongst the years.

Aim: Osomarvelous

MIS Major, Senior, LOVE database! Also know how to integrate db backend with dynamic web pages, jsp more so, but know a lil cfusion and can easily learn enough ASP.

 

[Omarvelous 10+ year member]

OK, now the part of every database that scares the hell out of me - the archtecture. How do we plan on doing this?

Product
- id
- manufacturer [link: Manufacturer.id]
- model
- street price
- power input/output
- T/S spec (where applicable)
- Efficiency (where applicable)
- author id [link: author.id]
- type id [link: type.id]

Type
- id
- kind {subwoofer, amp, comp set, coax, mid, tweeter, enclosure, etc}


Reviews
- id
- item reviewed (product, manufacturer, other review, author, or picture)
- item type (review brand X subs in general, or brand Y comps in general! if applicable)
- item id [link: item reviewed.item id] (if applicable)
- date posted
- review
- author id [link: author.id]

pictures
- id
- item reviewed (product, manufacturer, other review, author, or picture)
- item id [link: item reviewed.item id]
- picture
- author id [link: author.id] 

Authors
- id
- username
- join date
- posts

(It is said a good programmer looks both ways before crossing a one way street.)

Either way can be done, but we need this figured out before we can get to the all important part of putting data into and getting data out of it.

I just hope u distinguish the IDs. Like not just ID as coloumn name in each table, but AuthID or RevID, or ProdID and use those as the column names ith the foriegn and primary keys.

Didn't see a Manuf Table, i'm sure u planned on adding it

Think we should fullly map out the db before we actually implement it. It can be easily updated/changed and so on after we create it, if it has been already. But best to draw it at most efficiency before then.

 

[Raven 10+ year member]

Well, I had a pretty clear diagram of the layout before I started, however now that the structure is pretty much finished those diagrams are about as useful as a 14th century map of Africa. =)

The IDs stayed "id". As I've been saying this kind of thing isn't exactly a livelyhood, more a hobby I grew out of. That said, what are you talking about? Foreign key? I used "id" because it's universal. I can set what table to get a specific id from. Otherwise, it's just another variable I have to softcode. Yeah, I could do it, but it's just more effort that I have yet to find necessary.

 

[Omarvelous 10+ year member]

Well, I had a pretty clear diagram of the layout before I started, however now that the structure is pretty much finished those diagrams are about as useful as a 14th century map of Africa. =)
The IDs stayed "id". As I've been saying this kind of thing isn't exactly a livelyhood, more a hobby I grew out of. That said, what are you talking about? Foreign key? I used "id" because it's universal. I can set what table to get a specific id from. Otherwise, it's just another variable I have to softcode. Yeah, I could do it, but it's just more effort that I have yet to find necessary.

It helps when linking, tahts all.

If you have Prod.ID, and Manf.ID, when u try to use Manf.ID in the Prod table, you can't use the same Manuf.ID, because you already have a ID in PRod, so u'd have to change that foreign key to say Prod.ManufID.

So in Prod it's ManufID, but in Manuf its ID. Get what i'm saying? It's just good practice to distinguish IDs, since it's usually a Primary key, and Primary keys are mostly used for foreign keys.

I would have personally done it as so Prod.ProdID, Manuf.ManufID, so when i tie the Manuf to a Prod, it's Prod.ManufID same as Manuf.ManufID. MAkes life easier when coding, since they are equal in all tables. Get it? //content.invisioncic.com/y282845/emoticons/wink.gif.608e3ea05f1a9f98611af0861652f8fb.gif

 

[theCybe 5,000+ posts]

Finished product?!? I just started today. I'm going to see if I can accomplish basic input/output today. So far so good, I guess.
EDIT: What is PHP Nuke?

it's a CMS - content management system.

here's a stock install on my httplayground;

http://www.kayrad.com/nuke

http://www.cmswatch.com/

what's great about CMS in general is that it's like, .. OOBE, if you will; plugins.

 

[Raven 10+ year member]

It helps when linking, tahts all.
If you have Prod.ID, and Manf.ID, when u try to use Manf.ID in the Prod table, you can't use the same Manuf.ID, because you already have a ID in PRod, so u'd have to change that foreign key to say Prod.ManufID.

So in Prod it's ManufID, but in Manuf its ID. Get what i'm saying? It's just good practice to distinguish IDs, since it's usually a Primary key, and Primary keys are mostly used for foreign keys.

I would have personally done it as so Prod.ProdID, Manuf.ManufID, so when i tie the Manuf to a Prod, it's Prod.ManufID same as Manuf.ManufID. MAkes life easier when coding, since they are equal in all tables. Get it? //content.invisioncic.com/y282845/emoticons/wink.gif.608e3ea05f1a9f98611af0861652f8fb.gif

Ahh, that does make sense. However, I just use the table name for a field instead. IE, the "product" table has a "manufacturer" field in it. That and I never really use SQL statements for more than one table at a time. Like I said, hobby. //content.invisioncic.com/y282845/emoticons/wink.gif.608e3ea05f1a9f98611af0861652f8fb.gif

it's a CMS - content management system.
here's a stock install on my httplayground;

http://www.kayrad.com/nuke

Ahh! I see. SIN uses it, yes?

 

[theCybe 5,000+ posts]

re: sin

exactly. They may use postnuke, I didn't check. There are a ton of them out there. Highly customizable, open source, and easy to maintain.

Here's another;

http://www.kayrad.com/mambo http://www.kayrad.com/gallery

 

[flakko 5,000+ posts]

i love the way that looks.... although the technical jargon is confusing me lol

 

[Raven 10+ year member]

Looks are not my department. My job is the backend. Trust me, at this point the admin panel looks like a simplistic version of Adire's old Website.

Anyway, the edit feature is working. It won't do pictures yet, but I'm not done. I centralized the whole thing, too. You can now add and edit, and soon delete, without having to open new windows and re-browse.

If you can accept dipping a worm in paint and letting it crawl around a canvas as art, then I'm definitely making a work of art. =)

 

[theCybe 5,000+ posts]

Just PM me when some work needs to be done on my end. //content.invisioncic.com/y282845/emoticons/smile.gif.1ebc41e1811405b213edfc4622c41e27.gif

If you need an ftp testarea, also lmk.

Was a domain purchased, flakko?