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
|
<?php
//--------------authentification------------------------------------------------
$db_link = mysql_connect($sql_serveur,$sql_user,$sql_passwd);
$requete=mysql_db_query($sql_bdd,"select * from membre where idcontrol=\"$idcontrol\"",$db_link);
IF(mysql_num_rows($requete)==0)
{
header("Location:$url_erreur");
}
//-------------------------------------------------------------------------------
$connexion = @mysql_connect("$serveur","$user","$password");
IF (!$connexion) {
echo erreurServeurMySQL();
}
IF ($connexion) {
switch($action)
{
case "valider";
$Date = date("Y/m/d");
echo "<center><font face=verdana size=3><b>".translate("News updated")."</b></font><br><br><font face=verdana size=2><a href=\"http://fr-iranscholarship.net/index.php\">".translate("Return to home page")."</a></font></center>";
$resultat = mysql_db_query("$base","update $table set titre=\"$titre\",texte=\"$texte\",date=\"$Date\",auteur=\"$auteur\",autmail=\"$autmail\",image=\"$image\",imgurl=\"$imgurl\",target=\"$target\",accueil=\"$accueil\" where id=$id",$connexion);
break;
case "mod";
$resultat = mysql_db_query("$base","select * from $table where id=$id",$connexion);
$id = mysql_result($resultat,0,"id");
$titre = mysql_result($resultat,0,"titre");
$texte = mysql_result($resultat,0,"texte");
$auteur = mysql_result($resultat,0,"auteur");
$autmail = mysql_result($resultat,0,"autmail");
$image = mysql_result($resultat,0,"image");
$imgurl = mysql_result($resultat,0,"imgurl");
$target = mysql_result($resultat,0,"target");
$accueil = mysql_result($resultat,0,"accueil");
echo "<center><font face=verdana size=3><b>".translate("Update this news")."</b></font></center><br>";
echo "<center><table>";
echo "<form method=post action=index".$lng.".php3?file=modn&idcontrol=$idcontrol>";
echo "<font face=verdana size=2><input type=hidden name=action value='valider'>";
echo "<input type=hidden name=id value=$id>";
echo "<tr>
<td align=left>
<font face=verdana size=2>".translate("Author")."</font><br>
<input type=text name=auteur size=32 value=\"$auteur\">
</td>
</tr>";
echo "<tr>
<td align=left>
<font face=verdana size=2>".translate("Author email")."</font><br>
<input type=text name=autmail size=32 value=\"$autmail\">
</td>
</tr>";
echo "<tr>
<td align=left>
<font face=verdana size=2>".translate("Title")."</font><br>
<input type=text name=titre size=32 value=\"$titre\">
</td>
</tr>";
echo "<tr>
<td align=left>
<font face=verdana size=2>".translate("Text")."</font><br>
<textarea name=texte wrap=virtual cols=30 rows=5>$texte</textarea>
</td>
</tr>
<tr>
<td align=left>
<font face=verdana size=2>".translate("Show on home")."</font></td></tr>";
?>
<tr>
<td align="left"><input type="radio" name="accueil" value="0" <?php IF((!$sent && $accueil == 'non') || ($sent && !$accueil)) echo 'checked="checked"'; ?>>No
<input type="radio" name="accueil" value="1" <?php IF((!$sent && $accueil == 'oui') || ($sent && $accueil)) echo 'checked="checked"'; ?>>Yes</td>
</tr>
<?
echo "<tr>
<td colspan=2 align=center>
<input type=submit value=".translate("submit").">
</td>
</tr>";
echo "</font></form></table></center><br><br>";
break;
DEFAULT:
echo "<center><font face=verdana size=3><b>".translate("Update news")."</b></font></center><br>";
$resultat = mysql_db_query("$base","select * from $table order by date desc",$connexion);
$num = mysql_num_rows($resultat);
$i=0;
echo "<center><table border=1><tr><th><font face=verdana size=2>Id</font></th><th><font face=verdana size=2>".translate("Title")."</font></th><th><font face=verdana size=2>".translate("Date")."</font></th><th><font face=verdana size=2>".translate("Author")."</font></th><th><font face=verdana size=2>".translate("email")."</font></th></tr>";
while($i<$num)
{
$id = mysql_result($resultat,$i,"id");
$titre = mysql_result($resultat,$i,"titre");
$Date = mysql_result($resultat,$i,"date");
$auteur = mysql_result($resultat,$i,"auteur");
$autmail = mysql_result($resultat,$i,"autmail");
$Date1 = "$Date[8]$Date[9]$Date[4]$Date[5]$Date[6]$Date[7]$Date[0]$Date[1]$Date[2]$Date[3]$Date[10]$Date[11]$Date[12]$Date[13]$Date[14]$Date[15]";
echo "<tr><td><a href='index".$lng.".php3?file=modn&action=mod&id=$id&idcontrol=$idcontrol'><font face=verdana size=2>$id</font></a></td><td><font face=verdana size=2>$titre</font></td><td><font face=verdana size=2>$Date1</font></td><td><font face=verdana size=2>$auteur</font></td><td><font face=verdana size=2><a href=mailto:$autmail>$autmail</a></font></td></tr>";
$i++;
}
echo "</table></center><br><br>";
break;
}
$result = mysql_close($connexion);
}
?> |
06/06/2006, 23h43
[SGBD] boutons radio et base mysql
00
