Hi
I read many questions, but no real solution here about inserting the file name into a database after having the file uploaded.
Many people say to insert a sql-query into the upload.php script, but I think this isn't a good idea as you maybe don't have an ID for your dataset before a form has been submitted and you need to worry about php issues and error treatment to not insert a record into the db whenever the upload failed.
The better way for me is to upload the file and give the filename back to the form before it has been submitted.
Like this you can create or even update consistent datasets.
In the uploadify documentation there is somewhere an example, which has an error as getElementById has a typo and it reads getElementByID.
I found a good solution on a coldfusion site (http://www.john-sieber.com) which lead me to the right track for non Cf sites.
He created an example, which inserts a hidden field into the initial form after the upload is done.
I think it is the best way as you submit your form only once but with all data.
There are some things different from his example, I had to change to make it work for a normal php/mysql setup .
I actually integrated it into a cakephp project, but cake doesn't matter here much.

1. The upload.php (uploadify.php) needs to return at last a echo 'ok'; to trigger the "onComplete" function. Without a return from the php it didn't fire any events for me.

2. John Sieber used a onSelect event, which didn't work for me. On 'stackoverflow.com' they somewhere also said not wrap function names into quotes, but I had to do this .

3. The field names like data[Banner][image] in my code are for cakephp; just use a normal string, if you need to

4. My database table has a field images in a table banners which holds the Image name and therefore my input field in the form has to be named data[Banner][image] and get the id BannerImage : Those are conventions from Cakephp and need to be adopted for your forms.

5. I didn't post the actual php which treats the form POST-data because I have this in a controller and anyway there is nothing special about it as you just need to treat a form with text fields like this

Here is the code:
My "uploadify-custom.js": (Or put it into the php-form into script tags)

/**
* Long description for file uploadify-custom.js
* Copyright 2011, TuxaneSoft,France (http://www.tuxane.com/)
* Licensed under The MIT License
* Redistributions of files must retain the above copyright notice.
* @version 0.5
* @modifiedby $jw$
* @lastmodified 16.02.2011
* @license http://www.opensource.org/licenses/mit-license.php The MIT License
*/

$(document).ready(function() {
$('#file_upload').uploadify({
'uploader' : '/uploadify/uploadify.swf',
'script' : '/uploadify/uploadify.php',
'cancelImg' : '/uploadify/cancel.png',
'folder' : '/uploads/upload_banner_image',
'auto' : true,
'multi' : false,
'fileDesc' : 'Images',
'onComplete': function(event, queueID, fileObj, response, data){
var form = document.forms['BannerAddForm'];
var i = 0;
var el = document.createElement("input");
el.type = "hidden";
el.name = "data[Banner][image]";
el.id = "BannerImage";
el.value = fileObj.name;
form.appendChild(el);
},
'onAllComplete': function(event,data) { document.getElementById('BannerAddForm').submit();},
});
});


The uploadify.php

<?php
if (!empty($_FILES)) {
$tempFile = $_FILES['Filedata']['tmp_name'];
$targetPath = $_SERVER['DOCUMENT_ROOT'] . $_REQUEST['folder'] . '/';
$targetFile = str_replace('//','/',$targetPath) . $_FILES['Filedata']['name'];
move_uploaded_file($tempFile,$targetFile);
echo '0'; // Required to trigger onComplete function on Mac OSX (same for linux and windows as it seems)

}
else { // Required to trigger onComplete function on Mac OSX (same for linux and windows as it seems)
echo '1';
}
?>


The page hold a form field like in the examples

<input id="file_upload" name="file_upload" type="file" />

If you don't use auto=true
put a submit buttom to your form like
<a href="javascript:$('#file_upload').uploadifyUpload();"><img id="withupload" src="img/submit.gif" /></a>

But I would consider it as better style to attach a normal HTML submit button to the page and have uploadify submit the form 'onComplete' (with auto=true and the submit() method 'onComplete') as it gives the user a possibillity to modify other form elements and save it without changing the image (or better dataset) of this page

You could maybe hide the HTML button , if the user clicks on 'select files' and have the form submitted after upload.

Hope it helps someone
Die Schiffsratte