I realize that I have been messing with this for so long that I have changed things from wrong to right to back to wrong. I had a couple of those things right at one point and didn't realize I had messed them up. What I had failed to realize is the extra code should go in the file field but that is because it's not that way in my other form. I don't understand how my other form is working properly.
I think I did all you said. I NOW have the image uploading but somehow I messed something else up because the info is not going into the database field. The image field is blank so therefore, no image show up on the page. Please check my code again to make sure I have this correct. I only changed the database to make the image field a text rather than a blob. This shouldn't be this difficult!! :-)
thank you!
<?php require_once("Connections/connFay.php"); ?>
<?php require_once("WA_DataAssist/WA_AppBuilder_PHP.php"); ?>
<?php require_once("WA_DigitalFilePro/HelperPHP.php"); ?>
<?php require_once( "WA_SecurityAssist/Helper_PHP.php" ); ?>
<?php
if (!WA_Auth_RulePasses("Logged in to Admin")){
WA_Auth_RestrictAccess("Admin_LogIn.php");
}
?>
<?php
ini_set('memory_limit','500M');
?>
<?php
// WA_UploadResult2 Params Start
$WA_UploadResult2_Params = array();
// WA_UploadResult2_1 Start
$WA_UploadResult2_Params["WA_UploadResult2_1"] = array(
'UploadFolder' => "CatImages/",
'FileName' => "[FileName]",
'DefaultFileName' => "",
'ResizeType' => "2",
'ResizeWidth' => "250",
'ResizeHeight' => "120",
'ResizeFillColor' => "#FFFFFF" );
// WA_UploadResult2_1 End
// WA_UploadResult2 Params End
?>
<?php
WA_DFP_SetupUploadStatusStruct("WA_UploadResult2");
if(isset($_POST["Insert_x"])){
WA_DFP_UploadFiles("WA_UploadResult2", "Image", "2", "[NewFileName]_[Increment]", "true", $WA_UploadResult2_Params);
}
?>
<?php
// WA Application Builder Insert
if (isset($_POST["Insert_x"])) // Trigger
{
$WA_connection = $connFay;
$WA_table = "Catalog";
$WA_sessionName = "WADA_Insert_Catalog";
$WA_redirectURL = "Catalog_Insert.php";
$WA_keepQueryString = false;
$WA_indexField = "ItemID";
$WA_fieldNamesStr = "CatalogID|ItemName|Description|Price|Age|Category|Image";
$WA_fieldValuesStr = "".((isset($_POST["CatalogID"]))?$_POST["CatalogID"]:"") ."" . "|" . "".((isset($_POST["ItemName"]))?$_POST["ItemName"]:"") ."" . "|" . "".((isset($_POST["Description"]))?$_POST["Description"]:"") ."" . "|" . "".((isset($_POST["Price"]))?$_POST["Price"]:"") ."" . "|" . "".((isset($_POST["Age"]))?$_POST["Age"]:"") ."" . "|" . "".((isset($_POST["Category"]))?$_POST["Category"]:"") ."" . "|" . "".((isset($_POST["Image"]))?$_POST["Image"]:"") ."";
$WA_columnTypesStr = "',none,''|',none,''|',none,''|none,none,NULL|',none,''|',none,''|',none,''";
$WA_fieldNames = explode("|", $WA_fieldNamesStr);
$WA_fieldValues = explode("|", $WA_fieldValuesStr);
$WA_columns = explode("|", $WA_columnTypesStr);
$WA_connectionDB = $database_connFay;
mysql_select_db($WA_connectionDB, $WA_connection);
if (!session_id()) session_start();
$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());
$_SESSION[$WA_sessionName] = mysql_insert_id();
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);
}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Insert Catalog</title>
<link href="WA_DataAssist/styles/Refined_Pacifica.css" rel="stylesheet" type="text/css" />
<link href="WA_DataAssist/styles/Arial.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div class="WADAInsertContainer">
<form action="Catalog_Insert.php" method="post" name="WADAInsertForm" id="WADAInsertForm" enctype="multipart/form-data">
<div class="WADAHeader"><h1 align="center">Insert Record</h1></div>
<div class="WADAHorizLine"><img src="WA_DataAssist/images/_tx_.gif" alt="" height="1" width="1" border="0" /></div>
<table class="WADADataTable" cellpadding="0" cellspacing="0" border="0">
<tr>
<th class="WADADataTableHeader">CatalogID:</th>
<td class="WADADataTableCell"><input type="text" name="CatalogID" id="CatalogID" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">ItemName:</th>
<td class="WADADataTableCell"><input type="text" name="ItemName" id="ItemName" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">Description:</th>
<td class="WADADataTableCell"><input type="text" name="Description" id="Description" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">Price:</th>
<td class="WADADataTableCell"><input type="text" name="Price" id="Price" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">Age:</th>
<td class="WADADataTableCell"><input type="text" name="Age" id="Age" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">Category:</th>
<td class="WADADataTableCell"><select name="Category" id="Category" value="" size="1" />
<option> </option>
<option>Active Play</option>
<option>Arts & Crafts</option>
<option>Calico Critters</option>
<option>Construction</option>
<option>Corolle Dolls</option>
<option>Games</option>
<option>Gears</option>
<option>Infants</option>
<option>Music</option>
<option>Play Mobile</option>
<option>Pretend Play</option>
<option>Puzzles</option>
<option>Science</option></td>
</tr>
<tr>
<th class="WADADataTableHeader">Image:</th>
<td class="WADADataTableCell"><input name="Image" type="file" id="Image" value="<?php echo $WA_DFP_UploadStatus["WA_UploadResult2"]["serverFileName"]; ?>" size="32"/></td>
</tr>
</table>
<div class="WADAHorizLine"><img src="WA_DataAssist/images/_tx_.gif" alt="" height="1" width="1" border="0" /></div>
<div class="WADAButtonRow">
<table class="WADADataNavButtons" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class="WADADataNavButtonCell" nowrap="nowrap"><input type="image" name="Insert" id="Insert" value="Insert" alt="Insert" src="WA_DataAssist/images/Pacifica/Refined_insert.gif" /></td>
<td class="WADADataNavButtonCell" nowrap="nowrap"><a href="Catalog_Results.php" title="Cancel"><img border="0" name="Cancel" id="Cancel" alt="Cancel" src="WA_DataAssist/images/Pacifica/Refined_cancel.gif" /></a></td>
</tr>
<tr>
<td><h2 align="center"> <a href="Catalog_Search.php">Go to Search Page</a></h2></td></tr>
</table>
<input name="WADAInsertRecordID" type="hidden" id="WADAInsertRecordID" value="" />
</div>
</form>
</div>
</body>
</html>
