Thanks Dagon, but I'm not very proficient in php. Could you be a bit more specific. Here's my source code:
<?php require_once('../Connections/dbConn.php'); ?>
<?php
// Load the common classes
require_once('../includes/common/KT_common.php');
// Load the tNG classes
require_once('../includes/tng/tNG.inc.php');
// Make a transaction dispatcher instance
$tNGs = new tNG_dispatcher("../");
// Make unified connection variable
$conn_dbConn = new KT_connection($dbConn, $database_dbConn);
// Start trigger
$formValidation = new tNG_FormValidation();
$tNGs->prepareValidation($formValidation);
// End trigger
//start Trigger_FileUpload1 trigger
//remove this line if you want to edit the code by hand
function Trigger_FileUpload1(&$tNG) {
$uploadObj = new tNG_FileUpload($tNG);
$uploadObj->setFormFieldName("thumbnail_path");
$uploadObj->setDbFieldName("thumbnail_path");
$uploadObj->setFolder("../downloads/");
$uploadObj->setMaxSize(1500);
$uploadObj->setAllowedExtensions("pdf, txt, jpg, jpeg, png, gif, swf");
$uploadObj->setRename("auto");
return $uploadObj->Execute();
}
//end Trigger_FileUpload1 trigger
//start Trigger_FileUpload trigger
//remove this line if you want to edit the code by hand
function Trigger_FileUpload(&$tNG) {
$uploadObj = new tNG_FileUpload($tNG);
$uploadObj->setFormFieldName("image_path");
$uploadObj->setDbFieldName("image_path");
$uploadObj->setFolder("../downloads/");
$uploadObj->setMaxSize(1500);
$uploadObj->setAllowedExtensions("pdf, txt, jpg, jpeg, png, gif, swf");
$uploadObj->setRename("auto");
return $uploadObj->Execute();
}
//end Trigger_FileUpload trigger
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_dbConn, $dbConn);
$query_bannersRS = "SELECT * FROM tbl_banners";
$bannersRS = mysql_query($query_bannersRS, $dbConn) or die(mysql_error());
$row_bannersRS = mysql_fetch_assoc($bannersRS);
$totalRows_bannersRS = mysql_num_rows($bannersRS);
mysql_select_db($database_dbConn, $dbConn);
$query_bannertypeRS = "SELECT * FROM tbl_banner_types";
$bannertypeRS = mysql_query($query_bannertypeRS, $dbConn) or die(mysql_error());
$row_bannertypeRS = mysql_fetch_assoc($bannertypeRS);
$totalRows_bannertypeRS = mysql_num_rows($bannertypeRS);
mysql_select_db($database_dbConn, $dbConn);
$query_productsRS = "SELECT * FROM tbl_products";
$productsRS = mysql_query($query_productsRS, $dbConn) or die(mysql_error());
$row_productsRS = mysql_fetch_assoc($productsRS);
$totalRows_productsRS = mysql_num_rows($productsRS);
mysql_select_db($database_dbConn, $dbConn);
$query_brandsRS = "SELECT * FROM tbl_brands";
$brandsRS = mysql_query($query_brandsRS, $dbConn) or die(mysql_error());
$row_brandsRS = mysql_fetch_assoc($brandsRS);
$totalRows_brandsRS = mysql_num_rows($brandsRS);
mysql_select_db($database_dbConn, $dbConn);
$query_bannertypeRS1 = "SELECT * FROM tbl_banner_types";
$bannertypeRS1 = mysql_query($query_bannertypeRS1, $dbConn) or die(mysql_error());
$row_bannertypeRS1 = mysql_fetch_assoc($bannertypeRS1);
$totalRows_bannertypeRS1 = mysql_num_rows($bannertypeRS1);
mysql_select_db($database_dbConn, $dbConn);
$query_brandsRS2 = "SELECT * FROM tbl_brands";
$brandsRS2 = mysql_query($query_brandsRS2, $dbConn) or die(mysql_error());
$row_brandsRS2 = mysql_fetch_assoc($brandsRS2);
$totalRows_brandsRS2 = mysql_num_rows($brandsRS2);
mysql_select_db($database_dbConn, $dbConn);
$query_productsRS2 = "SELECT * FROM tbl_products";
$productsRS2 = mysql_query($query_productsRS2, $dbConn) or die(mysql_error());
$row_productsRS2 = mysql_fetch_assoc($productsRS2);
$totalRows_productsRS2 = mysql_num_rows($productsRS2);
// Make an insert transaction instance
$ins_tbl_banners = new tNG_insert($conn_dbConn);
$tNGs->addTransaction($ins_tbl_banners);
// Register triggers
$ins_tbl_banners->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "KT_Insert1");
$ins_tbl_banners->registerTrigger("BEFORE", "Trigger_Default_FormValidation", 10, $formValidation);
$ins_tbl_banners->registerTrigger("END", "Trigger_Default_Redirect", 99, "goback.php");
$ins_tbl_banners->registerTrigger("AFTER", "Trigger_FileUpload", 97);
$ins_tbl_banners->registerTrigger("AFTER", "Trigger_FileUpload1", 97);
// Add columns
$ins_tbl_banners->setTable("tbl_banners");
$ins_tbl_banners->addColumn("banner_type_ID", "NUMERIC_TYPE", "POST", "banner_type_ID");
$ins_tbl_banners->addColumn("brand_ID", "NUMERIC_TYPE", "POST", "brand_ID");
$ins_tbl_banners->addColumn("product_ID", "NUMERIC_TYPE", "POST", "product_ID");
$ins_tbl_banners->addColumn("image_path", "FILE_TYPE", "FILES", "image_path");
$ins_tbl_banners->addColumn("thumbnail_path", "FILE_TYPE", "FILES", "thumbnail_path");
$ins_tbl_banners->addColumn("width", "DOUBLE_TYPE", "POST", "width");
$ins_tbl_banners->addColumn("height", "DOUBLE_TYPE", "POST", "height");
$ins_tbl_banners->addColumn("measurement", "STRING_TYPE", "POST", "measurement");
$ins_tbl_banners->addColumn("file_size", "NUMERIC_TYPE", "POST", "file_size");
$ins_tbl_banners->setPrimaryKey("banner_ID", "NUMERIC_TYPE");
// Execute all the registered transactions
$tNGs->executeTransactions();
// Get the transaction recordset
$rstbl_banners = $tNGs->getRecordset("tbl_banners");
$row_rstbl_banners = mysql_fetch_assoc($rstbl_banners);
$totalRows_rstbl_banners = mysql_num_rows($rstbl_banners);
?>
