<?php echo isset($_SERVER['SCRIPT_URI']) ? $_SERVER['SCRIPT_URI'] : $_SERVER["SCRIPT

// Implemenation: pass image id and tb (table) using tags displayed in phpMyEdit form. // Usage outside this phpMyEdit form:

$id = array_key_exists('id',$_GET) ? $_GET['id'] : ''; $opts['tb'] = array_key_exists('tb',$_GET) ? $_GET['tb'] : ''; if(is_numeric($id) && !empty($opts['tb'])){ $opts['hn'] = $_SERVER['DOCUMENT_ROOT'] == '/apache/htdocs' ? '127.0.0.1' : 'localhost'; $opts['db'] = 'domain_com'; $opts['un'] = 'username'; $opts['pw'] = 'passwrd'; @mysql_pconnect($opts['hn'],$opts['un'],$opts['pw']) or die ('Unable to connect'); @mysql_select_db($opts['db']) or die('Database not selected'); $res = @mysql_query('SELECT image, image_type2 FROM '.$opts['tb'].' WHERE id = '.$id); $data = @mysql_result($res,0,'image'); $type = @mysql_result($res,0,'image_type2'); Header("Content-type: $type"); echo $data; } ?> * * * * * * * * * * * * * * * * * * * * * * * * */ ob_start('ob_gzhandler'); ### Begin configuration ### $opts['tb'] = 'vs_images1'; $opts['hn'] = $_SERVER['DOCUMENT_ROOT'] == '/apache/htdocs' ? '127.0.0.1' : 'localhost'; $opts['db'] = 'domain_com'; $opts['un'] = 'username'; $opts['pw'] = 'passwrd'; // You probably do not need this switch(): switch($_SERVER["DOCUMENT_ROOT"]) { Case '/apache/htdocs': error_reporting(E_ALL & ~E_NOTICE); break; default: error_reporting(0); break; }; // $opts['logtable'] = 'vs_change_log'; /** * To display "thumbs" instead of full-size images * in List mode, set: $resize_images = 1; */ $resize_images = 0; $resize_height = 32; // max. height for "thumbs" (pixels) /** * Prevent users from uploading images having a * width greater than $max_image_width pixels, or * height greater than $max_image_height pixels. */ $max_image_width = 640; $max_image_height = 480; /** * $form_title in H3 tag below the phpMyEdit form: */ $form_title = 'upload images'; /** * Path/filename of stylesheet */ $stylesheet = 'style/blue.php'; $cfg['bdr_bottom'] = 1; // See /style/blue.php ### End configuration ### ?> <?php echo isset($_SERVER['SCRIPT_URI']) ? $_SERVER['SCRIPT_URI'] : $_SERVER["SCRIPT_FILENAME"]; ?> '; ?>

'.$oper_label.'

true, 'query' => true, 'sort' => true, 'tabs' => false, 'time' => false); $opts['inc'] = 5; $opts['key'] = 'id'; $opts['key_type'] = 'int'; $opts['language'] = $HTTP_SERVER_VARS['HTTP_ACCEPT_LANGUAGE']; $opts['multiple'] = '4'; $opts['navigation'] = 'TUD'; $opts['options'] = 'CVDFL'; // ACPVDFL $opts['sort_field'] = array('-id'); $opts['fdd']['id'] = array( 'css' => array('postfix' => 'right-align'), 'default' => '0', 'input' => 'R', 'maxlen' => 11, 'name' => 'ID', 'options' => 'VDFL', 'required' => true, 'select' => 'T', 'tab' => 'Caption', 'sort' => true ); $opts['fdd']['image_caption'] = array( 'help|ACP' => 'Limit 255 chars.', 'input' => '', 'maxlen' => 255, 'name' => 'Caption', 'options' => 'CVDFL', 'required' => true, 'select' => 'T', 'sqlw' => 'TRIM("$val_as")', 'sort' => true ); $opts['fdd']['image_caption']['sql|LF'] = 'if(image_caption = "", concat("-"), image_caption)'; /* ### DO NOT DISPLAY BINARY DATA ### $opts['fdd']['image'] = array( 'help|ACP' => 'Limit 16,777,215 chars.', 'input' => 'R', 'maxlen' => 16777215, 'name' => 'Image', 'options' => '', 'required' => true, 'select' => 'T', 'sqlw' => 'TRIM("$val_as")', 'strip_tags|LF' => true, 'tab' => 'Image', 'textarea' => array('rows' => '5', 'cols' => '110'), 'trimlen|LF' => 30, 'sort' => false ); */ $opts['fdd']['image_type1'] = array( 'default' => '0', 'help|ACP' => 'Limit 2 digits', 'input' => 'R', 'maxlen' => 2, 'options' => 'VDFL', 'required' => true, 'select' => 'D', 'sqlw' => 'TRIM("$val_as")', 'sort' => true ); $opts['fdd']['image_type1']['values2'] = array( '0' => 'None', '1' => 'GIF', '2' => 'JPG', '3' => 'PNG', '4' => 'SWF', '5' => 'PSD', '6' => 'BMP', '7' => 'TIFF (Intel)', '8' => 'TIFF (Motorola)', '9' => 'JPC', '10' => 'JP2', '11' => 'JPX', '12' => 'JB2', '13' => 'SWC', '14' => 'IFF', '15' => 'WBMP', '16' => 'XBM' ); $opts['fdd']['image_type1']['escape'] = false; if($resize_images > 0 && empty($operation)){ $opts['fdd']['image_type1']['sql|L'] = 'if(image_type1 > 0, concat("

