mysql - PHP - Update database when submitting form -
i have created edit functions problem when press submit button refreshes form , not update database new information entered in form.
i cannot seem find issue keeps edit_options.php working.
insert part....
// check if form has been submitted. if has, process form , save database if (isset($_post['submit'])){ // confirm 'id' value valid integer before getting form data if (is_numeric($_post['id'])){ // form data, making sure valid $id = $_post['id']; $option_name = mysql_real_escape_string($_post['option_name']); $option_value = mysql_real_escape_string($_post['option_value']); // check prodname/color fields both filled in if ($option_name == '' || $option_value == '') { // generate error message $error = 'error: please fill in required fields!'; //error, display form renderform($id, $option_name, $option_value, $error); } else { // save data database mysql_query("update options set option_name='$option_name', option_value='$option_value' option_id='$id'") or die(mysql_error()); // once saved, redirect view page header("location: view_products.php"); } } else{ // if 'id' isn't valid, display error echo 'error: ogiltigt id!'; } } // if form hasn't been submitted, data db , display form else{ // 'id' value url (if exists), making sure valid (checing numeric/larger 0) if (isset($_get['id']) && is_numeric($_get['id']) && $_get['id'] > 0){ // query db $id = $_get['id']; $result = mysql_query("select * options option_id=$id") or die(mysql_error()); $row = mysql_fetch_array($result); // check 'id' matches row in databse if($row){ // data db $name = $row['option_name']; $option_value = $row['option_value']; // show form renderform($id, $name, $option_value, ''); } else // if no match, display result { echo "no results!"; } } else // if 'id' in url isn't valid, or if there no 'id' value, display error { echo 'error: id saknas eller är ogiltigt'; } } form header function included...
<?php session_start(); if(!isset($_session['myusername'])){ header("location:login.php"); } //kollar om användaren är inloggad och har adminbehörigheter annars skickas personen till inloggningsidan if(isset($_session['permission']) && $_session['permission'] >= 4){ } else{ header("location:login.php"); } // connect database include '/include/config.php'; // results database $result = mysql_query("select * options") or die(mysql_error()); function renderform($id, $option_name, $option_value, $error) { ?> <!doctype html> <html> <head> <meta charset="utf-8"> <html lang="sv"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Ändra inställning - petrolia lagersystem</title> <!-- core css - include every page --> <link href="css/bootstrap.min.css" rel="stylesheet"> <link href="font-awesome/css/font-awesome.css" rel="stylesheet"> <link href="css/custom-style.css" rel="stylesheet"> <!-- page-level plugin css - blank --> <!-- sb admin css - include every page --> <link href="css/sb-admin.css" rel="stylesheet"> </head> <body> <div id="wrapper"> <?php include "top_menu.php"; ?> <?php include "side_menu.php"; ?> <div id="page-wrapper"> <div class="row"> <div class="col-lg-12"> <h1 class="page-header">inställningar</h1> <?php // if there errors, display them if ($error != '') { echo '<div style="padding:4px; border:1px solid red; color:red;">'.$error.'</div>'; } ?> <form action="" method="post"> <input type="hidden" name="id" value="<?php echo $id; ?>"/> <div> <p><strong>id:</strong> <?php echo $id; ?></p> <strong>inställning: *</strong> <input class="form-control" type="text" name="option_name" value="<?php echo $option_name; ?>"/><br/> <strong>värde: *</strong> <input class="form-control" type="text" name="option_value" value="<?php echo $option_value; ?>"/><br/> <p>* obligatoriskt</p> <button type="submit" class="btn btn-primary"><i class="fa fa-save fa-fw"></i>spara ändring</button> </div> </form> </div> <!-- /.col-lg-12 --> </div> <!-- /.row --> </div> <!-- /#page-wrapper --> </div> <!-- /#wrapper --> <!-- core scripts - include every page --> <script src="js/jquery-1.10.2.js"></script> <script src="js/bootstrap.min.js"></script> <script src="js/plugins/metismenu/jquery.metismenu.js"></script> <!-- page-level plugin scripts - blank --> <!-- sb admin scripts - include every page --> <script src="js/sb-admin.js"></script> <!-- page-level demo scripts - blank - use reference --> </body> </html> <?php }
correct query syntax one-
mysql_query("update options set option_name='".$option_name."', option_value='".$option_value."' option_id='".$id."'"); and same select query-
$result = mysql_query("select * options option_id='".$id."'"); hope you.
Comments
Post a Comment