Fixed: Not selecting a datalabel used to issue a notice(undefined offset)
[phpmyadmin/ammaryasirr.git] / transformation_wrapper.php
blob1c5e16a3ece2b86e4d725e47adc4f36c7c661369
1 <?php
2 /* vim: set expandtab sw=4 ts=4 sts=4: */
3 /**
5 * @package phpMyAdmin
6 */
8 /**
11 define('IS_TRANSFORMATION_WRAPPER', true);
13 /**
14 * Gets a core script and starts output buffering work
16 require_once './libraries/common.inc.php';
17 require_once './libraries/transformations.lib.php'; // Transformations
18 $cfgRelation = PMA_getRelationsParam();
20 /**
21 * Ensures db and table are valid, else moves to the "parent" script
23 require_once './libraries/db_table_exists.lib.php';
26 /**
27 * Get the list of the fields of the current table
29 PMA_DBI_select_db($db);
30 if (isset($where_clause)) {
31 $result = PMA_DBI_query('SELECT * FROM ' . PMA_backquote($table) . ' WHERE ' . $where_clause . ';', null, PMA_DBI_QUERY_STORE);
32 $row = PMA_DBI_fetch_assoc($result);
33 } else {
34 $result = PMA_DBI_query('SELECT * FROM ' . PMA_backquote($table) . ' LIMIT 1;', null, PMA_DBI_QUERY_STORE);
35 $row = PMA_DBI_fetch_assoc($result);
38 // No row returned
39 if (!$row) {
40 exit;
41 } // end if (no record returned)
43 $default_ct = 'application/octet-stream';
45 if ($cfgRelation['commwork'] && $cfgRelation['mimework']) {
46 $mime_map = PMA_getMime($db, $table);
47 $mime_options = PMA_transformation_getOptions((isset($mime_map[$transform_key]['transformation_options']) ? $mime_map[$transform_key]['transformation_options'] : ''));
49 foreach ($mime_options AS $key => $option) {
50 if (substr($option, 0, 10) == '; charset=') {
51 $mime_options['charset'] = $option;
56 // For re-usability, moved http-headers and stylesheets
57 // to a seperate file. It can now be included by libraries/header.inc.php,
58 // querywindow.php.
60 require_once './libraries/header_http.inc.php';
61 // [MIME]
62 if (isset($ct) && !empty($ct)) {
63 $mime_type = $ct;
64 } else {
65 $mime_type = (isset($mime_map[$transform_key]['mimetype']) ? str_replace('_', '/', $mime_map[$transform_key]['mimetype']) : $default_ct) . (isset($mime_options['charset']) ? $mime_options['charset'] : '');
68 if (empty($cn)) {
69 $cn = 'download.bin';
72 PMA_download_header($mime_type, $cn);
74 if (! isset($resize)) {
75 echo $row[$transform_key];
76 } else {
77 // if image_*__inline.inc.php finds that we can resize,
78 // it sets $resize to jpeg or png
80 $srcImage = imagecreatefromstring($row[$transform_key]);
81 $srcWidth = ImageSX($srcImage);
82 $srcHeight = ImageSY($srcImage);
84 // Check to see if the width > height or if width < height
85 // if so adjust accordingly to make sure the image
86 // stays smaller then the $newWidth and $newHeight
88 $ratioWidth = $srcWidth/$newWidth;
89 $ratioHeight = $srcHeight/$newHeight;
91 if ($ratioWidth < $ratioHeight) {
92 $destWidth = $srcWidth/$ratioHeight;
93 $destHeight = $newHeight;
94 } else {
95 $destWidth = $newWidth;
96 $destHeight = $srcHeight/$ratioWidth;
99 if ($resize) {
100 $destImage = ImageCreateTrueColor($destWidth, $destHeight);
103 // ImageCopyResized($destImage, $srcImage, 0, 0, 0, 0, $destWidth, $destHeight, $srcWidth, $srcHeight);
104 // better quality but slower:
105 ImageCopyResampled($destImage, $srcImage, 0, 0, 0, 0, $destWidth, $destHeight, $srcWidth, $srcHeight);
107 if ($resize == 'jpeg') {
108 ImageJPEG($destImage, '', 75);
110 if ($resize == 'png') {
111 ImagePNG($destImage);
113 ImageDestroy($srcImage);
114 ImageDestroy($destImage);