php新手问题:求一个完整的php+mysql新闻列表代码

kook_an 2009-08-21 11:38:10
包括:
数据库连接
读取表并列表显示
...全文
191 点赞 收藏 13
写回复
13 条回复
切换为时间正序
请发表友善的回复…
发表回复
kook_an 2009-08-21
up
回复
fenyao 2009-08-21
开源的有很多
比如http://www.php-open.com/21.htm
找找看吧
回复
kook_an 2009-08-21
kook_an 2009-08-21
在线等


有答案马上结贴给分

谢谢
回复
kook_an 2009-08-21
up
回复
CYBEREXP2008 2009-08-21
<?php

$conn = new com("adodb.connection") or die("Cannot start ADO");
$connstr="driver={microsoft access driver (*.mdb)}; dbq=". realpath("data/db_mail_shortnote.mdb");
$connstr="Provider=MySQL ODBC 5.1.5 Driver;SERVER=localhost;DATABASE=qykx;UID=root;PASSWORD=yuchao";

//require_once('adodb.inc.php');

//$conn = &ADONewConnection('mysql');

//$mysql_obj = $conn->connect('localhost','root','yuchao','qykx');


$conn->open($connst);
?>


这是conn.php文件
回复
CYBEREXP2008 2009-08-21

<?php include_once("conn/conn.php"); ?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<script language="javascript">
function open01(){
if(kh.style.display=='')
kh.style.display='none';
else if(kh.style.display=='none')
kh.style.display='';
}

function open02(){
if(ts.style.display=='')
ts.style.display='none';
else if(ts.style.display=='none')
ts.style.display='';
}
function open03(){
if(cydy.style.display=='')
cydy.style.display='none';
else if(cydy.style.display=='none')
cydy.style.display='';
}
function open04(){
if(file.style.display=='')
file.style.display='none';
else if(file.style.display=='none')
file.style.display='';
}

</script>
<body>

<table width="167" border="0" cellspacing="0" cellpadding="0">

<tr>
<td><img src="images/bg_09.gif" width="167" height="21"></td>
</tr>

<tr>
<td><img src="images/bg_14.gif" width="167" height="31" border="0" onClick="javascript:open04();"></td>
</tr>
</table>
<table width="167" border="0" cellpadding="0" cellspacing="0" background="images/bg_34.gif" id="file"

<?php

if(!($_GET[lmlb]=="客户信息管理" || $_GET[lmlb]=="同事信息管理"||$_GET[lmlb]=="常用短语管理" ||$_GET[lmlb]=="短信记录管理")){
?> style="display:none"
<?php
}
?>
>
<tr>
<td width="42" height="24" align="right" valign="middle">
<div align="right"><a href="indexs.php?lmbs=<?php echo $_GET[lmbs];?>&lmlb=客户信息管理" class="STYLE1"><img src="images/bg_19.gif" width="20" height="19" border="0"></a></div></td>
<td width="125" valign="middle"><a href="indexs.php?lmbs=<?php echo $_GET[lmbs];?>&lmlb=客户信息管理" class="STYLE1"> 客户信息管理</a></td>
</tr>
<tr>
<td height="24" align="right">
<div align="right"><a href="indexs.php?lmbs=<?php echo $_GET[lmbs];?>&lmlb=客户信息管理" class="STYLE1"><img src="images/bg_19.gif" width="20" height="19" border="0"></a></div></td>
<td><a href="indexs.php?lmbs=<?php echo $_GET[lmbs];?>&lmlb=同事信息管理" class="STYLE1"> 同事信息管理</a></td>
</tr>
<tr>
<td height="24" align="right">
<div align="right"><a href="indexs.php?lmbs=<?php echo $_GET[lmbs];?>&lmlb=客户信息管理" class="STYLE1"><img src="images/bg_19.gif" width="20" height="19" border="0"></a></div></td>
<td><a href="indexs.php?lmbs=<?php echo $_GET[lmbs];?>&lmlb=常用短语管理" class="STYLE1"> </a><a href="indexs.php?lmbs=<?php echo $_GET[lmbs];?>&lmlb=常用短语管理" class="STYLE1">常用短语管理</a></td>
</tr>
<tr>
<td height="24" align="right">
<div align="right"><a href="indexs.php?lmbs=<?php echo $_GET[lmbs];?>&lmlb=客户信息管理" class="STYLE1"><img src="images/bg_19.gif" width="20" height="19" border="0"></a></div></td>
<td><a href="indexs.php?lmbs=<?php echo $_GET[lmbs];?>&lmlb=短信记录管理" class="STYLE1"> </a><a href="indexs.php?lmbs=<?php echo $_GET[lmbs];?>&lmlb=短信记录管理" class="STYLE1">短信记录管理</a></td>
</tr>
<tr>
<td height="2" colspan="3" align="right"></td>
</tr>
</table>


