Page 1 of 1

MS Access or MYSQL ?

Posted: Wed Sep 11, 2002 2:50 am
by jojo
Hi;
I am new to this PHP and want to learn,
but when it comes to database, I have some doubt to choose the right database, appreciate your thought.

I know my way arount MS access, and have build some databases, but don't know anything about MYSQL,
it seems that everybody who works with php uses MYSQL,

I have seen around that you can use MS Access with PHP, but my question is:

1- is there any benefit to use MYSQL with php, over MS Access?

2- is there any problem if you use MS Access with php, any security issue perhaps?

3- Is there any program out there that making designing of database with MYSQL easier, it looks ,that you have to hand write your code and very time consuming, I might be wrong, but your comment on this is appreciated.


Thanks.

Re: MS Access or MYSQL ?

Posted: Wed Sep 11, 2002 3:01 am
by twigletmac
jojo wrote:1- is there any benefit to use MYSQL with php, over MS Access?
MySQL is supported by more web hosts and allows you to use *nix hosts which are generally cheaper. MS Access is not intended for use on the web and can have serious stability issues. PHP has built in support for MySQL via it's mysql_ functions.
jojo wrote:2- is there any problem if you use MS Access with php, any security issue perhaps?
No security issues that I know of, just stability ones.
jojo wrote:3- Is there any program out there that making designing of database with MYSQL easier, it looks ,that you have to hand write your code and very time consuming, I might be wrong, but your comment on this is appreciated.
There's quite a few front ends. One which is often used (and is especially useful on a hosted site) is phpMyAdmin

Most people here are going to be biased towards MySQL (or biased against MS Access :) ) but MySQL really is the better solution for use on the web.

For a more technical comparison try mysql.com's Crash Me comparison.

Mac

Posted: Wed Sep 11, 2002 5:06 pm
by jojo
Thank you twigletmac.