There is lot of database option avail for integrate into PHP.You should need to configure at the php.ini file according to your database selection before doing the connectivity. example,
For Mysql
extension=php_mysql.dll
For Microsft Sql Server
extension=php_mssql.dll
For Postgre Sql
extension=php_pgsql.dll
Connectivity
1. MySql
define("HOST","localhost");
define("USER","venkat");
define("PASSWD","xxxx");
define("DATABASE","pos");
function myConn()
{
$db=mysql_connect(HOST,USER,PASSWD);
mysql_select_db(DATABASE,$db);
return $db;
}
2. MS Sql
define("HOST","localhost");
define("USER","venkat");
define("PASSWD","xxxx");
define("DATABASE","pos");
function myConn()
{
$db=mssql_connect(HOST,USER,PASSWD);
mssql_select_db(DATABASE,$db);
return $db;
}
3. Postgre Sql
define("HOST","localhost");
define("USER","venkat");
define("PASSWD","xxxx");
define("DATABASE","pos");
function myConn()
{
$db=pgsql_connect(HOST,USER,PASSWD);
pgsql_select_db(DATABASE,$db);
return $db;
}
That's it .....
Monday, October 26, 2009
Subscribe to:
Post Comments (Atom)


No comments:
Post a Comment