The Bakery Everything CakePHP

Thanks for sharing. I hate to be a bitch, but do you think you could clean up your code before posting it? Completing the php doc, removing outcommmented code and debugs and private comments shouldnt take that long :)

Also your example could be clearer. If the point is that you use html->link with the file value of the database then this should be more empathised. You suggest doing a find all for all images even if you just need one? If you just need the file field, why do you ask for the blob?

I have made some changes to your code, including implementing file hashing instead of the old method of file naming. I also made the code cakePHP friendly. I am still working on this to make it better, I hope this helps someone.

This should work with any model you want to name it, however I decided to call it images for brevity:

Sql Table:


CREATE TABLE `images` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(75) NOT NULL default '',
  `clean_name` varchar(75) NOT NULL default '',
  `type` varchar(255) NOT NULL default '',
  `size` int(11) NOT NULL default '0',
  `data` longblob NOT NULL,
  `filehash` varchar(255) NOT NULL default '',
  `ext` varchar(255) NOT NULL default '',
  `created` datetime default NULL,
  `updated` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;


<?php 
/**
 * ImageBehavior - To help with image CRUD
 * @author Grzegorz Pawlik 1.0
 * @author Travis Rowland (Theaxiom) 1.2
 * @version 1.2
 */
class ImageBehavior extends ModelBehavior {
    
    var $_defaults = array(
        'cache_dir' => 'filecache', 'use_cache' => true, 'file_input' => 'File', 'tmp_name' => 'tmp_name', 'model_name' => 'Image', 'file' => 'file',
        'ext_field' => 'ext', 'filehash_field' => 'filehash', 'name_field' => 'name', 'data_field' => 'data', 'clean_name_field' => 'clean_name'
    );
    
    function setup(&$Model, $config = array()) {
        if (!is_array($config)) {
            $config = array('type' => $config);
        }
        $settings = array_merge($this->_defaults, $config);
        $this->settings[$Model->alias] = $settings;
    }

    function beforeSave(&$Model) {
        extract($this->settings[$Model->alias]);
        if(isset($Model->data[$Model->alias][$file_input][$tmp_name]) && is_uploaded_file($Model->data[$Model->alias][$file_input][$tmp_name])) {
            $Model->data[$Model->alias] = array_merge($Model->data[$Model->alias],  $Model->data[$Model->alias][$file_input]);
            App::import('Core', 'File');
            $file = new File($Model->data[$Model->alias][$tmp_name], false);
            $Model->data[$Model->alias][$data_field] = addslashes( $file->read() );
            $Model->data[$Model->alias][$filehash_field] = md5($Model->data[$Model->alias][$name_field] . $Model->data[$Model->alias][$data_field]);
            $file = explode('.', $Model->data[$Model->alias][$name_field]);
            $Model->data[$Model->alias][$ext_field] = array_pop($file);
            $Model->data[$Model->alias][$clean_name_field] = array_pop($file);
        }
        
        return true;
    }

    function afterFind(&$Model, $results, $primary) {
        extract($this->settings[$Model->alias]);
        
        foreach($results as $key => $val) {
            if (isset($val[$model_name])) {
                $relpath = $cache_dir . DS . $val[$model_name][$filehash_field] . '.' . $val[$model_name][$ext_field];
                $fullpath = IMAGES . $relpath;
                
                if(!file_exists($fullpath) || !$use_cache) {
                    file_put_contents($fullpath, stripslashes($results[$key][$model_name][$data_field]));
                }
                
                $results[$key][$model_name][$file] = $relpath;
                unset($results[$key][$model_name][$data_field]);
            }
        }

        return $results;
    }
}
?>

You can now call it from other models recursively (1 level) by adding the following code to the other model:


    var $actsAs = array('Image');

You get the image url from within the other model by requesting the "file" field.

Example view code:


<?php echo $html->image($otherModel['Image']['file'], array('height'=>'100', 'width'=>'100')); ?>

images_controller.php


<?php 
class ImagesController extends AppController {

    var $name = 'Images';
    var $helpers = array('Html', 'Form');
    
    function index() {
        $this->set('images', $this->Image->findAll());
    }
    
    function add() {
        if (!empty($this->data)) {
            $this->Image->create();
            if($this->Image->save($this->data)) {
                $this->Session->setFlash(__('Image upload successful', true));
                $this->redirect(array('action' => 'index'));
            } else {
                $this->Session->setFlash(__('Error on Image upload. Please try again.'));    
            }
        }
    }
    
    function edit($id = null) {
        if (!$id && empty($this->data)) {
            $this->Session->setFlash(__('Invalid Id', true));
            $this->redirect(array('action' => 'index'));
        }
        if (!empty($this->data)) {
            if($this->Image->save($this->data)) {
                $this->Session->setFlash(__('Image upload successful', true));
                $this->redirect(array('action' => 'index'));
            } else {
                $this->Session->setFlash(__('Error on Image upload. Please try again.'));    
            }
        }
        if (empty($this->data)) {
            $this->data = $this->Image->read(null, $id);
        }
    }
}
?>

image model (image.php)


<?php 
class Image extends AppModel {
    var $name = 'Image';
    var $actsAs = array('Image');
}
?>

add/edit.ctp


<?php echo $form->create('Image', array('action' => 'add', 'type' => 'file'));
    echo $form->file('File');
    echo $form->submit('Upload');
echo $form->end(); ?>


see above

Wouldn't it be better to save blobs in separate table? That would also save the problem with quering blobs with every select...

thanks.

Thank you so much, I can't believe I didn't think of that! I was trying to figure out a way to do that, thank you so much you are a life saver. I will modify this behavior and post an update soon. Thanks again!

Wouldn't it be better to save blobs in separate table? That would also save the problem with quering blobs with every select...

thanks.

Thank you so much, I can't believe I didn't think of that! I was trying to figure out a way to do that, thank you so much you are a life saver. I will modify this behavior and post an update soon. Thanks again!
You welcome :)

Of course to be production ready it may need some more polish:
- default image if field is empty
- some kind of size management (max size allowed or resizing or splitting big images)
- different sizes of the same image (as an option)

I will try to work it out some time after Easter, but I am new to Cake so it may take some time...

Thanks for the code.

I haven't set it up before, but PHPThumb has settings that will pull images from a database instead of the file system. It seems like the behavior for loading them in combined with PHPThumb for outputting the image paths directly in img src tags would be a pretty slick combination.

Great Behaviour!
In my setup the "images" model "belongsTo" another model (and the other model "hasOne" image, respectively").

Saving the other model nothing is saved in the images table. Any suggestions ? Does this behaviour work only if the corresponding model is saved directly ($this->Image->save() ) or should function calling associated models too (e.g $this->othermodel->save() )? I'm using the 1.2 version. Thanks !

hey!
great behavior!
had problems in the beginning because it was interfering with some other behaviors...but nevertheless, while bugfixing and testing on windows i discovered that you have to use following short hack to got it running on windows (for the v1.2 of the ImageBehavior):

simply use

$results[$key][$model_name][$file] = str_replace('\\','/', $relpath); //WindowsHack

instead of

$results[$key][$model_name][$file] = $relpath;

I think that the best form of storage would be in the encrypted form on an external peripheral


Cremation Urns

When I have rationalized the realistic way to solve that over time that it starts to blend three years ago. car shipping Yes, it will be evaluated with a presentation.