[SOLVED] How Can we use more than one Data Base Access in One Page

[binumathew]

How Can we use more than one Data Base Access in One Page

 

Can u show me some examples? or code snippets??

[Mchl]

what do you mean by "more than one Data Base Access in One Page"?

[binumathew]

Means,i can able to Connect one or more table and DB's at same time can it possible???

[Mchl]

Yes you can. The exact way to do it depends on what database you use.

[binumathew]

i am using MySQL 5, Can u gave me a code snippet???

[Mchl]

Sure.

 

//create connection to database1
$connection1 = new mysqli("server1","user1","password1","database1");

//create connection to database2
$connection2 = new mysqli("server2","user2","password2","database2");

//this is the query we want to send to databases
$sql = "SELECT * FROM table1";

//query database1
$result1 = $connection1->query($sql);

//query database2
$result2 = $connection2->query($sql);

[binumathew]

Ok Is it important that we need to close each connection..???

[Mchl]

All connections are closed when script ends execution .Closing them manually is recommended though (less strain on MySQL server).

[binumathew]

Can u gave me code for that???as i am beginner in PHP i dont know well about PHP

[Mchl]

Connections are closed using

$connection1->close();

 

It's all in manual for mysqli

[binumathew]

i am using MYSQL not MYSQLI

 

One more Question,i am using two tables from one database.on that time can i use the same connection,how to??

[Mchl]

Then check the manual for mysql (although be aware, that mysqli should be used for MySQL 4.1 and higher).

 

If you need to send two or more queries within one connection... just do it!

 

$sql1 = "SELECT * FROM table1";

$result1 = $connection->query($sql1);

$sql2 = "SELECT * FROM table2";

$result2 = $connection->query($sql2);

[binumathew]

How it is possible??beacause already a connection is open na??

[binumathew]

I am using MYSQL 5 is it important that i should use MYSQLi()????

[Mchl]

Yes... once you open the connection, you can use it to send as many queries as you wish (or as many as MySQL server permits you).

 

mysqli is recommended for MySQL 4.1 and up. You can still use the 'old' mysql extension, but mysqli gives you several important advantages. Read this excellent article

 

http://www.charlesrowe.com/2007/06/15/the-four-major-benefits-of-mysqli/

 

 

[binumathew]

The link is not working

[Mchl]

Aww... man!... It was such a good article... I hope it's just a server problem and the article will be available soon...

 

Anyway, there even is a tool for automated conversion from mysql to mysqli

http://forge.mysql.com/wiki/Converting_to_MySQLi

[binumathew]

Thks......

[Mchl]

And another informative article from Zend

http://devzone.zend.com/node/view/id/686

[binumathew]

Can u gave me a full snippet for ACCESSING 2 TABLES @ SAME TIME,LIKE CONECTING,ACCESSING AND SO ON??

[Mchl]

I gave you links to sources with code examples. Try them. Modify them. If you have problems, post your code and say what's going wrong.

[binumathew]

I need code in PHP by MYSQL. not MYsqli

[Mchl]

The syntax is close to identical:

mysql