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);

Tell me is it possible to protect special characters in a query string?

962

---

What are the steps involved to run php?

1117

---

Which function would you use to insert a record into a database in php?

1096

---

What is the correct and the most two common way to start and finish a php block of code?

1009

---

What is $_ get and $_ post in php?

1148

---

Are sessions stateless?

966

---

What are the rules in creating php variable?

1073

---

Explain how to execute a php script using command line.

1231

---

Tell me how can you pass a variable by reference?

1012

---

Why overriding is called runtime polymorphism?

1029

---

Is multiple inheritance supported in php?

1057

---

What is stdclass in php?

1013

---

What is the function mysql_pconnect() usefull for?

1177

---

Tell me what is the difference between exception::getmessage and exception::getline?

955

---

How do I check if a given variable is empty?

1000

---