Viewing file:  Curisite.php (4.92 KB) -rw----r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<link rel="stylesheet" href="css/lightbox.css" type="text/css" media="screen" />
<style type="text/css">
<!--
body {
margin-right: 0px;
margin-bottom: 0px;
}
.Style3 {color: #FFFFFF}
-->
</style>
<script type="text/javascript" src="js/prototype.js"></script>
<script type="text/javascript" src="js/scriptaculous.js?load=effects,builder"></script>
<script type="text/javascript" src="js/lightbox.js"></script>
</head>
<body>
<p class="Style3">INFORMATIONS</span>
<table width="800" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<?php
include ("connect.php");
$get = mysql_query("SELECT * FROM presentation WHERE ID='3'");
$i=1;
while ($row = mysql_fetch_assoc($get))
{
// obtenir données
$i++;
$texte = $row['TEXTE'];
if (isset($_SESSION['identifiant']))
{
if (isset($_GET['valider']))
{
$text2 = mysql_real_escape_string($_POST['text2']);
$num = '3';
$query = mysql_query("UPDATE presentation SET TEXTE='$text2' WHERE ID='$num'");
echo "<p class='Style2'>Modification réussis</p>";
$get4 = mysql_query("SELECT * FROM presentation WHERE ID='$num'");
while ($row4 = mysql_fetch_assoc($get4))
{
$texte4 = $row4['TEXTE'];
echo "<p class='Style2'>$texte4</p>";
}
}
else
{echo '<table><form action="index.php?page=Curisite&valider=1" method="POST" enctype="multipart/form-data"><td><tr>
<textarea name="text2" id="text2" cols="80" rows="20">'.$texte.'</textarea></tr>
<tr><input type="submit" name="sup2" value="Enregistrer"></tr></td>
</form></table>';
}
}
else
{
echo "<p class='Style2'>$texte</p>";
}
}
if (isset($_SESSION['identifiant']))
{
if (isset($_GET['ajout1']))
{
echo" <form action='index.php?page=Curisite&add1=1' method='POST' enctype='multipart/form-data'>
<table width='700'><td><tr><br>Titre: <input name='titre' type='text' value='' maxlength='70' /></tr>
<tr>Photo: <input type='file' name='myfile'>Attention! Mettre un fichier JPG uniquement!! </tr>
<tr><td><input type='submit' name='sup' value='Ajouter'></td></tr></table>
</form><br><br><br><br><br>";
}
else
{
if (isset($_GET['add1']))
{
$name = $_FILES['myfile']['name'];
$name = strtr($name, 'ÁÀÂÄÃÅÇÉÈÊËÍÏÎÌÑÓÒÔÖÕÚÙÛÜÝ', 'AAAAAACEEEEEIIIINOOOOOUUUUY');
$name = strtr($name, 'áàâäãåçéèêëíìîïñóòôöõúùûüýÿ/', 'aaaaaaceeeeiiiinooooouuuuyy_');
$size = $_FILES['myfile']['size']; //voir le tutorial upload pour vérifier que c'est une image
$tmp_name = $_FILES['myfile']['tmp_name'];
$titre = $_POST['titre'];
$title = strtr($titre, 'ÁÀÂÄÃÅÇÉÈÊËÍÏÎÌÑÓÒÔÖÕÚÙÛÜÝ', 'AAAAAACEEEEEIIIINOOOOOUUUUY');
$title = strtr($title, 'áàâäãåçéèêëíìîïñóòôöõúùûüýÿ/', 'aaaaaaceeeeiiiinooooouuuuyy_');
if ($name)
{
//Chargement en cours
$location ="curiosite/$title.$name";
move_uploaded_file($tmp_name,$location); //regarder le tutorial pour que personne ne puisse y installer des fichier!!!
$query = mysql_query("INSERT INTO curiosite VALUES ('','$titre','$location')");
echo "Ajout réussi
<META HTTP-EQUIV='Refresh' CONTENT='0;URL=index.php?page=Curisite'>";
}
else
echo("Sélectionner un fichier!");
}
else
{
echo" <div align='right'><form action='index.php?page=Curisite&ajout1=1' method='POST' enctype='multipart/form-data'>
<input type='submit' name='sup2' value='Ajouter une Photo'>
</form></div><br>";
}
}
if (isset($_GET['delete'])){
$id = $_GET['id'];
$query = mysql_query("DELETE FROM curiosite WHERE ID='$id'");
echo ("<p class='Style2'><strong>La photo n'existe maintenant plus.</strong></p>");
}
else
echo "<p class='Style2'><strong>Pour supprimer une photo: Cliquer dessus.</strong></p>";
}
?>
<?php
//apparition des données
$get = mysql_query("SELECT * FROM curiosite");
$i=1;
while ($row = mysql_fetch_assoc($get))
{
// obtenir données
$i++;
$picture = $row['PHOTO'];
$name = $row['NOM'];
$id = $row['ID'];
if (isset($_SESSION['identifiant']))
{echo "<a href='index.php?page=Curisite&id=".$id."&delete=3'>";}
else
{echo "<a href='$picture' rel='lightbox[roadtrip]' title='".$name."'>";}
echo "<img src='$picture' width='100' height='70' border='0' alt='$name' title='$name' /></a><img src='image/transparent.png' width='10' height='70' /> ";
if ($i>7)
{
echo "<br>";
$i=1;
}
}
echo "</p></td>";
?>
</tr>
</table>
<p> </p>
</body>
</html>
|
