Insert data to Table!!

why2k

I create php program to insert data from text file to the first table....then I check if data in the first table have in the second table I will delete or not I will Insert...
but when have many data I access from browser I have a problem ..it's time out....
Can tell me to config this problem...by apache..or by php...or mysql config...
Or anyone please tell me any easy way to solve this problem...!
Thank you very much for every answer
-🙂...

bibie

Hi, I'll try to answer your question.
If you've created such migration program, why would you like to see it on the browser ? I have faced this problem before,and I'd like to share my solution. I create a PHP program, but I execute it in command line ( it's much more like a shell scripting ) then I schedule that program to run every amount of determined time. The key is : make that migration program run as background, so you do not need to see its progress on the browser. Time out problem is a matter of web server configuration.
Hope it helps, pal..🙂

why2k

That Right!!!-🙂
It's the best answer that I want to know...
and I want to try it....but I have many questions to ask you..Habibi..:-)
I want to set any thing to run shell script..
and I want example script to use them.......when you set time to execute script
can tell me to config..or edit any file in linux..
...I have many question to know...Can help me?....:-)
Anyone can tell me>>please..

bibie

Well, I'm really sorry about this one, I forgot to mention that I did all of these things under Windows environment. In Windows, I execute PHP program as command line by using this command under DOS prompt : C:>php myprogram.php3. Perhaps there is equivalent command for Linux environment, maybe there is executable file named php in Linux...just check it out (looking for "x" attribute in that file).
Next step is creating batch file that runs php myprogram.php3, and then I schedule the batch file using task scheduler in Windows.
As far as I know, you could schedule your script using cron in Linux, but I don't know much this thing, try its man instead.
Hope this enlighten you, pal...🙂