Ajax Powered MySQL Table Editor
MyAjax Editor, is a powerful Ajax MySQL Table Editor. It’s main feature is it’s fast Web 2.0 Ajax inteface that allows you to update and maintain your data quickly and easily.
It replicates the functionality of an Excel spreadsheet, allowing you to click from cell to cell to make changes. The Ajax search quickly narrows down the data that you are looking to view or make changes to. There are many configuration options for displaying your data, such as column highlighting or if you only want to only display certain fields. A full list of configuration options can be found below.
Rows can also be deleted, and inserted via quick and easy Ajax controls.
Feature list:
- Fast inline data editing via Ajax
- Quick Ajax Search
- Ajax Sort, and Paginated results
- Delete a row
- Insert new rows
- Lots of customizable options (List below)
- Built on jQuery Javascript framework
- Designed for PHP and MySQL (although can be used on other systems e.g. SQL Lite)
- Ideal for LARGE amounts of MySQL data
- Only loads and displays data that is required
Configuration Options:
- Show only select fields.
- Custom CSS styles per column (e.g. Text colour, font size/weight, column highlighting, etc)
- Number of results to show per page.
- Specify which field Ajax Search should be performed on.
- Which field to initially sort on.
- Which direction to initially sort on (Ascending or Descending).
- Define a fixed column width.
Demo
Demo – Changes are not commited to our databases for obvious spam related issues, refreshing the page will restore table data.
Screenshots
One Click Editing:
Fast Ajax Search:
Ajax Pagination:
Ajax Column Sorting
Easily insert a new row:
Delete a row:
Requirements:
- PHP
- MySQL database
Ajax Powered MySQL Table Editor
- Number of Downloads: 81
- Number of Files: 32
- Total File Size: 213kb
- Compatible Browsers: IE6, IE7, IE8, Firefox 2.5+, Opera, Safari
Yess!! Great script thanks, have been using it for a few days and has certainly made things a lot easier. One question how do I make a column bold like in your demo??
In config.php you can specify which columns to style like this:
Thanks for the feedback, can I ask what you are using the script for? Just interesting to see how people are using our scripts!
Thanks. We are using it on our intranet to update a ticketing system database (osticket), we were using a command line utility previously to ssh and update manually a sql database.. time consuming as you can imagine! I have been looking for a script similar to this for a while but none really cut the mustard!
Thanks again
Hi
I am trying the editor but, although the update/new record “seems” like it has been accepted, if I go looking for the the word I just changed/added, it doesn’t display it.
Is there a reason for this ?
Yes we have disabled updates intentionally so that people don’t spam our database. If you download and install it on your own database though, changes will be committed as expected.
Hello Boss! This is the perfect script and I would like to purchase. Can I use it for 3+ millions records? My database is 1.2gb.
Yes we have tested it with a 370mb sample database containing 1+ million rows on a Quad Core Opteron 1354 (2.2GHz), with 2GB DDR2 RAM, and a 10,000rpm SATA HDD.
Locally, page load time was consistantly less than 0.02 seconds.
thnx for this great release.i need to use this for our inventory.we are selling on-line and my partners are in different locations.stocks are in different locations
i have some questions in my mind ;
1) do i need to buy also “Ajax Powered MySQL Table Viewer” ? is it enough to buy this script only to view stock ?
2) only me and my partners will work on this.we need password protection.is it possible ?
3) is the script editable ? can i add coulomns, menus etc ?
4) does it support import/export to excel files ?
thnx for your answer
Cem
1) No, the “Ajax Powered MySQL Table Viewer” just lets you view your MySQL databases. This has the additional functionality of allowing you to edit your MySQL data.
2) Yes this is totally possible, a simple login script to protect index.html, or restrict access in your .htaccess file would do the job.
3) It would be quite straightforward for you to edit index.html with your own menus. The columns that you wish to display can be specified in the config file, although you cannot insert a new column into your database with this script.
4) No import/export options to excel with this release. Quite possibly something we would bear in mind for future updates.
i have solved problems.they are about table format that i created
but ;
how can i add Turkish font ?
thnx
The font type is declared in the file: includes/stylesheet.css so it’s just a case of editing where it says at the top “font-family:” with your Turkish font.
Hello, I love this problem.
I’m planning on purchasing it, but before I do, I had a question.
I have a table with about 100 columns and 5000 rows. From the demo above, it seems that the 5000 rows is not going to be an issue because I can scroll between the pages. What about with Columns? Is there a limit to the number of columns that can get displayed?
Out of 100 columns in my table, I will be displaying 80 of them.
Thanks
No, there is no limit on the number of columns or rows that are displayed.
Thank You for answering my question.
As the demo above shows, I’m able to scroll between the rows via the page number on the bottom.
How will I scroll between the columns. After columns go off the screen is there a scroll bar at the bottom? Similar to an HTML frame?
Thanks,
Neil
The columns width will expand to the size of your browser. You could add scroll bars to the container div however by adding “overflow: auto” to the stylesheet. Otherwise you could manually set your columns width in the config.php file.
Is it possible to have the same script edit multiple tables or do I need to modify multiple copies of the same table script?
This is sweet! Got it working no problem! Thank you.
The table is defined in config.php, so it’s just a case of changing the value in this file to edit multiple tables.
Is there any limit to the length of text in a text field? For example this is an entry in a table cell:
“Own Choice of three classical pieces including one from the 20th or 21st century. Only two to be performed, competitor’s choice followed by adjudicator?s choice. Time limit 10 minutes.”
I want to be able to see ALL of this and edit it without having to ‘inch’ along with the arrow keys.
Yes, all text fields from your MySQL database are editable in a text area rather than an input box. Input boxes are only displayed for non blob/text fields where there is a limit on the number of characters.
Can the table cells be text areas (say cols 30, rows 5) both in the normal display and the edit display?
Yes, if the field is a text field it will display a textarea with multiple rows in edit mode and allow you to show full text in normal display.
Is there a way to render images?
This can be done with an additional bit of Javascript in $(document).ready:
2
3
4
5
6
7
8
9
10
11
12
13
14
$('#ajaxtb th').each(function() {
if($(this).text() == fieldName){
var colnum = $(this).parent().children().index($(this));
}
$('#ajaxtb tr').each(function() {
$('td', this).each(function() {
if($(this).parent().children().index($(this)) == colnum){
$(this).html('<img src=\"' + $(this).text() + '\" />');
}
});
});
});
}
The problem with this being that when you go to edit that cell it will contain “<img src..", we plan on adding some functionality to this script to allow images to be rendered by specifying column names from within the config file in our next update.