Discussion Forums  >  Suggestions, Ideas, Wish List

Replies: 3    Views: 214

JacobMillsap
Lost but trying
Profile
Posts: 8
Reg: Oct 14, 2012
Cincinnati
5,530
11/19/12 06:19 AM (13 years ago)

Creating a Database

For school my partner and I are creating an app, how would one go about creating a database for cloths, i know that all cloths have an RN number on them. Not sure how to do this, would be greatly apreciated. A database individually for that app, not network database. Let me elaborate. This is going to be a fashion app that user can plug in each piece of clothing into the database on that App. I really dont want to say more on open forum.
 
Fingers Crossed
Veteran developer
Profile
Posts: 234
Reg: Jan 16, 2012
Simcoe, ON
6,390
like
11/19/12 03:36 PM (13 years ago)
An article by GoNorthWest I found worked quite well for creating and populating a database.... http://www.buzztouch.com/files/howtos/Posting_Current_Location_to_a_Database_v1.0.pdf It might be enough to get you on your way. I used it in conjunction with http://www.zymic.com/ to use as a testing site etc.
 
Karaokeman
Lost but trying
Profile
Posts: 14
Reg: Jan 18, 2013
La Grande
9,940
like
01/31/13 07:19 PM (12 years ago)
im curious what kind of database to use for my app. its all singer and song title data for a karaoke book. i need to be able to have users search my songbook by artist or title not sure how to do this as the artist search would need to display a list of song by that artist and so on. any help would be great
 
Fingers Crossed
Veteran developer
Profile
Posts: 234
Reg: Jan 16, 2012
Simcoe, ON
6,390
like
01/31/13 07:50 PM (12 years ago)
Short answer - a mySql database, and a php script to query it. As always, it sounds easier than it actually is, but it isn't THAT hard to do. If you don't know php or SQL, a quick google will get you on your way. You will need a host that allows php and SQL, but if you have that, you can play around with it. As a simple example, you could have the SQL do something like Select Songs From dbKaraoke where artist = varArtist (Overly simplified, but in that direction) Hope that helps. Graham.
 

Login + Screen Name Required to Post

pointerLogin to participate so you can start earning points. Once you're logged in (and have a screen name entered in your profile), you can subscribe to topics, follow users, and start learning how to make apps like the pros.