RE: [PHP] question about using sql server with php
| From: | bruce | Date: | Mon, 27 Oct 2008 13:19:26 +0000 |
| Subject: | RE: [PHP] question about using sql server with php | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-282487@lists.php.net to get a copy of this message | ||
hey sudhakar..
when you're changing database apps, you're normally going to have to change
the connection codem as well as possibly the query structure for your
different select/insert/etc.. queries.
there should be plenty of examples/tutorials on the net, as well as in the
php.net website.
have fun!
-----Original Message-----
From: Sudhakar [mailto:sudhakararaog@gmail.com]
Sent: Sunday, October 26, 2008 8:49 PM
To: php-general@lists.php.net
Subject: [PHP] question about using sql server with php
i have a question about how to use sql database with php instead of using my
sql database
when i use my sql database the php code to connect to the my sql database is
=
$conn = mysql_connect($hostname, $user, $password);
if(!$conn)
{
echo "Unable to connect to Database";
}
else
{
mysql_select_db($database, $conn);
$query = mysql_query($selectquery);
mysql_close($conn);
}
if i have to connect to a sql databse instead of my sql database as some
companies use sql database, how can i change the php code to connect, run a
query and close connection to the sql database.
apart from changing the code to connect to sql database is there something
else i need to do.
please advice.
thanks