Re: [PHP-DB] php.ini Question
On Friday 24 May 2002 20:35, Daz wrote: > Hi > > could anyone point me in the right direction please?? Yes, but there's no need to post twice. > I needed to use php to upload some large files into mysql and reading > through previous posts saw that the php.ini file has a default entry > limit of 2M... this explained why small files were ok but not large > ones... > > OK.. but I didnt have a php.ini... hence I downloaded the lastest php > and used the 4.2.1 "php.ini-dist" file renaming it to the "php.ini" > and putting it in usr/local/bin as listed in "phpinfo()" > > I changed the min file upload limit to 1000M setting and rebooted the > machine.. I hope you mean the max file upload limit. > Since then "phpinfo()" says the default php.ini file is just > /php.ini and also worse is that all my forms no longer work! basic > variables are not being passed across... Most likely it's because you have: register_globals = Off > I also read that this can be caused by a setting in the php.ini > file.. but which one? Best way to find out is to go through the whole php.ini file. Have the manual handy so you can refer to what settings does what. > Also is there a limit on the file size I can upload?? I noticed that > there is also a limit in the php.ini file on the amount of data > "post" can handle.. is this a concern?? Probably, if you find that you're still hitting a limit then increase "post_max_size" as well. Also for older versions of php file uploads are stored in memory and are not written to disk until the whole file has been transferred. Thus you may find that you need to increase "memory_limit" as well. -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* "There... I've run rings 'round you logically" -- Monty Python's Flying Circus */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] php.ini Question
First, I would recommend that you not try to load files directly into MySQL. rather, upload the file to a directory with full permissions and just insert the link to the file into your database. I do this for several clients and have found it to work very efficiently, even to uploading huge graphics. On Friday, May 24, 2002, at 07:35 AM, Daz wrote: > Hi > > could anyone point me in the right direction please?? > > I needed to use php to upload some large files into mysql and reading > through previous posts saw that the php.ini file has a default entry > limit of 2M... this explained why small files were ok but not large > ones... > > OK.. but I didnt have a php.ini... hence I downloaded the lastest php > and used the 4.2.1 "php.ini-dist" file renaming it to the "php.ini" and > putting it in usr/local/bin as listed in "phpinfo()" > > I changed the min file upload limit to 1000M setting and rebooted the > machine.. > > Since then "phpinfo()" says the default php.ini file is just /php.ini > and also worse is that all my forms no longer work! basic variables are > not being passed across... > > I also read that this can be caused by a setting in the php.ini file.. > but which one? > > Also is there a limit on the file size I can upload?? I noticed that > there is also a limit in the php.ini file on the amount of data "post" > can handle.. is this a concern?? > > Setup: "OSX Server 10.1.4, PHP 4.2.1, Mysql 3.23.46" > > Cheers for any advice! > > Daz > Terry Romine Web Developer JumpInteractive.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php