if ($ress->eof || $ress->bof) { ?> <tr> <td height="20" colspan="7" align="center" bgcolor="#F8F8F8"><div align="center" class="STYLE1">没有信息!</div></td> </tr> <?php } else { $ress->absolutepage = $page; $mypagesize = $ress->pagesize; while (!$ress->eof && $mypagesize > 0) { ?> <tr> <td height="21" colspan="2" align="center" bgcolor="#F8F8F8"><span class="STYLE1"> <?php $fields = $ress->fields(note_content); echo $fields->value; ?> </span></td> <td colspan="2" align="center" bgcolor="#F8F8F8"><span class="STYLE1"> <?php $fields = $ress->fields(note_category); echo $fields->value; ?> </span></td> <td colspan="3" align="center" bgcolor="#F8F8F8"><a href="delete_colleague_customer.php?lmbs=<?php echo $_GET[lmbs]; ?> ¬e=<?php $fields = $ress->fields(note_id); echo $fields->value;
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; }
public function chkuser() { include_once "conn/conn.php"; $rs = new com("adodb.recordset"); //创建记录集对象 $rs->open("select * from tb_user where username='******' and userpwd='" . $this->pwd . "'", $conn, 3, 1); if ($rs->eof || $rs->bof) { echo "<script>alert('对不起,密码或用户名错误!');history.back();</script>"; exit; } else { session_register("username"); //创建一个变量 $username = $name; /* session_register("producelist"); //电话号码存储车 $producelist=""; //默认值为空 session_register("quatity"); $quatity=""; session_register("producelists"); $producelists=""; session_register("quatitys"); $quatitys=""; session_register("producelistes"); //常用短语存储车 $producelistes=""; session_register("quatityes"); $quatityes=""; */ $data = substr(date("Y-n-j"), 5, 50); $rss = new com('adodb.recordset'); //创建记录集对象 $rss->open("select * from tb_colleague where colleague_birthday='" . $data . "'", $conn, 3, 1); $res = new com('adodb.recordset'); //创建记录集对象 $res->open("select * from tb_customer where customer_birthday='" . $data . "'", $conn, 3, 1); if ($rss->eof and $res->eof) { echo "<script>alert('登录成功!');window.location.href='indexs.php';</script>"; // echo "<meta http-equiv=\"Refresh\" content=\"3;url=indexs.php\">登录成功,3秒钟转入前页,请稍等......"; } else { echo "今天是"; $data = substr(date("Y-n-j"), 5, 50); $rss = new com('adodb.recordset'); //创建记录集对象 $rss->open("select * from tb_colleague where colleague_birthday='" . $data . "'", $conn, 3, 1); while (!$rss->eof) { $fields = $rss->fields(colleague_name); $birthday = $fields->value; echo $birthday . "."; $rss->movenext; } $res = new com('adodb.recordset'); //创建记录集对象 $res->open("select * from tb_customer where customer_birthday='" . $data . "'", $conn, 3, 1); while (!$res->eof) { $fields = $res->fields(customer_name); $birthday = $fields->value; echo $birthday . "."; $res->movenext; } echo "的生日"; echo "<meta http-equiv=\"Refresh\" content=\"10;url=indexs.php\">10秒钟转入主页,请稍等......"; } } }
$page = intval($_GET[page]); } if ($rs->eof || $rs->bof) { ?> <tr> <td height="20" colspan="5" bgcolor="#FFFFFF"><div align="center">没有信息!</div></td> </tr> <?php } else { $res->absolutepage = $page; $mypagesize = $rs->pagesize; while (!$rs->eof && $mypagesize > 0) { ?> <tr> <td width="20"><input type="checkbox" name="check[]" value="<?php $fields = $rs->fields(mail_id); echo $fields->value; ?> " /></td> <td width="132" height="25"><div align="center"> <?php $fields = $rs->fields(mail_title); echo $fields->value; ?> </div></td> <td><div align="center"> <?php $fields = $rs->fields(mail_formuser); echo $fields->value; ?> </div></td>
$arrayquatity = explode("@", $_SESSION[quatity]); while (list($name, $value) = each($_POST)) { for ($i = 0; $i < count($array) - 1; $i++) { if ($array[$i] == $name) { $arrayquatity[$i] = $value; } } } $_SESSION[quatity] = implode("@", $arrayquatity); for ($i = 0; $i < count($array) - 1; $i++) { $id = $array[$i]; if ($id != "") { $sql = 'select * from tb_colleague where colleague_id=' . $id . ''; $res = new com("adodb.recordset"); $res->open($sql, $conn, 3, 1); $fields = $res->fields(colleague_mail); echo $fields->value; } } ?> </textarea></td> <td width="86" height="33" class="STYLE2"><a href="delete_mail.php">删除邮箱</a></td> </tr> <tr> <td><span class="STYLE2">注意:群发使用*分隔邮箱地址</span></td> </tr> </table></td> </tr> <tr> <td height="25" align="center">主 题:</td> <td height="25"><input name="subject" type="text" class="inputcss" id="subject" style="background-color:#e8f4ff " onMouseOver="this.style.backgroundColor='#ffffff'" onMouseOut="this.style.backgroundColor='#e8f4ff'" size="50" /></td>
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" align="right"><img src="images/bg_19.gif" width="20" height="19"></td> <td height="24"> <a href="mail_che6.php?id=<?php $fields = $rs->fields(colleague_id); echo $fields->value; ?> "><?php $fields = $rs->fields(colleague_name); echo $fields->value; ?> </a></td> </tr><?php
if ($rs->eof || $rs->bof) { ?> <tr> <td height="20" colspan="6" align="center" bgcolor="#F8F8F8"><div align="center" class="STYLE1">没有信息!</div></td> </tr> <?php } else { $res->absolutepage = $page; $mypagesize = $rs->pagesize; while (!$rs->eof && $mypagesize > 0) { ?> <tr> <td align="center" bgcolor="#F8F8F8"><span class="STYLE1"> <?php $fields = $rs->fields(colleague_name); echo $fields->value; ?> </span></td> <td align="center" bgcolor="#F8F8F8"><span class="STYLE1"> <?php $fields = $rs->fields(colleague_tel); echo $fields->value; ?> </span></td> <td align="center" bgcolor="#F8F8F8"><span class="STYLE1"> <?php $fields = $rs->fields(colleague_mail); echo $fields->value; ?> </span></td>
$arrayquatityes = explode("@", $_SESSION[quatityes]); while (list($names, $values) = each($_POST)) { for ($i = 0; $i < count($arrayes) - 1; $i++) { if ($arrayes[$i] == $names) { $arrayquatityes[$i] = $values; } } } $_SESSION[quatityes] = implode("@", $arrayquatityes); for ($i = 0; $i < count($arrayes) - 1; $i++) { $ides = $arrayes[$i]; if ($ides != "") { $sql = 'select * from tb_note where note_id=' . $ides . ''; $rs = new com("adodb.recordset"); $rs->open($sql, $conn, 3, 3); $fields = $rs->fields(note_content); echo $fields->value; } } ?> </textarea> </div></td> </tr> <tr> <td width="306" height="20"><div align="center" class="STYLE1">注册手机号:</div></td> <td width="639" height="20"><div align="left"><input name="regtel" type="text" class="inputcss" id="regtel" size="30" > </div></td> </tr> <tr> <td height="20"><div align="center" class="STYLE1">注册密码:</div></td> <td height="20"><div align="left"><input name="regpwd" type="password" class="inputcss" id="regpwd" size="30">
if ($res->eof || $res->bof) { ?> <tr> <td height="20" colspan="6" bgcolor="#F8F8F8"><div align="center" class="STYLE1">暂无短信发送记录!</div></td> </tr> <?php } else { $res->absolutepage = $page; $mypagesize = $res->pagesize; while (!$res->eof && $mypagesize > 0) { ?> <tr> <td height="20" align="center" valign="middle" bgcolor="#F8F8F8"><span class="STYLE1"> <?php $fields = $res->fields(short_ip); echo $fields->value; ?> </span></td> <td align="center" valign="middle" bgcolor="#F8F8F8"><span class="STYLE1"> <?php $fields = $res->fields(short_tel); echo $fields->value; ?> </span></td> <td align="center" valign="middle" bgcolor="#F8F8F8"><span class="STYLE1"> <?php $fields = $res->fields(short_tels); echo $fields->value; ?> </span></td>
if ($res->eof || $res->bof) { ?> <tr> <td height="20" colspan="6" bgcolor="#F8F8F8"><div align="center" class="STYLE1">没有信息!</div></td> </tr> <?php } else { $res->absolutepage = $page; $mypagesize = $res->pagesize; while (!$res->eof && $mypagesize > 0) { ?> <tr> <td align="center" bgcolor="#F8F8F8"><span class="STYLE1"> <?php $fields = $res->fields(customer_name); echo $fields->value; ?> </span></td> <td align="center" bgcolor="#F8F8F8"><span class="STYLE1"> <?php $fields = $res->fields(customer_tel); echo $fields->value; ?> </span></td> <td align="center" bgcolor="#F8F8F8"><span class="STYLE1"> <?php $fields = $res->fields(customer_mail); echo $fields->value; ?> </span></td>