Hey guys trying to get this audio uploading script to work but I can't seem to get anything into the database. I think something may have gone awry with my variables perhaps. Could you possibly point out where I'm going wrong if you can see it that is. Feel like my brain is melting
Thanks v.much as always
[ php ]
<!doctype html>
<html lang="en">
<head>
<!--how browser interprets stuff-->
<meta charset="utf-8" />
<title>FXMAS</title>
<link rel="stylesheet" href="main.css" />
</head>
<body>
<div id="big_wrapper">
<form enctype="multipart/form-data" action="upload.php" method="POST">
File: <input type="file" name = "file"><br>
<input type="submit" value="Upload">
</form>
<header id="main_header">
<h1></h1>
<h4></h4>
</header>
<nav id="menu">
<form method="get" action="/search" id="search">
<input name="q" type="text" size="40" placeholder="Search..." />
</form>
<ul>
<li><a href="music.php">Music</li>
<li><a href="fx.php">FX</li>
<li><a href="upload.php">Upload</li>
<li><a href="forum.php">Forum</li>
<li><a href="reports.php">Reports</li>
<li><a href="about.php">About</li>
</ul>
</nav>
<section>
<article>
<header>
<hgroup> <!--when you have more than one header-->
<h1></h1>
<h2></h2>
</hgroup>
</header>
<p></p>
<footer>
<p>written by Jamie 2014</p>
</footer>
</article>
<article>
<header>
<hgroup> <!--when you have more than one header-->
<h1></h1>
<h2></h2>
</hgroup>
</header>
<p></p>
<footer>
<p></p>
</footer>
</article>
</section>
<aside>
<h4></h4>
</aside>
<footer>
</footer>
</div>
</body>
</html>
<?php
// Connects to your Database
mysql_connect("localhost", "root", "") or die(mysql_error()) ;
mysql_select_db("mydb") or die(mysql_error()) ;
if ((($FILES["file"]["type"] == "audio/mp3")
|| ($FILES["file"]["type"] == "audio/mp4")
|| ($FILES["file"]["type"] == "audio/wav"))
&& ($FILES["file"]["size"] < 1000000))
{
if ($FILES["file"]["error"] > 0)
{
echo "Return Code: " . $FILES["file"]["error"] . "<br />";
}
else
{
echo "Upload: " . $FILES["file"]["name"] . "<br />";
echo "Type: " . $FILES["file"]["type"] . "<br />";
echo "Size: " . ($FILES["file"]["size"] / 1024) . " Kb<br />";
echo "Temp file: " . $FILES["file"]["tmp_name"] . "<br />";
if (file_exists("upload/" . $FILES["file"]["name"]))
{
echo $FILES["file"]["name"] . " already exists. ";
}
else
$mp3_name = $_FILES["file"]["name"];
$mp3_path = "pload/$mp3_name";
move_uploaded_file($_FILES["file"]["tmp_name"], $mp3_path);
$sql = "INSERT INTO 'music' SET name='$mp3_name', location'$mp3_path'";
$result = mysql_query($sql);
if($result)
{
echo 'MP3 Upload successfully';
}
else
{
echo 'ERROR: Upload Failed';
}
}
}
else
{
echo "Invalid file";
}
?>
[ /php ]