• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Trying to put info from files into database

#1
Hi there,

I am trying to scan through a specific folder (which will have images in) and for each one get the information and add them into a database.  These files will already be uploaded onto the server so this is to be able to rebuild the information in the table.

PHP Code:
$this->db->truncate('gallery_images');

 
   $this->load->library('upload');
 
   $files scandir(base_url().'public/images/gallery/');
 
   foreach($files as $file) {
 
       $this->upload->do_upload($file);
 
       $this->session->set_flashdata('success_message'$this->upload->data('file_name'));
 
       $data = array( 
 
           'category' => 'uncategorised',
 
           'image_name' => $this->upload->data('file_name'),
 
           'alt' => $this->upload->data('file_name'),
 
           'full_path' => $this->upload->data('full_path'),
 
           'image_width' => $this->upload->data('image_width'),
 
           'image_height' => $this->upload->data('image_height')
 
       );
 
       $this->add_content($data'gallery_images');

 
   }

 
   redirect('admin/gallery/gallery_images'); 

I have tested it and I know that it's not finding any files but I don't know why.

Thanks,

Doomie22
Reply

#2
You cannot use the upload library for files that are already on the server.
You need to use the the directory helper to load the folder's file into an array.
The file helper will give you some the information you want but I don't think you can get the image size, so you would need to use raw PHP or there maybe a library available but that I don't know.
A good decision is based on knowledge and not on numbers. - Plato

Reply

#3
ok atm I am not too bothered about the width and height then.  I have tried the following but I am getting an "Invalid argument supplied for foreach()"


PHP Code:
$this->db->truncate('gallery_images');

 
   $this->load->helper('directory');
 
   $this->load->helper('file');
 
   
    $files 
directory_map(base_url().'public/images/gallery/');
 
   
    foreach
($files as $file) {
 
       
        $get_info 
get_file_info($file);
 
       
        $data 
= array( 
 
           'category' => 'uncategorised',
 
           'image_name' => $get_info['name'],
 
           'alt' => $get_info['name'],
 
           'full_path' => $get_info['server_path'],
 
           'image_width' => '800',
 
           'image_height' => '600'
 
       );
 
       $this->add_content($data'gallery_images');

 
   }
 
   $this->session->set_flashdata('success_message''Gallery Reloaded');
 
   redirect('admin/gallery/gallery_images'); 
Reply

#4
You don't need / should not have base_url in the path as this gives you a url (http://domain.ext/yourpath)
You need a physical path.
Per the documentation: Paths are almost always relative to your main index.php file.
So you should call

PHP Code:
$files directory_map('./public/images/gallery/');
// in public is where your index.php file is then 
$files directory_map('./images/gallery/'); 
If you still have an error do a var_dump or print_r of $files to see the content
A good decision is based on knowledge and not on numbers. - Plato

Reply

#5
I am seeing the files in the array but for some reason I am just getting null from this.

PHP Code:
$get_info get_file_info($file); 
Reply

#6
Does $file contain the the path or just the file name ?
Get_file_info need the path as well as the file name.
You might be better of using just the file helper.


PHP Code:
$this->load->helper('file');
 
   
    $files 
get_filenames('./images/gallery/',TRUE); //TRUE to include the path with the file name
 
   
    foreach
($files as $file) {
 
       
        $get_info 
get_file_info($file);
 
       
        $data 
= array( 
 
           'category' => 'uncategorised',
 
           'image_name' => $get_info['name'],
 
           'alt' => $get_info['name'],
 
           'full_path' => $get_info['server_path'],
 
           'image_width' => '800',
 
           'image_height' => '600'
 
       );
 
       $this->add_content($data'gallery_images'); 

But I am not sure if this will include sub-folder. you will need to do a var_dump be sure.
Have a look at the helpers documentation to see what is available.
A good decision is based on knowledge and not on numbers. - Plato

Reply

#7
Maybe this will help, not CI but works.

Read: 3. Recursive Directory Listing

The Art of Web
What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.