Please Help Me...!

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Locked
saqib389
Forum Commoner
Posts: 44
Joined: Wed Nov 30, 2005 2:13 am

Please Help Me...!

Post by saqib389 »

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

Code: Select all

<?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

Code: Select all

<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'
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

You've posted this already. Locked.
[url=http://forums.devnetwork.net/viewtopic.php?t=30037]Forum Rules[/url] Section 1.1 wrote:3. Do not make multiple, identical posts. This is viewed as spam and will be deleted.
Locked