| [ Index ] |
|
Code source de phpMyAdmin 2.10.3 |
1 <?php 2 /* $Id: browse_foreigners.php 10308 2007-04-20 16:41:22Z lem9 $ */ 3 // vim: expandtab sw=4 ts=4 sts=4: 4 /** 5 * display selection for relational field values 6 */ 7 8 /** 9 * Gets a core script and starts output buffering work 10 */ 11 require_once ('./libraries/common.lib.php'); 12 13 PMA_checkParameters(array('db', 'table', 'field')); 14 15 require_once ('./libraries/ob.lib.php'); 16 if ($cfg['OBGzip']) { 17 $ob_mode = PMA_outBufferModeGet(); 18 if ($ob_mode) { 19 PMA_outBufferPre($ob_mode); 20 } 21 } 22 require_once ('./libraries/header_http.inc.php'); 23 $field = urldecode($field); 24 25 /** 26 * Displays the frame 27 */ 28 $per_page = 200; 29 require_once ('./libraries/relation.lib.php'); // foreign keys 30 require_once ('./libraries/transformations.lib.php'); // Transformations 31 $cfgRelation = PMA_getRelationsParam(); 32 $foreigners = ($cfgRelation['relwork'] ? PMA_getForeigners($db, $table) : FALSE); 33 34 $override_total = TRUE; 35 36 if (!isset($pos)) { 37 $pos = 0; 38 } 39 40 $foreign_limit = 'LIMIT ' . $pos . ', ' . $per_page . ' '; 41 if (isset($foreign_navig) && $foreign_navig == $strShowAll) { 42 unset($foreign_limit); 43 } 44 45 require ('./libraries/get_foreign.lib.php'); 46 47 if (isset($pk)) { 48 $pk_uri = '&pk=' . urlencode($pk); 49 ?> 50 <input type="hidden" name="pk" value="<?php echo urlencode($pk); ?>" /> 51 <?php 52 } else { 53 $pk_uri = ''; 54 } 55 56 $gotopage = ''; 57 $showall = ''; 58 // $the_total comes from get_foreign.lib.php 59 60 if (isset($disp_row) && is_array($disp_row)) { 61 62 if ( $cfg['ShowAll'] && ($the_total > $per_page) ) { 63 $showall = '<input type="submit" name="foreign_navig" value="' . $strShowAll . '" />'; 64 } 65 66 $session_max_rows = $per_page; 67 $pageNow = @floor($pos / $session_max_rows) + 1; 68 $nbTotalPage = @ceil($the_total / $session_max_rows); 69 70 if ( $the_total > $per_page ) { 71 $gotopage = PMA_pageselector( 72 'browse_foreigners.php?field=' . urlencode($field) . 73 '&' . PMA_generate_common_url($db, $table) 74 . $pk_uri . 75 '&fieldkey=' . (isset($fieldkey) ? $fieldkey : '') . 76 '&foreign_filter=' . (isset($foreign_filter) ? htmlspecialchars($foreign_filter) : '') . 77 '&', 78 $session_max_rows, 79 $pageNow, 80 $nbTotalPage 81 ); 82 } 83 } 84 ?> 85 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 86 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 87 <html xmlns="http://www.w3.org/1999/xhtml" 88 xml:lang="<?php echo $available_languages[$lang][2]; ?>" 89 lang="<?php echo $available_languages[$lang][2]; ?>" 90 dir="<?php echo $text_dir; ?>"> 91 92 <head> 93 <title>phpMyAdmin</title> 94 <meta http-equiv="Content-Type" content="text/html; charset=<?php echo $charset; ?>" /> 95 <link rel="stylesheet" type="text/css" 96 href="./css/phpmyadmin.css.php?<?php echo PMA_generate_common_url( '', '' ); ?>&js_frame=right&nocache=<?php echo $_SESSION['PMA_Config']->getMtime(); ?>" /> 97 <script src="./js/functions.js" type="text/javascript" language="javascript"></script> 98 <script type="text/javascript" language="javascript"> 99 //<![CDATA[ 100 self.focus(); 101 function formupdate( field, key ) { 102 if (opener && opener.document && opener.document.insertForm) { 103 var field = 'field_' + field; 104 105 <?php if ( isset( $pk ) ) { ?> 106 var element_name = field + '[multi_edit][<?php echo urlencode( $pk ); ?>][]'; 107 <?php } else { ?> 108 var element_name = field + '[]'; 109 <?php } ?> 110 111 <?php if ( isset( $fieldkey ) && is_numeric($fieldkey) ) { ?> 112 var element_name_alt = field + '[<?php echo $fieldkey; ?>]'; 113 <?php } else { ?> 114 var element_name_alt = field + '[0]'; 115 <?php } ?> 116 117 if (opener.document.insertForm.elements[element_name]) { 118 // Edit/Insert form 119 opener.document.insertForm.elements[element_name].value = key; 120 self.close(); 121 return false; 122 } else if (opener.document.insertForm.elements[element_name_alt]) { 123 // Search form 124 opener.document.insertForm.elements[element_name_alt].value = key; 125 self.close(); 126 return false; 127 } 128 } 129 130 alert('<?php echo PMA_jsFormat($strWindowNotFound); ?>'); 131 } 132 //]]> 133 </script> 134 </head> 135 136 <body id="body_browse_foreigners"> 137 138 <form action="browse_foreigners.php" method="post"> 139 <fieldset> 140 <?php echo PMA_generate_common_hidden_inputs( $db, $table ); ?> 141 <input type="hidden" name="field" value="<?php echo urlencode($field); ?>" /> 142 <input type="hidden" name="fieldkey" 143 value="<?php echo isset($fieldkey) ? $fieldkey : ''; ?>" /> 144 <?php if ( isset( $pk ) ) { ?> 145 <input type="hidden" name="pk" value="<?php echo urlencode($pk); ?>" /> 146 <?php } ?> 147 <span class="formelement"> 148 <label for="input_foreign_filter"><?php echo $strSearch . ':'; ?></label> 149 <input type="text" name="foreign_filter" id="input_foreign_filter" 150 value="<?php echo isset($foreign_filter) ? htmlspecialchars($foreign_filter) : ''; ?>" /> 151 <input type="submit" name="submit_foreign_filter" value="<?php echo $strGo;?>" /> 152 </span> 153 <span class="formelement"> 154 <?php echo $gotopage; ?> 155 </span> 156 <span class="formelement"> 157 <?php echo $showall; ?> 158 </span> 159 </fieldset> 160 </form> 161 162 <table width="100%"> 163 <?php 164 if (isset($disp_row) && is_array($disp_row)) { 165 $header = '<tr> 166 <th>' . $strKeyname . '</th> 167 <th>' . $strDescription . '</th> 168 <td width="20%"></td> 169 <th>' . $strDescription . '</th> 170 <th>' . $strKeyname . '</th> 171 </tr>'; 172 173 echo '<thead>' . $header . '</thead>' . "\n" 174 .'<tfoot>' . $header . '</tfoot>' . "\n" 175 .'<tbody>' . "\n"; 176 177 $values = array(); 178 $keys = array(); 179 foreach ( $disp_row as $relrow ) { 180 if ($foreign_display != FALSE) { 181 $values[] = $relrow[$foreign_display]; 182 } else { 183 $values[] = ''; 184 } 185 186 $keys[] = $relrow[$foreign_field]; 187 } 188 189 asort( $keys ); 190 191 $hcount = 0; 192 $odd_row = true; 193 $val_ordered_current_row = 0; 194 $val_ordered_current_equals_data = false; 195 $key_ordered_current_equals_data = false; 196 foreach ( $keys as $key_ordered_current_row => $value ) { 197 //for ( $i = 0; $i < $count; $i++ ) { 198 $hcount++; 199 200 if ($cfg['RepeatCells'] > 0 && $hcount > $cfg['RepeatCells']) { 201 echo $header; 202 $hcount = 0; 203 $odd_row = true; 204 } 205 206 $key_ordered_current_key = $keys[$key_ordered_current_row]; 207 $key_ordered_current_val = $values[$key_ordered_current_row]; 208 209 $val_ordered_current_key = $keys[$val_ordered_current_row]; 210 $val_ordered_current_val = $values[$val_ordered_current_row]; 211 212 $val_ordered_current_row++; 213 214 if (PMA_strlen( $val_ordered_current_val ) <= $cfg['LimitChars']) { 215 $val_ordered_current_val = htmlspecialchars($val_ordered_current_val); 216 $val_ordered_current_val_title = ''; 217 } else { 218 $val_ordered_current_val_title = 219 htmlspecialchars( $val_ordered_current_val ); 220 $val_ordered_current_val = 221 htmlspecialchars( PMA_substr( $val_ordered_current_val, 0, 222 $cfg['LimitChars'] ) . '...' ); 223 } 224 if (PMA_strlen( $key_ordered_current_val ) <= $cfg['LimitChars']) { 225 $key_ordered_current_val = htmlspecialchars($key_ordered_current_val); 226 $key_ordered_current_val_title = ''; 227 } else { 228 $key_ordered_current_val_title = 229 htmlspecialchars( $key_ordered_current_val ); 230 $key_ordered_current_val = 231 htmlspecialchars( PMA_substr( $key_ordered_current_val, 0, 232 $cfg['LimitChars'] ) . '...' ); 233 } 234 235 if ( ! empty( $data ) ) { 236 $val_ordered_current_equals_data = $val_ordered_current_key == $data; 237 $key_ordered_current_equals_data = $key_ordered_current_key == $data; 238 } 239 240 ?> 241 <tr class="<?php echo $odd_row ? 'odd' : 'even'; $odd_row = ! $odd_row; ?>"> 242 <td nowrap="nowrap"> 243 <?php 244 echo ($key_ordered_current_equals_data ? '<b>' : '') 245 .'<a href="#" title="' . $strUseThisValue 246 . ($key_ordered_current_val_title != '' ? ': ' . $key_ordered_current_val_title : '') . '"' 247 .' onclick="formupdate(\'' . md5($field) . '\', \'' 248 . htmlspecialchars($key_ordered_current_key) . '\'); return false;">' 249 .htmlspecialchars($key_ordered_current_key) . '</a>' . ($key_ordered_current_equals_data ? '</b>' : ''); 250 ?></td> 251 <td> 252 <?php 253 echo ($key_ordered_current_equals_data ? '<b>' : '') 254 . '<a href="#" title="' . $strUseThisValue . ($key_ordered_current_val_title != '' ? ': ' 255 . $key_ordered_current_val_title : '') . '" onclick="formupdate(\'' 256 . md5($field) . '\', \'' . htmlspecialchars($key_ordered_current_key) . '\'); return false;">' 257 . $key_ordered_current_val . '</a>' . ($key_ordered_current_equals_data ? '</b>' : ''); 258 ?></td> 259 <td width="20%"> 260 <img src="<?php echo $GLOBALS['pmaThemeImage'] . 'spacer.png'; ?>" 261 alt="" width="1" height="1"></td> 262 263 <td> 264 <?php 265 echo ($val_ordered_current_equals_data ? '<b>' : '') 266 . '<a href="#" title="' . $strUseThisValue . ($val_ordered_current_val_title != '' ? ': ' 267 . $val_ordered_current_val_title : '') . '" onclick="formupdate(\'' . md5($field) 268 . '\', \'' . htmlspecialchars($val_ordered_current_key) . '\'); return false;">' 269 . $val_ordered_current_val . '</a>' . ($val_ordered_current_equals_data ? '</b>' : ''); 270 ?></td> 271 <td nowrap="nowrap"> 272 <?php 273 echo ($val_ordered_current_equals_data ? '<b>' : '') . '<a href="#" title="' 274 . $strUseThisValue . ($val_ordered_current_val_title != '' ? ': ' . $val_ordered_current_val_title : '') 275 . '" onclick="formupdate(\'' . md5($field) . '\', \'' 276 . htmlspecialchars($val_ordered_current_key) . '\'); return false;">' . htmlspecialchars($val_ordered_current_key) 277 . '</a>' . ($val_ordered_current_equals_data ? '</b>' : ''); 278 ?></td> 279 </tr> 280 <?php 281 } // end while 282 } 283 ?> 284 </tbody> 285 </table> 286 287 </body> 288 </html> 289 290 <?php 291 /** 292 * Close MySql connections 293 */ 294 if (isset($controllink) && $controllink) { 295 @PMA_DBI_close($controllink); 296 } 297 if (isset($userlink) && $userlink) { 298 @PMA_DBI_close($userlink); 299 } 300 301 302 /** 303 * Sends bufferized data 304 */ 305 if (isset($cfg['OBGzip']) && $cfg['OBGzip'] 306 && isset($ob_mode) && $ob_mode) { 307 PMA_outBufferPost($ob_mode); 308 } 309 ?>
titre
Description
Corps
titre
Description
Corps
titre
Description
Corps
titre
Corps
| Généré le : Mon Nov 26 15:18:20 2007 | par Balluche grâce à PHPXref 0.7 |
|
|