saqib389 Posted July 6, 2006 Share Posted July 6, 2006 Hello alli 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 queryhere is the link of my workhttp://saqib.flowlabs.com/database/here is the code of CONTROL FILE[code]<?phpfunction 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"><?phpif (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' Quote Link to comment https://forums.phpfreaks.com/topic/13885-neeed-help-please-help-me/ Share on other sites More sharing options...
Gast Posted July 6, 2006 Share Posted July 6, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/13885-neeed-help-please-help-me/#findComment-54117 Share on other sites More sharing options...
saqib389 Posted July 6, 2006 Author Share Posted July 6, 2006 THX FOR replyingyes 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 Quote Link to comment https://forums.phpfreaks.com/topic/13885-neeed-help-please-help-me/#findComment-54126 Share on other sites More sharing options...
redarrow Posted July 6, 2006 Share Posted July 6, 2006 echo $sql;see what not working ok. Quote Link to comment https://forums.phpfreaks.com/topic/13885-neeed-help-please-help-me/#findComment-54131 Share on other sites More sharing options...
Gast Posted July 6, 2006 Share Posted July 6, 2006 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... Quote Link to comment https://forums.phpfreaks.com/topic/13885-neeed-help-please-help-me/#findComment-54132 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.