March 2010 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Charts in server status page
by Akash Chauhan 23 Mar '10

23 Mar '10

Hi my name is Akash Chauhan , and I am a 3rd year student of National Institute of Technology Trichy India, also I am member of development team of a project called connectnit.org which connects all the NIT's at one place, also I am member of my college's webdesigning team. I am interested in GSOC 2010 . As having good experience in php and mysql i was happy to see PMA in it ,when I was looking at the ideas of PMA and I am interested in the idea CHARTs for server status using GD2 and would like to contribute for the same. I will be updating all my works at my blog http://connectnit.org/blogs/cipher/

1 0

Re: [Phpmyadmin-devel] [Phpmyadmin-users] phpMyAdmin wont start
by Dieter Adriaenssens 23 Mar '10

23 Mar '10

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 2010/3/23 ayman bs : > I do apologize Marc, I thought Gmail will automatically choose the mailing > list address. > Jim, Usually the "it works" problem comes when you point your browser to a > proxy server... > > Check it. A default Apache install (in debian/Ubuntu) puts a html-file in the webroot, with the message 'It works!' as well. ;) It's just a message telling you that your webserver was installed and configured correctly, and is up and running. Greets, Dieter > > On Tue, Mar 23, 2010 at 1:04 PM, Marc Delisle wrote: >> >> ayman bs a écrit : >>> >>> Usually the "it works" problem comes when you point your browser to a >>> proxy server... >>> >> >> I am not the one who has this problem. Please reply to the list. >> >>> >>> >>> >>> On Tue, Mar 23, 2010 at 11:28 AM, Marc Delisle >> > wrote: >>> >>> Jim Weidner -- K2JXW / ARLHS a écrit : >>> > I downloaded and installed XAMPP, >>> > The control box says that MySQL and Apache are running. >>> > I enter http://127.0.0.1 and get the return "It works." >>> > I type http://localhost and get the return "It works." >>> > I type http://localhost/phpMyAdmin and get nothing -- can't find >>> it >>> > How do I get phpMyAdmin to run? >>> >>> Hi, >>> "It works" is not the usual output from XAMPP. You should get an >>> orange >>> page with menus, in which you would see a link to phpMyAdmin. Please >>> seek support from XAMPP forums. >>> >>> Also, I believe that the link should be http://localhost/phpmyadmin in >>> XAMPP but I might be mistaken. >>> >>> -- >>> Marc Delisle >>> http://infomarc.info >>> >>> >>> - ------------------------------------------------------------------------------ >>> 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. >>> http://p.sf.net/sfu/intel-sw-dev >>> _______________________________________________ >>> Phpmyadmin-users mailing list >>> Phpmyadmin-users(a)lists.sourceforge.net >>> >>> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-users >>> >>> >> >> >> -- >> Marc Delisle >> http://infomarc.info > > > ------------------------------------------------------------------------------ > 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. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > Phpmyadmin-users mailing list > Phpmyadmin-users(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/phpmyadmin-users > > - -- Groetjes, Dieter Adriaenssens -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.12 (MingW32) Comment: Use GnuPG with Firefox : http://getfiregpg.org (Version: 0.7.10) iEYEARECAAYFAkuo0MAACgkQZGJbiPqZM6MflgCgkw7SsB91d8qf4/20CQwF3afr pgoAn2Nvpg9xMCdxTh1f20fkbFvavWNE =QnJr -----END PGP SIGNATURE-----

3 3

Re: [Phpmyadmin-devel] GSoc 2010 - Charts in server status page
by Madhura Jayaratne 23 Mar '10

23 Mar '10

> Hi everyone, > > My name is Madhura Jayaratne and I am an undergraduate from the > University of Moratuwa Sri Lanka. I have few years of experience in > using php and mySql and was a user of phpMyAdmin for few years. > > When I was going through the GSoC idea list I noticed the project idea > on charts and was interested as I have engaged in developing a general > charting framework during my internship. I went through the requested > feature list and had a look at the area of the codebase where I have to > do the development. > > I have few ideas to add in this regard. My feeling is that, before > adding charts to the runtime information tab we should put in place a > framework that would allow us to extend charting facilitates wherever we > want to have it in phpMyAdmin. > > What I'm proposing is a general data structure that would facilitate > multiple types of charts (we can learn a lot from Google Visualization > API in this regard), and a set of interfaces that would facilitate > different implementation for different chart rendering engines( we can > even go for something other than CD2, if we feel like that sometimes > down the line) > > Though this would take few weeks of extra time, I feel that this allows > a lot of extensibility. When we have this framework in place we can do > the implementation as for the requirement we have now and we can go on > to add different charts to phpMyAdimn in the future as the requirement > arises. > > Would love to hear your opinion about this > > Thanx in advance > > Regards, > -- > Madhura Jayaratne Are you thinking about a js framework (producing the charts on the client) or a PHP framework (running on the server). -- Marc Delisle http://infomarc.info What I had in my mind was a PHP framework running on the server. What do you think about that? Regards -- Madhura Jayaratne

