Posted By

danhanly on 01/20/11

Tagged

Versions (?)

Last Edited at 01/20/11 08:45pm

Statistics

Viewed 821 times

Favorited by 2 user(s)

Related snippets

Uploadify JQuery & PHP/MySQL Database Control

/ Published in: jQuery

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

Highlighted TextExpand

<?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>

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.