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
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
|
<HTML><HEAD>
<TITLE>contact.php</TITLE>
</HEAD>
<BODY>
<FORM>
Nom: <INPUT TYPE=TEXT NAME='Nom'><BR>
Prenom: <INPUT TYPE=TEXT NAME='Prenom'><BR>
Fonction: <INPUT TYPE=TEXT NAME='Fonction'><BR>
Societe: <INPUT TYPE=TEXT NAME='Societe'><BR>
Téléphone: <INPUT TYPE=TEXT NAME='Telephone'><BR>
Email: <INPUT TYPE=TEXT NAME='Email'><BR>
Adresse: <INPUT TYPE=TEXT NAME='Adresse'><BR>
Commentaire: <INPUT TYPE=TEXT NAME='Commentaire'><BR>
<INPUT TYPE=SUBMIT VALUE='ajouter' NAME='ajouter' >
recherche: <INPUT TYPE=TEXT NAME='recherche'><BR>
</FORM>
<?php
$connexion = mysql_connect("localhost", "dbcolas", "sn2011");
if (!$connexion)
{
echo "Connexion impossible \n";
exit;
}
if (!mysql_select_db("suivi"))
{
echo "Connexion base impossible\n";
exit;
}
$res=mysql_query("SELECT * FROM contact",$connexion) or die(mysql_error());
//echo $res;
$Nom = $_GET['Nom'];
$Prenom = $_GET['Prenom'];
$Fonction = $_GET['Fonction'];
$Societe = $_GET['Societe'];
$Telephone = $_GET['Telephone'];
$Email = $_GET['Email'];
$Adresse = $_GET['Adresse'];
$Commentaire = $_GET['Commentaire'];
$recherche = $_GET['recherche'];
// FONCTION RECHERCHE OK
if( isset( $_GET['recherche'] ) )
{
echo "Résultat de la recherche";
?>
<table>
<TR><th>--------------------</th><th>
<?php
$reqrech = mysql_query("SELECT * FROM contact WHERE Id LIKE '%$recherche%' OR Nom LIKE '%$recherche%' OR Prenom LIKE
'%$recherche%'");
while($data=mysql_fetch_object($reqrech))
{
echo '<tr><td>',$data->Id, '</td><td>', $data->Nom,'</td><td>',$data->Prenom,'</td></tr>';
?>
<TR><th>--------------------</th><th>
<?php
}
}
// FONCTION AJOUTER PROBLEME DOUBLE CLIC
if( isset( $_GET['ajouter'] ) )
{
echo "Entrez vos champs";
$requete = mysql_query("INSERT INTO contact (Nom, Prenom, Fonction, Societe, Telephone, Email, Adresse,
Commentaires) VALUES ('$Nom', '$Prenom', '$Fonction', '$Societe', '$Telephone', '$Email', '$Adresse', '$Commentaire')");
}
?>
<table>
<TR><th>--------------------</th><th>
<?
$req= mysql_query("SELECT * FROM contact");
while($data=mysql_fetch_object($req))
{
echo '<tr><td>',$data->Id, '</td><td>', $data->Nom,'</td><td>',$data->Prenom,'</td></tr>';
?>
<TR><th>--------------------</th><th>
<?php
//FONCTION SUPPRESSION
echo "<a href=\"suppression.php?Id=" . $data['Id'] . "><INPUT TYPE=SUBMIT VALUE='supprimer' NAME='supprimer' ></a>";
//FONCTION MODIFIER
//echo "<a href=\"modification.php?Id=" . $data['Id'] . "><INPUT TYPE=SUBMIT VALUE='modifier' NAME='modifier' ></a>";
}
?>
</BODY></HTML> |
