Which is a better database to connect to php?

Question

I am building a website and plan to use a database and php. but what is easier to connect? Php to MS SQL 2005 - 08? or MySQL? any sources on how?

which is more simpler?

Answer 1

There really is little difference in complexity when scripting PHP to connect and query either. As for which database you use, you should probably conduct some research to discover the pros and cons of both. I personally use MySQL.



MsSQL PHP docs: http://php.net/mssql



MySQL: http://php.net/mysql



Although, you should probably be doing it OOP style, with MySQLi (improved): http://php.net/mysqli

Answer 2

Only the connection string changes - neither one is "difficult", it's just a line of text.



MySQL is the better database, but if the site you're on only has MSSQL you have no choice. It's usually Windows-ASP-MSSQL and Linux-PHP-MySQL, but some hosting companies may not do it that way. If I had the choice I'd definitely go with MySQL. (And an ADO connection, but that's just me.)

Answer 3

you're lacking the database call. you need to use the recent mysql library for extremely own homestead page, it extremely is mysqli instead of mysql. This mysql library which you're using will quickly be deprecated. it is the recent way of connecting. @ $db = new mysqli('dblocation' ,'username','password', 'dbname');

Answer 4

Normal MySQL will most likely be the easiest to get help with. do you have both those downloaded?

WampServer an easy way to download them.

how are you making the site?

Answer 5

mysql is what most people uses