I would like to take part in this year's Google Summer of Code to
implement the User Preferences proposal. I took part in GSoC two years
ago, implementing phpMyAdmin's new setup script, which I hope works as
intended :) Currently I am on the first year of postgraduate course
for master's degree on Poznań University of Technology, specialization
- Data Processing Technologies.
In accordance with project proposal, all settings would be stored in
pmadb, with an option for easy export and import. User will be able to
change all relevant PMA features which do not affect performance or
security settings. After taking a quick glance at config.default.php I
believe these settings should be considered for customization:
* DROP confirmations
* show executed sql (ShowSql)
* LeftFrame*, table comments in tooltips
* displayed rows
* INSERT form customization
* default files (DefaultTab*)
* maybe export/import default options?
* MySQL manual type
* window title
* SQL Query box settings
* hiding some tabs under one drop-down menu (eg. I have never used
Designer or Query by example for database / Import for single table)
because of the size limit , i am resending the my previous mail but this
time in place of attaching the image i am providing a URL
URL for image:
PFA with this mail
as marc Suggested that we should discuss the design with the help of an
so i have made a mock schema with three tables artist,song and sings.details
u can see in the diagram with this mail.
i know The Design which i have developed till now is just the beginning
draft , lot of discussion and thought has to be put to finalize the design
Its my Bad to miss the having clause,we can put it in with the Group By
option in menu bar(see the diagram).
I got a comment from Michal cihar that this time phpMyadmin is selecting
only those students who have contributed something before,but i have not
contributed to phpmyadmin till now.
But i am willing to contribute can anyone please suggest me some bugs to
fix and which can be done in the given timeline also please tell where to
find documentation for developers,explaining overall structure
2010/3/31 ANKIT GUPTA <ankitatbits(a)gmail.com>
> PFA with this mail
> as marc Suggested that we should discuss the design with the help of an
> so i have made a mock schema with three tables artist,song and
> sings.details u can see in the diagram with this mail.
> i know The Design which i have developed till now is just the beginning
> draft , lot of discussion and thought has to be put to finalize the design
> with functionality.
> Its my Bad to miss the having clause,we can put it in with the Group By
> option in menu bar(see the diagram).
> I got a comment from Michal cihar that this time phpMyadmin is selecting
> only those students who have contributed something before,but i have not
> contributed to phpmyadmin till now.
> But i am willing to contribute can anyone please suggest me some bugs to
> fix and which can be done in the given timeline also please tell where to
> find documentation for developers,explaining overall structure
> Ankit Gupta
> ---------- Forwarded message ----------
> From: Michal Čihař <michal(a)cihar.com>
> Date: Wed, Mar 31, 2010 at 7:39 PM
> Subject: Re: [Phpmyadmin-devel] [Phpmyadmin] Interested in Participating in
> GSoC 2010
> To: phpmyadmin-devel(a)lists.sourceforge.net
> Dne Tue, 30 Mar 2010 23:06:43 +0530
> ANKIT GUPTA <ankitatbits(a)gmail.com> napsal(a):
> > i have already tried that command but it is also not working,i am getting
> > following error
> > fatal:unable to connect a socket (connection timed out).
> > I also want to discuss about the design for visual query designer,i have
> > thought of some points like
> > to add an option button with each selected attribute of table where we
> > will have a menu bar with following fields GROUP ,ORDER ,Rename and
> > As user selects option from this menu bar other boxes/options will
> > appear as the case is.
> > i am planing to implement select from clause,joins,group by order by and
> > various aggregate function in query builder.you can check further details
> > my Gscoc Application .
> > please suggest any other functionality which we can add or any
> > features in the design.
> You did not explicitely mention HAVING clause...
> Michal Čihař | http://cihar.com | http://blog.cihar.com
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> Phpmyadmin-devel mailing list
For the last few hours, I've been trying to use jQuery to implement
pagination via AJAX in phpMyAdmin. The page I've selected for
experimenting is the sql.php page, where one can view a table from a
the DOM via the $GLOBALS['js_include'] array, and bound an AJAX call
on the navigation buttons.
When I execute the call for a particular table, sql.php replies with
the results for the next 30 rows, but it also outputs a lot of other
html. As a way around this, I plan to use a variable 'ajax_request',
which is set to true when an AJAX call is being made, and accordingly,
wrote the jQuery script. If ajax_request is set to true in $_POST, I
will modify the output of sql.php and print only the table containing
the data from the table, the profiling data, (and any other necessary
part) and prevent the printing of the header, footer and other tabs.
However, due to the sanitization of $_GET, $_POST and $_REQUEST, I am
unable to access the variable.
I tried adding the variable name to variables_whitelist and the
array_list arrays in libraries/common.inc.php, but I guess those are
the wrong places. Could someone please tell me where I'm going wrong,
or which is the right php file/function to check?
Ninad S. Pundalik
GPG Key Fingerprint: 2DF7 B856 C75E C9F9 0504 C0EF D456 1946 7C45 2C69
Im from University of Moratuwa, Sri Lanka and I'm really exited on getting a
chance to contribute with phpMyAdmin since it's a really popular software.
Im interested in developing the idea : *Export relations scheme to other
*It will be very useful if the relations schemes can be exported to other
formats such as dia files, which are much more suitable for inclusion in
*I have experience in working with PHP and MySQL. i have been using these
languages for my University projects.*
*Please provide me further info on this project, I appreciate all the
assistance I can get because I want to participate in GSoC 2010 with a
project for this community.*
I'm highly interested in the GSoC project "User interface cleanup".
A little bit about me: My name is Silvan Troxler. I'm studying
computer science at the university of Zurich (Switzerland) and working
as a freelance web developer in my spare time. I also worked for an
internet agency for 18 months before I started studying. My task there
was to build websites and test them in different browsers. In general
some other things). Plus I'm a long time phpMyAdmin user (at least
five years) and a long time phpMyAdmin theme hater ;-) I'm more a
programmer than an excellent designer. But I have an eye for
aesthetics and appreciate sleek, minimal and self-explaining designs
(as phpMyAdmin should have one). I also would love to express myself
in such a well-known project as phpMyAdmin and learn even more about
graphics, usability and accessability. I started working with web
sites back in 2002.
Back to the project: I plan to implement a template engine into
phpMyAdmin as a starting point. This will simiplify the further
development of the GUI and make it much easier to work with AJAX. For
example with the template engine Smarty I made good experience and use
it almost everytime. Especially as of version 3 Smarty is very easy to
use and implement. Do you have other proposals for another template
engine as well? As a further point I would love to get rid of the
frames in PMA. With a template engine, this would be not that hard.
And of course the UI will be cleaned up but I don't yet have any
If you are interested in my coding style you may have a look at a
project I was developing the last six weeks for an university project.
It is some kind of bug tracking system which can be integrated in
existing websites and collects all PHP errors which occur. With this
you can for example collect all E_STRICT errors which where hidden on
the web server. It also features a overview page for all errors which
occurred with an easy search interface (similar to the one of trac).
Consider this application as a veeeery alpha one which needs much of
cleaning before beeing usable. This project uses JQuery and Smarty.
http://silvantroxler.ch/gsoc/mdudu-0.0.1a.zip (about 360KB)
Thanks for your replies and your work on PMA
ps: I have to do some kind of internship for the university and GSoC
counts as one, so it would be great if I could be a part of this years
extending/improving of PMA :)
I'm Yian, currently an undergrad at UC Berkeley. I am interested in
participating in phpMyAdmin's GSoC this year as I've used phpMyAdmin for
many years (on a number of web applications) and would like to finally make
I've looked through the list of project ideas and the source code, and I
find that I'm most interested in working on exporting the relations schema
to other formats. I'll start going through the source code a bit more and
perhaps think about how to export schemas to dia or svg.
Out of curiosity, would exporting the schema to dia involve only exporting
the structure whereas exporting to svg might have the data (organized in
some user-specified way, like maybe by summing certain fields together for
everything with the same X)?
in libraries/messages.inc.php we have
$strCreateTableShort = _pgettext('$strCreateTableShort', 'Create table');
This gives a good result for all languages I tried, except English (US).
Hi everyone. My name is Gustavo, a phd student from Brazil, and I'm also
interested in participate into gsoc.
I became interested in the topics provided by Helmo. Does anyone else have
subscribe to these topics? Where I can find Helmo to discuss about it?
MySQLTuner is a script written in Perl that will assist you with your
MySQL configuration and make recommendations for increased performance
and stability. Within seconds, it will display statistics about your
MySQL installation and the areas where it can be improved. More info
I am currently porting this script into a PHP class, that will have
these public functions -
- get_engine_tuneups (not yet ready)
I wanted to see if there is some interest from the PMA developers in
integerating this into PMA. Currently there are tabs to show the
variables and status counters (server_status.php and
server_variables.php). I was thinking of a server_tuneups.php script
that would print out tuning recommendations.
This is not a GSoC project.
Let me know what you think.