📄 multi_db.php
字号:
<html>
<head>
<title>Maildata record browser</title>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<?php
$connect= mysql_connect("localhost","root","")
or die("Could not connect to MySQL server in localhost !");
$db="Mailinglist";$db2="Seconddb";$sqlquery = "SELECT * from Maildata";
$queryresult = mysql_db_query($db,$sqlquery) or die("query failed");echo "<table width=600 border=1 align=center>";
echo " <tr>";
echo " <td width=200> <center><b>Name </b></center></td>\n";
echo " <td width=200> <center><b>E-mail</b></center></td>\n";
echo " <td width=200> <center><b>Secondary e-mail</b></center></td>\n";
echo " </tr>\n";
while ($row=mysql_fetch_array($queryresult))
{
echo " <tr>\n";
echo " <td>".$row["Name"]."</td>\n";
echo " <td>".$row["Email"]."</td>\n";
$sqlquery2 = "SELECT Address from Info where Email='".$row["Email"]."'";
$queryresult2 = mysql_db_query($db2,$sqlquery2);
if ($row2=mysql_fetch_array($queryresult2))
{ echo " <td>".$row2["Address"]."</td>\n";
} else { echo " <td> </td>\n";
} echo " </tr>\n";
}
echo "</table>\n";
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -