应用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 >

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

< title ></ title >

< style type ="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 >

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

< tr >

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

< table width ="460" border ="0" align ="center" >

< tr >

< td width ="100" height ="226" > < div align ="center" >

< p align ="center" >< img src ="image/doc.png" width ="87" height ="100" align ="middle" >< br >

</ p >

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

</ p >

</ div ></ td >

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

< table width ="360" border ="0" >

< tr class ="style2" >

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

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

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

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

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

</ tr >

< tr class ="min1" background ="image/line.gif" >

< td height ="3" colspan ="5" >< div align ="center" >< img src ="image/line1.gif" width ="98%" height ="1" ></ div ></ td >

</ tr >

<? phpdo{ ?>



< tr class ="style2" >

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

< td >< div align ="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 >< div align ="center" > <? php$cmd="/usr/local/bin/svnlookyoungest".$row_Recordset1['depart_locate']."/".$row_Recordset1['depart_dir'];exec($cmd,$ver);echo$ver[0]; ?> </ div >

</ td >

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

</ div ></ td >

< td >< div align ="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 >

< tr class ="min1" background ="image/line.gif" >

< td height ="3" colspan ="5" >< div align ="center" >< img src ="image/line1.gif" width ="98%" height ="1" ></ div ></ td >

</ tr >

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

</ table >

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

</ tr >

< tr >

< td colspan ="2" >< div align ="center" >

< p class ="style7" >< br >

< span class ="style2" >< br >

</ span ></ p >

</ div ></ td >

</ tr >

</ table ></ td >

</ tr >

< tr >

< td valign ="top" >< table width ="400" border ="0" align ="center" cellpadding ="0" cellspacing ="0" >

< tr >

< td height ="80" valign ="bottom" >< div align ="center" >< img src ="image/TITLE.gif" width ="271" height ="61" ></ div ></ td >

</ tr >

</ table ></ td >

</ tr >

</ table >

</ body >

</ html >

<? php

mysql_free_result($Recordset1);

?>

执行结果如下