Jump to content

Neeed Help Please Help Me.!


saqib389

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'





Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.