Jump to content

Recommended Posts

Hello everyone.

 

I'm in the making of a dynamic (hopefully) site to let people browse, listen and download the music I've made through the years, where I can use an upload form (uploading a file + some relevant info) to automatically make a ... song.php?id=*** site. (By now you know, I'm totally clueless ;) )

 

I've set up a database, an upload form, it's tested, everything works so far (a file gets uploaded to the server, and relevant info is posted to the db).

The problem is, I dont know how to use this effectively.

 

I'm able to retrieve a Title through searching for a specific artisthandle, like so:

 

$result = mysql_query("SELECT * FROM uploading
WHERE Artist='artistname'");

while($row = mysql_fetch_array($result))
  {
  echo "..: Artistname"; 
  echo "<br />";
  echo $row['Title'];
  echo "<br />";
  }

 

But from here on out, I don't know - and I really fail to find tutorials (which have been my only source as of now).

 

In general, I want my site to, systematically, work much like e.g. www.ctgmusic.com. How is it set up? How do you make ...php/?id='''  pages? How does it work? :(

What variables or functions do I need to use?

 

If anyone have an easy-going tutorial on these basics, I would be extatic!

Hope to hear from you :)

$_GET['id'] will retreve the song id from the url for you thats a big help there

then its just a basic sql query to get the song by id and the relavent data and display it nothing complicated just simple is best lol

 

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.