pLZ GUIDE ME I AM NOW WORKING ON MY ONLINE EXAM PROJECT BUT SOME PROBLEM IS THERE. I HAVE A FORM WHICH HAVE A jump menu. text field and Submitt button. i want that when i select the desire thing from the jumpmenu and then click on submit button it should be go to the selected item page and as well as update the table row "time" from the text field. so plz kindly provide me the points where i shuld need in this scripts.
<?php require_once('../../../../../Connections/Class5th.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $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;
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
$updateSQL = sprintf("UPDATE ans_001 SET `Time`=%s WHERE ID=%s",
GetSQLValueString($_POST['Time'], "int"),
GetSQLValueString($_POST['ID'], "int"));
mysql_select_db($database_Class5th, $Class5th);
$Result1 = mysql_query($updateSQL, $Class5th) or die(mysql_error());
}
mysql_select_db($database_Class5th, $Class5th);
$query_Time = "SELECT * FROM ans_001";
$Time = mysql_query($query_Time, $Class5th) or die(mysql_error());
$row_Time = mysql_fetch_assoc($Time);
$totalRows_Time = mysql_num_rows($Time);
?><!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=iso-8859-1" />
<title>Untitled Document</title>
<script type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_jumpMenuGo(selName,targ,restore){ //v3.0
var selObj = MM_findObj(selName); if (selObj) MM_jumpMenu(targ,selObj,restore);
}
//-->
</script>
</head>
<body>
<form id="form1" name="form1" method="POST" action="<?php echo $editFormAction; ?>">
<select name="menu1">
<option value="01.php">Q01</option>
<option value="02.php">q02</option>
<option value="03.php">q03</option>
</select>
<input type="button" name="Button1" value="Go" onclick="MM_jumpMenuGo('menu1','parent',0)" />
<input name="ID" type="hidden" id="ID" value="<?php echo $row_Time['ID']; ?>" />
<label>
<input name="Time" type="text" id="Time" value="1000" />
</label>
<input type="hidden" name="MM_update" value="form1">
</form>
</body>
</html>
<?php
mysql_free_result($Time);
?>
