Server IP : 180.180.241.3 / Your IP : 216.73.216.252 Web Server : Microsoft-IIS/7.5 System : Windows NT NETWORK-NHRC 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586 User : IUSR ( 0) PHP Version : 5.3.28 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/AppServ/www/app/webroot/phpMyAdmin/a/doc/doctrees/ |
Upload File : |
€cdocutils.nodes document q)q}q(U nametypesq}q(X manual pageqˆX transformationsqˆX introductionqNX file structureq NX mysql_fetch_field()q ˆX link sectionqˆX transformationshowtoqˆX usageq NX transformationsintroqˆX transformationsfilesqˆuUsubstitution_defsq}qUparse_messagesq]qcdocutils.nodes system_message q)q}q(U rawsourceqU Uparentqcdocutils.nodes section q)q}q(hU U referencedqKhhUsourceqcdocutils.nodes reprunicode qXI /opt/pma-git/phpmyadmin/release/phpMyAdmin-4.0.10/doc/transformations.rstq…q }q!bUexpect_referenced_by_nameq"}q#hcdocutils.nodes target q$)q%}q&(hX .. _transformations:q'hhhh Utagnameq(Utargetq)U attributesq*}q+(Uidsq,]q-Ubackrefsq.]q/Udupnamesq0]q1Uclassesq2]q3Unamesq4]q5Urefidq6Utransformationsq7uUlineq8KUdocumentq9hUchildrenq:]q;ubsh(Usectionq<h*}q=(h0]q>X transformationsq?ah2]q@h.]qAh,]qB(h7Uid1qCeh4]qDhauh8Kh9hUexpect_referenced_by_idqE}qFh7h%sh:]qG(cdocutils.nodes title qH)qI}qJ(hX TransformationsqKhhhh h(UtitleqLh*}qM(h0]qNh2]qOh.]qPh,]qQh4]qRuh8Kh9hh:]qScdocutils.nodes Text qTX TransformationsqU…qV}qW(hhKhhIubaubh$)qX}qY(hX .. _transformationsintro:qZhhhh h(h)h*}q[(h,]q\h.]q]h0]q^h2]q_h4]q`h6Utransformationsintroqauh8Kh9hh:]qbubh)qc}qd(hU hhhh h"}qehhXsh(h<h*}qf(h0]qgh2]qhh.]qih,]qj(Uintroductionqkhaeh4]ql(hheuh8K h9hhE}qmhahXsh:]qn(hH)qo}qp(hX Introductionqqhhchh h(hLh*}qr(h0]qsh2]qth.]quh,]qvh4]qwuh8K h9hh:]qxhTX Introductionqy…qz}q{(hhqhhoubaubcdocutils.nodes paragraph q|)q}}q~(hX To enable transformations, you have to setup the ``column_info`` table and the proper directives. Please see the :ref:`config` on how to do so.qhhchh h(U paragraphq€h*}q(h0]q‚h2]qƒh.]q„h,]q…h4]q†uh8Kh9hh:]q‡(hTX1 To enable transformations, you have to setup the qˆ…q‰}qŠ(hX1 To enable transformations, you have to setup the q‹hh}ubcdocutils.nodes literal qŒ)q}qŽ(hX ``column_info``qh*}q(h0]q‘h2]q’h.]q“h,]q”h4]q•uhh}h:]q–hTX column_infoq—…q˜}q™(hU hhubah(UliteralqšubhTX1 table and the proper directives. Please see the q›…qœ}q(hX1 table and the proper directives. Please see the qžhh}ubcsphinx.addnodes pending_xref qŸ)q }q¡(hX :ref:`config`q¢hh}hh h(Upending_xrefq£h*}q¤(Ureftypeq¥X refq¦Urefwarnq§ˆU reftargetq¨X configq©U refdomainqªX stdq«h,]q¬h.]qUrefexplicitq®‰h0]q¯h2]q°h4]q±Urefdocq²Utransformationsq³uh8Kh:]q´cdocutils.nodes emphasis qµ)q¶}q·(hh¢h*}q¸(h0]q¹h2]qº(Uxrefq»h«X std-refq¼eh.]q½h,]q¾h4]q¿uhh h:]qÀhTX configqÁ…qÂ}qÃ(hU hh¶ubah(UemphasisqÄubaubhTX on how to do so.qÅ…qÆ}qÇ(hX on how to do so.qÈhh}ubeubh|)qÉ}qÊ(hXË You can apply different transformations to the contents of each column. The transformation will take the content of each column and transform it with certain rules defined in the selected transformation.qËhhchh h(h€h*}qÌ(h0]qÍh2]qÎh.]qÏh,]qÐh4]qÑuh8Kh9hh:]qÒhTXË You can apply different transformations to the contents of each column. The transformation will take the content of each column and transform it with certain rules defined in the selected transformation.qÓ…qÔ}qÕ(hhËhhÉubaubh|)qÖ}q×(hXà Say you have a column 'filename' which contains a filename. Normally you would see in phpMyAdmin only this filename. Using transformations you can transform that filename into a HTML link, so you can click inside of the phpMyAdmin structure on the column's link and will see the file displayed in a new browser window. Using transformation options you can also specify strings to append/prepend to a string or the format you want the output stored in.qØhhchh h(h€h*}qÙ(h0]qÚh2]qÛh.]qÜh,]qÝh4]qÞuh8Kh9hh:]qßhTXà Say you have a column 'filename' which contains a filename. Normally you would see in phpMyAdmin only this filename. Using transformations you can transform that filename into a HTML link, so you can click inside of the phpMyAdmin structure on the column's link and will see the file displayed in a new browser window. Using transformation options you can also specify strings to append/prepend to a string or the format you want the output stored in.qà…qá}qâ(hhØhhÖubaubh|)qã}qä(hX´ For a general overview of all available transformations and their options, you can consult your *<www.your-host.com>/<your-install- dir>/transformation\_overview.php* installation.qåhhchh h(h€h*}qæ(h0]qçh2]qèh.]qéh,]qêh4]qëuh8Kh9hh:]qì(hTX` For a general overview of all available transformations and their options, you can consult your qí…qî}qï(hX` For a general overview of all available transformations and their options, you can consult your qðhhãubhµ)qñ}qò(hXF *<www.your-host.com>/<your-install- dir>/transformation\_overview.php*qóh*}qô(h0]qõh2]qöh.]q÷h,]qøh4]qùuhhãh:]qúhTXC <www.your-host.com>/<your-install- dir>/transformation_overview.phpqû…qü}qý(hU hhñubah(hÄubhTX installation.qþ…qÿ}r (hX installation.r hhãubeubh|)r }r (hX¥ For a tutorial on how to effectively use transformations, see our `Link section <http://www.phpmyadmin.net/home_page/docs.php>`_ on the official phpMyAdmin homepage.r hhchh h(h€h*}r (h0]r h2]r h.]r h,]r h4]r uh8Kh9hh:]r (hTXB For a tutorial on how to effectively use transformations, see our r …r }r (hXB For a tutorial on how to effectively use transformations, see our r hj ubcdocutils.nodes reference r )r }r (hX>