Again, another question better-asked on the PHP-DB list, so it's
being CC'd there. Responses in-line....
On Wed, Mar 19, 2008 at 1:08 AM, Sudhakar <sudhakararaog@xxxxxxxxx> wrote:
> instead of using mysql database which is conventionally used as database
> with php, if sql server database is used with php are there any major
> differences to keep in mind.
There are going to be some SQL syntax differences, yes. Despite
the name Standard Query Language, it's not really standard by anything
but the most basic of queries.
> 1.
> are the connection statements ex = $conn = mysql_connect($hostname, $user,
> $dbpassword); etc does these remain the same or are they different.
No, that's for MySQL, hence the name of the function,
mysql_connect(). You'll want to use mssql_connect() and the
mssql_****() family of functions. RTFM: http://php.net/mssql
If you're on a *NIX-like box, you'll also need to build and install FreeTDS.
> 2.
> unlike in mysql with phpmyadmin which is browser based to access databases
> and tables how to access sql server for the same functionality
STFW before asking here:
http://www.google.com/search?q=phpmyadmin+sql+server
> 3.
> can anyone provide a link about a manual for using sql database with php
Again, STFW and RTFM.
http://www.google.com/search?q=php+sql+server
http://php.net/mysql
http://php.net/mssql
Also, keep in mind that you'll have to rewrite all parts of your
code that currently utilize MySQL to convert it to MSSQL/SQL Server.
--
</Daniel P. Brown>
Forensic Services, Senior Unix Engineer
1+ (570-) 362-0283
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
