Feb
14
So while trolling around the forums of one of my most favorite client-side MySQL database tools (sqlYog at webYog), I noticed they had Invision Power Forum, and they just enabled blogging for all their registered forum members. Two of their most active blogging members were linked to in the developer's blog, so I went to go read them. One of them, sdozono (he's got a lot of great stuff there, check it out) was talking about web-based tools for use with database manipulation. At first, I was wondering why he'd even mention web-based manipulation of MySQL data when you're at a desktop application client's website, and phpMyAdmin is pretty much the unrivaled veteran for database administration.
I took a closer look...
I took a closer look...
I have to start out with their own marketing quote:
How many times have you hand coded a MySQL table editor in PHP?
phpMyEdit application provides an instant table editor.
phpMyEdit generates PHP code for displaying/editing MySQL tables in HTML. All you need to do is to write a simple calling program (a utility to do this is included). It includes a huge set of table manipulation functions (record addition, change, view, copy, and removal), table sorting, filtering, table lookups, and more. - phpMyEdit
Checking out their screenshots shows me (and/or you) a slightly more detailed explanation of what they mean. This is a codebase for creating administrative access to the common functions of data manipulation via MySQL and PHP. Considering I just finished "hand cod[ing] a MySQL table editor in PHP", I think this fits the bill for me...and is also embarrassing that I only found it now. I usually don't like using other peoples' code, but this just looks awesome. One thing that I had a problem with in my code was that I could only maintain unrationalized tables (luckily none of these tables could be rationalized). However, I was also able to easily add in error checking, drop-down boxes for date data-types (instead of allowing the user to fudge it all up by entering text -- it also checks for validity) and many other cool things. I don't know if I could do that with this. However, I'm still planning on taking a look at it before I start working on my user management system that I originally intended on writing back in college.
Granted, I was right when I said that I didn't have time to work on everything necessary and that the project kept seeing scope creep and was outside of my timeframe for the scope of the project. However, a user management system is at the heart of any web-based application, unless perhaps it's either a guestbook or a ...crap, what's it called; oh well, it doesn't matter. Bigger applications have some sort of user management -- this might be helpful in some sense, either to look at the code, or to use it.
I'm still deciding on whether or not I want to tackle creating my own simple framework. All of the ones that I've seen thus far just don't seem to do exactly what I'd want it to. But I digress. phpMyEdit looks very powerful and easy enough to use, as well as modular and extensible.
How many times have you hand coded a MySQL table editor in PHP?
phpMyEdit application provides an instant table editor.
phpMyEdit generates PHP code for displaying/editing MySQL tables in HTML. All you need to do is to write a simple calling program (a utility to do this is included). It includes a huge set of table manipulation functions (record addition, change, view, copy, and removal), table sorting, filtering, table lookups, and more. - phpMyEdit
Checking out their screenshots shows me (and/or you) a slightly more detailed explanation of what they mean. This is a codebase for creating administrative access to the common functions of data manipulation via MySQL and PHP. Considering I just finished "hand cod[ing] a MySQL table editor in PHP", I think this fits the bill for me...and is also embarrassing that I only found it now. I usually don't like using other peoples' code, but this just looks awesome. One thing that I had a problem with in my code was that I could only maintain unrationalized tables (luckily none of these tables could be rationalized). However, I was also able to easily add in error checking, drop-down boxes for date data-types (instead of allowing the user to fudge it all up by entering text -- it also checks for validity) and many other cool things. I don't know if I could do that with this. However, I'm still planning on taking a look at it before I start working on my user management system that I originally intended on writing back in college.
Granted, I was right when I said that I didn't have time to work on everything necessary and that the project kept seeing scope creep and was outside of my timeframe for the scope of the project. However, a user management system is at the heart of any web-based application, unless perhaps it's either a guestbook or a ...crap, what's it called; oh well, it doesn't matter. Bigger applications have some sort of user management -- this might be helpful in some sense, either to look at the code, or to use it.
I'm still deciding on whether or not I want to tackle creating my own simple framework. All of the ones that I've seen thus far just don't seem to do exactly what I'd want it to. But I digress. phpMyEdit looks very powerful and easy enough to use, as well as modular and extensible.
0 Trackbacks