Aravinthan

EDIT: IGNORE THIS

Ok

After inserting 2476, It sends out: This error....

Or Maybe search for the players using the id instead of name?

Yeah, So, what do you propose? Split it into 2 switch cases? OR 2 different pages?

Maybe split the Update and Insert into 2 different pages?

OK I searched the DB, and his id is 902... Doesnt make any sens. I put a id field, with an auto_incriment feautre.... So it is supposed to go one by one..... Any idea why it might be messing up? EDIT: I think I might know why, there is 3 or 4 Sean Collins, but like the code Updates, when there is already one, it doesnt insert the other ones.... Man this is annoying.... Any way to work around it?

Hi, The data seems to be well inserted, But there is still 4 players in the middle that doesnt get inserted. The 2476 gets inserted, but not the 2477.... And it inserts the 2478 right after 2476....

OK si I change: $field_data = explode(' ', $line_data); To: $line_data = str_replace(' ',' ',$line_data); $line_data = str_replace(' ',' ',$line_data); $field_data = explode(' ', $line_data); But the first data of each line seems to not be inserting....

AHHHHHH... I know why, because as you see, we split it be 2 spaces: But here: Only 1.... Is there a way to fix this? Because there might be other players who have the same problem....

And I also found out what case it didnt enter. Line 11: goal_streak, point_streak, total_gp, suspended_games, training, weight, height, status_in_organisanization. -32 -5 32 0 1 195 8 4 But the -5, doesnt get inserted into the point_streak, instead, its the the 32 which takes his place..... So everything else just snowballs from there....

Man what is with me and bad news? Anyways, I tought it did well, until I saw that there was 4 datas missing. Yeah, there is supossed to be 3500 and there is only 3496. And it is not at the end, but somewhere in the middle. I managed to find, where one of data has not been inserted. THe data, with id 2476 has been inserted. But the datas 2477, has been skipped... And it inserted the player 2478 instead... Any idea why? Thanks for your help, And sorry for keep closing and re-opening this thread, Ara

Thank you sooooooo much!!! It works!!!!

Whats sleep(15) ? Well changed it to 100, and it inserted 734 datas....

Hi, it inserted 583 Data and it says: Cannot inset/update table!MySQL server has gone away

Ok so I change: $all_players_data To 3500, It worked, but it doesnt insert all, there still some missing and I get the MYSQL server gone error.... Now I am playing with the 3500 and MaxChunk number without any result...

Forgot to mention. Line 141 is: $Chunks = ceil(count($all_players_data / $MaxChunk));

You lost me there... Lol OK so this is what it gives me: // split every 20 lines into a new array $all_players_data = array_chunk($players_data_file, 20); //Calculate Number of chuncks $MaxChunk = 500; $Chunks = ceil(count($all_players_data / $MaxChunk)); //Break into chunks $chunk_all_players_data = array_chunk($all_players_data, $Chunks, true); //Loop through each chunk foreach($chunk_all_players_data as $chunk_players_data) { // loop through each block of 20 lines foreach($chunk_players_data as $player_data) //UPDATED { // check to see if the player already exist $player_name = sql_safe($player_data[13]); $user_exists_sql = "SELECT `name` FROM `$player_table_name` WHERE `name`=$player_name "; $result = mysql_query($user_exists_sql) or die('Error checking user!<br />'.mysql_error()); // if the user does not exist, use an INSERT STATEMENT // we'll add the user into the database if(mysql_num_rows($result) == '0') { $sql = "INSERT INTO `$player_table_name` SET "; $update_user = false; } // user does exist so we'll use an UPDATE statement // update the existing user else { $sql = "UPDATE `$player_table_name` SET "; $update_user = true; } // here we're looping through each line foreach($player_data as $line_key => $line_data) { // if we're not on line 8, 9, 10, 13, 14 or 15 // turn line data into an array if(!in_array($line_key, array(7, 8, 9, 12, 13, 14))) { $field_data = explode(' ', $line_data); // match up the data with the field array // this is where our query is generated foreach($field_data as $field_key => $field_value) { if(isset($fields[$line_key][$field_key])) $sql .= "`" . $fields[$line_key][$field_key] . "`=" . sql_safe($field_value) . ', '; } $sql .= "\n"; } // add the whole line into the query else { // if we're updating the user skip line 14 if( $update_user && $line_key == 13) continue; $sql .= "`" . $fields[$line_key][0] . "`=" . sql_safe($line_data) . ", \n"; } } // remove the last three characters from $sql $sql = substr($sql, 0, -3); // add the WHERE clause only if we are updating the user if($update_user) $sql .= " WHERE name=$player_name"; echo '<pre>' . print_r($sql, true) . '</pre>'; mysql_query($sql) or die('Cannot inset/update table!'.mysql_error()); } } Unfortunatley, I get this error:

So I contacted my host, and they told me I should try splitting it... 500 datas and then another 500....

Oh yeah of course!!!! Thanks so much, but like usual another problem -.-

You are right, there is an error: EDIT: I checked teh players file and the name is: So thats why.... I put addslashes() $player_name = addslashes(sql_safe($player_data[13])); But it shows me: Thanks for your help, Ara

Ok, I got a little problem.... It just inserts the first 115.... not the rest.... How come? Thansk for your help, ARa

Edit: Never mind it works now!!! Thanks so much!

UP

Hi wow, thanks but can you tell where and how can I put these?: