mysql - $http(req) entering into success even though query string not making entry in DB - AngularJS -


this addnewproduct function.

productservice.addnewproduct = function(newproduct)  {      //alert (json.stringify (newproduct));      var req = {         url: "cgi-bin/addnewproduct.pl",         method: 'get',         params: {productid: newproduct.productid, productname: newproduct.productname, productimagepath: newproduct.productimagepath, brandid: newproduct.brandid, subcategoryid: newproduct.subcategoryid}         //params: { newproduct: productdata }     };      $http(req).success(function(data, status, headers, config)     {         productlist.unshift(newproduct);         //alert (data);         alert ('new product added!');     })     .error(function()     {         alert ('new product add error!');     });  }

this addnewproduct.pl

    #!c:/perl64/bin/perl.exe  use strict; use warnings; use dbi; use cgi::carp qw(warningstobrowser fatalstobrowser); use cgi; use cgi::cookie; use cgi::session qw(); use json;  print "content-type: text/html\n\n";  $cfg = "config.pl"; $db_handle = dbi->connect ("dbi:mysql:$cfg->{database}", $cfg->{user}, $cfg->{password} ) or die "couldn't connect database: $dbi::errstr\n";  $cgi = cgi->new(); #my $decodeddata = decode_json($cgi->param("newproduct"));  $product_id = $cgi->param('productid'); $product_name = $cgi->param('productname'); $product_description = 'desc'; $image_path = $cgi->param('productimagepath'); $brand_id = $cgi->param('brandid'); $subcatty_id = $cgi->param('subcategoryid');  $sql_query = "insert table_products values ($product_id, '$product_name', '$product_description', '$image_path', '$brand_id')"; $statement = $db_handle->prepare ($sql_query) or die "couldn't prepare query '$sql_query': $dbi::errstr\n";   $statement->execute() or die "sql error: $dbi::errstr\n";     $db_handle->disconnect; #print $cgi->header;

this table structure.

mysql> describe table_products; +---------------------+--------------+------+-----+---------+-------+ | field               | type         | null | key | default | | +---------------------+--------------+------+-----+---------+-------+ | product_id          | int(11)      | no   | pri | null    |       | | product_name        | varchar(64)  | no   |     | null    |       | | product_description | varchar(64)  | no   |     | null    |       | | product_image_path  | varchar(128) | no   |     | null    |       | | brand_id            | int(11)      | no   |     | null    |       | | available           | tinyint(1)   | no   |     | null    |       | +---------------------+--------------+------+-----+---------+-------+

please note in query string missing value available field. means entry wont created in table using query string.

but after $http(req), getting alert ('new product added.').

why so? when entry not created in perl should enter in error. missing , how fix these kind of errors?


Comments

Post a Comment

Popular posts from this blog

javascript - Using jquery append to add option values into a select element not working -

i'm looking dynamically populate select element names of items stored array. for reason it's not working , i'm not sure why. html: <div class="col-md-4 col-md-offset-4"> <select class="select1"> </select> , <select class="select2"> </select> </div> note i'm using bootstrap layout. here's jquery i'm using try , populate ".select1" jquery: select: function() { $.each(state.greens, function(index, value) { $(".select1").append("<option value =' " + index + " '>" + state.greens[index].name + "</option>"); }); } note function 'select' stored within object called 'display'. state.greens name of array i'm trying access. so @ end of html page call display.select(); call function. no error messages showing in console. also, saw question: appending
Read more

Android soft keyboard reverts to default keyboard on orientation change -

i'm building android soft keyboard , can't seem fix bug - have arabic , qwerty keyboard , when rotate device on qwerty keyboard (or arabic shift), it's if program has "restarted" , becomes arabic keyboard without shift. the onsaveinstancestate(bundle savedinstancestate) not work because application not extend activity inputmethodservice . i put following in android manifest android:configchanges="keyboard|keyboardhidden|orientation" android:windowsoftinputmode="stateunchanged|adjustresize"> i tried using @override public void onconfigurationchanged(configuration newconfig) { super.onconfigurationchanged(newconfig); log.i(mydebug, "config changed " + currentkeyboard.equals(qwerty)); } however, currentkeyboard.equals(qwerty)) results false , made sure true before orientation change. any appreciated. i think applications fault. if application restarting on orientation change
Read more

Rendering JButton to get the JCheckBox behavior in a JTable by using images does not update my table -

i rendering jbutton image on simulate jcheckbox behavior. why don't let jtable render jcheckbox? because need bigger checkboxes , there's no way can resize them (as far know). so, have own table cell renderer , editor. both renders jbutton , checkbox images on them. trying change image checked image unchecked image (or vice versa) , update cell value (boolean true or false). however, reason, getcelleditorvalue() not update table. so, release mouse, value goes original one. any appreciated! lot! public class tableexample extends jframe { jscrollpane pane; jpanel panel; jtable table; object[][] data; mytablemodel tm; renderer buttoncolumn; public tableexample(object[][] data) throws ioexception { string[] columns = {"column#1", "column#2", "column#3", "column#4", "column#5", "column#6"}; this.data = data; this.setpreferredsize(new dimension(700, 500));
Read more