rockindano30 Posted March 28, 2008 Share Posted March 28, 2008 Hello, I have a project that i am doing. created this huge website with php/mysql. well my question is, can i use or would it be proper to use mysql instead of sql for their server set up? cause my understanding is that sql does not work with php according to some people i have talked to. or php/mysql and apache be all i need and run a safe server. help!!!!!!! Quote Link to comment https://forums.phpfreaks.com/topic/98318-solved-question-on-setting-up-a-server-with-phpmysql-and-apache2/ Share on other sites More sharing options...
ysamu Posted March 28, 2008 Share Posted March 28, 2008 if you are talking about MySQL against Microsoft SQL Server, apart from the price difference, PHP is working very well with MSSQL. Quote Link to comment https://forums.phpfreaks.com/topic/98318-solved-question-on-setting-up-a-server-with-phpmysql-and-apache2/#findComment-503134 Share on other sites More sharing options...
wildteen88 Posted March 28, 2008 Share Posted March 28, 2008 PHP can be used with a whole range of different databases. In order for PHP to work with other databases you'll need to enable the correct extension/ODBC driver for the particular database you wish to use, which you can get from the manual. MS SQL manual Quote Link to comment https://forums.phpfreaks.com/topic/98318-solved-question-on-setting-up-a-server-with-phpmysql-and-apache2/#findComment-503142 Share on other sites More sharing options...
rockindano30 Posted March 28, 2008 Author Share Posted March 28, 2008 Thanks alot guys that answered some doubts and question that i had. would mysql work or be proper to use it for this server. i was told that it was not that suitable. i don't know why. i have setup some servers with these three config's and software and work fine. Quote Link to comment https://forums.phpfreaks.com/topic/98318-solved-question-on-setting-up-a-server-with-phpmysql-and-apache2/#findComment-503200 Share on other sites More sharing options...
discomatt Posted March 28, 2008 Share Posted March 28, 2008 It all depends on the software you'd like to interact with the database. MySQL is a very, very powerful and fast db language... but if you're going for Excel and Access integration, it might not be the best route. Quote Link to comment https://forums.phpfreaks.com/topic/98318-solved-question-on-setting-up-a-server-with-phpmysql-and-apache2/#findComment-503208 Share on other sites More sharing options...
wildteen88 Posted March 28, 2008 Share Posted March 28, 2008 You can use any database server you like. All work just as good as MySQL. If you want to use MySQL then use MySQL if the client wants to use MSSQL then you'll have to adapt your script so it'll work with MS SQL. Quote Link to comment https://forums.phpfreaks.com/topic/98318-solved-question-on-setting-up-a-server-with-phpmysql-and-apache2/#findComment-503212 Share on other sites More sharing options...
rockindano30 Posted March 28, 2008 Author Share Posted March 28, 2008 thank you guys for the help and advice. not that i don't know this but i always see it as "you can never know all" no matter how long or good you're at it. you always learn something new and come across some doubts or hurdles. i guess the only dif. will be the script and of course the PRICE$$$ Quote Link to comment https://forums.phpfreaks.com/topic/98318-solved-question-on-setting-up-a-server-with-phpmysql-and-apache2/#findComment-503218 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.