title: editing php page to insert new value to my table
body: <p>hey I'm Newbie and want to edit php page and adding some extra code so my problem is<br>
  I added new column to my table and I want to send data from new input text to my table to new column<br>
  I add the input text and now I wand to insert that data in new column
  even I didn't find the insert query to editing it </p>
  
  <p>my code is below </p>
  
  <pre><code>&lt;?php include_once 'asset/admin-ajax.php'; ?&gt;
  &lt;?php echo message_box('success'); ?&gt;
  &lt;?php echo message_box('error'); ?&gt;
  
  
  &lt;div class="row"&gt;
      &lt;div class="col-sm-12"&gt;
          &lt;div class="wrap-fpanel"&gt;
              &lt;div class="panel panel-default" data-collapsed="0"&gt;
                  &lt;div class="panel-heading"&gt;
                      &lt;div class="panel-title"&gt;
                          &lt;strong&gt;&lt;?php echo $this-&gt;language-&gt;form_heading()[13] ?&gt;&lt;/strong&gt;
                      &lt;/div&gt;
                  &lt;/div&gt;
                  &lt;div class="panel-body"&gt;
                      &lt;form id="form" action="&lt;?php echo base_url() ?&gt;admin/employee/save_employee_award/&lt;?php
                      if (!empty($award_info-&gt;employee_award_id)) {
                          echo $award_info-&gt;employee_award_id;
                      }
                      ?&gt;" method="post"  enctype="multipart/form-data" class="form-horizontal"&gt;
                          &lt;div class="panel_controls"&gt;
                              &lt;div class="form-group" id="border-none"&gt;
                                  &lt;label for="field-1" class="col-sm-3 control-label"&gt;&lt;?php echo $this-&gt;language-&gt;from_body()[14][0] ?&gt; &lt;span class="required"&gt;*&lt;/span&gt;&lt;/label&gt;
                                  &lt;div class="col-sm-5"&gt;
                                      &lt;select name="designations_id" class="form-control" onchange="get_employee_by_designations_id(this.value)"&gt;                            
                                          &lt;option value=""&gt;اختر تعيين.....&lt;/option&gt;
                                          &lt;?php if (!empty($all_department_info)): foreach ($all_department_info as $dept_name =&gt; $v_department_info) : ?&gt;
                                                  &lt;?php if (!empty($v_department_info)): ?&gt;
                                                      &lt;optgroup label="&lt;?php echo $dept_name; ?&gt;"&gt;
                                                          &lt;?php foreach ($v_department_info as $designation) : ?&gt;
                                                              &lt;option value="&lt;?php echo $designation-&gt;designations_id; ?&gt;" 
                                                              &lt;?php
                                                              if (!empty($award_info-&gt;designations_id)) {
                                                                  echo $designation-&gt;designations_id == $award_info-&gt;designations_id ? 'selected' : '';
                                                              }
                                                              ?&gt;&gt;&lt;?php echo $designation-&gt;designations ?&gt;&lt;/option&gt;                            
                                                                  &lt;?php endforeach; ?&gt;
                                                      &lt;/optgroup&gt;
                                                  &lt;?php endif; ?&gt;                            
                                              &lt;?php endforeach; ?&gt;
                                          &lt;?php endif; ?&gt;
                                      &lt;/select&gt;
                                  &lt;/div&gt;
                              &lt;/div&gt;
                              &lt;div class="form-group" id="border-none"&gt;
                                  &lt;label for="field-1" class="col-sm-3 control-label"&gt;&lt;?php echo $this-&gt;language-&gt;from_body()[14][1] ?&gt; &lt;span class="required"&gt;*&lt;/span&gt;&lt;/label&gt;
                                  &lt;div class="col-sm-5"&gt;
                                      &lt;select name="employee_id" id="employee" class="form-control" &gt;
                                          &lt;option value=""&gt;اختر موظف...&lt;/option&gt;  
                                          &lt;?php if (!empty($employee_info)): ?&gt;
                                              &lt;?php foreach ($employee_info as $v_employee) : ?&gt;
                                                  &lt;option value="&lt;?php echo $v_employee-&gt;employee_id; ?&gt;" 
                                                  &lt;?php
                                                  if (!empty($award_info-&gt;employee_id)) {
                                                      echo $v_employee-&gt;employee_id == $award_info-&gt;employee_id ? 'selected' : '';
                                                  }
                                                  ?&gt;&gt;&lt;?php echo $v_employee-&gt;first_name . ' ' . $v_employee-&gt;last_name ?&gt;&lt;/option&gt;                            
                                                      &lt;?php endforeach; ?&gt;
                                                  &lt;?php endif; ?&gt;
                                      &lt;/select&gt;
                                  &lt;/div&gt;
                              &lt;/div&gt;
  
                              &lt;div class="form-group"&gt;
                                  &lt;label for="field-1" class="col-sm-3 control-label"&gt;&lt;?php echo $this-&gt;language-&gt;from_body()[14][2] ?&gt; &lt;span class="required"&gt;*&lt;/span&gt;&lt;/label&gt;
  
                                  &lt;div class="col-sm-5"&gt;
                                      &lt;input type="text" name="award_name" class="form-control" value="&lt;?php
                                      if (!empty($award_info-&gt;award_name)) {
                                          echo $award_info-&gt;award_name;
                                      }
                                      ?&gt;" /&gt;
                                  &lt;/div&gt;
                              &lt;/div&gt;
  
  
  
                              &lt;div class="form-group"&gt;
                                  &lt;label for="field-1" class="col-sm-3 control-label"&gt; new column &lt;span class="required"&gt;*&lt;/span&gt;&lt;/label&gt;
  
                                  &lt;div class="col-sm-5"&gt;
                                      &lt;input type="text" name="new_column" class="form-control" value="&lt;?php
                                      if (!empty($award_info-&gt;new_column)) {
                                          echo $award_info-&gt;new_column;
                                      }
                                      ?&gt;" /&gt;
                                  &lt;/div&gt;
                              &lt;/div&gt;
  
  
  
  
                              &lt;div class="form-group"&gt;
                                  &lt;label for="field-1" class="col-sm-3 control-label"&gt;&lt;?php echo $this-&gt;language-&gt;from_body()[14][3] ?&gt;&lt;/label&gt;
  
                                  &lt;div class="col-sm-5"&gt;
                                      &lt;input type="text" name="gift_item" class="form-control" value="&lt;?php
                                      if (!empty($award_info-&gt;gift_item)) {
                                          echo $award_info-&gt;gift_item;
                                      }
                                      ?&gt;" /&gt;
                                  &lt;/div&gt;
                              &lt;/div&gt;
                              &lt;div class="form-group"&gt;
                                  &lt;label for="field-1" class="col-sm-3 control-label"&gt;&lt;?php echo $this-&gt;language-&gt;from_body()[14][4] ?&gt;&lt;/label&gt;
  
                                  &lt;div class="col-sm-5"&gt;
                                      &lt;input type="text" name="award_amount" class="form-control" value="&lt;?php
                                      if (!empty($award_info-&gt;award_amount)) {
                                          echo $award_info-&gt;award_amount;
                                      }
                                      ?&gt;" /&gt;
                                  &lt;/div&gt;
                              &lt;/div&gt;
                              &lt;div class="form-group"&gt;
                                  &lt;label class="col-sm-3 control-label"&gt;&lt;?php echo $this-&gt;language-&gt;from_body()[14][5] ?&gt; &lt;span class="required"&gt;*&lt;/span&gt;&lt;/label&gt;
  
                                  &lt;div class="col-sm-5"&gt;
                                      &lt;div class="input-group"&gt;
                                          &lt;input type="text" name="award_date" placeholder="ادخل الشهر"  class="form-control monthyear" value="&lt;?php
                                          if (!empty($award_info-&gt;award_date)) {
                                              echo $award_info-&gt;award_date;
                                          }
                                          ?&gt;" data-format="dd-mm-yyyy"&gt;
                                          &lt;div class="input-group-addon"&gt;
                                              &lt;a href="#"&gt;&lt;i class="entypo-calendar"&gt;&lt;/i&gt;&lt;/a&gt;
                                          &lt;/div&gt;
                                      &lt;/div&gt;
                                  &lt;/div&gt;
                              &lt;/div&gt;
                              &lt;div class="form-group"&gt;
                                  &lt;div class="col-sm-offset-3 col-sm-5"&gt;
                                      &lt;button type="submit" id="sbtn" name="sbtn" value="1" class="btn btn-primary"&gt;&lt;?php echo $this-&gt;language-&gt;from_body()[1][12] ?&gt;&lt;/button&gt;
                                  &lt;/div&gt;
                              &lt;/div&gt;
                          &lt;/div&gt;
                      &lt;/form&gt;
                  &lt;/div&gt;
              &lt;/div&gt;
          &lt;/div&gt;
      &lt;/div&gt;
  &lt;/div&gt;
  
  
  
  &lt;div class="row"&gt;
      &lt;div class="col-sm-12" data-offset="0"&gt;
          &lt;div class="panel panel-default"&gt;
              &lt;div class="panel-heading"&gt;
                  &lt;div class="panel-title"&gt;
                      &lt;span&gt;
                          &lt;strong&gt;&lt;?php echo $this-&gt;language-&gt;from_body()[14][6] ?&gt;&lt;/strong&gt;
                      &lt;/span&gt;
                  &lt;/div&gt;
              &lt;/div&gt;
              &lt;!-- Table --&gt;
  
              &lt;table class="table table-bordered table-hover" id="dataTables-example"&gt;
                  &lt;thead&gt;
                      &lt;tr&gt;
                          &lt;th class="col-sm-1"&gt;رقم الموظف&lt;/th&gt;
                          &lt;th&gt;اسم الموظف&lt;/th&gt;
                          &lt;th&gt;اسم المكافئة&lt;/th&gt;
                          &lt;th&gt;بند المكافئة&lt;/th&gt;
                          &lt;th&gt;مبلغ الكافئة&lt;/th&gt;
                          &lt;th&gt;الشهر&lt;/th&gt;
                          &lt;th&gt;  : اجراء&lt;/th&gt;
  
  
                      &lt;/tr&gt;
                  &lt;/thead&gt;
                  &lt;tbody&gt;
                      &lt;?php if (!empty($all_employee_award_info)):foreach ($all_employee_award_info as $v_award_info): ?&gt;
                              &lt;tr&gt;
                                  &lt;td&gt;&lt;?php echo $v_award_info-&gt;employment_id ?&gt;&lt;/td&gt;
                                  &lt;td&gt;&lt;?php echo $v_award_info-&gt;first_name . ' ' . $v_award_info-&gt;last_name; ?&gt;&lt;/td&gt;
                                  &lt;td&gt;&lt;?php echo $v_award_info-&gt;award_name;?&gt;&lt;/td&gt;
                                  &lt;td&gt;&lt;?php echo $v_award_info-&gt;gift_item; ?&gt;&lt;/td&gt;
                                  &lt;td&gt;&lt;?php echo $v_award_info-&gt;award_amount;?&gt;&lt;/td&gt;
                                  &lt;td&gt;&lt;?php echo date('F y', strtotime($v_award_info-&gt;award_date)) ?&gt;&lt;/td&gt;
                                  &lt;td&gt;
                                      &lt;?php echo btn_edit('admin/employee/employee_award/' . $v_award_info-&gt;employee_award_id . '/' . $v_award_info-&gt;designations_id); ?&gt;
                                      &lt;?php echo btn_delete('admin/employee/delete_employee_award/' . $v_award_info-&gt;employee_award_id); ?&gt;
                                  &lt;/td&gt;
                              &lt;/tr&gt;                   
                          &lt;?php endforeach; ?&gt;
                      &lt;?php endif; ?&gt;
                  &lt;/tbody&gt;
              &lt;/table&gt;
          &lt;/div&gt;
      &lt;/div&gt;
  &lt;/div&gt;
  </code></pre>
  
  <p>anyone for help please </p>