phpMSAdmin

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.

I’ve just released 0.11 to the great SourceForge mirror network. This is another decent sized release which includes another much promised feature. Triggers can now be listed, modified, created, or deleted using phpMSAdmin. You can access this feature by either using the table context menu (right clicking on a table in the menu) or by clicking on the “Triggers” link next to each table on the database properties page. Note however that triggers have not yet been added to the mobile version which will most likely happen in 0.12. Thanks, and enjoy.