news.php

通达OA部分源代码

<?
include_once "myconnect.php";
include_once "logincheck.php";

function main()
{

?>
<table width="100%" border="0" cellpadding="0" cellspacing="0" dwcopytype="CopyTableCell">
  <tr> 
    <td valign="top"> <table width="98%" border="0" align="center" cellpadding="2" cellspacing="0">
        <tr> 
          <td align="center" valign="top"> <table width="100%" border="0" cellspacing="10" cellpadding="2">
              <tr> 
                <td height="25" bgcolor="#004080"><strong><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">&nbsp;NEWS</font></strong></td>
              </tr>
              <?
  				$cnt=0;
				$no_latest=mysql_fetch_array(mysql_query("select sb_latest_news_cnt from sbbleads_config"));
				$rs_query=mysql_query("select *,UNIX_TIMESTAMP(sb_postedon) as ondate from sbbleads_news order by sb_id desc");

				while (($rs0=mysql_fetch_array($rs_query)))//&&($cnt<$no_latest))
				{ 
				
			     ?>
              <tr bgcolor="#<? if($cnt%2<>0){echo "EEEEEE"; }else{echo "F2F2F2";}?>"> 
                <td width="46%" height="19" valign="top" > <table width="100%" border="0" cellspacing="0" cellpadding="0">
                    <tr> 
                      <td valign="top"><font size="1" face="Arial, Helvetica, sans-serif">&nbsp;</font></td>
                      <td valign="top"> <table width="100%" border="0" align="left" cellpadding="0" cellspacing="0">
                          <tr> 
                            <td><font color="#333333" size="1" face="Arial, Helvetica, sans-serif"><? echo sb_date($rs0["ondate"]);?></font></td>
                            <td align="right"><a href="news_desc.php?id=<? echo $rs0["sb_id"];?> " class="insidelink"><font size="2" face="Arial, Helvetica, sans-serif">View</font></a>&nbsp;&nbsp;<a href="edit_news.php?id=<? echo $rs0["sb_id"];?> " class="insidelink"><font size="2" face="Arial, Helvetica, sans-serif">Edit</font></a>&nbsp;&nbsp;<a href="delete_news.php?id=<? echo $rs0["sb_id"];?> " class="insidelink" onClick="javascript: return confirm('Do you really want to delete the NEWS');"><font size="2" face="Arial, Helvetica, sans-serif">Delete</font></a>&nbsp;&nbsp;</td>
                          </tr>
                        </table></td>
                    </tr>
                    <tr> 
                      <td><font size="1" face="Arial, Helvetica, sans-serif">&nbsp;</font></td>
                      <td><font color="#003366" size="2" face="Arial, Helvetica, sans-serif"> 
                        <? 
					if (strlen ($rs0["sb_subject"])>100)
					{
					 echo substr($rs0["sb_subject"], 0,  strrpos( substr($rs0["sb_subject"], 0, 100),' ' ))."..";  
					}
					else
					{
					 echo $rs0["sb_subject"];  
					}
					  
                        ?>
                        </font></td>
                    </tr>
                    <tr> 
                      <td><font size="1" face="Arial, Helvetica, sans-serif">&nbsp;</font></td>
                      <td><font color="#333333" size="1" face="Arial, Helvetica, sans-serif"> 
                        <? 
					if (strlen (strip_tags($rs0["sb_description"]))>100)
					{
					 echo substr(strip_tags($rs0["sb_description"]), 0,  strrpos( substr(strip_tags($rs0["sb_description"]), 0, 100),' ' ))."..";  
					}
					else
					{
					 echo strip_tags($rs0["sb_description"]);  
					}

					  ?>
                        </font></td>
                    </tr>
                  </table>
                  <font color="#003366" size="1" face="Verdana, Arial, Helvetica, sans-serif"> 
                  <font color="#003366" size="1" face="Verdana, Arial, Helvetica, sans-serif"> 
                  </font></font></td>
              </tr>
              <?
			  $cnt++;
			  }// end while
			  ?>
              <tr> 
                <td>&nbsp;</td>
              </tr>
            </table></td>
        </tr>
      </table></td>
  </tr>
</table>
<?
}// end main
?>
<?

include_once "template.php";
?>