2 1

[Phpmyadmin-devel] JQuery AJAX Implementation - Google SoC
by Meher Anand 23 Mar '10

23 Mar '10

Hi. I've tried to come up with a method that will help the UI experience for the user through AJAX while degrading gracefully for non Javascript supporting browsers. So here it goes: Ajaxifying the Browse table interface: 1) Currently clicking on the Delete icon causes a Javascript alert and then a page refresh takes place. Instead of refreshing, we can have a $(this).parent().parent().hide() called and at the same time, send a request to sql.php to make the deletion. 2) Currently clicking on the Edit icon causes a new page to open and changes must be made and saved there. We can associate the double click event of JQuery (.dblclick) with each of the fields inside a row so that when one would double click on a field in the row, all fields in the row turn into text boxes where changes can be made and once the focus is removed, the text boxes can become text fields again. Once a user decides to commit all changes, he would click the 'Submit Changes' button and he would receive the status update regarding the changes in the table. 3) A similar method can be employed to implement the Add row feature in Ajax. These are the ideas that I could come up with right now. The best part about this is, one need not be concerned about majority of things while writing the Javascript code. One can see that if Javascript is disabled, the application would run how it would have normally run otherwise. Also, there is a team that is working on GUI improvement. Their work can be run independently of this and very minor changes would have to be made in order to accommodate the JQuery Ajax code into the improved application. Please review this idea and let me know if you have any questions regarding the same. Regards. Meher Anand

3 6

[Phpmyadmin-devel] Can this be a GSoC project for phpMyAdmin?
by Edvard Ananyan 23 Mar '10

23 Mar '10

Hi, As you may already know Joomla! didn't participate in GSoC this year. Last year I was a GSoC student doing a project for Joomla: http://jwcp.googlecode.com/ Here you can find my last year's proposal: http://edo.webmaster.am/proposals/11 This year I want to extend it and make possible to select tables from the database which can be kept under revision control with the help of mysql triggers. Currently in Working Copy I'm using a "spy" implemented with mysql triggers which can log the changes made on the table. What do you think can the versioning of mysql tables become a project for phpMyAdmin? Regards, Edvard

2 5

[Phpmyadmin-devel] GSoc 2010 - Charts in server status page
by Madhura Jayaratne 23 Mar '10

23 Mar '10

Hi everyone, My name is Madhura Jayaratne and I am an undergraduate from the University of Moratuwa Sri Lanka. I have few years of experience in using php and mySql and was a user of phpMyAdmin for few years. When I was going through the GSoC idea list I noticed the project idea on charts and was interested as I have engaged in developing a general charting framework during my internship. I went through the requested feature list and had a look at the area of the codebase where I have to do the development. I have few ideas to add in this regard. My feeling is that, before adding charts to the runtime information tab we should put in place a framework that would allow us to extend charting facilitates wherever we want to have it in phpMyAdmin. What I'm proposing is a general data structure that would facilitate multiple types of charts (we can learn a lot from Google Visualization API in this regard), and a set of interfaces that would facilitate different implementation for different chart rendering engines( we can even go for something other than CD2, if we feel like that sometimes down the line) Though this would take few weeks of extra time, I feel that this allows a lot of extensibility. When we have this framework in place we can do the implementation as for the requirement we have now and we can go on to add different charts to phpMyAdimn in the future as the requirement arises. Would love to hear your opinion about this Thanx in advance Regards, -- Madhura Jayaratne

2 1

[Phpmyadmin-devel] GSOC project - User interface cleanup
by Isuru Udana 23 Mar '10

23 Mar '10

