Friday, January 4, 2013

Re: Save Uploaded/Parsed File to Database Table

Thank you for such a quick response, and yes I can not get the file to save in my database. Now to answer some of your questions...yes Coverage can only have one spreadsheet, and yes my spreadsheet table has a coverage_id field. With that said, I added 

die(debug(uploadedFile)); 
$CoverageId = $this->id;

and this is what I see in the view 

Array  (      [name] => SLT.xls      [type] => application/vnd.ms-excel      [tmp_name] => /tmp/phpH03DuW      [error] => 0      [size] => 36352  )

All I need from this array is the file name. Now with that said, I read alot of articles online about saving files to a database. Some people think it is better to save to the file system rather than the database. In my case I think the best thing for me to do is save the file in my db. My only question is "If I save the files to my database will it affect the performance of my website over time?" 

Now as far as my view goes..do I need to add an input for user_id and coverage_id as hidden fields?

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com.
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
 
 

No comments: