function resize_clone($path, $file)
{
list($width, $height, $type, $attr) = getimagesize($path.$file);
$ratio = $height / $width;
if ($height > 500 OR $width > 500)
{
if($ratio <= 1)
{
$x = 500;
$y = 500*$ratio;
}
else
{
$y = 500;
$x = 500*(1/$ratio);
}
}
else
{
if($ratio <= 1)
{
$x = $width;
$y = $width*$ratio;
}
else
{
$y = $height;
$x = $height*(1/$ratio);
}
}
$size = getimagesize($path.$file);
if ( $size)
{
if ($size['mime']=='image/jpeg' )
{
$img_big = imagecreatefromjpeg($path.$file); # On ouvre l'image d'origine
$img_new = imagecreate($x, $y);
# création de la miniature
$img_mini = imagecreatetruecolor($x, $y)
or $img_mini = imagecreate($x, $y);
// copie de l'image, avec le redimensionnement.
imagecopyresized($img_mini,$img_big,0,0,0,0,$x,$y,$size[0],$size[1]);
imagejpeg($img_mini,$path."big_".$file );
}
}
if($ratio <= 1)
{
$x = 90;
$y = 90*$ratio;
}
else
{
$y = 90;
$x = 90*(1/$ratio);
}
unlink($path.$file);
}
//////
la boucle :
$sql = 'SELECT * FROM table WHERE nom="xx"';
mysql_query("SET NAMES 'utf8'");
$req = mysql_query($sql);
while($data = mysql_fetch_assoc($req))
{
resize_clone("uploads/", $data['img']);
}
mysql_free_result ($req);
<?php
$sql1 = 'SELECT * FROM sections';
$req1 = mysql_query($sql1) or die('Erreur SQL !'.$sql1.''.mysql_error());
while($data1 = mysql_fetch_assoc($req1))
{
if($data1['activee']=='oui') {
$check = 'checked="checked"';
}
else {
$check = '';
}
echo '<input type="checkbox" name="choix['.$data1['nom_class'].']" id="'.$data1['nom_class'].'" '.$check.' class="checkbox" value="'.$data1['nom_class'].'"/> <label for="'.$data1['nom_class'].'"><span style="color:#666; text-decoration:none; cursor:pointer;">'.$nom.'</span></label><br>'."\t\r";
<?php
if(isset($_POST['choix'])){
foreach($_POST['choix'] as $chkbx){
$sql = "UPDATE sections SET activee=\"oui\" WHERE nom_class='$chkbx'";
mysql_query($sql) or die('Erreur SQL!'.$sql.'<br>'.mysql_error());
$res = mysql_query($sql);
}}
$sql = 'SELECT distinct(page), count(page) as nb_page FROM stats WHERE date LIKE "'.$date_mois.'%" GROUP BY page ORDER BY nb_page DESC LIMIT 0,10';
$result = mysql_query($sql) ;
while ($data = mysql_fetch_array($result)) {
$nb_page = $data['nb_page'];
$page = $data['page'];
}
mysql_free_result($result);
$visites = array(88, 142, 288, 322, 676, 829, 536, 556, 693, 352, 427, 888);
$input = array($color1,$color2,$color3,$color4,$color5,$color6,$color7,$color8);
$rand_keys = array_rand($input, 2);
if($input[$rand_keys[0]] != $bg_home) {
$bg_home2 = $input[$rand_keys[0]];
}
else {
?????
}
// Préparation de la requête avec le LIMIT
$sql = 'SELECT * FROM table ORDER BY id ASC';
mysql_query("SET NAMES 'utf8'");
// on exécute la requête
$req = mysql_query($sql) or die('Erreur SQL !<br />'.$sql.'<br />'.mysql_error());
//met les données dans un tableau
while($data = mysql_fetch_assoc($req))
{
$tablo[]=$data;
}
$nbcol=2;
$nb=count($tablo);
for($i=0;$i<$nb;$i++){
//les valeurs à afficher
$id=$tablo[$i]['id'];
$text2=$tablo[$i]['text2'];
$hauteur_text2 = strlen($text2);
}
<?PHP
echo '<table><tr><td>Nom</td><td>Modifié le</td></tr>';
$dir = ".";
if ($dh = opendir($dir)) {
while (($file = readdir($dh)) !== false) {
if ($file != '.' && $file != '..' && $file != "robots.txt" && $file != ".htaccess"){
echo '<tr><td>'.$file.'</td>';
echo '<td>'.date("d M Y H:i:s",filectime($dir."/".$file));
echo '</td></tr>';
}
}
echo '</table>';
closedir($dh);
}
Chargement en cours