Neeed Help Please

saqib389saqib389 BeginnerLink Clerk
in Coding Languages
Hello all
i just want to ask from you is that.. i want to update my data.. i can add it.. but if i click on the numbers and i want to update that which i just enter it.. then can any one tell me how to do it ? coz i m unable to add update query

here is the link of my work
http://saqib.flowlabs.com/database/
here is the code of CONTROL FILE

<?php
function saqib_db_test () {
	$config = get_config_array($_SERVER["client_name"], 'saqib.db_test');
	$notice_array = array();

	//select all data
	if ($_REQUEST["mode"] == "") {
		$sql = "SELECT field_id, field_value FROM test_table ORDER BY lower(field_value)";
		$result = db_exec($_SERVER["client_name"], $sql);
		if ($result["success"] != true) {
			return $result;
		}
		$numrows = pg_numrows($result["result"]);
		$design_process = 'start';

	//add one record
	} elseif ($_REQUEST["mode"] == "add") {
		if ($_REQUEST["step"] == 2) {
			$result = validate_field ($_REQUEST["field_value"], 'Field Value', true, false, 200, 10, -1);
			if ($result["success"] != true) {
				$notice_array[] = $result["notice"];
			}
			if (sizeof($notice_array) > 0) {
				$design_process = 'add';
			} else {
				$sql = "INSERT INTO test_table (field_value) VALUES (" . db_esc($_REQUEST["field_value"]) . ")";
				$result = db_exec($_SERVER["client_name"], $sql);
				if ($result["success"] != true) {
					return $result;
				}
				$design_process = 'added';
			}
		} else {
			$design_process = 'add';
		}

	//edit one record
	} elseif ($_REQUEST["mode"] == "edit") {
		if ($_REQUEST["step"] == 3) {
			$result = validate_field ($_REQUEST["field_value"], 'Field Value', true, false, 200, 10, -1);
			if ($result["success"] != true) {
				$notice_array[] = $result["notice"];
			}
			$result = validate_field ($_REQUEST["field_id"], 'Field Id', true, true);
			if ($result["success"] != true) {
				$notice_array[] = $result["notice"];
			}

			if (sizeof($notice_array) < 1) {




[color=red][b]$sql = "UPDATE test_table SET field_value = '$field_value' ";[/b][/color]

			
				$result = db_exec($_SERVER["client_name"], $sql);
				if ($result["success"] != true) {
					return $result;
				}
				$design_process = 'edited';
			} else {
				$design_process = 'edit';
			}
		} else {
			$design_process = 'edit';
		}

	} else {
		$design_process = 'error';
	}

	$buffer = get_design_buffer('saqib.db_test', $design_process, get_defined_vars());

	return array("success" => true, "buffer" => $buffer);
}
?>

here is the code of EDIT FILE



<html>
<head>
<title>saqib.db_test</title>
</head>
<body>

<div style="margin:100px">


<?php


if (sizeof($notice_array)  < 1) {
	echo('<pre>');
	print_r($notice_array);
	echo('</pre><br /><br />');
}


?>


<form method="post" action="/database/">

<input type="hidden" name="mode" value="edit" />
<input type="hidden" name="step" value="3" />




Field Value: <br /><input type="text" name="field_value" />
<br />

<input type="submit" value=" Edit Now!" />

</form>

</div>

</body>
</html>


PLEASE ANY ONE CAN HELP ME ... I NEED THE SOLOUTION'

Comments

  • AeriffAeriff Junior Member Shared Hoster
    Erm, It appears to me that this works fine..? I've edited and added new records and no errors, It would help next time if you could say what is wrong.
Sign In or Register to comment.