"codeigniter insert if not exist" Code Answer's

You're definitely familiar with the best coding language Whatever that developers use to develop their projects and they get all their queries like "codeigniter insert if not exist" answered properly. Developers are finding an appropriate answer about codeigniter insert if not exist related to the Whatever coding language. By visiting this online portal developers get answers concerning Whatever codes question like codeigniter insert if not exist. Enter your desired code related query in the search bar and get every piece of information about Whatever code related question on codeigniter insert if not exist.

codeigniter insert if not exist

Oliver Weit on Jun 29, 2020

    function safe_update_batch($table_name,$records,$filter_field)
    {
        $filters=array();

        foreach($records as $record)$filters[]=$record[$filter_field];

        $this->db->query("SET SESSION group_concat_max_len=10000000");

        $query=$this->db->select("GROUP_CONCAT($filter_field) AS existing_keys",FALSE)->where_in($filter_field, $filters)->get($table_name);

        $row=$query->row();
        $found_fields=explode(',',$row->existing_keys);         

        $insert_batch=array();
        $update_batch=array();

        foreach($records as $record)
        {
            if(in_array($record[$filter_field],$found_fields))$update_batch[]=$record;
            else $insert_batch[]=$record;
        }

        if(!empty($insert_batch))$this->db->insert_batch($table_name,$insert_batch);
        if(!empty($update_batch))$this->db->update_batch($table_name,$update_batch,$filter_field);      
    }

Source: stackoverflow.com

Add Comment

All those coders who are working on the Whatever based application and are stuck on codeigniter insert if not exist can get a collection of related answers to their query. Programmers need to enter their query on codeigniter insert if not exist related to Whatever code and they'll get their ambiguities clear immediately. On our webpage, there are tutorials about codeigniter insert if not exist for the programmers working on Whatever code while coding their module. Coders are also allowed to rectify already present answers of codeigniter insert if not exist while working on the Whatever language code. Developers can add up suggestions if they deem fit any other answer relating to "codeigniter insert if not exist". Visit this developer's friendly online web community, CodeProZone, and get your queries like codeigniter insert if not exist resolved professionally and stay updated to the latest Whatever updates.

"codeigniter insert if not exist" Code Answer's

codeigniter insert if not exist

Whatever answers related to "codeigniter insert if not exist"

Whatever queries related to "codeigniter insert if not exist"

Browse Other Code Languages