1 <html xmlns:py="http://genshi.edgewall.org/" xmlns:xi="http://www.w3.org/2001/XInclude" py:strip="">
3 <py:def function="page_rss">${rss_news}</py:def>
4 <py:def function="page_rss_title">phpMyAdmin project news</py:def>
6 <div py:match="content" id="body">
8 <xi:include href="_littleboxes.tpl" />
13 phpMyAdmin is a free software tool written in <a href="http://php.net">PHP</a>
14 intended to handle the administration of <a href="http://mysql.com">MySQL</a>
15 over the World Wide Web. phpMyAdmin supports a wide range of operations with
16 MySQL. The most frequently used operations are supported by the user interface
17 (managing databases, tables, fields, relations, indexes, users, permissions,
18 etc), while you still have the ability to directly execute any SQL statement.
21 <div class="bookbanner">
22 <a href="${base_url}docs.${file_ext}#books" id="fader">
23 <img src="images/books/pma_en_3.3_113x149.jpg" alt="phpMyAdmin book" />
24 <img src="images/books/pma_en_100x123.png" alt="phpMyAdmin book" />
25 <img src="images/books/pma_cz_90x122.jpg" alt="phpMyAdmin book" />
26 <img src="images/books/pma_es_100x123.png" alt="phpMyAdmin book" />
31 phpMyAdmin comes with a wide range of <a
32 href="${base_url}docs.${file_ext}">documentation</a> and users are welcome to
33 update <a href="http://wiki.phpmyadmin.net/">our wiki pages</a> to share ideas and
34 howtos for various operations. The <a
35 href="${base_url}team.${file_ext}">phpMyAdmin team</a> will try to help you if
36 you face any problem, you can use <a
37 href="${base_url}support.${file_ext}">variety of support channels</a> to get
42 phpMyAdmin is also very deeply documented in a book written by one of developers
43 – <a href="${base_url}docs.${file_ext}#books">Mastering phpMyAdmin for
44 Effective MySQL Management</a>, which is available in English, Czech and Spanish.
48 To ease usage to a wide range of people, phpMyAdmin is translated into <a
49 href="${base_url}translations.${file_ext}">65 languages</a> and supports both LTR
54 Since version 3.0.0, phpMyAdmin joined the <a
55 href="${base_url}gophp5.${file_ext}">GoPHP5 initiative</a> and dropped
56 compatibility code for older PHP and MySQL versions; version 3 and later requires
57 at least PHP 5.2 and MySQL 5.
61 phpMyAdmin has won several <a href="${base_url}awards.${file_ext}">awards</a>.
62 Among others, it was chosen as the best PHP application in various awards and
63 has won every year the SourceForge.net Community Choice Awards as "Best Tool or Utility for SysAdmins".
67 phpMyAdmin is a thirteen-year-old project with a stable and flexible code
68 base, to find out more about the project and its history see <a
69 href="${base_url}about.${file_ext}">separate page</a>.
72 <div class="floatbox">
75 <li>Intuitive web interface</li>
76 <li>Support for most MySQL features:
78 <li>browse and drop databases, tables, views, fields and indexes</li>
79 <li>create, copy, drop, rename and alter databases, tables, fields and
81 <li>maintenance server, databases and tables, with proposals on server
83 <li>execute, edit and bookmark any
84 <abbr title="structured query language">SQL</abbr>-statement, even
86 <li>manage MySQL users and privileges</li>
87 <li>manage stored procedures and triggers</li>
91 <abbr title="comma separated values">CSV</abbr> and
92 <abbr title="structured query language">SQL</abbr>
94 <li>Export data to various formats:
95 <abbr title="comma separated values">CSV</abbr>,
96 <abbr title="structured query language">SQL</abbr>,
97 <abbr title="Extensible Markup Language">XML</abbr>,
98 <abbr title="Portable Document Format">PDF</abbr>,
99 <abbr title="International Organization for Standards">ISO</abbr>/<abbr
100 title="International Electrotechnical Commission">IEC</abbr> 26300 -
101 OpenDocument Text and Spreadsheet,
102 <abbr title="Microsoft Word 2000">Word</abbr>,
103 L<sup>A</sup>T<sub><big>E</big></sub>X
106 <li>Administering multiple servers</li>
107 <li>Creating <abbr title="Portable Document Format">PDF</abbr> graphics of
108 your database layout</li>
109 <li>Creating complex queries using Query-by-example (QBE)</li>
110 <li>Searching globally in a database or a subset of it</li>
111 <li>Transforming stored data into any format using a set of predefined
112 functions, like displaying BLOB-data as image or download-link
114 <li>And much more...</li>
118 <div class="floatbox hslice" id="latest-news">
119 <h2 class="entry-title"><a href="${base_url}news.${file_ext}">Latest News</a></h2>
121 <li py:for="item in short_news">
122 <a href="${base_url}news.${file_ext}#${item.anchor}">${item.title}</a> (${item.date})
125 <p class="signature"><a href="${base_url}news.${file_ext}">...more news.</a></p>
128 <div class="floatbox hslice" id="latest-blogs">
129 <h2 class="entry-title"><a href="http://planet.phpmyadmin.net/">Latest Posts in Developers Blogs</a></h2>
131 <li py:for="item in short_blogs">
132 <a href="${item.link}">${item.title}</a> (${item.date})
135 <p class="signature"><a href="http://planet.phpmyadmin.net/">...more blogs.</a></p>
138 <div class="clearer"></div>
142 <xi:include href="_page.tpl" />