Item DataBase

[callimuc]

Well I have seen on several threads, heard from several people and realized on several servers that an ´Item-DataBase´ seems to be something good.
I wanted to try also making such a thing but how exactly are they made? Like is everything bumped in an array (doesn´t seem to be good in my oppinion)?

PHP Code:

this.items = {weapon, {stats, more stats, ...}, weapon2, {stats, more stats, ...}, ...}; 


Is it prefered to make them like

PHP Code:

this.item0001 = {weapon, info, damage, image, icon, more stats, ....};
this.item0002 = {"skip", "ani", NULL, "skip.png", "skip-icon.png", {"chat", "funny"}, ....};
.... 


Can anyone maybe tell me some goods and bads about that, maybe give me an example and how they should be used and stuff? No I´m not asking for a full code, just never saw/worked with such a system so I want to see how to work with it.

I do know that everything is stored in a DB.