String size overflow in PHP

Question

error code : String size overflow code :

     mysql_connect($servername,$username,$password) or die(mysql_error());
mysql_select_db($dbname);

$sql= "INSERT INTO EM (sourceindex, targetindex,source,target) VALUES ";

for($i=0;$i<$combine_arr_size;$i++){
   for($j=0;$j<$combine_arr_size;$j++){
   $sql.="('$i','$j','$combine_words_array[$i]','$combine_words_array[$j]'),";
 }
}
mysql_query(substr($sql,0,-1));

combine_arr_size is almost 379200,I found a solution is maximum memory_limit setting , is any other choice or code changing ?

String size overflow code You have a string bigger than 2GB?!? What are you trying to do? I think you want to make some splits in your insert query, so that you won't go over 2GB for a string?!? — Rizier123
– Rizier123, Commented Apr 10, 2015 at 6:46

Rahul Gahlot · Accepted Answer · 2015-04-10 06:53:50Z

1

Insert data one by one by executing insertion code in loop, and extend maximum execution time of file.

for($i=0;$i<$combine_arr_size;$i++){
   for($j=0;$j<$combine_arr_size;$j++){
   $sql="INSERT INTO EM (sourceindex, targetindex,source,target) VALUES ('$i','$j','$combine_words_array[$i]','$combine_words_array[$j]')";
 mysql_query($sql);
}
}

answered Apr 10, 2015 at 6:53

Rahul Gahlot

682 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Rizier123 Over a year ago

Well maybe to run +/- half a million querys may take a while, OP could simply split it into groups of e.g. 100 sets or so

Rahul Gahlot Over a year ago

Sorry I am not getting you.

Rizier123 Over a year ago

Well now an explanation why OP's method didn't worked would be nice.

Collectives™ on Stack Overflow

String size overflow in PHP

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related