📄 phplist.txt
字号:
<%@ CodeTemplate Language="C#" TargetLanguage="Text" Src="" Inherits="" Debug="False"
Description="Template description here." %>
<%@ Property Name="SourceTable" Type="SchemaExplorer.TableSchema" Category="Context"
Description="Table to get the data from."%>
<%@ Property Name="Page"
Type="System.String"
Optional="False"
Category="1. Class Definition"
Description="The name of Folder." %>
<%@ Assembly Name="SchemaExplorer" %>
<%@ Assembly Name="System.Data" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="SchemaExplorer" %>
<%@ Import Namespace="System.Text"%>
<?
include "template_top.php";
$sql1 = "1=1";
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title></title>
</head>
<body>
<form id="form1">
<table>
<tr>
<td>
<input type="button" name="button" value="添加" onClick="window.location='<%=Page%>_add.php'" />
</td>
</tr>
</table>
<table >
<tr>
<% for (int i = 0; i < SourceTable.Columns.Count; i++) { %>
<td><%=SourceTable.Columns[i].Name%>;</td>
<%}%>
</tr>
<?
$pagefollow = ""; //页面链接参数
$pagesize = 5;
$result = mysql_query("select * from <%=GetTableName()%>",$db);
$resnum = mysql_num_rows($result); //总信息数
$pagecount = ceil($resnum / $pagesize); //总页数
if($page > $pagecount) $page = 1; //如果当前页数大于总页数，则转为第1页
$pageResult = mysql_query("select * from <%=GetTableName()%> where ".$sql1." limit ".(($page - 1)* $pagesize).",".$pagesize,$db);
while($myrow=mysql_fetch_array($pageResult))
{
<% for (int i = 0; i < SourceTable.Columns.Count; i++) { %>
$<%=SourceTable.Columns[i].Name%> = $myrow['<%=SourceTable.Columns[i].Name%>'];
<%}%>
?>
<form>
<input type="hidden" id="hidid" value="<?=$id?>"/>
<tr>
<% for (int i = 0; i < SourceTable.Columns.Count; i++) { %>
<td><?=$<%=SourceTable.Columns[i].Name%>?></td>
<%}%>
<td><a href="<%=Page%>_edit.php?id=<?=$id?>" >修改</a></td>
<td><a href="<%=Page%>_del.php?id=<?=$id?>" >删除</a></td>
</tr>
</form>
<?
}
?>
<tr>
<td colspan="4"><? pagelist($resnum,$pagesize,$page,$pagefollow," 条信息")?></td>
</tr>
</table>
</form>
</body>
</html>
<script runat="template">
private string GetTableName()
{
return SourceTable.Name.ToString();
}
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -