Welcome Guest, Not a member yet? Register   Sign In
Solved: insert pic
#1

(This post was last modified: 04-28-2018, 08:42 AM by davy_yg.)

Hello,

I am trying to insert pic file name into the database.  How to do that?


controllers/upload_image.php


PHP Code:
 public function do_upload()
        {
                $config['upload_path']          './uploads/';
                $config['allowed_types']        'gif|jpg|png';
                $config['max_size']             100;
                $config['max_width']            500;
                $config['max_height']           400;

                $this->load->library('upload'$config);
                $this->load->model('mphoto');

                if ( ! $this->upload->do_upload('userfile'))
                {
                        $error = array('error' => $this->upload->display_errors());

                        $this->load->view('upload'$error);
                }
                else
                {
                        $data = array('upload_data' => $this->upload->data());

                        $this->mphoto->insert_pic();

                        $this->load->view('upload_success'$data);
                }
        




models/mphoto.php

PHP Code:
    class pic_model extends CI_Model {

        public $title;
        public $content;
        public $date;

        public function get_last_two_entries()
        {
                $query $this->db->get('photos'2);
                return $query->result();
        }

        public function insert_pic()
        {
                $this->pic_name    $_FILE['userfile']; // please read the below note
                
                $this
->db->insert('photos'$this);         
        } 
       

I am not sure if this is correct: 
PHP Code:
$this->pic_name    $_FILE['userfile']; 

I simply want to capture the file name.
" If I looks more intelligence please increase my reputation."
Reply
#2

Read the User Guide!

PHP Code:
// full_path gives you the path and file name
$this->pic_name $this->upload->data('full_path'); 


Upload Data
What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )
Reply
#3

I wonder why I cannot load the model:

An uncaught Exception was encountered

Type: RuntimeException

Message: C:\xampp\htdocs\ci_upload_image\application\models/Mphoto.php exists, but doesn't declare class Mphoto

Filename: C:\xampp\htdocs\ci_upload_image\system\core\Loader.php

Line Number: 340

Backtrace:

File: C:\xampp\htdocs\ci_upload_image\application\controllers\upload_image.php
Line: 13
Function: model

File: C:\xampp\htdocs\ci_upload_image\index.php
Line: 315
Function: require_once
" If I looks more intelligence please increase my reputation."
Reply
#4

When I am trying to get the filename value from the model it is null.


A Database Error Occurred

Error Number: 1048

Column 'pic_name' cannot be null

INSERT INTO `photos` (`pic_name`) VALUES (NULL)

Filename: C:/xampp/htdocs/ci_upload_image/system/database/DB_driver.php

Line Number: 691

mphoto.php

public function insert_pic()
{

$this->pic_name = $this->upload->data('filename');

$this->db->insert('photos', $this);
}

cupload_image.php

public function do_upload()
{
$config['upload_path'] = './uploads/';
$config['allowed_types'] = 'gif|jpg|png';
$config['max_size'] = 100;
$config['max_width'] = 500;
$config['max_height'] = 400;

$this->upload->initialize($config);


if ( ! $this->upload->do_upload('userfile'))
{
$error = array('error' => $this->upload->display_errors());

$this->load->view('upload', $error);
}
else
{
$data = array('upload_data' => $this->upload->data());

$this->mphoto->insert_pic();

$this->load->view('upload_success', $data);
}
}
" If I looks more intelligence please increase my reputation."
Reply
#5

Nevermind, I already find the answer to this thread. I think I am going to close it. Thanks!
" If I looks more intelligence please increase my reputation."
Reply




Theme © iAndrew 2016 - Forum software by © MyBB