I know your uploading to MySQL, but it might be the php engine that
iss cutting you off.
Check max_upload_size in php.ini, it might be set to 1 MB.
My site's db only uses a Medium blob, and as you can see I have a 1.3
MB file, among others.
1 [BLOB - 23.7 KiB]
1 [BLOB - 715 B]
1 [BLOB - 13.7 KiB]
1 [BLOB - 255.0 KiB]
1 [BLOB - 1.3 MiB]
1 [BLOB - 756.8 KiB]
And here is the sql i used to create the table. I made no other
special settings. you'll notice it is a binary table though
CREATE TABLE `digbiz_project_files` (
`id` int(11) NOT NULL auto_increment,
`project_id` int(11) NOT NULL,
`user_id` bigint(20) NOT NULL,
`name` varchar(75) collate utf8_bin NOT NULL,
`type` varchar(255) collate utf8_bin NOT NULL,
`size` int(11) NOT NULL,
`data` mediumblob NOT NULL,
`created` datetime default NULL,
`modified` datetime default NULL,
PRIMARY KEY (`id`),
KEY `project_id` (`project_id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin
AUTO_INCREMENT=9 ;
How did you come up with the 999kb limit? Are you sure it is not
related to the time (php timing out etc)
How do you move the file from the temporary uploaded location to the
db?
Regards,
Eddie
On Oct 22, 5:38 am, "Da-Omiete Iboroma" <[EMAIL PROTECTED]> wrote:
> Thanks but I am using just that. But it cannot upload any file that
> is more than 999kb.
>
> Is there any configuration that I will do to phpmyadmin so that it can
> upload files that are more than 999kb?
>
> Thanks
>
> On 10/21/08, Thanga Durai <[EMAIL PROTECTED]> wrote:
>
>
>
> > If you are using blob data type make it as longblob.
>
> > Thangadurai.
>
> > On Tue, Oct 21, 2008 at 4:57 PM, AD7six <[EMAIL PROTECTED]> wrote:
>
> >> On Oct 20, 3:41 pm, "Da-Omiete Iboroma" <[EMAIL PROTECTED]> wrote:
> >> > Please I am having problem downloading pdf (Acrobat reader) files that
> >> > I uploaded in mysql database.
>
> >> > The file downloads but it does not embed the pdf file in the browser.
>
> >> > Instead, it opens the pdf file and make the current page blank
>
> >> > Below is the file download code. Pls help me
>
> >> > <?php
> >> > $db_name = "database_name";
> >> > $table_name = "books_table";
> >> > $connection = mysql_connect("localhost", "username", "password") or
> >> > die("couldn't connect.");
>
> >> As this has nothing to do with using CakePHP, thread closed.
>
> >> Cheers,
>
> >> AD- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
