SERVER FORCE HTTP to HTTPS

 Add this script inside .htaccess file to force https.

RewriteCond %{HTTPS} !=on
RewriteRule ^.*$ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]

CODEIGNITER IMAGE AUTO ROTATE WHEN UPLOAD USING MOBILE

I have a project that can upload image. During I upload an image using desktop, the image if fine. But if I upload an image using my phone, the image will rotated automatically.

Solution

1) You need to add a new library.The library automatically rotates the provided image based on the embedded EXIF data. I use it in my projects to correctly display images uploaded from mobile devices

<?php if (!defined('BASEPATH')) exit('No direct script access allowed');

/**

* @file application/libraries/Image_autorotate.php

*/

class Image_autorotate

{

    function __construct($params = NULL) {

    

        if (!is_array($params) || empty($params)) return FALSE;

        

        $filepath = $params['filepath'];

        $exif = @exif_read_data($filepath);

        

        if (empty($exif['Orientation'])) return FALSE;

        

        $CI =& get_instance();

        $CI->load->library('image_lib');

        

        $config['image_library'] = 'gd2';

        $config['source_image'] = $filepath;

        

        $oris = array();

        

        switch($exif['Orientation'])

        {

        case 1: // no need to perform any changes

        break;

        case 2: // horizontal flip

        $oris[] = 'hor';

        break;

                                        

        case 3: // 180 rotate left

        $oris[] = '180';

        break;

                            

        case 4: // vertical flip

        $oris[] = 'ver';

        break;

                        

        case 5: // vertical flip + 90 rotate right

        $oris[] = 'ver';

        $oris[] = '270';

        break;

                        

        case 6: // 90 rotate right

        $oris[] = '270';

        break;

                        

        case 7: // horizontal flip + 90 rotate right

        $oris[] = 'hor';

        $oris[] = '270';

        break;

                        

        case 8: // 90 rotate left

        $oris[] = '90';

        break;

        

        default: break;

        }

        

        foreach ($oris as $ori) {

        $config['rotation_angle'] = $ori;

        $CI->image_lib->initialize($config);

        $CI->image_lib->rotate();

        }

    }

}

// END class Image_autorotate

/* End of file Image_autorotate.php */

/* Location: ./application/libraries/Image_autorotate.php */

Place this file inside library folder.

2)  call this library after you have upload an image.

$imageinfo = $this->upload->data();
$full_path = $imageinfo['full_path'];

// check EXIF and autorotate if needed
$this->load->library('image_autorotate', array('filepath' => $full_path));

Reference :-

• https://forum.codeigniter.com/thread-55034.html
  
• https://www.php.net/manual/en/function.exif-read-data.php#76964
  

CodeIgniter PHP : Merge Array

There are condition when we have two array and want to combine them. In PHP, we can use function array_merge() to merge those to array.

Below is the example how to use the function.

<?php
    $a1=array("a"=>"red","b"=>"green");
    $a2=array("c"=>"blue","b"=>"yellow");
    print_r(array_merge($a1,$a2));
?>

Result :

Array ([a]=>red [b]=>yellow [c]=>blue)

As you can see there are two value for key=b. But the result is going to print the 2nd array array as the value.

MySQL Insert or Update column with value from another table

INSERT

Sometimes, there was an old data that need to be transfer from old table to new table. However, not all fields are required to transfer. So, below is the example of two tables and fields, and the sql statement.

tableOld
id     name     ic_no     phone_no     address

tableNew
id     name     ic_no     phone_no     

MySQL statement

INSERT INTO tableNew (name,ic_no,phone_no)
  SELECT name,ic_no,phone_no FROM tableOld 
  WHERE tableOld.id > 1;

This SQL statement is called as insert into select.

UPDATE

In this case, I want to get value from table1 to update into table2 based on certain condition or value.
For example :-

table1
id     name     ic_no     phone_no

table2
id     name     phone_no     address

I want to get phone_no from table1 and update the value phone_no into table2 with condition table2.name = table1.name.

MySQL statement

UPDATE table2 t2 
        INNER JOIN table1 t1 
             ON t2.name = t1.name
