📄 gallery.php
字号:
<HTML>
<body bgcolor="#ccccff" link="#0000ff" vlink="#0000ff" alink="#0033ff">
<br><br>
<br>
<?
//连接到本地mysql数据库
$myconn=mysql_connect("localhost","jackie","123456");
//选择test为操作库
mysql_select_db("users",$myconn);
?>
<table cellspacing=0 bordercolordark=#FFFFFF width="95%" bordercolorlight=#000000 border=1 align="center" cellpadding="2">
<tr bgcolor="#6b8ba8" style="color:FFFFFF">
<td width="20%" align="center" valign="bottom">Gallery Name</td>
<td width="20%" align="center" valign="bottom">Gallery Owner</td>
<td width="20%" align="center" valign="bottom">E-mail</td>
</tr>
<?
$strSql="select * from auth_users";
//用mysql_query函数从reguser表里读取数据
$result=mysql_query($strSql,$myconn);
while($row=mysql_fetch_array($result))//通过循环读取数据内容
{
?>
<tr>
<td align="center"><a href="http://82.39.116.47/reg/gallery_2.php?id=<?echo $row["id"]?>"><?echo $row["gallery_name"]?></a></td>
<td align="center"><?echo $row["username"]?></a></td>
<td align="center"><a href="mailto:<?echo $row["email"]?>"><?echo $row["email"]?></a></td>
</tr>
<?
}
?>
</table>
<hr>
<li><a href=/Reg/index.php>To Main Page</a>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -