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
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
|
<?
// première ébauche de l'application
$titre ="connection to users" ;
//parametre de connexion
$host = "localhost";
$user = "root";
$password = "";
$database = "user";
$conn = mysql_connect($host,$user,$password);
if (!$conn) {
echo "Connection impossible\n";
exit;
}
?>
<html>
<head><title><? echo $titre ; ?></title></head>
<body>
<h1><? echo $titre; ?></h1>
<form action="" method="POST">
date : <input type="text" name="jour" size="2">
/ <input type="text" name="mois" size="2">
/ <input type="text" name="annee" size="4">
<input type="submit" name="go" value="chercher">
</form>
<hr>
<table border="1">
<tr><th>ID</th><th>Login</th><th>Password</th><th>Nom</th><th>Prénom</th><th>Entite</th><th>Mail</th><th>Tel-pro-fix</th> <th>statut</th></tr>
<?
$sql = "SELECT Id, Login, Password, Nom, Prenom, Entite, Mail, Tel, Statut FROM utilisateur";
$a=mysql_select_db($database,$conn);
print_r("coucou",$a);
$result = mysql_query($sql, $conn);
//chaine de connexion pour la deuxieme base
$database1 = "glpi";
$a1=mysql_select_db($database1,$conn);
while($row = mysql_fetch_array($result)) {
// requete:
$sql1 = "INSERT INTO `glpi_users` ( `ID` , `name` , `password` , `password_md5` , `email` , `phone` , `phone2` , `mobile` , `realname` , `firstname` , `location` , `tracking_order` , `language` , `list_limit` , `active` , `comments` , `id_auth` , `auth_method` , `last_login` , `date_mod` , `deleted` )
VALUES (
' ',".$row["Login"].",".$row["Password"].", NULL ,".$row["Mail"].", ".$row["Tel"].", NULL , NULL ,".$row["Prenom"].",".$row["Nom"].", '1' , '0', NULL , '20', '1', NULL , '-1', '-1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0'
)";
echo "<tr>
<td>".$row["Id"]."</td>
<td>".$row["Login"]."</td>
<td>".$row["Password"]."</td>
<td>".$row["Nom"]."</td>
<td>".$row["Prenom"]."</td>
<td>".$row["Entite"]."</td>
<td>".$row["Mail"]."</td>
<td>".$row["Tel"]."</td>
<td>".$row["Statut"]."</td></tr>" ;
//Insertion
$result1 = mysql_query($sql1, $conn);
}
?>
</table>
</body>
</html> |
