• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to update all rows in database using batch update?

#1
I want to update database and add slug to every row. Problem is the code i wrote only update 1 row.

here is the structure of database

site_id integer primarykey autoincrement
site_title varchar
slug varchar



this is my controller here i make slug from title i get from database and want to update all row and insert new slug to every row

PHP Code:
public function ghjk(){
    
$this->load->helper('text');
    
$this->load->model("model_get");    
   
$results$this->model_get->getalltitles();

    foreach (
$results as $key) {
      
# code...
      
$page_title=$key['site_title'];
  
$cleanslug convert_accented_characters($page_title);


    
$slug["slug"] = url_title($cleanslug,'-',TRUE);    
    
$data["id"] = $key['site_id'];
    echo 
$slug["slug"];
    echo 
$data["id"];

    }
 


     
$this->load->model("model_get");     
    
$this->model_get->updateall($data,$slug);                    




this is my model

PHP Code:
function updateall($data,$slug){

$mdata = array(
  
   array(
      
'site_id' => $data['id'] ,
      
'slug' => $slug['slug']
   ),

);





 
$this->db->update_batch('newsites'$mdata'site_id');

  } 
Reply

#2
Hi,

I would do something like this. Added comments to the code to try and make it clear how it works.

Controller
PHP Code:
function ghjk()
{
 
   $this->load->helper('text');
 
   $this->load->model("model_get");

 
   // Get title and id form database
 
   // Assuming that $results includes row ID and title
 
   $results $this->model_get->getalltitles();

 
   // Set $data array but leave it empty for now.
 
   $data = array();

 
   // Get key and value
 
   foreach ($results as $key => $value)
 
   {
 
       // Clean the slug
 
       $cleanslug convert_accented_characters($value['site_title']);

 
       // Add cleaned title and id to new data array.
 
       // By using the key value, we create a new array for each row
 
       // in the already existsing data array that we created earlier.
 
       // This also gives us the correct formatted array for update_batch()
 
       // function later.
 
       
        $data
[$key]['slug'   url_title($cleanslug,'-',TRUE);
 
       $data[$key]['site_id'] = $value['site_id'];
 
   }

 
   // Print out array for debug
 
   print_r($data);

 
   // Update database
 
   $this->model_get->updateall($data);


Model
PHP Code:
function updateall($data = array())
{
 
   // Check so incoming data is actually an array and not empty
 
   if (is_array($data) && ! empty($data))
 
   {
 
       // We already have a correctly formatted array from the controller,
 
       // so no need to do anything else here, just update.
 
       
        
// Update rows in database
 
       $this->db->update_batch('newsites'$data'site_id');
 
   }


A small note. In your original code you load the model twice in the same controller function. You only need to load it once, so I removed the second loading in my example.
Reply

#3
(04-20-2015, 03:00 PM)silentium Wrote: Hi,

I would do something like this. Added comments to the code to try and make it clear how it works.

Controller

PHP Code:
function ghjk()
{
 
   $this->load->helper('text');
 
   $this->load->model("model_get");

 
   // Get title and id form database
 
   // Assuming that $results includes row ID and title
 
   $results $this->model_get->getalltitles();

 
   // Set $data array but leave it empty for now.
 
   $data = array();

 
   // Get key and value
 
   foreach ($results as $key => $value)
 
   {
 
       // Clean the slug
 
       $cleanslug convert_accented_characters($value['site_title']);

 
       // Add cleaned title and id to new data array.
 
       // By using the key value, we create a new array for each row
 
       // in the already existsing data array that we created earlier.
 
       // This also gives us the correct formatted array for update_batch()
 
       // function later.
 
       
        $data
[$key]['slug'   url_title($cleanslug,'-',TRUE);
 
       $data[$key]['site_id'] = $value['site_id'];
 
   }

 
   // Print out array for debug
 
   print_r($data);

 
   // Update database
 
   $this->model_get->updateall($data);


Model

PHP Code:
function updateall($data = array())
{
 
   // Check so incoming data is actually an array and not empty
 
   if (is_array($data) && ! empty($data))
 
   {
 
       // We already have a correctly formatted array from the controller,
 
       // so no need to do anything else here, just update.
 
       
        
// Update rows in database
 
       $this->db->update_batch('newsites'$data'site_id');
 
   }


A small note. In your original code you load the model twice in the same controller function. You only need to load it once, so I removed the second loading in my example.



Thank you very much man. It worked like a charm. It took my day but you saved me thanks.
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.