Insert to MySQL inside foreach

Posted on 16th Feb 2014 07:03 pm by admin

Hey.
I am parsing some html, and putting inside an html db.
I need to create a randomized integer to be a unique identifier, and i chose just to use time().

But I foreach the results, and inside here i do the inserting.
But when i call time() in foreach, it'll be the same for every entry parsed.

foreach code:
Code: foreach($linjerMatches[1] as $k=>$v) {
echo $fylke." <b>".$linjerMatches[1][$k]."</b> ".time()."<br />";

//$sql = "INSERT INTO ruteinfo_linjer(fylke,identifier,linje) VALUES('".$fylke."', '".time()."', '".$linjerMatches[1][$k]."')";
//$result = mysql_query($sql, $linkID) or die("Error");
}
time() will output the same for every row. How can i fix that?

Your Answer:

Login to answer

Other forums

preg-match with a string and numbers
Hi, I can't get the expression to work for my preg_match, what I'd like is for it to match the strin

Posting to another Site?
I have software that people install.
When they install it, is there a way to make it post their d

Quick Syntax Question
Hi folks,

I'm getting the following error: "unexpected T_LNUMBER". I'm trying to b

Onclick problem in Firefox
Hi,
I am using a . It doesn't seem to

Problem with an browser game.
Hello,i just joined that great forum and i got php prob,its kinda freaky...anyway i got browser game

Hom to make one url to open together with another url
I have a chat, which i want to be opened, as soon as the users login to the site. As it is now, when

Local file browser with php
Halo..

So this is what i want to create. I have a folder that i share and it has many movies.

dinamic "textboxes"?
Ey all, my first post here, i hope its not a hard one

I display mysql results in a table

EU VAT Package 2010
Does any one know whether SAP will be developing new reporting functionality due the new VAT rules t

IS this code correct
The reason i ask is everything underneath it appears to be alink as well, tis blimmin annoying