Eric,
Thanks. That worked to get images uploaded. However it's inserting image #1 in all three records.
I have 3 record inserts. The file field is named image. So I have 3 WA Upload server behaviors. One for each image_0, image_1, image_2.
But in the Multiple Insert server behavior, how do I bind it? The other fields are recognized as repeat fields. I can only bind to one file field.
php:
<?php
mysql_select_db($database_dbCMS, $dbCMS);
$query_rsGallery = "SELECT * FROM tblGallery ORDER BY id ASC";
setQueryBuilderSource($query_rsGallery,$WADbSearch1,false);
$rsGallery = mysql_query($query_rsGallery, $dbCMS) or die(mysql_error());
$row_rsGallery = mysql_fetch_assoc($rsGallery);
$totalRows_rsGallery = mysql_num_rows($rsGallery);
?>
<?php
$queryString_rsGallery = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_rsGallery") == false &&
stristr($param, "totalRows_rsGallery") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_rsGallery = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_rsGallery = sprintf("&totalRows_rsGallery=%d%s", $totalRows_rsGallery, $queryString_rsGallery);
?>
<?php
// WA_UploadResult1 Params Start
$WA_UploadResult1_Params = array();
// WA_UploadResult1_1 Start
$WA_UploadResult1_Params["WA_UploadResult1_1"] = array(
'UploadFolder' => "../../../images/gallery/",
'FileName' => "[FileName]",
'DefaultFileName' => "",
'ResizeType' => "3",
'ResizeWidth' => "",
'ResizeHeight' => "525",
'ResizeFillColor' => "" );
// WA_UploadResult1_1 End
// WA_UploadResult1_2 Start
$WA_UploadResult1_Params["WA_UploadResult1_2"] = array(
'UploadFolder' => "../../../images/gallery/thumbs/",
'FileName' => "[FileName]",
'DefaultFileName' => "",
'ResizeType' => "3",
'ResizeWidth' => "150",
'ResizeHeight' => "225",
'ResizeFillColor' => "#FFFFFF" );
// WA_UploadResult1_2 End
// WA_UploadResult1 Params End?>
<?php
// WA_UploadResult2 Params Start
$WA_UploadResult2_Params = array();
// WA_UploadResult2_1 Start
$WA_UploadResult2_Params["WA_UploadResult2_1"] = array(
'UploadFolder' => "../../../images/gallery/",
'FileName' => "[FileName]",
'DefaultFileName' => "",
'ResizeType' => "3",
'ResizeWidth' => "120",
'ResizeHeight' => "525",
'ResizeFillColor' => "#FFFFFF" );
// WA_UploadResult2_1 End
// WA_UploadResult2_2 Start
$WA_UploadResult2_Params["WA_UploadResult2_2"] = array(
'UploadFolder' => "../../../images/gallery/thumbs/",
'FileName' => "[FileName]",
'DefaultFileName' => "",
'ResizeType' => "3",
'ResizeWidth' => "120",
'ResizeHeight' => "225",
'ResizeFillColor' => "#FFFFFF" );
// WA_UploadResult2_2 End
// WA_UploadResult2 Params End?>
<?php
// WA_UploadResult3 Params Start
$WA_UploadResult3_Params = array();
// WA_UploadResult3_1 Start
$WA_UploadResult3_Params["WA_UploadResult3_1"] = array(
'UploadFolder' => "../../../images/gallery/",
'FileName' => "[FileName]",
'DefaultFileName' => "",
'ResizeType' => "3",
'ResizeWidth' => "120",
'ResizeHeight' => "525",
'ResizeFillColor' => "#FFFFFF" );
// WA_UploadResult3_1 End
// WA_UploadResult3_2 Start
$WA_UploadResult3_Params["WA_UploadResult3_2"] = array(
'UploadFolder' => "../../../images/gallery/thumbs/",
'FileName' => "[FileName]",
'DefaultFileName' => "",
'ResizeType' => "3",
'ResizeWidth' => "120",
'ResizeHeight' => "225",
'ResizeFillColor' => "#FFFFFF" );
// WA_UploadResult3_2 End
// WA_UploadResult3 Params End
?>
<?php
WA_DFP_SetupUploadStatusStruct("WA_UploadResult1");
if(isset($_POST["Insert_x"])){
WA_DFP_UploadFiles("WA_UploadResult1", "image_0", "2", "[NewFileName]_[Increment]", "JPG:70", $WA_UploadResult1_Params);
}?>
<?php
WA_DFP_SetupUploadStatusStruct("WA_UploadResult2");
if(isset($_POST["Insert_x"])){
WA_DFP_UploadFiles("WA_UploadResult2", "image_1", "2", "[NewFileName]_[Increment]", "JPG:70", $WA_UploadResult2_Params);
}?>
<?php
WA_DFP_SetupUploadStatusStruct("WA_UploadResult3");
if(isset($_POST["Insert_x"])){
WA_DFP_UploadFiles("WA_UploadResult3", "image_2", "2", "[NewFileName]_[Increment]", "JPG:70", $WA_UploadResult3_Params);
}
?>
<?php
// WA DataAssist Multiple Inserts
if (isset($_POST["Insert_x"])) // Trigger
{
if (!session_id()) session_start();
$WA_loopedFields = array("id", "location", "imagetext");
$WA_connection = $dbCMS;
$WA_table = "tblGallery";
$WA_redirectURL = "tblgallery_ResultsMultiTest.php";
$WA_keepQueryString = false;
$WA_fieldNamesStr = "id|location|imagethumb|imagelarge|imagetext";
$WA_columnTypesStr = "none,none,NULL|',none,''|',none,''|',none,''|',none,''";
$WA_insertIfNotBlank = "";
$WA_fieldNames = explode("|", $WA_fieldNamesStr);
$WA_columns = explode("|", $WA_columnTypesStr);
$WA_connectionDB = $database_dbCMS;
$WA_multipleInsertCounter = 0;
mysql_select_db($WA_connectionDB, $WA_connection);
while (WA_AB_checkMultiInsertLoopedFieldsExist($WA_loopedFields, $WA_multipleInsertCounter)) {
if ($WA_insertIfNotBlank == "" || WA_AB_checkLoopedFieldsNotBlank(array($WA_insertIfNotBlank), $WA_multipleInsertCounter)) {
$WA_fieldValuesStr = "".WA_AB_getLoopedFieldValue("id", $WA_multipleInsertCounter) ."" . "|" . "".WA_AB_getLoopedFieldValue("location", $WA_multipleInsertCounter) ."" . "|" . "".$WA_DFP_UploadStatus["WA_UploadResult1"]["serverFileName"] ."" . "|" . "".$WA_DFP_UploadStatus["WA_UploadResult1"]["serverFileName"] ."" . "|" . "".WA_AB_getLoopedFieldValue("imagetext", $WA_multipleInsertCounter) ."";
$WA_fieldValues = explode("|", $WA_fieldValuesStr);
$insertParamsObj = WA_AB_generateInsertParams($WA_fieldNames, $WA_columns, $WA_fieldValues, -1);
$WA_Sql = "INSERT INTO `" . $WA_table . "` (" . $insertParamsObj->WA_tableValues . ") VALUES (" . $insertParamsObj->WA_dbValues . ")";
$MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());
}
$WA_multipleInsertCounter++;
}
if ($WA_redirectURL != "") {
if ($WA_keepQueryString && $WA_redirectURL != "" && isset($_SERVER["QUERY_STRING"]) && $_SERVER["QUERY_STRING"] !== "" && sizeof($_POST) > 0) {
$WA_redirectURL .= ((strpos($WA_redirectURL, '?') === false)?"?":"&").$_SERVER["QUERY_STRING"];
}
header("Location: ".$WA_redirectURL);
}
}
?><?php
// RepeatSelectionCounter_1 Initialization
$RepeatSelectionCounter_1 = 0;
$RepeatSelectionCounterBasedLooping_1 = false;
$RepeatSelectionCounter_1_Iterations = "3";
?>
Thanks,
Troy
