Storing images in database using active record

[eluser]jppi_Stu[/eluser]
What about Base64-encoding the image data before storing it and decoding it when you retrieve it?

Code:

$book = array(
            'title' => $this->input->post( 'title' ),
            'cover' => base64_encode($cover)
);

Then your data won't need any escaping. This will increase storage requirements and would presumably decrease performance, but those may not be the most critical considerations if you really need to store images directly in the database.

(In general, I find it disappointing when someone asks how to accomplish something and others only tell them not to do it at all, without having any knowledge about the reasons behind the original inquiry. If it's a bad idea, go ahead and say so, but provide an answer too. Sometimes the bad idea is the lesser of evils.)