`
wewi
  • 浏览: 21656 次
  • 性别: Icon_minigender_1
  • 来自: 杭州
文章分类
社区版块
存档分类
最新评论

应用php查询subversion状态

阅读更多
<?phprequire_once('Connections/files.php');?>

<?php

mysql_select_db($database_files,$files);

$query_Recordset1="SELECT*FROMdepartmentORDERBYdepart_idASC";

$Recordset1=mysql_query($query_Recordset1,$files)ordie(mysql_error());

$row_Recordset1=mysql_fetch_assoc($Recordset1);

$totalRows_Recordset1=mysql_num_rows($Recordset1);

?>

<!DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN"

"http://www.w3.org/TR/html4/loose.dtd"
>

<html>

<head>

<metahttp-equiv="Content-Type"content="text/html;charset=utf-8">

<title></title>

<styletype="text/css">...

<!--

body
{...}{

margin-left
:0px;

margin-top
:0px;

margin-right
:0px;

margin-bottom
:0px;

background-color
:#2163AB;

}


.style2
{...}{font-size:12px}

.style7
{...}{color:#999999}

-->

</style>

</head>



<body>

<tablewidth="100%"height="100%"border="0"align="center"valign="bottom"cellpadding="0"cellspacing="0">

<tr>

<tdheight="360"valign="bottom"bgcolor="#FFFFFF"><p>&nbsp;</p>

<tablewidth="460"border="0"align="center">

<tr>

<tdwidth="100"height="226"><divalign="center">

<palign="center"><imgsrc="image/doc.png"width="87"height="100"align="middle"><br>

</p>

<p><spanclass="style2">文档备份</span><br>

</p>

</div></td>

<td><?phpif($totalRows_Recordset1>0){//Showifrecordsetnotempty?>

<tablewidth="360"border="0">

<trclass="style2">

<td><divalign="center"><strong>部门</strong></div></td>

<td><divalign="center"><strong>目录</strong></div></td>

<td><divalign="center"><strong>最新版本</strong></div></td>

<td><divalign="center"><strong>最后提交人</strong></div></td>

<td><divalign="center"><strong>最后提交时间</strong></div></td>

</tr>

<trclass="min1"background="image/line.gif">

<tdheight="3"colspan="5"><divalign="center"><imgsrc="image/line1.gif"width="98%"height="1"></div></td>

</tr>

<?phpdo{?>



<trclass="style2">

<td><divalign="center"><?phpecho$row_Recordset1['depart_name'];?></div></td>

<td><divalign="center"><?phpecho$row_Recordset1['depart_dir'];?></div></td><?php$cmd="/usr/local/bin/svnlookinfo".$row_Recordset1['depart_locate']."/".$row_Recordset1['depart_dir'];exec($cmd,$info);?>

<td><divalign="center"><?php$cmd="/usr/local/bin/svnlookyoungest".$row_Recordset1['depart_locate']."/".$row_Recordset1['depart_dir'];exec($cmd,$ver);echo$ver[0];?></div>

</td>

<td><divalign="center"><?phpecho$info[0];?>

</div></td>

<td><divalign="center"><?php$submit_date=explode('',$info[1]);if($info[0])echo$submit_date[0]."&nbsp;".$submit_date[1];unset($info);unset($ver);unset($submit_date)?>

</div></td>

</tr>

<trclass="min1"background="image/line.gif">

<tdheight="3"colspan="5"><divalign="center"><imgsrc="image/line1.gif"width="98%"height="1"></div></td>

</tr>

<?php}while($row_Recordset1=mysql_fetch_assoc($Recordset1));?>

</table>

<?php}//Showifrecordsetnotempty?></td>

</tr>

<tr>

<tdcolspan="2"><divalign="center">

<pclass="style7"><br>

<spanclass="style2"><br>

</span></p>

</div></td>

</tr>

</table></td>

</tr>

<tr>

<tdvalign="top"><tablewidth="400"border="0"align="center"cellpadding="0"cellspacing="0">

<tr>

<tdheight="80"valign="bottom"><divalign="center"><imgsrc="image/TITLE.gif"width="271"height="61"></div></td>

</tr>

</table></td>

</tr>

</table>

</body>

</html>

<?php

mysql_free_result($Recordset1);

?>

执行结果如下

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics