i dont know if this would help checkout my upload script
PHP Code:
<?php
function get_mime_type($file) {
// our list of mime types
$mime_types = array(
"pdf"=>"application/pdf",
"exe"=>"application/octet-stream",
"zip"=>"application/zip",
"docx"=>"application/msword",
"doc"=>"application/msword",
"xls"=>"application/vnd.ms-excel",
"ppt"=>"application/vnd.ms-powerpoint",
"gif"=>"image/gif",
"png"=>"image/png",
"jpeg"=>"image/jpg",
"jpg"=>"image/jpg",
"mp3"=>"audio/mpeg",
"wav"=>"audio/x-wav",
"mpeg"=>"video/mpeg",
"mpg"=>"video/mpeg",
"mpe"=>"video/mpeg",
"mov"=>"video/quicktime",
"avi"=>"video/x-msvideo",
"3gp"=>"video/3gpp",
"css"=>"text/css",
"jsc"=>"application/javascript",
"js"=>"application/javascript",
"php"=>"text/html",
"htm"=>"text/html",
"html"=>"text/html"
);
$extension = strtolower(end(explode('.',$file)));
$type=explode("/",$mime_types[$extension]);
return $type[0];
}
if($_SERVER['REQUEST_METHOD'] == "POST"){
if(move_uploaded_file($_FILES['file']['tmp_name'], "../../uploads/".$_FILES['file']['name'])){
// connect to the mysql server
$link = mysql_connect("localhost", "root", "")
or die ('Could not connect to mysql because '.mysql_error());
// select the database
mysql_select_db("mis_revamp")
or die ('Could not select database because '.mysql_error());
$media_type=get_mime_type("../../uploads/".$_FILES['file']['name']);
$query1="SELECT * FROM media WHERE media_filename='".$_FILES['file']['name']."'";
$result1=mysql_query($query1);
$numrows1=mysql_num_rows($result1);
mysql_query("INSERT INTO media VALUES ('','".$_FILES['file']['name']."','".filesize("../../uploads/".$_FILES['file']['name'])."','../uploads/','".$media_type."',CURDATE())");
$query1="SELECT * FROM media WHERE media_filename='".$_FILES['file']['name']."'";
$result1=mysql_query($query1);
$numrows1=mysql_num_rows($result1);
while($row=mysql_fetch_array($result1))
{
$id=$row['media_id'];
}
}
$extnsn=strtolower(end(explode('.',$_FILES['file']['name'])));
$filename=str_replace(".".$extnsn,"",$_FILES['file']['name']);
echo '<div class="dfiles"><img src="../../uploads/'.$_FILES['file']['name'].'" style="float: left; padding-top: 3px;" height="30" width="30"/><h5><b>'.$filename.'</b> </h5>
<div class="progress" style="font-size: 11px"><a href="media/edit_media/'.$id.'">Edit Media</a></div></div>';
}
?>