php script / Cron

[rob_illinois]

I need to write a script that grabs a file from a folder and uploads it to a mysql db. I have a website hosted by a third party and they have a 2meg cap on there server for uploads, I had made a script in a html page that allowed me to upload the file manually and this worked fine but now the new text file is over 4megs and the server will not allow this. When I uploaded the file before how it works is it deletes current data and reaplces with the info in the new text file. I can not split the file. I really need to get it to work so I thought about a php.ini with a maxfile string in the same dir as the script but no dice. Someone please help.

Any questions at all shoot.

Thanks

[superwormy]

Umm... maybe I misunderstood, but if you can't upload more than 2 megs at a time, and you can't split the 4 meg file... then you just plain can't upload it.

A PHP/Cron script isn't going to help you there.

Maybe the question you need to ask yourself is WHY you can't split it, or send it peice by piece ( if its records, maybe something like SOAP woudl help, send record by record over HTTP... )

[rob_illinois]

The size limit is only for webpages/scripts. but if i run it local and right on the ftp server then it does not apply to the limit and will work. This is from the server people at the hosting company.

[Kudose]

Ok...assuming I read that all correctly:

You do not need Cron Jobs. You Will need to create a script that will break down your file and then execute the proper queries to insert into the database.

You will then upload that file, and whatever file you have been uploading via your website, via FTP.

Then execute the script in the browser. I would recommend having the execution page password protected and allow user input for the files names. So you can upload 50 files, then enter 50 names and execute the command all at once.

Hope that helps and makes sense.

🙂

[rob_illinois]

I have a script now that allows me to upload the file via a web browser but the file size is over 4meg and the server limit through browsers is 2meg so It will not work. I can not split the file due to the php script that deletes the sql db and replaces it with the new information from the text file. If I split it then I only get half the info. I wanted to do it where the text file was on the server in the same folder as a php script and do a cron job that would execute it every 12 days. Unless you know of a better way, I am open to ideas.

Thanks