Answer Posted / vijaya

we can always fetch from one database and rewrite to
another. Here is a nice solution of it.

$db1 = mysql_connect(”host”,”user”,”pwd”)
mysql_select_db(”db1″, $db1);
$res1 = mysql_query(”query”,$db1);
$db2 = mysql_connect(”host”,”user”,”pwd”)
mysql_select_db(”db2″, $db2);
$res2 = mysql_query(”query”,$db2);At this point you can only
fetch records from you previous ResultSet,

i.e $res1 - But you cannot execute new query in $db1, even
if you supply the link as because the link was overwritten
by the new db.so at this point the following script will fail

$res3 = mysql_query(”query”,$db1); //this will failSo how to
solve that?

Take a look below.

$db1 = mysql_connect(”host”,”user”,”pwd”)
mysql_select_db(”db1″, $db1);
$res1 = mysql_query(”query”,$db1);

$db2 = mysql_connect(”host”,”user”,”pwd”, true)
mysql_select_db(”db2″, $db2);
$res2 = mysql_query(”query”,$db2);

So mysql_connect has another optional boolean parameter
which indicates whether a link will be created or not. as we
connect to the $db2 with this optional parameter set to
‘true’, so both link will remain live.

now the following query will execute successfully.
$res3 = mysql_query(”query”,$db1);

Where sessions stored in PHP?

989

---

Is php a strongly typed language?

1013

---

How to update memcached when you make changes to php?

978

---

Does php have a future?

941

---

List some array functions in php?

936

---

What is isset function in php?

1192

---

What are variables in research examples?

1085

---

Tell us how to set cookies in php?

931

---

What is the use of 'print' in php?

1020

---

Why do we use interface in php?

973

---

What is the advantage of runtime polymorphism?

942

---

How to replace a text in a string with another text in php?

979

---

How can we upload a file in php?

1018

---

Are sessions stateless?

919

---

What is the mysql injection?

995

---