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

drop-down with sub-category appear
Hello,

i know how to build a simple dro-down list, im looking for a code when im gonna choose

Solution to the FindControl problem
I have seen may posts about having problems with the FindControl method. Most seem to come about bec

How to display objects in a row
I have 7 codes that i want to display in a row one next to another.
The first is {$ads->ad

Simple email form - Newbie
Hello all,

First time poster!

I've been asked to create a simple HTML form that submit

how to use two buttons with php
hi i have one form. there are three fields which are to be filled by the user. and then there are tw

Pagination won't carry results past page 2.
Hi all,

I've worked out my pagination script and its paginating fine until I click next from

php forms and database navigatio
Hello,
I'm new to php and i'd like to post the following.
I have written code to get records f

unexpected T_VARIABLE error
Hey all! I'm getting an unexpected T_VARIABLE with the following function:

function getHighes

how do i make new line after *
First check this page here. and you see my report. Im pulling form a mysql db. I want to beable to m

[RESOLVED] Socket/Port remains open after app crashes
I'm having this problem with a networked app in vb.net.

If the program exits normally the por