New to databases and a bit put off by mySQL, can NE1 help?

Hi all,

I am very new to databases but am deturmined to crack it! I have PHP, mySQL and Apache installed. I am however a bit put off by the command line construction of database tables in mySQL. I was expecting to see something like MS Access. I'm not really sure what my question is, but I suspect I'd like to know if there is other good database software which works well with PHP and Apache. Perhaps MS Access?

Hope someone can help with this one.

Rob Howells

A visit to http://www.phpmyadmin.net/ might help. It's an interface for MySQL.

Lots of useful links at the bottom of the page too.

Good luck. Don't be put off by having to learn the odd command here and there. If you're going to use php to 'talk' to the database, they'll come in very handy.

Forget the mickeysoft. Get stuck in to MySQL. You won't regret it.

Thanks Chalky for your reply. I can see the advantage of using phpmyadmin, and I take on board your thoughts on MickeySoft. What about though if the end user is going to update his/her own databases. Some of my clients have minimal knowledge of HTML let alone anything else. What do you do?

Thanks gain

Rob

For those wishing to update their own databases, I provided online forms - one each for Add New, Modify Existing, and Delete. The online form calls a php routine which does the needful, and displays the results of the editing.

I then dump the forms in a directory with its own .htaccess file and assign a username and password to the client.

The 'Add New' is a blank form with an input for each database field.
The 'Modify Existing' asks who you want to modify and then reads their info from the database, providing the user with a populated form, which they can then edit and save.
The 'Delete' asks who (of course), then goes to a confirmation screen. If confimed, all data for that particular entry is deleted.

Good luck. Have fun writing the forms and associated routines.

I'm not going to do the job for you, it would take all the fun and satisfaction out of it for you, but if you wanted a few code snippets, email me privately eh?

Best regards

Hi, MySQL Front is also a nice GUI for MySQL administration. I'm a newbie too, and I have just build an database enabled site with some tutorials. Goodluck!