SET t2.ic_no= t1.ic_no
WHERE t2.name = t1.name;

Codeigniter How to make Onclick showHide Radio Button Function (Javascript)

All the code will be coded inside view file. First make your radio button.

<input type="radio" id="expense" name="transaction" onclick="ShowHideDiv()" checked /><?php echo lang('title_expense')?>

<input type="radio" id="income" name="transaction" onclick="ShowHideDiv()" /><?php echo lang('title_income')?>

Make sure the radio button have an id and the same name. Also put onclick that equal to function that you want. For this project we want ShowHideDiv  func.

Then make the div that you want to show or hide.

<div id="expense_list" style="block: none">

//anything that you want to put inside this div

//it can be table or something

</div >

<div id="income_list" style="show: none">

//anything that you want to put inside this div

//it can be table or something

</div >

Lastly make the jquery script to make the ShowHideDiv() func.

<script type="text/javascript">

function ShowHideDiv() {

    var expense = document.getElementById("expense");

    var income = document.getElementById("income");

    var expense_list = document.getElementById("expense_list");

    var income_list = document.getElementById("income_list");

    expense_list.style.display = expense.checked ? "block" : "none";

    income_list.style.display = income.checked ? "block" : "none";

}

</script>

"block" : "none"  - means the func to hide the content is block.
"show" : "none"  - means the func will show nothing.(hide content)

CodeIgniter How to Make send Email Function

First, make a hidden form of table id in view to call it at controller.

View

echo form_hidden('id', $table->id);

Then make a send_email function inside controller file.

Controller

  public function send_email($id)

  {

    $leave = $this->one_model->get('table', $id);

    $staff = $this->one_model->get('staff', $leave->created_by);

    $approver = $this->one_model->get('staff', $staff->leave_approver_id);

    $organization = $this->one_model->get('organizations', $leave->org_id);

    $apply_date = date_create($leave->created_at);

    $apply_date = date_format($apply_date, DATE_FORMAT);

    $date_start = date_create($leave->date_start);

    $date_start = date_format($date_start, DATE_FORMAT);

    $date_end = date_create($leave->date_end);

    $date_end = date_format($date_end, DATE_FORMAT);

    // construct msg - with invoice link inside

    $message = '

Permohonan cuti diterima seperti berikut:

Pemohon Cuti: '.$staff->name.'

Tarikh Permohonan: '.$apply_date.'

Tarikh Mula: '.$date_start.'

Tarikh Akhir: '.$date_end.'

Jumlah Hari: '.$leave->total_day.'

Sebab: '.$leave->reason.'

Untuk memberi maklum balas sila ke localhost/smap/lu/'.$leave->secure_id.'

Terima kasih';

    $this->load->library('mailgun');

    $this->mailgun->from("$organization->name<postmaster@mg.smap.my>");

    $this->mailgun->reply_to($organization->email);

    $this->mailgun->to($approver->email);

    $this->mailgun->bcc('hello@smap.my');

    $this->mailgun->subject("Permohonan Cuti ($staff->name)");

    $this->mailgun->message($message);

    $this->mailgun->send();

  }

Controller process

    $id = $post['id'];

    $this->send_email($id);

CodeIgniter How to make filter function

How to make filter function in PHP.

View

For view, first make the dropdown list and filter button.

<?php echo form_open(''); ?>

<table width="100%">

<tr>

<td align="right">

<?php echo form_dropdown('name', $array_list, $selected_array, 'class="form-control input-inline input-small"'); ?>

<input type="submit" value="<?php echo lang('lbl_filter'); ?>" class="btn btn-primary" />

</td>

</tr>

</table>

<?php echo form_close(); ?>

'name' = data name that will to represent the data and be used to call in controller.

$array_list = data that you want to display inside the dropdown.

$selected_array = array that you have select to filter.

Controller list

$data = array();

      $data['selected_array'] = '';

  

      if ($post = $this->input->post()) {

        $post = $post = $this->input->post();

        $data_name = $post['name']; //data name that hv been set in view

  

        if (!empty($name)) {

          $this->db->where("column in table = $data_name");

          $data['selected_array'] = $data_name;

        }

      }

This controller is used to set the filter function.