包括:
数据库连接
读取表并列表显示
数据库连接
读取表并列表显示
解决方案 »
- 关于如何选定一个文件并打开的问题
- 急求PHP分页赋值问题....大大帮助解决一下.....在线等了给分附代码等待5个小时了还没解决 大家帮帮忙
- 开发php聊天室中关于session的问题
- 疯了,要生成1亿个10位的随机数字
- 变量中有值,为什么empty为真?
- 生成静态页面的前台登陆问题????
- PHP Fatal error: Uncaught exception 'com_exception' with message
- 高分急求: copy()时,提示"failed to open dtream:permission denide in fileup.php" 在线等
- 关于php
- 用什么开发软件开发php,象用frontpage和interdev 开发asp,即可以看页面,又可以看代码。
- PHP的file_put_contents为什么只能输出ANSI编码的TXT文件?
- 请教一个PHP的问题(急!!!)
比如http://www.php-open.com/21.htm
找找看吧
down.chainz.com
<?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>这个事电子邮件列表文件,你改改就是了!!
$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文件