Heavy loadtime when putting arrays into a mysql DB

stormblast

$article, $price and $count are arrays with the same amount of items.

count($article) -> result: 3 (correct)

However, the page loads for an endless time but nothing happens.. if I remove the following code everything works fine.. what am I doing wrong? Thanks!

$asd = count($article);

 for ($i=1; i<=$asd; $i++){
$sqla = @mysql_query("INSERT INTO warenkorb SET wk_email='".$email."', wk_artikel='".$article[$i]."', wk_preis='".$price[$i]."', wk_anzahl='".$count[$i]."', wk_versand='".$versand."', wk_sum='".$sum."");
}

sfullman

it looks like it should run.

I suggest you print the size of the three arrays to verify that (though this wouldn't affect the query), then add:

echo "$i: ".time()." <br>";
in the loop to see where things are hanging.

Also remove the @ so you can see any warnings generated.

HTH.
Sam

stormblast

Changed:

 for ($i=1; i<=count($article); $i++){
$sqla = mysql_query("INSERT INTO warenkorb SET wk_email='".$email."', wk_artikel='".$article[$i]."', wk_preis='".$price[$i]."', wk_anzahl='".$count[$i]."', wk_versand='".$versand."', wk_sum='".$sum."");
echo "$i: ".time()." <br>"; 
}

count($article) still results in 3.

I'm clueless :/

I get an endless result like that:

.....
136: 1100797989
137: 1100797989
138: 1100797989
139: 1100797989
140: 1100797989
141: 1100797989
142: 1100797989
143: 1100797989
144: 1100797989
145: 1100797989
146: 1100797989
147: 1100797989
148: 1100797989
149: 1100797989
150: 1100797989
151: 1100797989
152: 1100797989
153: 1100797989
154: 1100797989
155: 1100797989
156: 1100797989
157: 1100797989
158: 1100797989
159: 1100797989
160: 1100797990
161: 1100797990
162: 1100797990
163: 1100797990
164: 1100797990
165: 1100797990
166: 1100797990
167: 1100797990
168: 1100797990
169: 1100797990
170: 1100797990
171: 1100797990
172: 1100797990
173: 1100797990
174: 1100797990
175: 1100797990
176: 1100797990
177: 1100797990
178: 1100797990
179: 1100797990
180: 1100797990
181: 1100797990
182: 1100797990
183: 1100797990
184: 1100797990
185: 1100797990
186: 1100797990
187: 1100797990
188: 1100797990
189: 1100797990
190: 1100797990
191: 1100797990
192: 1100797990
193: 1100797990
194: 1100797990
195: 1100797990
196: 1100797990
197: 1100797990
198: 1100797990
199: 1100797990
...

sfullman

are you showing me all the code? i.e. is htere more in the loop you're not showing me? the for() looks fine, check your i value before and after.

for ($i=1; i<=count($article); $i++){
echo "start i at $i<br>";

// your operations here, whatever

echo "end i at $i<br>";
}

OR, your count($article) value is changing.. keep working at it.

stormblast

Yes I'm showing you the complete for() code.

New try:

$asd = count($article);
echo "count value: $asd<br>";

 for ($i=1; i<=$asd; $i++){
 echo "start i at $i<br>"; 
$sqla = mysql_query("INSERT INTO warenkorb SET wk_email='".$email."', wk_artikel='".$article[$i]."', wk_preis='".$price[$i]."', wk_anzahl='".$count[$i]."', wk_versand='".$versand."', wk_sum='".$sum."");
echo "end i at $i<br>"; 
echo "$i: ".time()." <br>"; 
}

Result:

count value: 2
start i at 1
end i at 1
1: 1100798901
start i at 2
end i at 2
2: 1100798901
start i at 3
end i at 3
3: 1100798901
start i at 4
end i at 4
4: 1100798901
start i at 5
end i at 5
5: 1100798901
start i at 6
end i at 6
6: 1100798901
start i at 7
end i at 7
7: 1100798901
start i at 8
end i at 8
8: 1100798901
start i at 9
end i at 9
9: 1100798901
start i at 10
end i at 10
10: 1100798901
...

I really don't get it. $i isn't used anywhere else.

I'm using PHP/4.3.8-9. Is that a prob?