Hi, I am an undergraduate from University of Moratuwa. I would like to do the "User interface cleanup" project for google summer of code. I have some experience in user interface design and php. I went through the given feature requests. I wonder whether these given feature requests are the features I have to implement. Is there any place where I can find list of enhancements to be done for the user interface? -- Isuru Udana Undergraduate Department of Computer Science & Engineering, University of Moratuwa, Web: http://isudana.tk/ Blog: http://mytecheye.blogspot.com/ gTalk : isudana skype: isudana

2 1

[Phpmyadmin-devel] committing a patch to git
by Dieter Adriaenssens 22 Mar '10

22 Mar '10

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all, Yesterday, I tried to commit a patch to the QA_3_3 branch and then merge it with master. Everything went well until I had to merge my changes in the QA_3_3 branch to master. This is what I did : git pull (to sync with current changes in git) git checkout QA_3_3 (made changes to main.php and ChangeLog) git commit -a -m "message" so far no problems, but then git checkout master git merge QA_3_3 and then I got this : $ git merge QA_3_3 Auto-merging ChangeLog CONFLICT (content): Merge conflict in ChangeLog Auto-merging Documentation.html Auto-merging libraries/config.default.php Auto-merging main.php Auto-merging tbl_change.php CONFLICT (content): Merge conflict in tbl_change.php Automatic merge failed; fix conflicts and then commit the result. I understand the automerge of Documentation.html and libraries/config.default.php. They are probably different between branches. I understand why merging ChangeLog had difficulties, because I changed something there. I can imagine why main.php (the file I changed) merged without problem, probably because that file was previously unchanged, so the merge was no problem. But what I don't understand is why the tbl_change.php caused problems. I didn't touch that file, so as far as I'm concerned, that file should have been correctly merged the previous time (commit before me). After manualy changing the tbl_change.php and ChangeLog file, I did this : git add ChangeLog git add tbl_change.php (because git status instructed me to) and then git commit git push This resulted in these two commits : Changed link to git repository on main page Merge branch 'QA_3_3' It then turned out I forgot to solve two conflicts in tbl_change.php (indicated by >>>>>> HEAD and <<<<<< QA_3_3). I changed this file and commited again : fix mistake in merge Merge branch 'master' of ssh://phpmyadmin.git.sourcefor... (the last commit happened automaticaly when I did a git pull, before git push, because Marc had pushed a commit in the meanwhile) So, I think everything in git is as it should be now. But I guess I made some mistakes, or there must be a way to avoid these kind of problems. (4 commits to change 2 lines of code seems a bit too much. ;) ) Everything went well until the merge part, so I wonder how you guys do it. Is it possible to only merge the changes in the last commit, and ignore all other files? Thanks for the help. Kind regards, Dieter -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.12 (MingW32) Comment: Use GnuPG with Firefox : http://getfiregpg.org (Version: 0.7.10) iEYEARECAAYFAkuh7AwACgkQZGJbiPqZM6NKMgCeNbl8eMom81IBckdbnAKMXhI7 Gp0AmwdUVPcfZbgHz8hbBjIBvhszXnP1 =tzfb -----END PGP SIGNATURE-----

3 3

[Phpmyadmin-devel] Introduction
by Shreyas Ahir 22 Mar '10

22 Mar '10

Hi, I am Shreyas currently doing my M.S in Computer science from Indiana University Bloomington. I am LAMP developer for last 5 years and counting. I intend to participate in GSOC 2010. I would love to work on charts in server status page. I have been using phpmyadmin for last 5 years and this time i hope i get a chance to contribute to it. I have already donwloaded the entire source code and have started going through it. I hope to learn a lot from all you guys in GSOC 2010. Cheers, Shreyas

2 1

[Phpmyadmin-devel] gsoc idea
by anirvana mishra 22 Mar '10

22 Mar '10

hello, I am a computer-science student.I have a strong background in c,c++,php,python and ajax.I am very much interested in ajaxifying the current phpmyadmin interface.I am giving links to some of my past works. 1. troika.dcetech.com (tech fest website fully in ajax) 2. mist10.dcetech.com (online code breaking game fully in ajax) 3. repertoire.dcetech.com apart from that many minor projects. i am web assistant at ACM's crossroad magazine and council member at mozdev.org. I am admin at dcetech.com(fully phpbb) i would like to carry forward this idea of ajaxifying the UI.We can use jquery to simplify the code and different functions to display alerts and ajax loaders etc.Looking forward for Lem9's feedback. Thanks -- Cheers Anirvana Mishra

3 2