Advanced Search

Return to Snippet

Revision: 39771
at January 20, 2011 20:45 by danhanly
Initial Code 
<?php

require "../../scr/config-data.php.inc";
mysql_connect($host,$username,$password) or die 
("Could Not Connect".mysql_error());
mysql_select_db($db) or die ("Could Not Connect".mysql_error());
$pid = $_POST['pid'];
	
if (!empty($_FILES)) {		
	$selectAlias = mysql_query("SELECT * FROM project WHERE id = '$pid'");
	while($alias_result = mysql_fetch_array($selectAlias)){
		$alias = $alias_result['alias'];		
	}
	$tempFile = $_FILES['Filedata']['tmp_name'];
	$targetPath = $_SERVER['DOCUMENT_ROOT'] . $_REQUEST['folder'] . '/' . $alias . '-';
	$targetFile =  str_replace('//','/',$targetPath) . $_FILES['Filedata']['name'];			
	move_uploaded_file($tempFile,$targetFile);
	echo str_replace($_SERVER['DOCUMENT_ROOT'],'',$targetFile);
	
	$filePath = "proj/" .$alias . '-' . $_FILES['Filedata']['name'];
	mysql_query("INSERT INTO image VALUES (NULL, '$pid', '$filePath')") or die("Database Query Error: ". mysql_error());
}

?>

<html>
<head>
<link href="../mod/uploadify/uploadify.css" type="text/css" rel="stylesheet" />
<script type="text/javascript" src="../mod/uploadify/jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="../mod/uploadify/swfobject.js"></script>
<script type="text/javascript" src="../mod/uploadify/jquery.uploadify.v2.1.4.min.js"></script>
<script type="text/javascript">
var pid;

$(document).ready(function() {
	document.getElementById("files").style.display = "none";
	$('#file_upload').uploadify({
	  'uploader'    : '../mod/uploadify/uploadify.swf',
	  'script'      : '../mod/uploadify/uploadify.php',
	  'cancelImg'   : '../mod/uploadify/cancel.png',
	  'folder'      : '../proj',
	  'auto'        : true,
	  'multi'       : true,
	  'onError'     : function (event,ID,fileObj,errorObj) {
      						alert(errorObj.type + ' Error: ' + errorObj.info);
   					  },
	  'onSelectOnce': function(event,data) {
    						$('#file_upload').uploadifySettings('scriptData', {'pid': pid});
  	  				  }
				
	});
});
</script>
<head>
<body>
       <input id="file_upload" name="file_upload" type="file" />
</body>
<html>
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
The uploaded file is attached to the "pid" of the recently inserted project.

the "pid" variable is retrieved from the database after the project has been entered

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Uploadify JQuery & PHP/MySQL Database Control

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql, database, php, file, script, jquery

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
jQuery