close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Multiple file uploads with multiple inserts into - confused need help DB

Thread began 7/01/2011 9:21 pm by YellowCircleWeb | Last modified 10/05/2011 10:34 am by YellowCircleWeb | 4274 views | 7 replies

Morgan

Originally Said By: Jason Byrnes
  no, you cant use the multiple insert behavior with file uploads.


this is going to take some hand coding to pull off.


you will need to store the server file name of the uploaded files into a session variable array.

then, set up a single insert record behavior that has an array loop around it.

by naming a session with "[]" it will create an array, for example:
$_SESSION['uploadedFiles'][]

use the following code after the upload file behaviors to store the uploaded files into the session array:
php:
<?php

if($WA_DFP_UploadStatus["WA_UploadResult1"]["statusCode"] == "1"$_SESSION['uploadedFiles'][] = $WA_DFP_UploadStatus["WA_UploadResult1"]["serverFileName"]; 
if(
$WA_DFP_UploadStatus["WA_UploadResult2"]["statusCode"] == "1"$_SESSION['uploadedFiles'][] = $WA_DFP_UploadStatus["WA_UploadResult2"]["serverFileName"]; 
if(
$WA_DFP_UploadStatus["WA_UploadResult3"]["statusCode"] == "1"$_SESSION['uploadedFiles'][] = $WA_DFP_UploadStatus["WA_UploadResult3"]["serverFileName"]; 
if(
$WA_DFP_UploadStatus["WA_UploadResult4"]["statusCode"] == "1"$_SESSION['uploadedFiles'][] = $WA_DFP_UploadStatus["WA_UploadResult4"]["serverFileName"]; 
if(
$WA_DFP_UploadStatus["WA_UploadResult5"]["statusCode"] == "1"$_SESSION['uploadedFiles'][] = $WA_DFP_UploadStatus["WA_UploadResult5"]["serverFileName"]; 
?>



then add the insert record behavior to the page, for the column that will store the file name, paste the following code into the value box:
php:
<?php echo $_SESSION['uploadedFiles'][i]; ?>



now add an array loop around the insert behavior:
php:
<?php for($i 0$i sizeof($_SESSION['uploadedFiles']); $i++) { ?>

<insert record code here>
<?php ?>
<?php 
if(sizeof($_SESSION['uploadedFiles']) > 0) {
  unset(
sizeof($_SESSION['uploadedFiles']));
  
header("Location: successpage.php");
}



the second if will unset the session and redirect to the success page.  



Is this code still useable?
Cos its what i need to get my multiupload to work with out a loads of empty posts in my db.

Ah well i try it out! :)
You guys at WA should really build that multiupload in to DataBridge, old Interakts extention had a awesome one, ctrl + click any file/files, bam right in the kisser, i mean in to the database, easy as making pie. :)

/Morgan

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...