Multiple edit does not work
Hi
Have recently purchased Data Assist 2. Have created a multiple insert page and it is working ok. Tried to create a multiple update page, while the page comes up with the required fields when the submit button is pressed it does not update nor does it go to the "go to" page. Have followed your tutorial, after many attempts always the same result. Attached the code for the page can you assist please.
<?php require_once('../Connections/connvbsa.php'); ?>
<?php require_once("../WA_DataAssist/WA_AppBuilder_PHP.php"); ?>
<?php
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_connvbsa, $connvbsa);
$query_Team_Score_Edit = "SELECT team_id, team_name, team_grade, Result_pos, Result_score, HB FROM Team_entries WHERE Team_entries.team_grade='APB'";
$Team_Score_Edit = mysql_query($query_Team_Score_Edit, $connvbsa) or die(mysql_error());
$row_Team_Score_Edit = mysql_fetch_assoc($Team_Score_Edit);
$totalRows_Team_Score_Edit = mysql_num_rows($Team_Score_Edit);?>
<?php
// WA DataAssist Multiple Updates
if (isset($_POST["button_<?php echo $RepeatSelectionCounter_1; ?>"])) // Trigger
{
if (!session_id()) session_start();
$WA_loopedIDField = array("WADA_RepeatID_team_id");
$WA_connection = $connvbsa;
$WA_table = "Team_entries";
$WA_redirectURL = "Ladders.php";
$WA_keepQueryString = false;
$WA_indexField = "team_id";
$WA_fieldNamesStr = "Result_pos|Result_score|HB";
$WA_columnTypesStr = "none,none,NULL|none,none,NULL|',none,''";
$WA_fieldNames = explode("|", $WA_fieldNamesStr);
$WA_columns = explode("|", $WA_columnTypesStr);
$WA_connectionDB = $database_connvbsa;
$WA_multipleUpdateCounter = 0;
mysql_select_db($WA_connectionDB, $WA_connection);
while (WA_AB_checkLoopedFieldsNotBlank($WA_loopedIDField, $WA_multipleUpdateCounter)) {
$WA_fieldValuesStr = "".$row_Team_Score_Edit['Result_pos'] ."" . "|" . "".$row_Team_Score_Edit['Result_score'] ."" . "|" . "".$row_Team_Score_Edit['HB'] ."";
$WA_fieldValues = explode("|", $WA_fieldValuesStr);
$WA_where_fieldValuesStr = WA_AB_getLoopedFieldValue($WA_loopedIDField[0], $WA_multipleUpdateCounter);
$WA_where_columnTypesStr = "none,none,NULL";
$WA_where_comparisonStr = "=";
$WA_where_fieldNames = explode("|", $WA_indexField);
$WA_where_fieldValues = explode("|", $WA_where_fieldValuesStr);
$WA_where_columns = explode("|", $WA_where_columnTypesStr);
$WA_where_comparisons = explode("|", $WA_where_comparisonStr);
$updateParamsObj = WA_AB_generateInsertParams($WA_fieldNames, $WA_columns, $WA_fieldValues, -1);
$WhereObj = WA_AB_generateWhereClause($WA_where_fieldNames, $WA_where_columns, $WA_where_fieldValues, $WA_where_comparisons );
$WA_Sql = "UPDATE `" . $WA_table . "` SET " . $updateParamsObj->WA_setValues . " WHERE " . $WhereObj->sqlWhereClause . "";
$MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());
$WA_multipleUpdateCounter++;
}
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 = "1";
?><!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">
<!-- DW6 -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>VBSA Administrative area</title>
<script src="../Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
<link href="../CSS/vbsa_DB.css" rel="stylesheet" type="text/css" />
</head>
<body>
<center>
<form id="form1" name="form1" method="post" action="">
<?php
// RepeatSelectionCounter_1 Begin Loop
$RepeatSelectionCounter_1_IterationsRemaining = $RepeatSelectionCounter_1_Iterations;
while($RepeatSelectionCounter_1_IterationsRemaining--){
if($RepeatSelectionCounterBasedLooping_1 || $row_Team_Score_Edit){
?>
<table border="0">
<?php do { ?>
<tr>
<td>Team</td>
<td><input type="hidden" name="WADA_RepeatID_team_id_<?php echo $RepeatSelectionCounter_1; ?>" id="WADA_RepeatID_team_id_<?php echo $RepeatSelectionCounter_1; ?>" value="<?php echo $row_Team_Score_Edit["team_id"]; ?>" />
<input type="text" name="Result_pos_<?php echo $RepeatSelectionCounter_1; ?>" value="<?php echo htmlentities($row_Team_Score_Edit['Result_pos'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
<td><input type="text" name="Result_score_<?php echo $RepeatSelectionCounter_1; ?>" value="<?php echo htmlentities($row_Team_Score_Edit['Result_score'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
<td><input type="text" name="HB_<?php echo $RepeatSelectionCounter_1; ?>" value="<?php echo htmlentities($row_Team_Score_Edit['HB'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<?php } while ($row_Team_Score_Edit = mysql_fetch_assoc($Team_Score_Edit)); ?>
<tr>
<td> </td>
<td><input type="submit" name="button_<?php echo $RepeatSelectionCounter_1; ?>" id="button_<?php echo $RepeatSelectionCounter_1; ?>" value="Submit" /></td>
<td> </td>
<td> </td>
</tr>
</table>
<?php
} // RepeatSelectionCounter_1 Begin Alternate Content
else{
?>
<td>No records match your request.</td>
<?php } // RepeatSelectionCounter_1 End Alternate Content
if(!$RepeatSelectionCounterBasedLooping_1 && $RepeatSelectionCounter_1_IterationsRemaining != 0){
if(!$row_Team_Score_Edit && $RepeatSelectionCounter_1_Iterations == -1){$RepeatSelectionCounter_1_IterationsRemaining = 0;}
$row_Team_Score_Edit = mysql_fetch_assoc($Team_Score_Edit);
}
$RepeatSelectionCounter_1++;
} // RepeatSelectionCounter_1 End Loop
?></form>
</center>
</body>
</html>
<?php
mysql_free_result($Team_Score_Edit);
?>