javascript - Not able to save updated rows in table column with php -

-

i troubling save records in update set statement within php. im using javascript update record on submit. see below code:

/* update record  */ $(document).on('submit', '#emp-updateform', function() {     $.post("update.php", $(this).serialize())     .done(function(data){         $("#dis").fadeout();         $("#dis").fadein('slow', function(){              $("#dis").html('<div class="alert alert-info">'+data+'</div>');              $("#emp-updateform")[0].reset();              $("body").fadeout('slow', function()              {                 $("body").fadeout('slow');                 window.location.href="home.php";              });                           });         });        return false; }); /* update record  */

note above method retrieving file update.php update set statement lies. see code:

if(isset($_post)){  $stmt = $update->runquery("update individualproduct set name=:name,model=:model,manufacturer=:manufacturer,productionyear=:productionyear,color=:color,purchaseamount=:purchaseamount id_product=:id");  $stmt->bindparam(":name",$pname); $stmt->bindparam(":model",$pmodel); $stmt->bindparam(":manufacturer",$pmanuf); $stmt->bindparam(":productionyear",$pyear); $stmt->bindparam(":color",$pcolor); $stmt->bindparam(":purchaseamount",$pamount); $stmt->bindparam(":id",$id);  $id         = $_post['id_product']; $pmanuf     = $_post['pmanuf']; $pname      = $_post['pname']; $pmodel     = $_post['pmodel']; $pyear      = $_post['pyear']; $pcolor     = $_post['pcolor']; $pamount    = $_post['pamount'];  $stmt->execute();}

here edit_form.php records column retrieved when editing:

<form method='post' id='emp-updateform' action='#'>  <table class='table table-bordered'>     <input type='hidden' name='id' value='<?php echo $row['id_product']; ?>' />     <tr>         <td>mærke</td>         <td><input type='text' name='manufacturer' class='form-control' value='<?php echo $row['manufacturer']; ?>' required></td>     </tr>      <tr>         <td>navn</td>         <td><input type='text' name='name' class='form-control' value='<?php echo $row['name']; ?>' required></td>     </tr>      <tr>         <td>model</td>         <td><input type='text' name='model' class='form-control' value='<?php echo $row['model']; ?>' required></td>     </tr>      <tr>         <td>Årgang</td>         <td><input type='text' name='productionyear' class='form-control' value='<?php echo $row['productionyear']; ?>' required></td>     </tr>      <tr>         <td>pris</td>         <td><input type='text' name='purchaseamount' class='form-control' value='<?php echo $row['purchaseamount']; ?>' required></td>     </tr>      <tr>         <td>farve</td>         <td><input type='text' name='color' class='form-control' value='<?php echo $row['color']; ?>' required></td>     </tr>      <tr>         <td colspan="2">         <button type="submit" class="btn btn-primary" name="btn-update" id="btn-update">         <span class="glyphicon glyphicon-plus"></span> save updates         </button>         </td>     </tr>  </table>

when enter value "acer" in row, example in "manufacturer" row value = "asus" , click on submit (save updates), value changes "asus" , not being updated input.


Comments

Post a Comment

Popular posts from this blog

php - How to display all orders for a single product showing the most recent first? Woocommerce -

-
i have password protected page on frontend. on page, want display full list of purchases associated single woocommerce product id. option 1: i've looked through woocommerce docs , , found: wc_cli_order , list_( $args, $assoc_args ) function lists orders. presumably, orders can filtered product id [--=] filter orders based on order property. line item fields (numeric array, started index zero): line_items.0.product_id option 2: i found article , based on customer id. i've modified code based on guesses meta_key , meta_value. $customer_orders = get_posts( array( 'numberposts' => -1, 'meta_key' => '_product', 'meta_value' => get_product_id(), 'post_type' => wc_get_order_types(), 'post_status' => array_keys( wc_get_order_statuses() ), ) ); how display orders single product showing recent order first? here solution put based on these articles: http://www.w...
Read more

asp.net - How to correctly use QUERY_STRING in ISAPI rewrite? -

-
i'm having difficult time , hope guys can help. using helicon isapi rewrite version 3.1.0.104 on our iis server. edit http.conf file , have tried , still fail. this trying do: redirect url: https://www.domain.com/switch-by-version?version=2.8.5.2594 to: https://test.domain.com/load/load.aspx?tver=2.8.5.2594 the version number @ end source url change, , need target url have same version number @ end of url example above shows. i tried following not work: rewritecond %{query_string} ^version=(\d\d?)\.(\d\d?)\.(\d\d?)\.(.*)$ [nc] rewriterule ^/switch-by-version(.*)$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l] any appreciated! thanks. if it's running in equivalent context of .htaccess , rule shouldn't start / . here's simpler version: rewritecond %{query_string} ^version=(\d+\.\d+\.\d+(?:\..+)?)$ [nc] rewriterule ^switch-by-version/?$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l]
Read more

angularjs - How restrict admin panel using in backend laravel and admin panel on angular? -

-
https://scotch.io/tutorials/token-based-authentication-for-angularjs-and-laravel-apps following tutorials, try write authentication restrict admin panel, didn't understood how can that. this admin panel, admin panel don't want show , request database unauthenticated users. my laravel-routes route::get('/admin',function(){ return view('index'); }); route::get('/api/v1/employees/{id?}', 'employees@index'); route::get('/api/v1/users/{id?}', 'employees@users'); route::post('/api/v1/employees', 'employees@store'); route::post('/api/v1/employees/{id}', 'employees@update'); route::delete('/api/v1/employees/{id}', 'employees@destroy'); route::group(['prefix' => 'api'], function() { route::resource('authenticate', 'authenticatecontroller', ['only' => ['index']]); route::post('authenticate', 'authentic...
Read more