Im building an online music video library with php can anyone point me out getting it wrking with the database

Recommended Answers

All 2 Replies

I'm a nice guy, but I got to say, RTFM. The code examples in the PHP documentation are VERY good. It is unlikely that anyone here is going to explain it more simply than the PHP documentation.

You did not mention what database you want to use, but lets assume MySQL. Here is a link to PHP's MySQL-related functions.
http://www.php.net/manual/en/ref.mysql.php

From the link above:

<?php
// Connecting, selecting database
$link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password')
    or die('Could not connect: ' . mysql_error());
echo 'Connected successfully';
mysql_select_db('my_database') or die('Could not select database');

// Performing SQL query
$query = 'SELECT * FROM my_table';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());

// Printing results in HTML
echo "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
    echo "\t<tr>\n";
    foreach ($line as $col_value) {
	    echo "\t\t<td>$col_value</td>\n";
    }
    echo "\t</tr>\n";
}
echo "</table>\n";

// Free resultset
mysql_free_result($result);

// Closing connection
mysql_close($link);
?>

The database is my sql i have connected to the database

itsuite.it.bton.ac.uk/student/iak/m

with the join form

i want to have a database with music link it to an API or something so that the database will have music on it so it can be streamed to a browser or mobile phone and pda devices

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.