function generatemyimg($imgid) { //include('bdd.php'); $finalimg = ''; $query = 'SELECT img FROM astropix_articles WHERE id = ' . $imgid; // $req = $bdd->prepare($query); // try { $req->execute(); } // catch (Exception $e) { return false;} // $data = $req->fetch(); $data = reqex($query); if (!$data or !preg_match('#(\\.jpg|\\.jpeg|\\.png|\\.gif)$#isU', $data['img'])) { $finalimg = 'cross.png'; } else { if (preg_match('#(\\.jpg|\\.jpeg)$#isU', $data['img'])) { $img = imagecreatefromjpeg($data['img']); } elseif (preg_match('#(\\.png)$#isU', $data['img'])) { $img = imagecreatefrompng($data['img']); } elseif (preg_match('#(\\.gif)$#isU', $data['img'])) { $img = imagecreatefromgif($data['img']); } else { return false; } $max = 115; $x = imagesx($img); $y = imagesy($img); if ($x > $max or $y > $max) { if ($x > $y) { $nx = $max; $ny = $y / ($x / $max); } else { $nx = $x / ($y / $max); $ny = $max; } } $nimg = imagecreatetruecolor($nx, $ny); imagecopyresampled($nimg, $img, 0, 0, 0, 0, $nx, $ny, $x, $y); if (preg_match('#(\\.jpg|\\.jpeg)$#isU', $data['img'])) { imagejpeg($nimg, 'images/' . $imgid . '.jpg'); $finalimg = 'images/' . $imgid . '.jpg'; } elseif (preg_match('#(\\.png)$#isU', $data['img'])) { imagepng($nimg, 'images/' . $imgid . '.png'); $finalimg = 'images/' . $imgid . '.png'; } elseif (preg_match('#(\\.gif)$#isU', $data['img'])) { imagegif($nimg, 'images/' . $imgid . '.gif'); $finalimg = 'images/' . $imgid . '.gif'; } else { $finalimg = 'cross.png'; } $imgid = $finalimg; } //end else !$data return $imgid; }
$dbpwd = ''; } $dsn = 'mysql:host=' . $dbhost . ';dbname=' . $dbname; $bdd = new PDO($dsn, $dbuser, $dbpwd, $pdo_options); $req = $bdd->prepare($query); if (preg_match('#SELECT #isU', $query)) { try { $req->execute(); } catch (Exception $e) { return false; } $data = $req->fetchAll(); if (isset($data[0])) { $data = $data[0]; } $max = count($data); for ($i = 0; $i < $max; $i++) { unset($data[$i]); } return $data; } else { try { $req->execute(); return true; } catch (Exception $e) { return false; } } } reqex('SET NAMES "UTF8"');
<body> <div id="contentview"> <table id="menuview"><?php if (!$id) { echo '<tr> <td class="divview"> Merci de choisir un article. Redirection dans 5s... <script type="text/javascript">setTimeout("window.location.href = \'view.php\';", 5000);</script> </td> </tr>'; } else { if ($data) { $id = $data['id']; $prev = reqex('SELECT * FROM `astropix_articles` WHERE `artdate` < \'' . $data['artdate'] . '\' ORDER BY `artdate` DESC LIMIT 0, 1'); $prev = $prev ? $prev['id'] : 0; $next = reqex('SELECT * FROM `astropix_articles` WHERE `artdate` > \'' . $data['artdate'] . '\' ORDER BY `artdate` ASC LIMIT 0, 1'); $next = $next ? $next['id'] : 0; echo "\t\t\t<tr>\n"; echo "\t\t\t\t" . '<th class="divview" colspan="3">'; if ($next) { echo '<a href="viewer.php?id=' . $next . '"><<<</a> '; } echo htmlentities($data['title']); if ($prev) { echo ' <a href="viewer.php?id=' . $prev . '">>>></a>'; } echo "</th>\n"; echo "\t\t\t</tr>\n"; echo "\t\t\t<tr>\n"; echo "\t\t\t\t" . '<td class="divview" id="artimage" colspan="2">' . "\n"; echo "\t\t\t\t\t" . '<a href="' . $data['img'] . '" target="_blank">';