using for each

[manalnor]

Hello dear friends,

 

Let say we have database table (id,text,code)

 

and text will be added from textarea

 

so i'm going to use the following

 

$text=nl2br($text);  // now per line
$sites=explode("<br />",$text); // now will seprate it

 

and code it just random number

 

srand ((float) microtime() * 10000000);
$random = rand(1, 1000000);
$code = $random;

 

now every line will be add as own entry using the following

 

foreach ($text as $value)
{
$sql = "INSERT INTO $table (text, code) VALUES ('$value', '$code')";
mysql_query($sql, $conn) or die(mysql_error());
}

 

Now each line added as own entry but the problem is all having the same random number generated

 

so how can i apply it for each for both $text and $code

 

 

example explain more

 

if we entered in textarea the following

 

hello world
i love this world

 

the above code will enter it as

 

(hello world,84777)  // 84777 is random code
(i love this world,84777)  // 84777 is the same

 

how then i can explod for both $text and $code so in each entry gets new random number

 

 

thanks.

[manalnor]

problem solved

 

i've found that i must using it after for each so it can gives different random number for each entry....logically

[Psycho]

Do NOT run MySQL queries in loops. Use the foreach loop to create the insert record text and then run one query at the end.

 

$values = array();
foreach ($text as $value)
{
    $code = rand(1, 1000000);
    $values[] = "('$value', '$code')";
}

$sql = "INSERT INTO $table (text, code) VALUES " . implode(', ', $values);
mysql_query($sql, $conn) or die(mysql_error());