View Single Post
01-02-2013, 01:32 PM
#2
unikorndesigns is offline unikorndesigns
unikorndesigns's Avatar
Status: Junior Member
Join date: May 2011
Location:
Expertise: Web Designing and Development
Software: Photoshop, Dreamweaver and etc
 
Posts: 41
iTrader: 0 / 0%
 

unikorndesigns is on a distinguished road

  Old

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>';
}
?>

Reply With Quote