Databases
StackOverflow2013
Postsdbo
POHow to take log of only affected rows during update_batch in codeigniter?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to take log of only affected rows during update_batch in codeigniter?
    primarykey
    data
    text
    <p>I searched the net but didn't find any solution to my problem. I have a form which is generated dynamically i get each fields in array and insert_batch it to database and also the same way i update_batch it,</p> <p>now I want to take log of my database during update_batch, my data comes in array is there any way to take log of only affected rows?</p> <p>Here is my simple code which i send to model for update_batch</p> <pre><code> $name = $this-&gt;input-&gt;post('name'); $type = $this-&gt;input-&gt;post('type'); $model = $this-&gt;input-&gt;post('model'); $license = $this-&gt;input-&gt;post('license'); $machine_no = $this-&gt;input-&gt;post('machine_no'); $value = $this-&gt;input-&gt;post('value'); $bought_date = $this-&gt;input-&gt;post('bought_date'); $bought_place = $this-&gt;input-&gt;post('bought_place'); $cur_price = $this-&gt;input-&gt;post('cur_price'); $bought_seller = $this-&gt;input-&gt;post('bought_seller'); $sfunds = $this-&gt;input-&gt;post('sfunds'); $u_rec_id = $this-&gt;session-&gt;userdata('rec_id'); $serial = $this-&gt;session-&gt;userdata('serial'); $all_array = array(); $form_data = array(); if($name) { if(is_array($name)) { for($j=0; $j&lt;count($name); $j++) { $this-&gt;ci_form = array( 'name' =&gt; $name[$j], 'vehicle_type' =&gt; $type[$j], 'made_model' =&gt; $model[$j], 'license' =&gt; $license[$j], 'machine_no' =&gt; $machine_no[$j], 'value' =&gt; $value[$j], 'date_acquired' =&gt; change_datei($bought_date[$j]), 'place_acquired' =&gt; $bought_place[$j], 'current_value' =&gt; $cur_price[$j], 'seller' =&gt; $bought_seller[$j], 'fund_source' =&gt; $sfunds[$j], 'userid' =&gt; $id, 'u_rec_id' =&gt; $u_rec_id, 'serial' =&gt; $serial, 'regdate' =&gt; date('Y-m-d H:m:s') ); array_push($all_array, $this-&gt;ci_form); } } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMehdi Jalal
    1. USMehdi Jalal
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. POHow to take log of only affected rows during update_batch in codeigniter?
      1. USMehdi Jalal
      1. VTFavorite
    2. VO
      singulars
      1. POHow to take log of only affected rows during update_batch in codeigniter?
      1. USMehdi Jalal
      1. VTFavorite
    1. COWhat do you mean by `log of database`? if you want to know how many rows are affected use `$this->db->affected_rows();`, if you want to get the sql query use `$this->db->last_query();`
      singulars
      1. POHow to take log of only affected rows during update_batch in codeigniter?
      1. USHashem Qolami
    2. COI have for example one table job_history and one table job_history_log, the fields in both table are same for security reason if any person changes any records in job_history i insert the updated records into job_history_log did you understand what i mean or not?
      singulars
      1. POHow to take log of only affected rows during update_batch in codeigniter?
      1. USMehdi Jalal
    3. COSo, if I understood correctly, you want to record `job_history` changes during the time. If I were you, I would just update `job_history` table and insert that row in `job_history_log` at the same time. `job_history_log` should has two additional fields: `log_id` as primary key and auto generated `timestamp` to save the insertion time.
      singulars
      1. POHow to take log of only affected rows during update_batch in codeigniter?
      1. USHashem Qolami
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload