how to insert 31103 rows of an array into mysql data base ?

hi

i am trying to insert 31103 row of array into mysql data base

but every time i check the inserted data its not complete in the last try i get 8955 rows of 31103

so what is the right way to do this ?

 

You should insert data in parts.
You can use for it Ajax

 

It might just be a script timeout.
If there is no error in your query, increase max_execution_time.

 

i don't use ajax but i use the for function to insert data row by row

 

Have you tested to timeout protect your loop?
for (....) {
// lots of stuff
set_time_limit(120);
}

 

thanks for the code but still the same problem

i think php is working faster that the mysql server because i lose separate rows from the middle of the array

is there any way to make php wait the mysql server

 

Can I suggest you turn error reporting ON

error_reporting(E_ALL);

PHP:

so you know the exact cause of the in-completed task, it may not be time related.

If your convinced its time related, then post your foreach statement code, for better advice. Also bare in mind set_time_limit(); wont work if php safe_mode is on, so check that out from your php configuration.