I'm trying to fetch data and an image from a database after saving them. The data and the image are saved correctly, but when I try to read them, an error occurs. I can't solve the problem.
My views are:
view1 is Upload_form.php
:
<html>
<head>
<title>Upload Form</title>
</head>
<body>
<?php echo $error;?>
<?php echo form_open_multipart('upload/do_upload');?>
<form action = "" method = "">
<input type = "text" name = "title" />
<br /><br />
<input type = "file" name = "userfile" size = "20" />
<br /><br />
<input type = "submit" value = "upload" name="file_name"/>
</form>
</body>
</html>
view2 is Upload_success.php
:
<html>
<head>
<title>Upload Form</title>
</head>
<body>
<h3>Your file was successfully uploaded!</h3>
<?php foreach ($image as $item) { ?>
<P> <?php echo $item['title']; ?> </P>
<img src="<?php echo base_url().'uploads/'. $item['image']; ?>">
<?php } ?>
<ul>
<?php foreach ($upload_data as $item => $value) { ?>
<li><?php echo $item;?>: <?php echo $value;?></li>
<?php } ?>
</ul>
<p><?php echo anchor('upload', 'Upload Another File!'); ?></p>
</body>
</html>
I think the error is in the else
statement. Please check it out.
Controller's name is upload.php
:
<?php
class Upload extends CI_Controller
{
public function __construct() {
parent::__construct();
$this->load->model('model','m');
$this->load->helper(array('form', 'url'));
}
public function index() {
$this->load->view('upload_form', array('error' => ' ' ));
}
public function do_upload()
{
$config['upload_path'] = './uploads/';
$config['allowed_types'] = 'gif|jpg|png';
$config['max_size'] = 100;
$config['max_width'] = 1024;
$config['max_height'] = 768;
$this->load->library('upload', $config);
if ( ! $this->upload->do_upload('userfile'))
{
$error = array('error' => $this->upload->display_errors());
$this->load->view('upload_form', $error);
}
else
{
$this->m->insertdata();
$data = array('upload_data' => $this->upload->data());
$this->load->view('upload_success', $data);
}
}
}
Model's name is model.php
:
<?php
class model extends CI_Model
{
function __construct()
{
parent::__construct();
$this->load->database();
}
public function insertdata()
{
$upload_data = $this->upload->data();
$data = array(
'name' => $this->input->post('title'),
'image' => $upload_data['file_name'],
);
$this->db->insert('image', $data);
$id= $this->db->insert_id();
$this->db->select('*');
$this->db->from('image');
$this->db->where('id', $id);
$d = $this->db->get();
return $d->result();
}
}