解决方案 »
- PDO数据分页类效率高还是用存储过程效率高?同时求代码!
- 象这样的衔接 .php/abc/efg/ 是用什么做的 根本找不到目录呀
- 多个文件之间require_once的问题
- PHP找私活
- phpMyAdmin能连接MySQL吗?
- 讨论一下,PHPMVC开发出来的系统运行速度怎么样呢?
- 我以前是学asp的,现在公司的网站是PHP的,不知道CSDN高手告诉我怎么样学好它,看哪些经典的书呢
- 关于PHP内置函数的问题?
- thinkphp upload 图片批量上传问题
- register new php version无法点击的问题
- 网页显示1000多行的表格时缓慢,有什么办法解决?
- 一个frame怎么一运行就是你想打开或者保存文件吗?我点打开还是打不开,他已经保存了
$list .= "'" . $nm['xm'].($i+1) . "'" .',';并不会循环,而且提示错误,没有能获取到任何数据,查询失败
$car = array('name'=>array(0=>array('xm'=>'我是特别的'),1=>array('xm'=>'你好'), 2=>array('xm'=>'你好'), 3=>array('xm'=>'你好')));
if(!$car['name']){
$list='Nothing';
}else{
$i = 1;
foreach($car['name'] as $nm)
{
if(strstr($list,$nm['xm']) && $i == 1)
{
$list = str_replace($nm['xm'],$nm['xm'].$i,$list);
$list .= "'" .$nm['xm'].($i+1). "'";
$i++;
}else{
if(strstr($list,$nm['xm']))
{
$list .= "'" .$nm['xm'].($i+1). "'" ;
$i++;
}else{
$list .= "'" .$nm['xm']. "'" .',';
}
}
}
}$list输出结果为:'我是特别的','你好1','你好2','你好3',但是$sql="SELECT * FROM table where table.title in ($list) limit 0,10";依然查询不到任何数据
可以确认,title有输出的结果,因为如果使用:$list ="'我是特别的','你好1','你好2','你好3'";
$sql="SELECT * FROM table where table.title in ($list) limit 0,10";
的话,以上sql语句是可以查询出来的
$list ="'我是特别的','你好1','你好2','你好3'";
$sql="SELECT * FROM table where title in ($list) limit 0,10";
$mysql_server_name='localhost';
$mysql_username='root';
$mysql_password='123456';
$mysql_database='test';
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database);
mysql_select_db('456789');
mysql_query("SET NAMES UTF8",$conn);
$list="'我是特别的','你好1','你好2','你好3'";
$sql="SELECT * FROM table where table.title in ($list) limit 0,10";
$result=mysql_query($sql,$conn);
while($submit = mysql_fetch_array($result)) {
echo $submit["id"];
echo $submit["title"]."<br>";
}
输出结果为:10我是特别的<br>11你好1<br>12你好2<br>13你好3<br>
$mysql_server_name='localhost';
$mysql_username='root';
$mysql_password='123456';
$mysql_database='test';
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database);
mysql_select_db('456789');
mysql_query("SET NAMES UTF8",$conn);
$list="";
$car = array('name'=>array(0=>array('xm'=>'我是特别的'),1=>array('xm'=>'你好'), 2=>array('xm'=>'你好'), 3=>array('xm'=>'你好')));
if(!$car['name']){
$list='Nothing';
}else{
$i = 1;
foreach($car['name'] as $nm)
{
if(strstr($list,$nm['xm']) && $i == 1)
{
$list = str_replace($nm['xm'],$nm['xm'].$i,$list);
$list .= "'" .$nm['xm'].($i+1). "'";
$i++;
}else{
if(strstr($list,$nm['xm']))
{
$list .= "'" .$nm['xm'].($i+1). "'" ;
$i++;
}else{
$list .= "'" .$nm['xm']. "'" .',';
}
}
}
}
$sql="SELECT * FROM table where table.title in ($list) limit 0,10";
$result=mysql_query($sql,$conn);
while($submit = mysql_fetch_array($result)) {
echo $submit["id"];
echo $submit["title"]."<br>";
}其中$list输出结果为:'我是特别的','你好1','你好2','你好3'
但是mysql提示错误:mysql_fetch_array(): supplied argument is not a valid MySQL result resource
$car = array('name'=>array(0=>array('xm'=>'我是特别的'),1=>array('xm'=>'你好'), 2=>array('xm'=>'你好'), 3=>array('xm'=>'你好')));
if(!$car['name']){
$list='Nothing';
}else{
$i = 1;
foreach($car['name'] as $nm)
{
if(strstr($list,$nm['xm']) && $i == 1)
{
$list = str_replace($nm['xm'],$nm['xm'].$i,$list);
$list .= "'" .$nm['xm'].($i+1). "'";
$i++;
}else{
if(strstr($list,$nm['xm']))
{
$list .= "'" .$nm['xm'].($i+1). "'" ;
$i++;
}else{
$list .= "'" .$nm['xm']. "'" .',';
}
}
}
}
这样,但是这样并不能查询出任何数据,提示:mysql_fetch_array(): supplied argument is not a valid MySQL result resource
$sql="SELECT * FROM table where table.title in ($list) limit 0,10";
我让你贴出
echo $sql;
的结果!拿到就那么难吗?
不好意思,理解错误