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
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
|
<?php
$table=@$_GET['table'];
$client=@$_GET['client'];
$requete=@$_GET['requete'];
$tableBDD=@$_GET['tableBDD'];
$table=@$_GET['table'];
$client=@$_GET['client'];
function affchamps($nom, $table, $requete)
{
if ($nom=='CL_0'){ $host="BDD_0.mysql.db"; $dbname="BDD_0"; $loginbdd="BDD_0"; $passbdd="MDP_0"; $suff_table="extratest_";}
if ($nom=='CL_1'){ $host="BDD_1.mysql.db"; $dbname="BDD_1"; $loginbdd="BDD_1"; $passbdd="MDP_1"; $suff_table="extratest_";}
if ($nom=='CL_2'){ $host="BDD_2.mysql.db"; $dbname="BDD_2"; $loginbdd="BDD_2"; $passbdd="MDP_2"; $suff_table="extra_";}
if ($nom=='CL_3'){ $host="BDD_3.mysql.db"; $dbname="BDD_3"; $loginbdd="BDD_3"; $passbdd="MDP_3"; $suff_table="ext_";}
if ($nom=='CL_4'){ $host="BDD_4.mysql.db"; $dbname="BDD_4"; $loginbdd="BDD_4"; $passbdd="MDP_4"; $suff_table="extra_";}
if ($nom=='CL_5'){ $host="BDD_5.mysql.db"; $dbname="BDD_5"; $loginbdd="BDD_5"; $passbdd="MDP_5"; $suff_table="extratest_";}
if ($nom=='CL_6'){ $host="BDD_6.mysql.db"; $dbname="BDD_6"; $loginbdd="BDD_6"; $passbdd="MDP_6"; $suff_table="extratest_";}
if ($nom=='CL_7'){ $host="BDD_7.mysql.db"; $dbname="BDD_7"; $loginbdd="BDD_7"; $passbdd="MDP_7"; $suff_table="ext_";}
if ($nom=='CL_8'){ $host="BDD_8.mysql.db"; $dbname="BDD_8"; $loginbdd="BDD_8"; $passbdd="MDP_8"; $suff_table="extra_";}
$liste_champs='<b><u>'.$nom.'</u></b><br>';
$link = mysql_connect($host,$loginbdd,$passbdd);mysql_select_db($dbname);
if ($requete<>'' and $requete<>'0'){$result = mysql_query("ALTER TABLE `".$suff_table.$requete);}
$query = "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = '".$suff_table.$table."'";
//$query = "SHOW ".$suff_table.$table." FROM ".$dbname;
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
$liste_champs.= $row['COLUMN_NAME']."<br>";
//$liste_champs.= $row[0]."<br>";
}
return $liste_champs;
mysql_close($link);
}
if ($client<>""){
echo '
<table>
<tr>
<td width="50%" valign="top" align="left">';$z=affchamps("CL_0",$table,$requete);echo $z.'</td>
<td width="50%" valign="top" align="left">';$z=affchamps($client,$table,$requete);echo $z.'</td>
</tr>
</table><br><br><br>';
}
else
{
function info($nom)
{
if ($nom=='CL_0'){ $host="BDD_0.mysql.db"; $dbname="BDD_0"; $loginbdd="BDD_0"; $passbdd="MDP_0"; $suff_table="extratest_";}
if ($nom=='CL_1'){ $host="BDD_1.mysql.db"; $dbname="BDD_1"; $loginbdd="BDD_1"; $passbdd="MDP_1"; $suff_table="extratest_";}
if ($nom=='CL_2'){ $host="BDD_2.mysql.db"; $dbname="BDD_2"; $loginbdd="BDD_2"; $passbdd="MDP_2"; $suff_table="extra_";}
if ($nom=='CL_3'){ $host="BDD_3.mysql.db"; $dbname="BDD_3"; $loginbdd="BDD_3"; $passbdd="MDP_3"; $suff_table="ext_";}
if ($nom=='CL_4'){ $host="BDD_4.mysql.db"; $dbname="BDD_4"; $loginbdd="BDD_4"; $passbdd="MDP_4"; $suff_table="extra_";}
if ($nom=='CL_5'){ $host="BDD_5.mysql.db"; $dbname="BDD_5"; $loginbdd="BDD_5"; $passbdd="MDP_5"; $suff_table="extratest_";}
if ($nom=='CL_6'){ $host="BDD_6.mysql.db"; $dbname="BDD_6"; $loginbdd="BDD_6"; $passbdd="MDP_6"; $suff_table="extratest_";}
if ($nom=='CL_7'){ $host="BDD_7.mysql.db"; $dbname="BDD_7"; $loginbdd="BDD_7"; $passbdd="MDP_7"; $suff_table="ext_";}
if ($nom=='CL_8'){ $host="BDD_8.mysql.db"; $dbname="BDD_8"; $loginbdd="BDD_8"; $passbdd="MDP_8"; $suff_table="extra_";}
//ect..... 200 CL
$link = mysql_connect($host,$loginbdd,$passbdd);mysql_select_db($dbname);
$info='<span style="float:right;"><i>';
$result = mysql_query("SELECT * FROM `".$suff_table."table_0` where supp='0'");$info.='D: '.mysql_num_rows($result).'<br>';
$result = mysql_query("SELECT * FROM `".$suff_table."table_1` where supp='0'");$info.='F: '.mysql_num_rows($result).'<br>';
$result = mysql_query("SELECT * FROM `".$suff_table."table_2`"); $info.='M: '.mysql_num_rows($result).'<br>';
$result = mysql_query("SELECT * FROM `pws_sms`");$info.='S: '.mysql_num_rows($result).'<br>';
$result = mysql_query("SELECT * FROM `extra_chat`");$info.='T: '.mysql_num_rows($result).'<br>';
$result = mysql_query("SELECT * FROM `".$suff_table."table_3` where a_acc='1'");$info.='U: '.mysql_num_rows($result).'<br>';
$resdate = mysql_query("SELECT date FROM `".$suff_table."table_4` ORDER BY `idJ` DESC limit 1");while($rowdt = mysql_fetch_array($resdate)){$info.='X: '.date ("d/m H:i", $rowdt['date']);}
$info.='</i></span>';
return $info;
mysql_close($link);
}
function affres($nom, $table, $requete)
{
if ($nom=='CL_0'){ $host="BDD_0.mysql.db"; $dbname="BDD_0"; $loginbdd="BDD_0"; $passbdd="MDP_0"; $suff_table="extratest_";}
if ($nom=='CL_1'){ $host="BDD_1.mysql.db"; $dbname="BDD_1"; $loginbdd="BDD_1"; $passbdd="MDP_1"; $suff_table="extratest_";}
if ($nom=='CL_2'){ $host="BDD_2.mysql.db"; $dbname="BDD_2"; $loginbdd="BDD_2"; $passbdd="MDP_2"; $suff_table="extra_";}
if ($nom=='CL_3'){ $host="BDD_3.mysql.db"; $dbname="BDD_3"; $loginbdd="BDD_3"; $passbdd="MDP_3"; $suff_table="ext_";}
if ($nom=='CL_4'){ $host="BDD_4.mysql.db"; $dbname="BDD_4"; $loginbdd="BDD_4"; $passbdd="MDP_4"; $suff_table="extra_";}
if ($nom=='CL_5'){ $host="BDD_5.mysql.db"; $dbname="BDD_5"; $loginbdd="BDD_5"; $passbdd="MDP_5"; $suff_table="extratest_";}
if ($nom=='CL_6'){ $host="BDD_6.mysql.db"; $dbname="BDD_6"; $loginbdd="BDD_6"; $passbdd="MDP_6"; $suff_table="extratest_";}
if ($nom=='CL_7'){ $host="BDD_7.mysql.db"; $dbname="BDD_7"; $loginbdd="BDD_7"; $passbdd="MDP_7"; $suff_table="ext_";}
if ($nom=='CL_8'){ $host="BDD_8.mysql.db"; $dbname="BDD_8"; $loginbdd="BDD_8"; $passbdd="MDP_8"; $suff_table="extra_";}
//ect..... 200 CL
$numcham="0";
$link = mysql_connect($host,$loginbdd,$passbdd);mysql_select_db($dbname);
if ($table=='chat'){$suff_table="extra_";}
if ($table=='sms'){$suff_table="pws_";}
if ($requete<>'' and $requete<>'0'){$result = mysql_query("ALTER TABLE `".$suff_table.$requete);}
$result = mysql_query("SELECT * FROM `".$suff_table.$table."`");
$numcham = mysql_num_fields($result);
if ($nom=="iobnet"){$_SESSION['verifnumcham']=$numcham;}
if ($numcham==$_SESSION['verifnumcham']){$color="green";}else{$color="red; font-weight:bold";}
$num_cham='<a href="?table='.$table.'&client='.$nom.'" style="color:'.$color.'">'.$numcham.'</a>';
return $num_cham;
mysql_close($link);
}
function affemail($nom, $table)
{
if ($nom=='CL_0'){ $host="BDD_0.mysql.db"; $dbname="BDD_0"; $loginbdd="BDD_0"; $passbdd="MDP_0"; $suff_table="extratest_";}
if ($nom=='CL_1'){ $host="BDD_1.mysql.db"; $dbname="BDD_1"; $loginbdd="BDD_1"; $passbdd="MDP_1"; $suff_table="extratest_";}
if ($nom=='CL_2'){ $host="BDD_2.mysql.db"; $dbname="BDD_2"; $loginbdd="BDD_2"; $passbdd="MDP_2"; $suff_table="extra_";}
if ($nom=='CL_3'){ $host="BDD_3.mysql.db"; $dbname="BDD_3"; $loginbdd="BDD_3"; $passbdd="MDP_3"; $suff_table="ext_";}
if ($nom=='CL_4'){ $host="BDD_4.mysql.db"; $dbname="BDD_4"; $loginbdd="BDD_4"; $passbdd="MDP_4"; $suff_table="extra_";}
if ($nom=='CL_5'){ $host="BDD_5.mysql.db"; $dbname="BDD_5"; $loginbdd="BDD_5"; $passbdd="MDP_5"; $suff_table="extratest_";}
if ($nom=='CL_6'){ $host="BDD_6.mysql.db"; $dbname="BDD_6"; $loginbdd="BDD_6"; $passbdd="MDP_6"; $suff_table="extratest_";}
if ($nom=='CL_7'){ $host="BDD_7.mysql.db"; $dbname="BDD_7"; $loginbdd="BDD_7"; $passbdd="MDP_7"; $suff_table="ext_";}
if ($nom=='CL_8'){ $host="BDD_8.mysql.db"; $dbname="BDD_8"; $loginbdd="BDD_8"; $passbdd="MDP_8"; $suff_table="extra_";}
//ect..... 200 CL
$link = mysql_connect($host,$loginbdd,$passbdd);mysql_select_db($dbname);
$result = mysql_query("SELECT mail_direction FROM `".$suff_table.$table."`");
while($row = mysql_fetch_array($result)){$res.= $row['mail_direction'].'; ';}
return $res;
mysql_close($link);
}
function listinfo()
{
$recol='<td style="text-align:left">';$recol.=info("CL_0");$recol.='</td>
<td style="text-align:left">';$recol.=info("CL_1");$recol.='</td>
<td style="text-align:left">';$recol.=info("CL_2");$recol.='</td>
<td style="text-align:left">';$recol.=info("CL_3");$recol.='</td>
<td style="text-align:left">';$recol.=info("CL_4");$recol.='</td>
<td style="text-align:left">';$recol.=info("CL_5");$recol.='</td>
<td style="text-align:left">';$recol.=info("CL_6");$recol.='</td>
<td style="text-align:left">';$recol.=info("CL_7");$recol.='</td>
<td style="text-align:left">';$recol.=info("CL_8");$recol.='</td>
';
return $recol;
}
function affrecol($table, $requete)
{
$recol='<td>';$recol.=affres("CL_0",$table, $requete);$recol.='</td>
<td>';$recol.=affres("CL_1",$table, $requete);$recol.='</td>
<td>';$recol.=affres("CL_2",$table, $requete);$recol.='</td>
<td>';$recol.=affres("CL_3",$table, $requete);$recol.='</td>
<td>';$recol.=affres("CL_4",$table, $requete);$recol.='</td>
<td>';$recol.=affres("CL_5",$table, $requete);$recol.='</td>
<td>';$recol.=affres("CL_6",$table, $requete);$recol.='</td>
<td>';$recol.=affres("CL_7",$table, $requete);$recol.='</td>
<td>';$recol.=affres("CL_8",$table, $requete);$recol.='</td>
';
return $recol;
}
function liste_email($table)
{
$remail="";
$remail.=affemail("CL_1",$table);
$remail.=affemail("CL_2",$table);
$remail.=affemail("CL_3",$table);
$remail.=affemail("CL_4",$table);
$remail.=affemail("CL_5",$table);
$remail.=affemail("CL_6",$table);
$remail.=affemail("CL_7",$table);
$remail.=affemail("CL_8",$table);
return $remail;
}
function affbq($nom, $table)
{
if ($nom=='CL_0'){ $host="BDD_0.mysql.db"; $dbname="BDD_0"; $loginbdd="BDD_0"; $passbdd="MDP_0"; $suff_table="extratest_";}
if ($nom=='CL_1'){ $host="BDD_1.mysql.db"; $dbname="BDD_1"; $loginbdd="BDD_1"; $passbdd="MDP_1"; $suff_table="extratest_";}
if ($nom=='CL_2'){ $host="BDD_2.mysql.db"; $dbname="BDD_2"; $loginbdd="BDD_2"; $passbdd="MDP_2"; $suff_table="extra_";}
if ($nom=='CL_3'){ $host="BDD_3.mysql.db"; $dbname="BDD_3"; $loginbdd="BDD_3"; $passbdd="MDP_3"; $suff_table="ext_";}
if ($nom=='CL_4'){ $host="BDD_4.mysql.db"; $dbname="BDD_4"; $loginbdd="BDD_4"; $passbdd="MDP_4"; $suff_table="extra_";}
if ($nom=='CL_5'){ $host="BDD_5.mysql.db"; $dbname="BDD_5"; $loginbdd="BDD_5"; $passbdd="MDP_5"; $suff_table="extratest_";}
if ($nom=='CL_6'){ $host="BDD_6.mysql.db"; $dbname="BDD_6"; $loginbdd="BDD_6"; $passbdd="MDP_6"; $suff_table="extratest_";}
if ($nom=='CL_7'){ $host="BDD_7.mysql.db"; $dbname="BDD_7"; $loginbdd="BDD_7"; $passbdd="MDP_7"; $suff_table="ext_";}
if ($nom=='CL_8'){ $host="BDD_8.mysql.db"; $dbname="BDD_8"; $loginbdd="BDD_8"; $passbdd="MDP_8"; $suff_table="extra_";}
//ect..... 200 CL
$res="";
$link = mysql_connect($host,$loginbdd,$passbdd);mysql_select_db($dbname);
$result = mysql_query("SELECT idBQ, nom_BQ FROM `".$suff_table.$table."` order by idBQ asc");
while($row = mysql_fetch_array($result)){$res.= $row['idBQ']." - ".$row['nom_BQ'].'<br>';}
return $res;
mysql_close($link);
}
echo '
<style>
td {text-align:center;}
th {text-align:center; font-weight:bold}
</style>
EMAILS : '.$r=liste_email('config');echo '<br>
<table width="100%" border="1">
<thead>
<tr>
<th></th>
<th>CL_0</th>
<th>CL_1</th>
<th>CL_2</th>
<th>CL_3</th>
<th>CL_4</th>
<th>CL_5</th>
<th>CL_6</th>
<th>CL_7</th>
<th>CL_8</th>
</tr>
</thead>
<tbody>
<tr><td><b>INFOS</b></td>'.$r=listinfo();echo '</tr>';
if ($tableBDD<>''){
echo '<tr><td>'.$tableBDD.'</td>'.$r=affrecol($tableBDD, $requete);echo '</tr>';
}
else
{
echo '
<tr><td>Table_1</td>'.$r=affrecol("table_1", $requete);echo '</tr>
<tr><td>Table_2</td>'.$r=affrecol("table_2", $requete);echo '</tr>
<tr><td>Table_3</td>'.$r=affrecol("table_3", $requete);echo '</tr>
<tr><td>Table_4</td>'.$r=affrecol("table_4", $requete);echo '</tr>
<tr><td>Table_5</td>'.$r=affrecol("table_5", $requete);echo '</tr>
<tr><td>Table_6</td>'.$r=affrecol("table_6", $requete);echo '</tr>
<tr><td>Table_7</td>'.$r=affrecol("table_7", $requete);echo '</tr>
<tr><td>Table_8</td>'.$r=affrecol("table_8", $requete);echo '</tr>
<tr><td>Table_9</td>'.$r=affrecol("table_9", $requete);echo '</tr>
<tr><td>Table_10</td>'.$r=affrecol("table_10", $requete);echo '</tr>
}
//echo '
//<tr><td>LISTE CHAMPS</td><td>';$b=affbq('CL_0',"banque");echo $b.'</td><td>';$b=affbq('CL_1',"banque");echo $b.'</td><td>';$b=affbq('CL_2',"banque");echo $b.'</td><td>';$b=affbq('CL_3',"banque");echo $b.'</td><td>';$b=affbq('CL_4',"banque");echo $b.'</td><td>';$b=affbq('CL_5','dem', $requete);echo $b.'</td><td>';$b=affbq('CL_6',"banque");echo $b.'</td><td>';$b=affbq('CL_7',"banque");echo $b.'</td><td>';$b=affbq('CL_8',"banque");echo $b.'</td></tr>
echo '
</tbody
</table>';
}
?> |
Amélioration de code pour gestion plusieurs BDD
Répondre avec citation
Partager