mysql & database help

[5cupa]

anyone know of a program that is user friendly GUI to easily write a simple mysql database with a cgi or php online search function?

or indeed anyhelp in setting up a simple online searchable database (doesent have to be mysql) if it can be done just as easy in another language

thanks

[mike_w]

phpMyAdmin?

http://www.phpmyadmin.net/

Is this just for editing the database yourself, or for lots of people (e.g. a wiki)? What operating system?

Mike.

[5cupa]

basically we have a list of therapists and want a searchable database online so people can find the therapist they need via location or treatment

supported FrontPage 98/2000/2002 Extensions
PHP4 & PHP5 w/Zend Optimizer, Perl5, Sendmail
CGI-BIN, SSI, .htaccess, Cronjobs
Flash, Shockwave, Midi, Multimedia Support


MySQL Database 5
phpMyAdmin
Daily Database Backups

[ikonia]

you may find the mysqladmin or the old mysqlcc tools on the mysql website

[directhex]

can OOo2 Base connect to a MySQL DB?

[ikonia]

I can't see a direct connection option in oo1.4 or oo2,
however 2 does support the odbc unix drivers which would allow mysql connection

[aidanjt]

The MySQL Tools Website has a few things you might have use for.

[5cupa]

did i mention i am a mysql virgin

[Moby-Dick]

did i mention i am a virgin

no , but thats hardly relevent

I don't think there is nessesarily a wizard driven , or point and click way of doing this

I assume it would be public facing and on the internet ?

designing the database is possibly the easy bit , but you'll porbably need someon who is reaosably good to write the front end so that not only does it look good / be easy to use , but is secure as well.

[TheAnimus]

Indeed all the tools mentioned aren't really suitable for a public facing database.

If the data isn't updated regularally, its possible that a CSV (comma seperated value) list could be used, there might be a simple alternative..... but you loose the benefits of a database.

How many accesses do you reacon your going to have from clients just searching the database?

How many times a day do you want to update the database?

You might find its easyest just to hire some kid do whip something up, or outsorce the website. Or better yet, learn say PHP yourself (thou i wouldn't recomend it enless your stuck with it, the language has come under a lot of flack lately for been insecure by design and the 'new' version hasn't done many of the things people had hoped it would)!

[Dav0s]

hmmm...tbh i woyld write a PHP GUI to edit the database..but im sure that somebody ahs done the same thing but generic.

[ikonia]

there is a VERY good tool called "Case Studio" - be warning its not free or cheap for a home user £100+ I think.

I've used it before. Its very good. It allows database design with "gui tools" and linking to tables, triggers, stored procedures etc etc. It will also generate scripts that create the database you've just designed for your required platform. Mysql/MSQL/Informix/Oracle etc etc. Its not really an enterprise class tool, but SME its perfect.

It also has the function to display your database design in a graphical display, with lines showing triggers and joins etc etc.

It is really good and worth the money if your using it more than once.

http://www.casestudio.com/enu/default.aspx


http://www.casestudio.com/enu/prices.aspx