'Limit 20 chars.', 'input' => 'R', 'maxlen' => 20, 'name' => 'Type', 'options' => 'VD', 'required' => true, 'select' => 'D', 'sqlw' => 'TRIM("$val_as")', 'sort' => true ); $opts['fdd']['image_width'] = array( 'css' => array('postfix' => 'right-align'), 'default' => '0', 'help|ACP' => 'Limit 6 digits', 'input' => 'R', 'maxlen' => 6, 'name' => 'Width', 'options' => 'VD', 'required' => true, 'select' => 'T', 'sqlw' => 'TRIM("$val_as")', 'tab' => 'Details', 'sort' => true ); $opts['fdd']['image_height'] = array( 'css' => array('postfix' => 'right-align'), 'default' => '0', 'help|ACP' => 'Limit 6 digits', 'input' => 'R', 'maxlen' => 6, 'name' => 'Height', 'options' => 'VD', 'required' => true, 'select' => 'T', 'sqlw' => 'TRIM("$val_as")', 'sort' => true ); $opts['fdd']['img_attrib'] = array( 'help|ACP' => 'Limit 30 chars.', 'input' => 'R', 'maxlen' => 30, 'name' => '', 'options' => 'VDFL', 'required' => true, 'sqlw' => 'TRIM("$val_as")', 'sort' => false ); // Possible IMG tag attributes: id, class, title, style, onclick, ondblclick, onmousedown, onmouseup, onmouseover, onmousemove, onmouseout, onkeypress, onkeydown, onkeyup, ismap, usemap, // Usual IMG tag attributes: align, alt, border, hspace, vspace, width, height $opts['fdd']['img_attrib']['sql|LVD'] = 'if(img_attrib > "", concat(" $\"",image_caption,"\"$ "),"")'; // The 'hidden' field may not be relevant to your application: $opts['fdd']['hidden'] = array( 'default' => '0', 'help|ACP' => 'Select', 'input' => '', 'maxlen' => 1, 'name' => 'Hidden', 'options' => 'CVDF', 'required' => true, 'select' => 'D', 'sqlw' => 'TRIM("$val_as")', 'sort' => true ); $opts['fdd']['hidden']['values2'] = array('0' => 'No', '1' => 'Yes'); $opts['fdd']['updated'] = array( 'datemask' => 'Y-m-d H:i:s', 'help|ACP' => 'Timestamp', 'input' => 'R', 'maxlen' => 14, 'name' => 'Updated', 'nowrap' => true, 'options' => 'VD', 'required' => false, 'select' => 'N', 'sqlw' => 'TRIM("$val_as")', 'tab' => 'Updated', 'sort' => true ); require('phpMyEdit.class.php'); new phpMyEdit($opts); ?>

' : 'To display "thumbs" instead of full-size images in List mode, set: $resize_images = 1;
'; ?> Click "V" to view an image, "D" to delete, or "C" to change captions.

0){ $success = 0; if(!$dbl = @mysql_pconnect($opts['hn'],$opts['un'],$opts['pw'])) { die ('

Unable to connect

'); } if(!@mysql_select_db($opts['db'])) { die('

Database not selected

'); } while(list($key,$val) = each($_POST)){ $$key = stripslashes(trim(strip_tags($val))); } echo "\n".'

Upload results for '.$opts['db'].'.'.$opts['tb'].' . . .

'; echo "\n".'

'; $image_caption = array_key_exists('image_caption',$_POST) ? htmlspecialchars(strip_tags(stripslashes(trim($_POST['image_caption'])))) : ''; list($image_width, $image_height, $image_type1, $img_attrib) = getimagesize($form_data); $errors = array(); if($image_width > $max_image_width){ $errors[] = 'The image width exceeds the allowed width of '.$max_image_width. ' pixels by '.($image_width-$max_image_width).' pixels'; } if($image_height > $max_image_height){ $errors[] = 'The image height exceeds the allowed height of '.$max_image_height. ' pixels by '.($image_height-$max_image_height).' pixels'; } if(!$data = addslashes(@fread(@fopen($form_data, "r"), filesize($form_data)))){ $errors[] = 'No file specified, or unable to read file'; } if(count($errors) > 0){ echo "\n".'

'.$errors[$i].'

'; echo "\n".'

'; }elseif($data = addslashes(@fread(@fopen($form_data, "r"), filesize($form_data)))) { $qry = sprintf("INSERT INTO {$opts['tb']} (image, image_caption, image_width, image_height, image_type1, image_type2, img_attrib) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s')", $data, addslashes($image_caption), $image_width, $image_height, $image_type1, $form_data_type, addslashes($img_attrib)); $res = @mysql_query($qry); $id = @mysql_insert_id(); if(!$id || !$res) { echo '

Upload failed.

No insert ID returned.
Query: '.$qry.'

'.mysql_error().'

'; }else{ echo "\n".'

Do not re-load this page.

'; echo "\n".'

Image ID #'.$id.'

'; echo $image_caption != '' ? '

'.stripslashes($image_caption).'

' : '

Caption omitted

'; echo '

'."\n".'

'.stripslashes($image_caption).'

'; $success = 1; } }else{ echo '

Query failed.

Query: '.$qry.'

'.mysql_error().'

'; } echo "\n".''; echo "\n".'

'; echo "\n".'Go Back'; echo "\n".' | '; echo "\n".'List images'; echo $success > 0 ? "\n".' | Edit caption' : ''; echo "\n".'

'; }; ?>

Caption
Image

Caption (recommended) becomes the alt="" attribute for the <IMG> tag. The Browse facilitates selecting an image on your computer. Click on Submit after an image has been selected. As currently configured, image files must not be wider than pixels, nor taller than pixels. Recommended file types: web-optimized GIF, JPG, or PNG. Allowed file types: BMP, GIF, IFF, JB2, JP2, JPC, JPG, JPX, PNG, PSD, SWC, SWF, TIFF, WBMP, XBM.