PHP Interview Questions-Answers Part-III
Questions : 51 List out some tools through which we can draw E-R diagrams for mysql.
Answer : 51 Case Studio
Smart Draw
Questions : 52 How can I retrieve values from one database server and store them in other database server using PHP?
Answer : 52 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 … Continue Reading
