[RESOLVED] Recommendations for a database system.

daveyc

Hi Guys,

Right, im looking at creating an online radio station. The server side setup and everything isn't a problem whatsoever, that's all done already..

The hard part is.. I'm looking to have my website database driven. For example, there's a list of genre's on the right hand side, when a user clicks one say for example "Alternative" It loads up "alternative.php" in the main iframe.. This is okay, all done.

The hard part is coming up with a database that contains all the stations. So when the page requests items from the database it will retrieve the stations by the selected genre, and display them in a table with a station image, and the listen link to connect to the server.

So, i need to know if there is a way out there to easily create a database. Writing the php script to pull the info i think i could manage, although im not too sure..

Any recommendations or pointing me in any direction (wether it be the right one or not!) would be very greatly appreciated 🙂

Thanks,

Davey

Kudose

daveyc wrote:
So, i need to know if there is a way out there to easily create a database...

Do you have a database system already installed?

If not, I recommend MySQL. It's fast, well supported, and best of all ... FREE.

Otherwise, check out the vendors website for a manual.

daveyc

Hi Kudose,

Yes, i have MySQL installed on the webserver already. I'm just wondering how i would go about such a task to pull the stations with the selected genre with their unique listen links 🙂

Thanks for your help

Davey

Gonwee

If its in the database already you can just write a query similar to this,

select * from stations;

If you have columns lets say, name and link, then you can just output them,

while ($row = mysql_fetch_array($query, MYSQL_ASSOC) {
// $row['name']; will be the name for the current station name
// $row['link']; will be the link to the current station
}

And in each iteration you can have it output a row in a table,

echo "
<tr>
<td>$row[name]</td><td><a href=\"$row[link]\">Listen Now</a></td>
</tr>";

But you will need to connect to the database before you can query it, if you don't know how heres how.

//$db is your database connection reference link
$db = mysql_connect('host', 'username', 'password');

mysql_select_db('database');

daveyc

Thanks for your help! 🙂 It's kinda doing what i want it to do now 🙂 Thanks a lot.

After looking through the web for a good while looking for some MySQL database wizards, i found these to be no use.

So, i done a bit more searching and found this tutorial. It may be of help to others in my situation 🙂

http://www.reg.ca/faq/PhpMyAdminTutorial.html

It's a little old, but still works 🙂

Davey

Gonwee

phpma is a good tool for db access. You can't really use it for an interface for you scripts, but it has cool features, like it will let you do a query, using its interface, and has a view code button that shows you the code to get that result.

Reading a bit about mysql might help you some to.

mnceo

even though this is resolved.. i reccomend MySQL also... i've been using it for about a year now and is great 🙂