- 论坛徽章:
- 0
|
while 里的数据为什么不循环呢? //
生成语句如下:
但在mysqlfront里执行正常,而使用mysql_num_rows()计算也是一条。
SELECT count(*) FROM Realtime_photo WHERE Photo_id = 'ap200301010006 ' or Photo_id = 'ap200301010007 ' or Photo_id = 'ap200301010008 ' or Photo_id = 'ap200301010009 ' or Photo_id = 'ap200301010010 ' or Photo_id = 'ap200301010011 ' or Photo_id = 'ap200301010012'
处理程序
<?
ob_start();
require_once('../include/class.php');
checkSession();
?>;
<html>;
<head>;
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">;
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">;
<meta name=" rogId" content="FrontPage.Editor.Document">;
<title>;下载图信息</title>;
</head>;
<body>;
<div align="left">;
<table border="1" width="737" height="46" bordercolor="#C0C0C0" bordercolorlight="#C0C0C0" bordercolordark="#C0C0C0">;
<tr>;
<td width="737" height="46" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF">;
<p align="center">;<b>;<font size="6">;下载图信息</font>;</b>;<br>;
</td>;
</tr>;
</table>;
</div>;
<div align="left">;
<table border="1" width="737" height="37" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF" bordercolor="#FFFFFF">;
<tr>;
<td width="109" height="37" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF" bgcolor="#FFFFFF">;ID</td>;
<td width="103" height="37" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF" bgcolor="#FFFFFF">;日期</td>;
<td width="235" height="37" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF" bgcolor="#FFFFFF">;标题</td>;
<td width="262" height="37" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF" bgcolor="#FFFFFF">;内容</td>;
</tr>;
</table>;
</div>;
<?php
if(!$_POST['text']){
echo "请填写ID号";
exit;
}
$text = $_POST['text'];
$add = 0;
$text = trim ($text);
$text = explode("\n",$text);
$count = count($text)-1;
while($add <= $count ){
$sql1.=" Photo_id = '$text[$add]' or ";
$add++;
}
//echo $count;
if($count == 0){
$count=1;
}
pageft($count,5);
//$sql2=" ORDER BY Photo_date DESC LIMIT $firstcount,$displaypg";
$sql1;//.=$sql2;
$sql1=substr($sql1,0,-4);
echo "SELECT count(*) FROM Realtime_photo WHERE $sql1";
$sql=$MYDB->;execute("SELECT count(*) FROM Realtime_photo WHERE $sql1" ;
$total=$MYDB->;nums($sql);
echo "<br>;";
echo $total;
exit;
echo "SELECT Photo_id,Photo_date,Photo_content,Photo_title FROM Realtime_photo WHERE $sql1";
$sql4=$MYDB->;execute("SELECT * FROM Realtime_photo WHERE $sql1" ;
//$count=1;
while($result = $MYDB->;fetch($sql4)){
// echo "<br>;";
?>;
<div align="left">;
<table border="1" width="739" height="33">;
<tr>;
<td width="113" height="33" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF" bgcolor="#FFFFFF">;<? echo $result['Photo_id']; ?>;</td>;
<td width="99" height="33" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF" bgcolor="#FFFFFF">;<? echo $result['Photo_date']; ?>;</td>;
<td width="237" height="33" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF" bgcolor="#FFFFFF">;<? echo $result['Photo_title']; ?>;</td>;
<td width="262" height="33" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF" bgcolor="#FFFFFF">;<? echo $result['Photo_content']; ?>;</td>;
</tr>;
</table>;
</div>;
<?
}
?>;
<p align="center">;<font size="2">;<? echo $pagenav; ?>;& </font>;</p>;
</body>;
</html>;
提交表单
<?
ob_start();
require_once('../include/class.php');
checkSession();
?>;
<html>;
<head>;
<meta http-equiv="Content-Language" content="zh-cn">;
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">;
<title>;下载图信息</title>;
</head>;
<body>;
<form method=" OST" action="../site_manage/down_pic_info.php">;
<p>; </p>;
<div align="center">;
<center>;
<table border="1" width="855" height="58">;
<tr>;
<td width="855" height="58" bordercolorlight="#C0C0C0" bordercolordark="#C0C0C0" bgcolor="#C0C0C0" bordercolor="#C0C0C0">;
<p align="center">;<font size="3">;<b>;下载图信息<br>;
</b>;</font>;</td>;
</tr>;
</table>;
</center>;
</div>;
<p>;<b>;<font size="3">;下载实时图文资料</font>;</b>;</p>;
<p align="center">;<textarea rows="10" name="text" cols="54">;</textarea>;</p>;
<p align="center">;<input type="submit" value="显示信息" name="submit">;<input type="reset" value="全部重写" name="post">;</p>;
<p>;<font size="3">;系统提示: 每个id之间使用“,”进行分割.</font>;</p>;
</form>;
</body>;
</html>;
我使用了同事的库,但感觉是库的问题。库如下
class MYDB
{
var $host; //连接数据库主机名
var $user; //连接数据库用户名
var $passWord; //连接数据库密码
var $selectDataBase; // 选择数据库
var $query; //执行sql
var $nums; //返回行数
var $fetch; //返回结果集
function connection($host,$user,$passWord)
{
$this->;host=$host;
$this->;user=$user;
$this->;passWord=$passWord;
$conn=@mysql_pconnect($this->;host,$this->;user,$this->;passWord) or
die("数据库连接有误,请与管理员联系" ;
return $conn;
}
function selectDB($db)
{
$this->;selectDataBase=@mysql_select_db($db);
if(!$this->;selectDataBase)
{
echo "请选择数据库";
}
return $this->;selectDataBase;
}
function execute($sql)
{
$this->;query=@mysql_query($sql) or die("SQL执行错误" ;
return $this->;query;
}
function nums($result)
{
$this->;nums=mysql_num_rows($result);
if($this->;nums<=0)
{
return 0;
}
else
{
return $this->;nums;
}
}
function fetch($result)
{
$this->;fetch = @mysql_fetch_array($result);
return $this->;fetch;
}
} |
|