<table width="14%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="images/bg_26.gif" width="167" height="31" border="0" onClick="javascript:open01();"></td>
</tr>
</table>
<table width="167" border="0" cellpadding="0" cellspacing="0" background="images/bg_34.gif" id="kh"
style="display:none"
<?php

if(!($_GET[idss]=='$fields->value')){
?>
<?php
}
?>
>

<?php

$sql="select * from tb_customer";
$rs=new com("adodb.recordset");
$rs->open($sql,$conn,1,1);
while(!$rs->eof)
{
$fields=$rs->fields(customer_id);
?>
<tr>
<td width="42" height="24" align="right"><img src="images/bg_19.gif" width="20" height="19"></td>
<td><a href="che4.php?idss=<?php $fields=$rs->fields(customer_id);echo $fields->value;?>"> 
<?php $fields=$rs->fields(customer_name);echo $fields->value;?>
</a></td>
</tr><?php
$rs->movenext;
}
?>
<tr>
<td height="2" colspan="3" align="right"></td>
</tr>
</table>


<table width="14%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="images/bg_27.gif" width="167" height="31" border="0" onClick="javascript:open02();"></td>
</tr>
</table>
<table width="167" border="0" cellpadding="0" cellspacing="0" background="images/bg_34.gif" id="ts"
style="display:none"

<?php

if(!($_GET[id]=='$fields->value')){
?>
<?php
}
?>
>

<?php
$sql="select * from tb_colleague";
$rs=new com("adodb.recordset");
$rs->open($sql,$conn,3,1);
while(!$rs->eof)
{
$fields=$rs->fields(colleague_id);
?>
<tr>
<td width="42" height="24" align="right"><img src="images/bg_19.gif" width="20" height="19"></td>
<td width="114">

<a href="che.php?id=<?php $fields=$rs->fields(colleague_id);echo $fields->value;?>"> </a><a href="che.php?id=<?php $fields=$rs->fields(colleague_id);echo $fields->value;?>"><?php $fields=$rs->fields(colleague_name);echo $fields->value;?></a></td>
</tr><?php
$rs->movenext;
}
?>
<tr>
<td height="2" colspan="3" align="right"></td>
</tr>
</table>
<table width="14%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="images/bg_28.gif" width="167" height="31" border="0" onClick="javascript:open03();"></td>
</tr>
</table>
<table width="167" border="0" cellpadding="0" cellspacing="0" background="images/bg_34.gif" id="cydy"
style="display:none"
<?php

if(!($_GET[ides]=='$fields->value')){
?>
<?php
}
?>
>

<?php

$sqls="select * from tb_note";
$res=new com("adodb.recordset");
$res->open($sqls,$conn,1,1);
while(!$res->eof)
{
$fields=$res->fields(note_id);
?>
<tr> <td width="42" height="24" align="right"><img src="images/bg_19.gif" width="20" height="19"></td>
<td width="122">
<a href="che3.php?ides=<?php $fields=$res->fields(note_id);echo $fields->value;?>"><?php $fields=$res->fields(note_content);echo $fields->value;?></a> </td>
</tr><?php
$res->movenext;
}
?>
<tr>
<td height="2" colspan="2" align="right"></td>
</tr>
</table>



</body>
</html>



这个事电子邮件列表文件,你改改就是了!!
回复
kook_an 2009-08-21
up
回复
kook_an 2009-08-21
up

谁复制过来代码
100分给谁

谢谢
回复
baiyuxiong 2009-08-21
找一个最简单的留言本程序看看就明白了
down.chainz.com
回复
kook_an 2009-08-21
up
回复
babysc1 2009-08-21
不会是让把代码发过来吧。。。
回复
发动态
发帖子
基础编程
创建于2007-09-28

2.1w+

社区成员

从PHP安装配置,PHP入门,PHP基础到PHP应用
申请成为版主
社区公告
暂无公告