php - Codeigniter database delete and insert multiple records -

-

i have problem different this , this. in model class had separate delete , save 2 different functions follows.

  #save advanced preferences function savepreference($preferences){      $this->db->insert('bingo_advanced_preferences', $preferences);       echo $this->db->last_query();     }   #delete advanced preferences function deletepreference($user_id,$criteria){ return $this->db->delete('bingo_advanced_preferences', array('bingo_user_id' => $user_id,'adv_criteria' =>$criteria));  }

if call these functions controller delete, update works. 

 //language preferences               if($this->input->post('language') && count($this->input->post('language')) > 0):                 $this->bingo_advanced_preferences->deletepreference($user,'15');                 ($i=0; $i < count($this->input->post('language')); $i++) {                      $language_options = array(                     'bingo_user_id' => $user,                     'adv_criteria' => 15, //languages                     'adv_criteria_value' => $this->input->post('language')[$i],                     'adv_date_created' => date('y-m-d h:i:s')                     );                 $this->bingo_advanced_preferences->savepreference($language_options);                 }             endif;

however doesn't cater scenario deselects correct order should this. 

    $this->bingo_advanced_preferences->deletepreference($user,'15');       if($this->input->post('language') && count($this->input->post('language')) > 0):              ($i=0; $i < count($this->input->post('language')); $i++) {                  $language_options = array(                 'bingo_user_id' => $user,                 'adv_criteria' => 15, //languages                 'adv_criteria_value' => $this->input->post('language')[$i],                 'adv_date_created' => date('y-m-d h:i:s')                 );             $this->bingo_advanced_preferences->savepreference($language_options);             }         endif;

this deletes records adv_criteria=15 , never updates(do subsequent saving). of course have solved problem if else statement question why doesn't work? how can make work?

for delete , can on view file 

<input type='checkbox' name='tableid[]' value='<?php echo $value->tableid; ?>"'>

then on controller this

function delete_multiple() {     // retrive multiple id list form     $check_id = $this->input->post('tableid[]');         // multiple delete loop id        foreach($check_id $checkid) {           $this->db->where('tableid', $checkid);           $this->db->delete('tablename');         } }

for insert , can on view file same above on controller this

function multiple_add() {   $table_id = $this->input->post('tableid[]');    foreach($table_id $tableid) {      $data_some = array(     'tableid' => $tableid,     'blah' => $this->input->post('blah')     );      // insert data function call     $this->db->insert('tablename', $data_some);     } }

Comments

Post a Comment

Popular posts from this blog

wordpress - (T_ENDFOREACH) php error -

-
creating wordpress website , i'm getting following php error: parse error: syntax error, unexpected 'endforeach' (t_endforeach) in /home/soralmedia/public_html/wp-content/themes/soral media/woocommerce/myaccount/my-orders.php on line 98 here's code file: <?php /** * orders * * shows recent orders on account page. * * template can overridden copying yourtheme/woocommerce/myaccount/my-orders.php. * * however, on occasion woocommerce need update template files , (the theme developer). * need copy new files theme maintain compatibility. try this. * little possible, happen. when occurs version of template file will. * bumped , readme list important changes. * * @see http://docs.woothemes.com/document/template-structure/ * @author woothemes * @package woocommerce/templates * @version 2.5.0 */ if ( ! defined( 'abspath' ) ) { exit; } $my_orders_columns = apply_filters( 'woocommerce_my_account_my_orders_columns', array( ...
Read more

Export Excel workseet into txt file using vba - (text and numbers with formulas) -

-
i new vba have developed code use in excel move text/numbers txt file. issue have 3 functions need go same txt file. when run first function has set fs = createobject("scripting.filesystemobject") set = fs.createtextfile(module1.nys45uploadfilename, true) a.writeline (str) a.close. the other 2 functions had save. set fs = createobject("scripting.filesystemobject") set = fs.savetextfile(module1.nys45uploadfilename, true) a.writeline (str) a.close. the first function go txt file, other 2 error object doesn't support property or method. when changed 3 create last function goes txt file. can not figure out word use in order make other 2 functions follow txt file in order keyed. the entire code follows private sub addrecord_click() on error goto errhandler module1.nys45uploadfilename = application.getsaveasfilename(filefilter:="textfiles (*.txt), *.txt") if module1.nys45uploadfilename = "false" exit sub ...
Read more

Using django-mptt to get only the categories that have items -

-
sample structure: all uppercase: category mixed case: item root ├── books │   ├── fiction │   │   └── classics │   └── non-fiction ├── clothing └── electronics ├── laptops ├── phones │   ├── apple │   │   ├── iphone 6 │   │   ├── iphone 6 plus │   │   ├── iphone 6s │   │   └── iphone 6s plus │   ├── motorola │   │   ├── moto g4 │   │   ├── moto g4 play │   │   ├── moto g4 plus │   │   └── moto x │   └── samsung └── tablets └── apple i'm trying have index page show "electronics" category. "clothing" category shouldn't show since it's empty , "books" category shouldn't show either since, although has child categories, child categories don't have items. similarly, "electronics" page should show "phones" category. "laptops" category shouldn't show since it's empty , "tablets" category shouldn't show either since...
Read more