Jump to content

Archived

This topic is now archived and is closed to further replies.

saqib389

Neeed Help Please Help Me.!

Recommended Posts

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]

<?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);
}
?>
[/code]

[b] here is the code of EDIT FILE[/b]

[code]



<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>
[/code]


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





Share this post


Link to post
Share on other sites
The only thing I can see is that your UPDATE query doesnt have a WHERE clause. You need to update the record only with the ID passed through the URL.

Share this post


Link to post
Share on other sites
THX FOR replying

yes my update code is
[code]
$sql = "UPDATE test_table SET field_value = '$field_value' WHERE  field_id = '$field_id'";
[/code]
its still not updating :( please help me

Share this post


Link to post
Share on other sites
Yeah do that to see if it displays correctly...

Is this a MySQL database or some other kind? I am not familiar with the "db_exec" function...

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.