I'm looking for direction and help.

I know HTML coding pretty well, have MySQL database support on the site I am building, but don't know much about MySQL and how to use it. (Yes, a BABY NEWBIE).

I've been asked to put the membership list up online, but I'd like to make it possible for someone in the group besides myself to update and maintain the online database.

Consequently, I've been looking for a pre-packaged MySQL database solution, one that is preferably free or inexpensive.

Ideally, this would be something that I can install and configure from a web browser, or at least configure text files locally that I upload. It should also allow someone in our group to add, remove, or modify records, a person who is just smart enough to use their computer, get on the web, and fill in forms, but not necessarily knowledgeable about creating webpages or MySQL databases.

The membership database is not complex; I only need the basics of name, address, phone, e-mail, and possibly other fields for future use. Ability to include pictures would be nice but certainly not necessary.

With all of that out of the way, is there a pre-packaged solution that exists, either for free or inexpensive? I clearly don't have time available to me to buy a MySQL book and a PHP book and learn how to code it first.

If what I am asking for simply doesn't exist, that it REQUIRES training in the use of MySQL before trying to do something like this, let me know and I'll just hard code it into tables or something (yuck).

Thanks,

    I use MyPHPAdmin it's free and web based php pages used to manage MySQL. There are windows binaries too.

      The only concern with using mysqlAdmin would be to make sure that the others who would be using it are atleast somewhat techincally savvy

        Very true, but I know that it can be modified/limited also. A website that I manage is on a shared virtual host and their
        install of phpmyadmin is restricted...just a thought.

          I appreciate the replies, but my technical savvy in dealing with MySQL is also extremely limited.

          It is kind of like having someone who knows about HTML and BODY tags for a web page, but nothing more, and wants to make a web page. Clearly, that person needs a graphic web page creation program, one that will take care of the details of what tags to use, how to use them, etc.

          What I need is that level of simplicity for creation of an online database, and the person who will add/remove/edit records needs just as much simplicity. Further, after the data is created, I need to know how to display it on a web page.

          Ideally, it would be something like a web calendar, which lets you view events, and then if you have to password as being an administrator, you can change it.

          Any further thoughts?

            The mysql Control center is actually fairly straight forward - it acts almost like excell and generally most people know excell

              Originally posted by mystrymaster
              The mysql Control center is actually fairly straight forward - it acts almost like excell and generally most people know excell

              Is that anything like phpMyAdmin? I have that available through my web host, but it doesn't look like it helps with creation of web pages based on the data.

                As far as helping with the creation of web pages I would have to say no - but it is a very easy windows gui to help get people who aren't truly interested in working with databases into being able to create or manipulate them.

                  Write a Reply...