php - Deleting Table Data Before Inserting New Data -


i have these 2 tables, table , table b. before updating table b want delete it's datas before inserting new one.

i have query delete data in table , insert new 1 after succeeded in deleting old records. inserting values it's not deleting old one, ended duplicating of new id's inserted before. tried code:

 public function editdiscount(){         foreach ($this->searchfields $field => $value) :         if($field == 'key'){             $key = $value;         } else if($field == 'name'){             $discountname = $value;         } else if($field == 'code'){              $discountcode = $value;         } else if($field == 'desc'){             $discountdesc = $value;         }else if($field == 'type'){             $discounttype = $value;         }else if($field == 'trans'){             $discounttransaction = $value;         }else if($field == 'exptype'){             $expiration = $value;         }else if($field == 'start'){             $expstartdate = $value;         }else if($field == 'end'){             $expenddate = $value;         }else if($field == 'value'){             $discountvalue = $value;         }else if($field == 'prodkey'){             $productid= $value;         }      endforeach;          $discount = vldiscount::query()             ->andwhere("autokey =?1")             ->andwhere("app_id =?2")             ->bind(array(1=>$key,2=>$this->session->get('appid')))             ->execute();      if($discount->count() != 0){          $discountupdate = vldiscount::findfirst($key);         $discountupdate->discountname           = $discountname;         $discountupdate->discountcode           = $discountcode;         $discountupdate->discountdesc           = $discountdesc;         $discountupdate->discounttype           = $discounttype;         $discountupdate->discounttransaction    = $discounttransaction;         $discountupdate->expiration             = $expiration;         $discountupdate->expstartdate           = $expstartdate;         $discountupdate->expenddate             = $expenddate;         $discountupdate->discountvalue          = $discountvalue;            if($discountupdate->update() == false){             $devmessage = array();             foreach ($discountupdate->getmessages() $key){                 $devmessage[] =  $key->getmessage();             }             return $this->respond(array(                     'usermessage' => 'failed',                     'devmessage' => $devmessage,                     'more' => 'failed update. 1 or more fields failed on validation.'));             }else if ($discounttransaction == 'p'){                  foreach ($this->searchfields $field => $value) :                 if($field == 'prodkey'){                     $productid = $value;                 }                 endforeach;                  $exs = explode('|',$productid);                 $deleteerrors = 0;                 foreach ($exs $xx) {                     $deleteproductdiscount = vldiscountproduct::query()                     ->andwhere("discountid =?1")                     ->andwhere("app_id =?2")                     ->bind(array(1=>(int)$xx,2=>$this->session->get('appid')))                     ->execute();                      foreach($productdiscountdelete $cat){                         $productsdelete = vldiscountproduct::findfirst($cat->$discountupdate->autokey);                         if ($deleteproductdiscount != false) {                             if ($productsdelete->delete() == false) {                                 $deleteerrors++;                                 $devmessage = array();                                 foreach ($deleteproductdiscount->getmessages() $key){                                     $devmessage[] =  $key->getmessage();                                 }                             }                         }                     }                     unset($deleteproductdiscount);                 }                  if($deleteerror == 0){                     $exp = explode('|',$productid);                      foreach ($exp $item){                          $productdiscount = new vldiscountproduct();                         $productdiscount->discountid    = $discountupdate->autokey;                         $productdiscount->productid     = $item;                         $productdiscount->app_id        = $this->session->get('appid');                          if($productdiscount->create() == false){                             $devmessage = array();                             foreach ($productdiscount->getmessages() $key){                                 $devmessage[] =  $key->getmessage();                             }                             return $this->respond(array(                                     'usermessage' => 'failed',                                     'devmessage' => $devmessage,                                     'more' => 'failed create. 1 or more fields failed on validation.'                             ));                         }                      }                     return $this->respond(array('usermessage' => 'ok'));                 }else{                     return $this->respond(array(                             'usermessage' => 'failed',                             'devmessage' => $devmessage,                             'more' => 'failed delete. 1 or more fields produced error.'                     ));                 }                 return $this->respond(array(                         'usermessage' => 'failed',                         'devmessage' => 'cannot find user information',                         'more' => 'failed update. 1 or more fields failed on validation.'));                    }             }         }

you're checking if($deleteerror == 0){ instead of if($deleteerrors == 0){.

update

this whole foreach statement off.

foreach($productdiscountdelete $cat){     $productsdelete = vldiscountproduct::findfirst($cat->$discountupdate->autokey);         if ($deleteproductdiscount != false) {             if ($productsdelete->delete() == false) {                 $deleteerrors++;                 $devmessage = array();                 foreach ($deleteproductdiscount->getmessages() $key){                     $devmessage[] =  $key->getmessage();                 }             }         } }

you never define $productdiscountdelete, it's never going foreach loop.


Comments

Post a Comment

Popular posts from this blog

javascript - Jquery show_hide, what to add in order to make the page scroll to the bottom of the hidden field once button is clicked -

i have button on website when clicked, reveals map. button can seen when page first loads up, when clicked, section holding map slides open , goes out of screen since page loads @ top (normal). want page scroll down bottom of div select when button pushed, if map out of screen. if page scrolled down, , clicks show map button, don't want page jump bottom of map. i tried figure out myself, no luck. seasoned jquery coders able give me guidance? many thanks! map = mapdiv.gmap3("get"); infobox = new infobox({ pixeloffset: new google.maps.size(-220, -310), closeboxurl: '', enableeventpropagation: true }); mapdiv.delegate('.infobox .close','click',function () { infobox.close(); }); jquery(".slidingdiv").hide(); jquery(".show_hide").show(); jquery('.show_hide').click(function(){ lastcenter=map.getcenter(); jquery(".slidingdiv&quo
Read more

javascript - Highcharts multi-color line -

Image
i looking create highchart multi-colored line. if goes down under value, become red, , when comes on value, become green . here picture example: or maybe highcharts have other charts models differentiate high or low level color? you can achieve coloring using lineargradient coloring: color: { lineargradient: { x1: 0, x2: 0, y1: 0, y2: 1 }, stops: [ [0, 'red'], [0.25, 'yellow'], [0.50, 'green'], [0.75, 'yellow'], [1, 'red'] ] } here 0 in stops relates minimum value of series , 1 maximum value, , in between percentages between values. if find percentages according values prior creating chart use correct stops values make relate specific values in data (at least approximately). see this jsfiddle example .
Read more

javascript - Enter key does not work in search box -

tried search guys sorry. input in search box doesnt work (or search) when hit enter when user clicks search button. doing wrong? here code. thanks. <script type="text/javascript"> $(document).ready(function() { $("#submit").click(function() { var url = "http://asla.org/awardssearch.html"; url += "?s=" + $('#googlecse').val(); window.location = url; }); $('#googlecse').keydown(function(event) { if (event.keycode == '13') { $("#submit").click(); } else { //do nothing :) } }); }); </script> <form class="navbar-form navbar-right" role="search"> <div class="search"> <input id="googlecse" type="text" onblur="if(this.value=='')this.value=this.defaultvalue;" onfocus="if(this.value==this.defaultvalue)t
Read more