1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
|
<?php
set_time_limit(0);
mysql_connect("localhost", "root", "") or
die("Could not connect: " . mysql_error());
mysql_select_db("scolarite00");
$res_t1 = mysql_query("SELECT code1, code2 FROM t1");
while ($line= mysql_fetch_array($res_t1))
{
$code1_t1=$line['code1'];
$code2_t1=$line['code2'] ;
//table det_tizi
$res_t2= mysql_query("SELECT * FROM t2");
while ($line2 = mysql_fetch_array($res_t2))
{
$code1_t2=$line2['code1'];
$code2_t2=$line2['code2'] ;
$nom_t2=$line2['nom'];
$pnom_t2=$line2['prenom'];
$adr_t2=$line2['adr'];
mysql_free_result($res_t2);
if ('$code1_t1'!= '$code1_t2' AND '$code2_t1'!='$code2_t2' )
//l'insertion
{
$sql = "INSERT INTO t1 VALUES ('$code1_t2' ,'$code2_t2', '$nom_t2', '$pnom_t2', '$adr_t2')";
mysql_query($sql)
or die('Erreur SQL !'.$sql.'
'.mysql_error());
}
}
}
mysql_close();
?> |
Partager