Re: question about php with sql database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



    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 General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux