AJAXify_Interface
William Desportes edited this page Apr 6, 2019
·
6 revisions
Pages 273
-
- JavaScript Functions that can be refactored with jQuery code
- In file js/functions.js
- In file js/common.js
- In file js/server_synchronize.js
- Actions to be Ajaxified on different pages
- Navigation panel
- Main Page (main.php & js/main.js)
- Privileges from the main menu(server_privileges.php & js/server_privileges.js)
- Database Privileges
- Database Operations (db_operations.php & js/db_operations.js)
- Database Structure
- Table Browse
- Table Structure
- Table Operations (tbl_operations.php & js/tbl_operations.js)
- SQL Query (server_sql.php, db_sql.php, tbl_sql.php, js/sql.js)
- Insert (tbl_change.php & js/tbl_change.js)
- Database, Table Search (db_search.php, tbl_select.php, db_search.js, tbl_search.js)
- Separate SQL Query window (querywindow.php & js/querywindow.js)
Popular destinations:
User resources:
Clone this wiki locally
A list of tasks and discussion for enhancing phpMyAdmin with AJAX. Partially implemented with the Google Summer of Code 2010 project AJAXify the phpMyAdmin Interface.
JavaScript Functions that can be refactored with jQuery code
In file js/functions.js
- confirmLink(): done
- confirmQuery()
- checkSqlQuery()
In file js/common.js
- addEvent()
- removeEvent()
- getElementsByClassName()
In file js/server_synchronize.js
- showDetails()
Actions to be Ajaxified on different pages
Navigation panel
- Create table (show in a popup dialog): done
Main Page (main.php & js/main.js)
- Change Password (will also affect user_password.php): done
- Create a New Database (will also affect db_create.php): done
Privileges from the main menu(server_privileges.php & js/server_privileges.js)
- Add a new user: done
- Revoke a user (and also drop databases with same name as user): done
- Edit privileges: done
- Export privileges: done
- Paginate table of users: done
- Flush privileges: done
Database Privileges
- Add a new user: done
Database Operations (db_operations.php & js/db_operations.js)
- Create table: done
- Rename Database: done
- Copy Database: done
- Change Collation: done
Database Structure
- Clicking on Insert for a table (will help user inserting for multiple tables from one place): done
Table Browse
- Page navigation: done
- Actions on multiple rows:
- Change - done
- Export - In export we have to save the results for a file. We can do that by setting the header parameter "Content-Disposition: attachment; filename="." in non ajax response and browser will save the data to the file. But in ajax, even though we set the parameter correctly the browser does not save the content for a file.
Refer :
https://stackoverflow.com/questions/2186562/post-to-server-receive-pdf-deliver-to-user-w-jquery
We can use this Jquery plugin as a solution for this issue.
Plugin :
https://www.filamentgroup.com/lab/jquery-plugin-for-requesting-ajax-like-file-downloads.html
Table Structure
- Actions on multiple rows:
- Change: done
- Index
- Edit: done
- Hide/Show index: done
- Change one column: done
- Add column(s): done
Table Operations (tbl_operations.php & js/tbl_operations.js)
- Alter table order (Sort): done
- Move Table: Should not ajaxify this
- Table Options: todo
- Copy Table: done
- Table Maintenance: done
- Check
- Repair
- Analyze
- Flush
- Optimize
SQL Query (server_sql.php, db_sql.php, tbl_sql.php, js/sql.js)
- Retrieve the response for a query with Ajax: done
- Paginate the results of a SQL query: done
Insert (tbl_change.php & js/tbl_change.js)
- Change the number of insertions on the fly without reloading the entire page: done, bugs remaining
- Insert rows with an Ajax request: todo
Database, Table Search (db_search.php, tbl_select.php, db_search.js, tbl_search.js)
- Show results with Ajax calls, paginate results: done
Separate SQL Query window (querywindow.php & js/querywindow.js)
- Use jQueryUI's Tabs and re-build the HTML for this page
- If necessary, refactor some functions from js/querywindow.js