How to use blob in codeigniter?

@daisha 

To use Blob in CodeIgniter, you can follow these steps:

1. Load the database library in your controller or model:

1

$this->load->database();

1. Create a table in your database with a column of type BLOB to store the Blob data.
2. Convert your file data into a Blob object before storing it in the database. You can use the file_get_contents() function to read the file contents and then use base64_encode() to encode it into a Blob object.

1
2

$fileData = file_get_contents('path/to/file');
$blobData = base64_encode($fileData);

1. Insert the Blob data into the database using the CodeIgniter's query builder:

1
2
3
4
5

$data = array(
    'blob_column' => $blobData
);

$this->db->insert('table_name', $data);

1. Retrieve the Blob data from the database by querying the table:

1
2
3
4
5

$query = $this->db->get('table_name');
$result = $query->row();

$blobData = $result->blob_column;
$fileData = base64_decode($blobData);

1. Finally, write the Blob data to a file:

1

file_put_contents('path/to/new_file', $fileData);

Note: Replace path/to/file and path/to/new_file with actual paths to your file.

That's it! You have successfully used Blob in CodeIgniter.