I need to create a database of around 1000 music albums that I can put on my site, with the ability to search the database according to several different criteria.
Being a complete and total NOOB to the world of databases, can anyone point me in the direction of some software that will let me create a good-looking and functional database, but that isn't too complicated for me to use?!
Sounds like a tall order I know, be grateful if anyone can help though.
This kind of system isn't very difficult to program. A good language would be PHP.
You did not mention if you have any programming skills but if you do you should be able to program the system if you are willing to learn the basics of SQL (Structured Query Language. A rather simple language for doing queries on realtional databases)
To get started I'd recommend creating a MySQL database (can be done from the cPanel by just setting a databasename and username & password pair) and then heading to phpMyAdmin (also from cPanel).
PhpMyAdmin is full graphical web utility for managing your databases. You shold be able to use it with no problems.
First select your just created database (from the pull down menu at left) and then create some tables in it. A table structure for your album database could be somthing like this:
CODE
Albums table: _______________________________________________________ album_id | artist_id | album_name | year | record_label
Artist table ____________________________________ artist_id | artist_name | country |
The fields of course can be anything you want... But it is smart to have id's for all rows (and setting them to auto_increment) so that each album and artist has an unique ID.
After you have created the tables (you could create just one for testing) then add some data to them. This also can be very easily done from the phpMyAdmin. But pay attention to the SQL code that phpMyAdmin prints out. This is the form that your scripts should be using when they insert/get data to/from the database. After few inserts you should be able to get the idea how SQL works. It is really that simple. Then you could read more about SQL and MySQL DBMS (database management system) from http://dev.mysql.com/doc.
Next step would be to create scripts to do queries from the database and printing out the data in a suitable manner for your site. I personally use PHP, but I'm sure ASP or JSP are just as good options for this. If you don't know any of these languages yet but have some previous programmign experience, pick the one that's closest to what you've been doing before. PHP is quite similar to C, if you know C you'll learn PHP real easy. JSP is Java for server side scripts so if you're java-man you'll feel home with JSP.
At least PHP has excellent online documentation (http://www.php.net) with lot of examples. Also for dealing with databases.
I hope this helped. Dealing with databases is whole lot easier that you might think, but like everything new, it takes time to learn and get used to it. And if and when you ran into problems remember that these boards are filled with people willing and capable to help out.
hbr - get your hosting account here (you've to meet the Post Requirements first) - but once you get that - we can guide you gradually in setting up your optimized MySQL Database and help you link it with a PHP based web-page that will spit out categorized albums+tracks - the way you want. It's a fairly long drawn process but nothing complicated at all - so no need to worry
lets see... from the sound of it.. i don't think you know any scripting language.. i recommend you to learn PHP.. php.net and phpfreaks.com is a good place to start. after that you can move on to mysql.. there are some good books out there on php and mysql combined.. i recommend you to read one of those.. and hey.. PM me if you need any help.. i love to help aspiring webmasters! cheers
It's not a database but have you considered creating a Gmail account and posting items by email to it. With extensive searching capability, ability to order emails by category and up to 2Gbyte storage, and did I mention free, it could meet your needs Regards
Hi there, I'm creating a music streaming website and using php and sql. When I call my music they all seemto play together,I tried using the code autostart=false but that doesnt seem to work? can anyone help?
I thought I would take a moment to point the users here to some of the database resources available
for reference and learning. First I will start with actually designing the database. This site by
R937 covers the basics of database design. The author is professional database guru and a frequent
helper at the at DB forums listed below. The Library of Free Data Models is an excellent
resource for finding data models for projects you may have or as examples of well put together data
models. With around 500 data models the chances are you find something at least cl....
Hello: I am new to JAVA and server-side applications and have a dumb question. I have set up
Tomcat on my machine and created a JSP program to query an Access database using a DSN-Less
connection. If I publish the page to a webserver and include the .MDB file will it work? I'm
not sure exactly what needs to be packaged with my Java application to make it work. Since I
don't have a remote server that supports .jsp I cannot really test it. I'm assuming that
JDBC driver would be bundled with my site but not sure. Thanks!....
Iam assuming the information in the databases i will create will be stored in the 500 MB space i
get, but since 500MB isn't enough iam wondering if you guys can tell me how much bytes the
following take: Varchar(x),Tinyint,Text,date,smallint,mediumint,bigint,float.... And the rest
present when you add/edit a row in a table. Also what are the ranges of tinyint,smallint,mediumint
and big int....
Hi i am new, I have a problem in understanding the query decomposition in D-DB. Can anyone help me
to understand the first question of the exercise 25.21 of Elmasri-Navath 4th edition? Consider the
following relations: BOOKS (Book#, Primary_author, Topic, Total_stock, $price) BOOKSTORE
(Store#, City, State, Zip, Inventory_value) STOCK (Store#, Book#, Qty) Consider a distributed
database for a bookstore chain called National Books with 3 sites called EAST, MIDDLE, and WEST.
Consider that BOOKS are fragmented by $price amounts into: B1:BOOK1:up to $20.....
Hi I am a manager at a trading/wholesaling company (and have no programming background). I
customized the Northwind sample access database to make invoices and keep accounts for my company.
We now opening another office at a distant location. So, the order entry will be done at two
points(we plan to use the same Access database). I am not able to figure out how to access the same
MS Access database from two different location(as LAN can't be used). Moreover, we can't
afford to pay huge sums to the software developers. Can intranet or uploading the database t....
Hey guys, im new here and am looking for answers /tongue.gif" style="vertical-align:middle"
emoid=":P" border="0" alt="tongue.gif" /> Firstly, i have designed a database using M$ access,
it consists of multiple forms which i plan to host on an intranet website, i need to be able to add
records directly from the form on the intranet website aswell as being able to edit/review current
entries on forms in the database. My question is, how would i go about integrating these forms onto
the intranet website? i plan on keeping the database and the intranet site on the s....
i have free script but it is working fine on a lot of sites i tried to use it to my web site ....i
edit its config.php right and but my database name and my user name and password every thing right
and when i try to install it it gives me this error can`t connect to database please choose
file from this mobile.sql can any body help plz coz i tried huderd of times and no thing happend....
I wondered if anyone here can help. I have a database on a remote server (A). I want to access it
through a php script on a different server C. I have allowed access on (A) in Cpanel - mysql dbases
- Remote Access by putting the IP address of server C The host of server (A) has also whitelisted
the IP of server C. Though I am having trouble connecting from server C which is with a different
webhost. any ideas how to get round this? I have though of SSH forwarding, but I think this can
only be used to connect a client - e.g. my pc to the remote server A. I do not ha....
There are a lot of different free software in Internet, but I have found only couple of free
graphical tools for database adminiatration. On another hand, MySQL is free for non commercial
usage. That's way it will be nice to have any good free GUI for this database. I remember the
time, when one of MySQL-Front versions was for free, but now it is opened only for testing period.
There is also free version of Toad, which is not full Toad, but it looks also very well - However, I
am not going to use Oracle (wchich is quite expensive commercial tool) on my desktop. The....
i am creating a game and i set when someone registers than he gets id...in "extra" i have set it to
be "auto_increment" but whenever new player signs up he gets number bigger than 210...(my first id
was 211,next was 212,third was 213,fourth got 214) how to set it to go from 1 to infinite? thnx....
Ok, i am new at web design, i dont know too much about it... I was working on a website for about
a month this is what i got, My Web , like i said, i dont know much.. i used FrontPage and did all
of that, my current host is AFMU which uses MySQL, but the way it is set up I dont know how to
acquire the URL of the database or any information i dont know what it means at all.. i just want to
do a simple login feature, i mean this is my first website and i am learning so I think it would be
a great feature to add in and learn. i can create data bases from there but do n....
Well I know that MySQL databases can get rather big, so I was just wondering how big everybodies
databases were? Do you have really big ones, or are they relatively small? Also what do you store in
them? (just text, or binary data as well)....
QUOTE Hi, I noticed there were a lot of questions in all of the database topics, so i went
around the internet using different sources, and have some information that will answer your
questions and help you understand databases. I hope this helps, and if you have any other questions
which arent answered below, please send a message asking. Thankyou. In computing, a database can be
defined as a structured collection of records or data that is stored in a computer so that a program
can consult it to answer queries. The records retrieved in answer to queries become i....
Iam thinking of starting an online game, I have some knowledge in PHP and C++ skills. But I am still
new to mysql. I have 2 things to ask, the first is a bit of topic but does this sight allow me to
host a game?. 2, how do i make a data base. You know units hp, attack and other characteristics. +
people making acounts (sign up by email and verify) and all other things. Can any one help me?
/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" />....
Most of us using databases or doing data minings are not aware of SQL-92 specification seemingly
these days. SQL-92 specifiaction is the SQL database query language standard. Oracle,mysql
postgresql,mssql and DB2 - most widely recognized SQL database programs - are all closely related to
SQL-92 specification for the use of query nevertheless how they implemented SQL-92 specification
features inside in the program. Implementation of SQL-92 specification features are applied in the
order of Oracle, postgresql and mysql. These databases might have specific database query....
Hi friends, How many concurrent users can practically access the oracle database?
they say tht the figure is hundreds of thousands users...is there any exact figure? or does the
number of concurrent users depend on any other factors as wel? I think depend on parameter
1.session 2.processes session Specific connection of a user to an Oracle instance through a user
process. A session lasts from the time the user connects until the time the user disconnects or
exits the database application. Multiple sessions can be created and exist concurrently for ....
In a game I'm working on, I would like to have a database of actors/actresses. I'm not sure
exactly how to do this. I'm pretty sure with the hosting here, I can only have 99 databases.
I'm a little lost as to how to make it. Can all the actors/actresses be put on one database
with the specific things I want to include (i.e. how well the do in each genre)? I'm new to
Mysql and just need some help as to where to start.....
I seem to have a problem with accessing my database with proper permissions. I have set the my
database correctly giving my db username all priviliges yet i seem to be unable to even log on with
this username with a denied access error. Any ideas on resolving this?....
Hello to all of you beautifull people out there, I am new to MySQL, i just wanted to know if its a
good practice to directly store images and other binary files in a MySQL database. Any one with
help? Thanks....
I am new to MySql and have just created a database after using a script. My problem is not the
script, but what it says about putting it into the output file. I cant figure out the right terms
to put it in, I keep getting errors. I try using; SELECT*FROM 'database name' WHERE
'location' but it isnt working. I'm lost with this stuff, I really am. Can someone
please help me out?....
Ive been planning to create a online application which requires tons of stuff from database. Ive
been using interbase, at first it was good but after a month i find it not user friendly at all...
Its to hard to code in php.. Can any of you guys give me a good database which is easy to use?....
Hi, everyone I've host and I want to upload phpbb2 but there isn't a cpanel and I know I
must create a mysql db how can I do? Did you realy read my post?....
Hi..I want to ask if its possible to automatically mirror my mysql databases into another mysql
server?or create a small php script to do this? The reason is because, we all know that database is
very improtant if we have dynamic website. I have my forum hosted and i want to automatically
mirror this or backup into another mysql server(free). Like in freesql.org. So that im not afraid
that i forgot to backup my database..also i have one central backup database. Thanks for the
help..Im looking forward for this posibility.....
Hi, Now its the era of Embedded databases, no more db servers, no more host,Because with embedded
db you can get all those options, what you are used to get with DB Servers. Some of Embedded DB Are
1) Cloudscape From IBM (NOW Derby from ASF) 2) HSQLDB (OpenSource) and many more Feel the power of
EDB Cheers Arunkumar.H.G....
Hello, i'm a newbie in using phpBB and I still lack knowledge in mySQL database. How do I
transfer the datas(users,configs, all of them) contained in my current forum to another one in
phpBB? I hope someone can help, a short but detailed tutorial would be good. Example is, if I want
to move to a new host and I want to transfer all the accounts on my old forum to the new one. Thanks
in advance, hope anyone here knows how to.....
Looking for advice, creating, online, music, database, ps, databases
*RANDOM STUFF*
*SIMILAR VIDEOS*
Searching Video's for advice, creating, online, music, database, ps, databases
Express your Opinions, Thoughts or Contribute your information that might help someone here.
Ask your Doubts & Queries to get answers.. "Together, We enlight each other!"
Register FREE for AD-FREE
forum, Create your own topics, Ask Questions, track topics, setup
subscriptions & notifications and Get a Free Website w/ Email and FTP.
