Jump to content

Archived

This topic is now archived and is closed to further replies.

spires

uploading audio?

Recommended Posts

Hi,

I posted earlyer and a few of you really pointed me in the right direction. 
But as usual, i'm stuck.

I have uploaded the mp3s to the server, and the id and date have been placed inside the database.
But, i cant seem to get the 'name' and 'userfile_name' to load into the database.

Can someone have a quick look at my code and point me in the right direction.  ;D
Thanks

[code]


<?php
include('db.php');


    echo '
<center>
  <table cellpadding="0" cellspacing="0" width="400" class="TLRB_border">
<tr>
<td align="center">

<strong>"All audio must be .mpeg files"</strong><br><br>
    <form method="POST" action="'.$_SERVER['PHP_SELF'].'" enctype="multipart/form-data">
<input type="hidden" name="MAX_FILE_SIZE" value="'.$_POST['320834100'].'">
<input type="hidden" name="id" value="'.$_POST['id'].'">
<input type="hidden" name="date_sent" value="'.$_POST['date_sent'].'">
<br>please choose a music file<br>
    <input type="file" name="userfile"><p>
    <input type="Submit" name="Submit" value="Submit">
    </form>
</td>
</tr>
</table><br>
</center>';



$query="select * from music where name='$name' and id='$id'";

$result=mysql_query($query);

while($row=mysql_fetch_assoc($result)) {

if($row["userfile_name"]=1) {

echo "<b>Sorry you have a video already</b><br><br><a href='../index.php'>Update music</a><br><br>";
exit;
}
}




if(!isset($_FILES['userfile'])=="none") {
echo"no file specified<br><a href='upload.php'>please try again1</a><br><br>";
exit;
}


$uploaddir ="mp3/";
$uploadfile = $uploaddir . basename($_FILES['userfile']['name']);

$size=$_FILES['userfile']['size'];
$type=($_FILES['userfile']['type']=="audio/mpeg");

if($size <= 320834100) {

if($type) {

if(move_uploaded_file($_FILES['userfile']['tmp_name'],$uploadfile)) {

$date_sent = date("Y-m-d");

$id = $_POST['id'];
$userfile_name = $_POST['userfile_name'];
$name = $_POST['name'];


$userfile_name = addslashes($userfile_name);

$query="INSERT INTO music (id, name, date_sent, userfile_name) VALUES ('$id', '$name', '$date_sent', '$userfile_name')";

$result=mysql_query($query);

echo "file uploaded";

}else{
echo"no file uploaded <br><br><br><a href='upload.php'>please try again2</a><br><br>";
exit;
}


}else{
echo"sorry wrong file type .mp3 only<br><br><br><a href='upload.php'>please try again3</a><br><br>";
exit;
}

}else{
echo"sorry wrong file type .mp3 only<br><br><br><a href='upload.php'>please try again4</a><br><br>";
exit;
}
?>



<?php

$music_query="SELECT * FROM music WHERE id='$id'";
$music_result=mysql_query($music_query);

while($mus=mysql_fetch_assoc($music_result)) {


$music_link="<embed src='mp3/".$mus["userfile_name"]."'  bgcolor='#A0C0F0' width='125' height='125' autostart='false' loop='false' >";
}

?>
[/code]

Share this post


Link to post
Share on other sites
Your form has no element named 'name' so this... $name = $_POST['name']; is redundant.

ps: What editor are you using? Those tabs are anoyingly difficult to read.

Share this post


Link to post
Share on other sites
^ Agreed about the tabs--they're slightly ridiculous to look at. It seems a lot of people have been posting code that's just all over the map and completely unorginized. O_O

Share this post


Link to post
Share on other sites
OK, Thanks

Explain please. i'm very new to PHP.

Quick question
How does the $_FILES read the name of the mp3?
How does it know what its callled and what part of the code does this?

I've only just started learning how to do this, and am not to shore how it all works yet.

Share this post


Link to post
Share on other sites
any better?

[code]
<link href="../css/nicky.css" rel="stylesheet" type="text/css">

<?php
include('db.php');


    echo '
<center>
  <table cellpadding="0" cellspacing="0" width="400" class="TLRB_border">
<tr>
<td align="center">

<strong>"All audio must be .mpeg files"</strong><br><br>
    <form method="POST" action="'.$_SERVER['PHP_SELF'].'" enctype="multipart/form-data">
<input type="hidden" name="MAX_FILE_SIZE" value="'.$_POST['320834100'].'">
<input type="hidden" name="name" value="'.$_POST['name'].'">
<input type="hidden" name="userfile_name" value="'.$_POST['userfile_name'].'">
<input type="hidden" name="id" value="'.$_POST['id'].'">
<input type="hidden" name="date_sent" value="'.$_POST['date_sent'].'">
<br>please choose a music file<br>
    <input type="file" name="userfile"><p>
    <input type="Submit" name="Submit" value="Submit">
    </form>
</td>
</tr>
</table><br>
</center>';



$query="select * from music where name='$name' and id='$id'";

$result=mysql_query($query);

while($row=mysql_fetch_assoc($result)) {

if($row["userfile_name"]=1) {
echo "<b>Sorry you have a video already</b><br><br><a href='../index.php'>Update music</a><br><br>";
exit;
}
}




if(!isset($_FILES['userfile'])=="none") {
echo"no file specified<br><a href='upload.php'>please try again1</a><br><br>";
exit;
}


$uploaddir ="mp3/";
$uploadfile = $uploaddir . basename($_FILES['userfile']['name']);

$size=$_FILES['userfile']['size'];
$type=($_FILES['userfile']['type']=="audio/mpeg");

if($size <= 320834100) {

if($type) {

if(move_uploaded_file($_FILES['userfile']['tmp_name'],$uploadfile)) {

$date_sent = date("Y-m-d");

$id = $_POST['id'];
$userfile_name = $_POST['userfile_name'];
$name = $_POST['name'];


$userfile_name = addslashes($userfile_name);

$query="INSERT INTO music (id, name, date_sent, userfile_name) VALUES ('$id', '$name', '$date_sent', '$userfile_name')";

$result=mysql_query($query);

echo "file uploaded";

}else{
echo"no file uploaded <br><br><br><a href='upload.php'>please try again2</a><br><br>";
exit;
}


}else{
echo"sorry wrong file type .mp3 only<br><br><br><a href='upload.php'>please try again3</a><br><br>";
exit;
}

}else{
echo"sorry wrong file type .mp3 only<br><br><br><a href='upload.php'>please try again4</a><br><br>";
exit;
}
?>



<?php

$music_query="SELECT * FROM music WHERE id='$id'";
$music_result=mysql_query($music_query);

while($mus=mysql_fetch_assoc($music_result)) {


$music_link="<embed src='mp3/".$mus["userfile_name"]."'  bgcolor='#A0C0F0' width='125' height='125' autostart='false' loop='false' >";
}

?>[/code]

Share this post


Link to post
Share on other sites

×

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.