<?
require ("config_ym.php");
$sql="select title from movies";
@$result=mysql_query($sql);
while($rs=mysql_fetch_object($result)){
$tmp = $rs->title.',';
}
$condition = " NOT (title IN ($tmp))" //这里是从远端数据库生成的本地查询的条件
require ("config_m.php");
$exec = "select * from movies where $condition"; //求总的记录数
$result = mysql_query($exec);
$recountCount = mysql_num_rows($result);
$totalPage = ceil($recountCount/10);
$page = (isset($_GET['page']) && $_GET['page']>=0)? $_GET['page']: 0;
$isLast = ($page==($totalPage-1))? true: false;
$hasNoPre = ($page==0)? true: false;
$hasNoNext = ($page==$totalPage-1)? true: false;
$isFirst = ($page==0)? true:false;$sql="select * from movies where $condition limit ".($page*10).",10";
@$result=mysql_query($sql);
while($rs=mysql_fetch_object($result)){ {
echo "<tr>";
echo "<td bgcolor='#ffffff' align='center'><input type='checkbox' name='addname[]' value='$name'></td>";
echo "<td bgcolor='#ffffff' align='center'>$rs->title</td>";
echo "<td bgcolor='#ffffff' align='center'>$rs->url</td>";
echo "</tr>";
}
?>
<tr><td bgcolor='#ffffff' align='center'></td><td colspan="10" bgcolor="#ffffff" align="right"><?
$str = "共 $recountCount 条记录,当前第 ".($page+1)."/$totalPage 页 ";
$str .= $isFirst? "首页 " : "<a href=\"delete.php?page=0\">首页</a> ";
$str .= $hasNoPre? "上一页 " : "<a href=\"delete.php?page=".($page-1)."\">上一页</a> ";
$str .= $hasNoNext? "下一页 " : "<a href=\"delete.php?page=".($page+1)."\">下一页</a> ";
$str .= $isLast? "尾页 " : "<a href=\"delete.php?page=".($totalPage-1)."\">尾页</a>";
echo $str;
?>config_ym.php的代码是这样的:
<?
$conn=mysql_connect ("192.168.4.20", "vcom", "vcom");
mysql_select_db("VOD3_01");
?>config_m.php的代码是这样的:
<?
$conn=mysql_connect ("localhost", "vcom", "vcom");
mysql_select_db("VOD3_01");
?>运行时出现了下面的错误:
Parse error: parse error in /home/apache/focus/load/add.php on line 149也就是
require ("config_m.php");这行出错.
require ("config_ym.php");
$sql="select title from movies";
@$result=mysql_query($sql);
while($rs=mysql_fetch_object($result)){
$tmp = $rs->title.',';
}
$condition = " NOT (title IN ($tmp))" //这里是从远端数据库生成的本地查询的条件
require ("config_m.php");
$exec = "select * from movies where $condition"; //求总的记录数
$result = mysql_query($exec);
$recountCount = mysql_num_rows($result);
$totalPage = ceil($recountCount/10);
$page = (isset($_GET['page']) && $_GET['page']>=0)? $_GET['page']: 0;
$isLast = ($page==($totalPage-1))? true: false;
$hasNoPre = ($page==0)? true: false;
$hasNoNext = ($page==$totalPage-1)? true: false;
$isFirst = ($page==0)? true:false;$sql="select * from movies where $condition limit ".($page*10).",10";
@$result=mysql_query($sql);
while($rs=mysql_fetch_object($result)){ {
echo "<tr>";
echo "<td bgcolor='#ffffff' align='center'><input type='checkbox' name='addname[]' value='$name'></td>";
echo "<td bgcolor='#ffffff' align='center'>$rs->title</td>";
echo "<td bgcolor='#ffffff' align='center'>$rs->url</td>";
echo "</tr>";
}
?>
<tr><td bgcolor='#ffffff' align='center'></td><td colspan="10" bgcolor="#ffffff" align="right"><?
$str = "共 $recountCount 条记录,当前第 ".($page+1)."/$totalPage 页 ";
$str .= $isFirst? "首页 " : "<a href=\"delete.php?page=0\">首页</a> ";
$str .= $hasNoPre? "上一页 " : "<a href=\"delete.php?page=".($page-1)."\">上一页</a> ";
$str .= $hasNoNext? "下一页 " : "<a href=\"delete.php?page=".($page+1)."\">下一页</a> ";
$str .= $isLast? "尾页 " : "<a href=\"delete.php?page=".($totalPage-1)."\">尾页</a>";
echo $str;
?>config_ym.php的代码是这样的:
<?
$conn=mysql_connect ("192.168.4.20", "vcom", "vcom");
mysql_select_db("VOD3_01");
?>config_m.php的代码是这样的:
<?
$conn=mysql_connect ("localhost", "vcom", "vcom");
mysql_select_db("VOD3_01");
?>运行时出现了下面的错误:
Parse error: parse error in /home/apache/focus/load/add.php on line 149也就是
require ("config_m.php");这行出错.
mysql_select_db("VOD3_01",$conn); 对于你上面的数据取不同的就用not in 子查询来实现
另外就是这显示出来的还是全部数据,并没有显示远程数据库里没有的,而是全部显示出来.<?
require ("config_y.php");
$sql="select title from movies";
@$result=mysql_query($sql);
while($rs=mysql_fetch_object($result)){
$tmp = $rs->title.',';
}
$condition = " NOT (title IN ('$tmp'))" ; //这里是从远端数据库生成的本地查询的条件
require ("config.php");
$exec = "select * from movies where $condition"; //求总的记录数
$result = mysql_query($exec);
$recountCount = mysql_num_rows($result);
$sql="select * from movies where $condition";
@$result=mysql_query($sql);
while($rs=mysql_fetch_object($result)){
echo "<tr>";
echo "<td bgcolor='#ffffff' align='center'><input type='checkbox' name='addname[]' value='$name'></td>";
echo "<td bgcolor='#ffffff' align='center'>$rs->title</td>";
echo "<td bgcolor='#ffffff' align='center'>$rs->url</td>";
echo "</tr>";
}
?>
<tr><td bgcolor='#ffffff' align='center'></td><td colspan="2" bgcolor="#ffffff" align="right">
<?
$str = "共 $recountCount 条记录";
echo $str;
?>
<input type="button" onClick="test()" value="添加"> </td></tr></table></form>