phpMSAdmin

Hey guys, sorry for the almost year off from releases. I’m back in the saddle again and you can expect at a minimum a maintenance release coming down the pipeline shortly. I’ve moved the website to a hosting provider a little less anemic then SourceForge’s free hosting which includes features like the ability to send email (stunning, I know). As a result the forums should stop piling up with spam from un-authenticated bots and once again be semi-useful. I’ve received a couple emails regarding the comeback tour of phpMSAdmin, so I’ll re-iterate, if you have a bug or a feature you’d like addressed, please email me at or post it in the forums. Thanks.

I’m swamped with a number of things going on in real life. I’ll be starting a new job on Monday and am just not going to have the time to get a release out for a while. Apologies, check back later. Thanks.

What the heck is QB and DE you ask? Why Query Builder and Database Export of course. This release (0.18) feature enhancements to both the database export and query builder features. The database export is now capable of exporting stored procedures, views and functions. The query builder is now capable of “LIKE” comparisons and can now utilize and “ORDER BY” selection. There were also two small bugs fixed on the query builder. Enjoy, and see you next week.

Hot on the trails of the last user feedback release, here is 0.17 including another user requested feature, a query builder. It’s not very advanced as of yet, but it works. Also included is the ability to import databases as opposed to the last release which could just export. The export function was slightly tweaked but no major functionality was added. Also numerous bugs were fixed which you can read about in the SourceForge changelog if your so inclined. Enjoy, and see you next time.

This release (0.16) includes a major new feature that was requested by a user in the forum, database exporting. Also included is an updated manual. Numerous bugs and notices were cleaned up and some minor layout/design tweaks were implemented. Full changelog is available via the “note” on the SourceForge releases page. I know what your saying, “Only one new feature?”, yep, this one was a tall-order and it still is not as inclusive as I would have liked. Enjoy, and stay tuned till next week.

This (0.15) is primarily another user-feedback release. Thanks to all those in the forums who had constructive suggestions on how to improve the software. First, added the ability to edit rows from both the table select and table browse modes (assuming an identity column is present). Also, support was added for manual connection specification. Dangerous table operations via the context (right-click) menu now prompt you by default to confirm the operations unless you turn this off in the configuration file. Also the context menu for databases was modified to include a create table link. For the first time ever, a work in progress manual is included. It is availabe in the “docs” directory in “Open Office”, “Microsoft Word”, “PDF”, and “HTML” formats. Numerous bugs were fixed including broken windows detection on the login page, incorrect title on database drop page, table insertion not enforcing maximum length restriction, and an odbc.ini “present but empty” error. Also a large number of notices were fixed throughout the software if you had notices turned on. There were also a number of small cosmetic changes. Added messages stating when there are no Stored Procedures, Views or Functions on the database properties page. Fixed IE incorrectly displaying a number of table borders.

Just released 0.14 to the wild wild net. I’m pretty happy with this one. This is a mid-level feature/bugfix release. First, it includes the ability to rename tables and you can now also toggle databases into and out of READ-ONLY mode (both available via the right-click context menu). Also added was the ability to assign database roles to new users. A bug preventing user account creation and a bug causing your selected username not to follow database selection have both been fixed. A password requirement was added for user account creation. Security has been enhanced by the addition of user IP and browser checks. The universal header, login, database drop, and database detach pages have all received slight color scheme changes. Also the table context menu (right click) has been cleaned up and reorganized.

I just released 0.13. This release features much improved error handling on the table select, table modify, and table creation functions. What do I mean by “much improved”? Well basically when an error happens it doesn’t just die and tell you what SQL Server responded with. It now shows what you were attempting to do so you don’t have to fill back in all your information and it shows the query it attempted to execute (in most places). Also added was the ability to rename columns. Also some smaller things were included like a link to insert rows from the table properties page and the function, procedure, and view modification functions will now search and replace to replace each objects definition from “CREATE” to “ALTER”. A small change but a handy one. This releases focus is a direct response to feedback by a user in the forums. Got an idea? Post a message, I’d love to hear it. Enjoy and see you next time.

Just dropped 0.12 to the mirrors. It’s a decent release. This release includes something I frankly should have thought about a long time ago, automatic parsing of your DSN list on Windows. There might be a bug or two, but give it a shot. Worse case scenario, it doesn’t work and you just set “detectionoff” in the config file. Also added to this release was better error handling functions. The only place the new functions have really been implemented is in the error handling for the addition of columns to tables, but they’ll slowly filter in to the other areas of the software. Also in the area of table modification, a bug was fixed where causing an error would cause a PHP parsing error … never a good thing. Finally, this release back-fills triggers into the mobile version of the client. Enjoy, and remember, if you have any problems/feedback/suggestions or praise =), the forum is available via the link on the right side of the homepage.

The project has just recently crossed over 3,000 downloads. It’s quite a milestone and I’d like to thank all of you who’ve tried out the software. I realize the acceleration to 3,000 was mainly because a number of you were downloading release after release every week, but in my opinion still quite impressive for a project like this. To go along with this occasion, I’m opening the forums for questions, feedback, etc. It will be permanently accesible via the forum link in the menu on the right side of this page. Thanks again for all your support.