April 2012 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Such a beautiful evening ...
by Alex Marin 05 Apr '12

05 Apr '12

... for reading GSoC applications before going to sleep, isn't it? So, with the start of the final countdown, I thought I'd add another proposal to your list. I realize that there is not much time left for feedback, but I hope you enjoy my ideas. All the best, Alex

1 0

[Phpmyadmin-devel] Display multiple query results at once
by Chanaka Dharmarathna 05 Apr '12

05 Apr '12

Hi Michal, I feel it's better to have some clarifications on above title under [1] in GSoC idea list. This topic is mentioned about displaying multiple query results at once in same page (Please make me correct if I'm wrong). The results will be appear as set of tables in the same page. But, in order to get those multiple query results, from where I should execute those two queries separately ? If it is SQL tab in pma, is it a task relating to above title that improving SQL query window page to adding multiple query boxes ? or any suggested way ? Regards ! [1] http://wiki.phpmyadmin.net/pma/GSoC_2012_Ideas_List#Refactoring:_Displaying… -- ____________________________________ Chanaka Indrajith Bsc.Computer Engineering Undergraduate Faculty of Engineering University of Peradeniya ____________________________________

3 4

Re: [Phpmyadmin-devel] PDF export - ID: 1376650 -- need help
by SELVAM P 05 Apr '12

05 Apr '12

Hi Marc , I am really sorry for the delay. I had my lab exams going on. I did compare the libraries/export/pdf.php with libraries/export/htmlword.php. I have written the function PMA_exportStructure() for pdf export and its working, printing the structure. But the problem is that the "pdf_structure_or_data" option value is "data". It has to be changed to "data_and_structure".I inspected the source code, this is the problematic code > <input type="hidden" value="data" name="pdf_structure_or_data">. > > So i am trying to pin point the script where the format specific options are set. Any help would be appreciated. -- Selvam Palanimalai Website <http://selvam.e-caffeine.net/> || LinkedIN<http://www.linkedin.com/profile/view?id=109815979> Department of EEE | Department of Biology, Birla Institute of Technology and Sciences

4 4

[Phpmyadmin-devel] [GSoC 2012] Removal of frames
by Darshana Gunawardana 05 Apr '12

05 Apr '12

Hi Dieter, I would like to know more about the idea 'Removal of Frames'. I have gone through with the wiki page[0] yet i want to clarify the scope of this project. [0] https://wiki.phpmyadmin.net/pma/Remove_frames Thank you. Darshana

2 1

[Phpmyadmin-devel] Need some suggestions for a feature request
by Chanaka Dharmarathna 05 Apr '12

05 Apr '12

Hi All, I'm interested on working the feature request [1]. As I understood, it is requested to link each result, which shows after browsing (click brows) any field in table structure, to relevant data row in that table. Please make me correct if I'm wrong. But if the browsing row is already a link, due to that field has a relation with another table field, what should be the behavior of this feature. My suggestion is to without bothering the column already a link or not, add a new link as 'show data row' after click on corresponding cells. If you have any suggestions please inform me to make some improvements. As well it is very helpful for me if you can suggest some source files related to these feature. [1] http://sourceforge.net/tracker/index.php?func=detail&aid=2998185&group_id=2… Regards ! -- ____________________________________ Chanaka Indrajith Bsc.Computer Engineering Undergraduate Faculty of Engineering University of Peradeniya ____________________________________

2 7

[Phpmyadmin-devel] [GSoC2012] Refactoring: Table search, Db search, Multi-table query
by Ammar Yasir 04 Apr '12

04 Apr '12

Hi, The noticed that the table search scripts(tbl_select.php, tbl_zoom_select.php) and multi-table query(db_qbe.php) basically display a 'Query-by-Example' form. I think we can design a qbeForm class through which we can customize a QBE form for each of the three scripts. The basic elements of a QBE form are columns and details about each column. Considering column as an entity, we can assign HTML content of each column element like datatype, collation, operator, sort, criteria as the attributes of 'column' entity. To be more specific, a 'column' entity would contain, S.No. | Attribute | HTML | Script 1 | Data-type | text | tbl_select.php, tbl_zoom_select.php 2 | Collation | text | tbl_select.php, tbl_zoom_select.php 3 | Sort | HTML Select | db_qbe.php 4 | Ins/Del | HTML input | db_qbe.php 5 | Modify | output of S.No 4 | db_qbe.php 6 | Show | HTML checkbox | db_qbe.php 7 | Criteria | (a) HTML input | db_qbe.php | (b) HTML Select | tbl_select.php, tbl_zoom_select.php 8 | Value | (a) HTML input | tbl_select.php, tbl_zoom_select.php | (b) multiselect | tbl_select.php, tbl_zoom_select.php | Foreign Values | tbl_select.php, tbl_zoom_select.php, browse_foreigners.php We can decide on what HTML we want to display for each 'column' entity(depending on the script in consideration) and customize our QBE form. One thing to note is that, from 'column' entity we will generate an empty HTML skeleton (say column block). The values of HTML select and others(for example operators) will be updated using AJAX calls. I guess that could also be included as a procedure in the QBE class (or column class). A QBE form can consist of various column blocks ( tbl_zoom_select.php has 2, db_qbe.php initially has 3 and tbl_select.php has count($fields) ). For, db_qbe.php 'column' blocks can be added dynamically just by creating an instance of 'column' entity. One issue could be that in tbl_zoom_select.php and db_qbe.php we need to select columns, i.e, columns are displayed in a select box, while in tbl_select.php all the columns are listed. But I guess, it can be worked out in time. Regards, Ammar Yasir

2 2

[Phpmyadmin-devel] Refactoring: Insert/edit, Privileges, Operations, Structure
by nandu 04 Apr '12

04 Apr '12

Marc Please visit https://sourceforge.net/tracker/?func=detail&aid=3514666&group_id=23067&ati… -- Nandlal Ahirwar MCA, II yr Maulana Azad National Institute of Technology, Bhopal India

1 1

[Phpmyadmin-devel] about jquery.event.drag
by Marc Delisle 04 Apr '12

04 Apr '12

Hi Madhura, Is there a specific reason why you committed a minified version of this library? See [0]. [0] http://threedubmedia.com/code/event/drag -- Marc Delisle http://infomarc.info

2 1

[Phpmyadmin-devel] Updated: GSoC proposal for "Removal of frames"
by Rouslan Placella 04 Apr '12

04 Apr '12

Hi all, I have just updated my proposal for the removal of frames from PMA. I've made all my points, but it still needs some work, so any feedback will be greatly appreciated :) Thanks. Bye, Rouslan

1 0

[Phpmyadmin-devel] GSoC proposal: Refactoring: Insert/edit, Privileges, Operations, Structure
by Atul Pratap Singh 04 Apr '12

04 Apr '12

Hi all, I am Atul Pratap Singh, a student from Varanasi, India. I have submitted my proposal for Refactoring: Insert/edit, Privileges, Operations, Structure for GSoC. Please provide your valuable comments and suggestions. It would be great if someone could suggest me some refactoring work in any scripts to practice on. Regards -- Atul Pratap Singh Senior Undergraduate Student Institute Of Technology, Banaras Hindu University, Varanasi, India.

1 0