-
Notifications
You must be signed in to change notification settings - Fork 0
/
Resultat Sous-Domaine.php
162 lines (148 loc) · 6.12 KB
/
Resultat Sous-Domaine.php
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
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
<style type="text/css">
<!--
body {
background-image: url(index_Image/fond.gif);
background-repeat: repeat;
}
a:link {
color: #0000FF;
}
a:visited {
color: #0000FF;
}
a:hover {
color: #FF0000;
}
a:active {
color: #0000FF;
}
.style3 {
color: #996633;
text-decoration: blink;
}
.style5 {font-size: 18px}
.style7 { color: #3399FF;
font-weight: bold;
}
.Style10 {
font-size: 36px;
font-weight: bold;
}
.Style11 {font-size: 24px}
.Style80 {font-size: 24px; font-weight: bold; color: #000000; }
.Style81 {color: #000000}
.Style83 {font-size: 30px}
.Style87 {color: #000000; font-size: 26px; }
-->
</style>
</head>
<body>
<div align="center">
<table width="1192" height="269" border="0" align="center" bordercolor="#FFFFFF" >
<tr>
<td width="1267" height="75" align="center" bordercolor="#000000" bgcolor="#CDAE46" class="style5 style3 footer"><p><span class="Style10 Style13">
<?
$d=$_POST['methode'];
if ($link = mysql_connect("localhost", "root", "")) {
if( $id_db = mysql_select_db("bas-lexique") ) {
$charset = mysql_client_encoding($link);
mysql_query("SET CHARACTER SET 'utf8'", $link);
$bol=0;
$requets =mysql_query("SELECT soudomain FROM statsoudomaine");
while ($donneess = mysql_fetch_array($requets) ){
if ($d==$donneess['soudomain']) { $bol=1; } }
if ($bol==1) {$requet1 =mysql_query("UPDATE statsoudomaine SET nbsoudomaine=nbsoudomaine+1 WHERE statsoudomaine.soudomain='$d' ");}
else { $requet1 =mysql_query("INSERT INTO `statsoudomaine` ( `soudomain` , `nbsoudomaine` ) VALUES ('$d', '1')"); }
} else { echo "<br>"; echo "<br>"; die("*** Echec de connexion à la base ***"); }
mysql_close(); // Dconnexion de MySQL
} else { echo "<br>"; echo "<br>"; die(" *** Echec de connexion au serveur de base de données ***"); }
?>
</span></p>
<table width="1126" height="111" border="0" align="center" >
<tr>
<td width="1292" height="107" align="center" bordercolor="#000000" bgcolor="#CDAE46" class="style5 style3 footer"><p align="center"><span class="Style10"><span class="Style81">Sous-Domaine :</span><span class="Style11"><span class="Style81"><? echo $_POST['methode'] ; ?></span></span>
<?
$d=$_POST['methode'];
$link = mysql_connect("localhost", "root", ""); // Connexion MySQL
mysql_select_db("bas-lexique"); // Slection de la base dico
$charset = mysql_client_encoding($link);
mysql_query("SET CHARACTER SET 'utf8'", $link);
if ($reponse = mysql_query("SELECT * FROM sousdomaine,contient,mot WHERE sousdomaine.Nom_soudomain_FR LIKE '$d%'
and sousdomaine.cle_soudomain=contient.cle_soudomain
and contient.Cle_mot=mot.Cle_mot ORDER BY `Mot_FR` ASC") ) { $cmpt=mysql_num_rows($reponse); }
?>
</span></p>
<table width="1087" border="1" bordercolor="#000000">
<tr>
<td bordercolor="#000000" bgcolor="#6699FF"><span class="Style80">Le Mot En Français <span class="Style83">^</span></span></td>
<td bordercolor="#000000" bgcolor="#6699FF"><span class="Style80">الكلمة في اللغة العربية </span></td>
<td bordercolor="#000000" bgcolor="#6699FF"><span class="Style80">The Word In English</span></td>
</tr>
<tr>
<td colspan="3"><span class="style5"><span class="Style11">
<? $c1=0; $c2=0; $c3=0;
while ($donnees = mysql_fetch_array($reponse)) { ?>
</span></span></td>
</tr>
<tr>
<td width="388" height="36"><span class="Style11"><span class="style5"><? if ($donnees['Mot_FR']=="") { echo " "; }else{ $c1=$c1+1;
echo $donnees['Mot_FR']; echo" "; }
?></span></span></td>
<td width="347"><span class="style5">
<? if ($donnees['Mot_AR']=="") { echo " "; }else{ $c2=$c2+1;
echo $donnees['Mot_AR']; echo" "; }
?>
</span></td>
<td width="330"><span class="style5"><? if ($donnees['Mot_EN']=="") { echo " "; }else{ $c3=$c3+1;
echo $donnees['Mot_EN']; echo" "; }
}
?></span></td>
</tr>
<tr>
<td height="50" valign="middle" bordercolor="#0000FF" bgcolor="#6699FF"><p class="Style11"><span class="Style81">Nombre de Mot En Français</span> <span class="Style81">:</span>
<?
echo $c1; ?>
</p>
</td>
<td valign="middle" bordercolor="#0000FF" bgcolor="#6699FF"><p class="Style11"><span class="Style81">Nombre de Mot En Arabe :
<?
echo $c2; ?>
</span></p></td>
<td valign="middle" bordercolor="#0000FF" bgcolor="#6699FF"><p class="Style11">
<span class="Style81">Nombre de Mot En Anglais : </span>
<?
echo $c3; ?>
</p></td>
</tr>
</table>
<p><span class="Style11"><span class="Style87">Nombre Totale</span>
<span class="Style87">: </span></span><span class="Style11 Style81">
<?
echo $cmpt;
mysql_close(); // Dconnexion de MySQL ?>
</span></p></td>
</tr>
</table>
<p class="Style11"> </p> </td>
</tr>
</table>
<p> </p>
</div>
<div align="justify">
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p><a href="Untitled-7.php" class="Style10">Précedent</a></p>
</div></body>
</html>