Código PHP:
<?php require_once('Connections/dec.php'); ?>
<?php require_once('Connections/dec.php'); ?>
<?php
//MX Widgets3 include
require_once('includes/wdg/WDG.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_dec = new KT_connection($dec, $database_dec);
// Start trigger
$formValidation = new tNG_FormValidation();
$formValidation->addField("uid", true, "numeric", "", "", "", "");
$formValidation->addField("dom_calle", true, "text", "", "", "", "");
$formValidation->addField("dom_delegacion", true, "text", "", "", "", "");
$formValidation->addField("dom_codigo_postal", true, "numeric", "zip_generic", "", "", "");
$formValidation->addField("dom_tel", true, "text", "phone", "", "", "");
$formValidation->addField("labor_tel", false, "text", "phone", "", "", "");
$formValidation->addField("experiencia_paq", true, "numeric", "int", "", "", "");
$formValidation->addField("experiencia_linea", true, "numeric", "int", "", "", "");
$tNGs->prepareValidation($formValidation);
// End 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;
}
}
$KTColParam1_nombre_alumno = "0";
if (isset($_GET["uid"])) {
$KTColParam1_nombre_alumno = (get_magic_quotes_gpc()) ? $_GET["uid"] : addslashes($_GET["uid"]);
}
mysql_select_db($database_dec, $dec);
$query_nombre_alumno = sprintf("SELECT usuarios.uid, usuarios.nombre, usuarios.apellidos FROM usuarios WHERE usuarios.uid=%s ", GetSQLValueString($KTColParam1_nombre_alumno, "int"));
$nombre_alumno = mysql_query($query_nombre_alumno, $dec) or die(mysql_error());
$row_nombre_alumno = mysql_fetch_assoc($nombre_alumno);
$totalRows_nombre_alumno = mysql_num_rows($nombre_alumno);
mysql_select_db($database_dec, $dec);
$query_nivel_experiencia = "SELECT nivel_experiencia.nivel, nivel_experiencia.valor_nivel FROM nivel_experiencia ORDER BY nivel_experiencia.valor_nivel";
$nivel_experiencia = mysql_query($query_nivel_experiencia, $dec) or die(mysql_error());
$row_nivel_experiencia = mysql_fetch_assoc($nivel_experiencia);
$totalRows_nivel_experiencia = mysql_num_rows($nivel_experiencia);
mysql_select_db($database_dec, $dec);
$query_nivel_experiencia1 = "SELECT nivel_experiencia.nivel, nivel_experiencia.valor_nivel FROM nivel_experiencia ORDER BY nivel_experiencia.valor_nivel";
$nivel_experiencia1 = mysql_query($query_nivel_experiencia1, $dec) or die(mysql_error());
$row_nivel_experiencia1 = mysql_fetch_assoc($nivel_experiencia1);
$totalRows_nivel_experiencia1 = mysql_num_rows($nivel_experiencia1);
// Make an insert transaction instance
$ins_alumnos = new tNG_insert($conn_dec);
$tNGs->addTransaction($ins_alumnos);
// Register triggers
$ins_alumnos->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "KT_Insert1");
$ins_alumnos->registerTrigger("BEFORE", "Trigger_Default_FormValidation", 10, $formValidation);
$ins_alumnos->registerTrigger("END", "Trigger_Default_Redirect", 99, "index.php?mod=puente&uid=$uid&id_curso=$id_curso&no_edicion=$no_edicion");
// Add columns
$ins_alumnos->setTable("alumnos");
$ins_alumnos->addColumn("uid", "NUMERIC_TYPE", "GET", "uid", "{GET.uid}");
$ins_alumnos->addColumn("dom_calle", "STRING_TYPE", "POST", "dom_calle");
$ins_alumnos->addColumn("dom_colonia", "STRING_TYPE", "POST", "dom_colonia");
$ins_alumnos->addColumn("dom_delegacion", "STRING_TYPE", "POST", "dom_delegacion");
$ins_alumnos->addColumn("dom_codigo_postal", "NUMERIC_TYPE", "POST", "dom_codigo_postal");
$ins_alumnos->addColumn("dom_lada", "STRING_TYPE", "POST", "dom_lada");
$ins_alumnos->addColumn("dom_tel", "STRING_TYPE", "POST", "dom_tel");
$ins_alumnos->addColumn("labor_institucion", "STRING_TYPE", "POST", "labor_institucion");
$ins_alumnos->addColumn("labor_puesto", "STRING_TYPE", "POST", "labor_puesto");
$ins_alumnos->addColumn("labor_actividad", "STRING_TYPE", "POST", "labor_actividad");
$ins_alumnos->addColumn("labor_lada", "STRING_TYPE", "POST", "labor_lada");
$ins_alumnos->addColumn("labor_tel", "STRING_TYPE", "POST", "labor_tel");
$ins_alumnos->addColumn("labor_ext", "STRING_TYPE", "POST", "labor_ext");
$ins_alumnos->addColumn("labor_fax", "STRING_TYPE", "POST", "labor_fax");
$ins_alumnos->addColumn("trabajador_unam", "STRING_TYPE", "POST", "trabajador_unam");
$ins_alumnos->addColumn("beca_unam", "STRING_TYPE", "POST", "beca_unam");
$ins_alumnos->addColumn("sindicato_unam", "STRING_TYPE", "POST", "sindicato_unam");
$ins_alumnos->addColumn("experiencia_paq", "NUMERIC_TYPE", "POST", "experiencia_paq");
$ins_alumnos->addColumn("experiencia_linea", "NUMERIC_TYPE", "POST", "experiencia_linea");
$ins_alumnos->addColumn("expectativas", "STRING_TYPE", "POST", "expectativas");
$ins_alumnos->addColumn("temas_interes", "STRING_TYPE", "POST", "temas_interes");
$ins_alumnos->setPrimaryKey("id", "NUMERIC_TYPE");
// Execute all the registered transactions
$tNGs->executeTransactions();
// Get the transaction recordset
$rsalumnos = $tNGs->getRecordset("alumnos");
$row_rsalumnos = mysql_fetch_assoc($rsalumnos);
$totalRows_rsalumnos = mysql_num_rows($rsalumnos);
?>