insert a filename in db not array in CakePHP when uploading

Question

I am using CakePHP 2.1 and trying to upload files into server.

I can successfully move the files to specified directory with manually naming a file, but its not taking the name from the file type from view: register.

Database table: users

Id Auto_Increment
username
file_name

Controller : UsersController.php

public function register(){
    if ($this->request->is('post')){
        //   $this->data['User']['resume_file']['tmp_name'] = 'test.php';
        //  The above statement is working good

        if ($this->User->save($this->request->data)){
            $this->Session->setFlash('Message : ' . $this->data['User']['resume_file']['tmp_name']);
            //debug($this->data['User']['resume_file']['tmp_name']);

            // This is giving an error, while inserting
        }
    }
}

View : users/register.php

<?php
    echo $this->Form->create('User', array('type'=>'file'));
    echo $this->Form->input('username');
    echo $this->Form->input('file_name', array('type'=>'file', 'label'=>'Upload document') );
    echo $this->Form->end('Register');
?>

Error : Database error

INSERT INTO `sample_db`.`users` (`file_name`, `created`) VALUES (Array, '2012-06-14 08:10:10')

What i seen is that, while insert into table, Array is inserted thats and error Array to string conversion error in CakePHP now how can i get the value of that input type : file_name in CakePHP

Or else if we can modify the data before saving with the below request statement..

$this->request->data

I tried to change that, with below statement

$this->data['User']['resume_file']['tmp_name'] = 'test.php';

but couldn't its returning same error, any idea...

shadyyx · Accepted Answer · 2013-09-20 07:40:38Z

3

Try this:

public function register(){
    if ($this->request->is('post')){
        $filename = $this->request->data['User']['file_name']['tmp_name'];
        $this->data['User']['file_name'] = $filename;

        if ($this->User->save($this->request->data)){
            $this->Session->setFlash('Message : ' . $filename);
        }
    }
}

edited Sep 20, 2013 at 7:40

answered Jun 14, 2012 at 8:37

shadyyx

16.1k7 gold badges62 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Rafee Over a year ago

Its still gives the same error (file_name, created) VALUES (Array, '2012-06-14 08:10:10') and Notice

Indirect modification of overloaded property UsersController::$data has no effect [APP\Controller\UsersController.php, line 39]

Rafee Over a year ago

I had edited you answer with commented statement, that is perfectly good.. but it taking the temporary value like D:\xampp\tmp\php5500.tmp how can i retrieve the original filename..

shadyyx Over a year ago

@Rafee: Instead of ['tmp_name'] use ['name']. You are welcome!

Rafee Over a year ago

okay any idea, how to get extension of file stackoverflow.com/questions/11031567/…

Rajnikanth Over a year ago

it works for me with some changes. $this->request->data instead of $this->data

Collectives™ on Stack Overflow

insert a filename in db not array in CakePHP when uploading

Database table: users

Controller : UsersController.php

View : users/register.php

Error : Database error

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

Database table: users

Controller : UsersController.php

View : users/register.php

Error : Database error

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related