搞不懂了，数据库数据查询有关问题

搞不懂了，数据库数据查询问题。
搞不懂了，数据库数据查询问题。
数据库设计如下
 l1 l2 l3 l4 l5 l6 dqs jqs zqs firstarea secondarea thirdarea ac
"1","1","2","3","4","5","6","21","0","3","4","6","0","0","0"
"2","1","2","3","4","5","7","22","0","4","5","6","0","0","1"
"3","1","2","3","4","6","7","23","0","3","4","6","0","0","1"
"4","1","2","3","5","6","7","24","0","4","5","6","0","0","1"
"5","1","2","4","5","6","7","25","0","3","4","6","0","0","1"
"6","1","3","4","5","6","7","26","0","4","4","6","0","0","1"
"7","2","3","4","5","6","7","27","0","3","4","6","0","0","0"
"8","1","2","3","4","5","8","23","0","3","4","6","0","0","2"
"9","1","2","3","4","6","8","24","0","2","3","6","0","0","2"
"10","1","2","3","5","6","8","25","0","3","4","6","0","0","2"
"11","1","2","4","5","6","8","26","0","2","3","6","0","0","2"
"12","1","3","4","5","6","8","27","0","3","3","6","0","0","1"

想根据已有条件选出来l1,l2,l3,l4,l5,l6的号码，设计了一张大表，包涵全部数据信息。。。
如，根据顾客利用表单提交的dqs,jqs,zqs,firstarea,secondarea,thirdarea等信息的值，挑选出l1到l6的号码都有什么。请问查询语句如何设计，还有表单的输入信息，如何传递给查询语句进行查询？

PHP code

我的想法如下条件要同时满足   <form method=post action="query_action.php"><p>大号数：<input type="text" name="dqs"></p><p>奇数：<input type="text" name="jqs"></p><p>质数：<input type="text" name="zqs"></p><p>第一部分：<input type="text" name="firstarea"></p><p>第二部分：<input type="text" name="secondarea"></p><p>第三部分：<input type="text" name="thirdarea"></p><p><input type="submit" value="查"></p></form><?php  //query_action.php$dqs=$_post['dqs'];$jqs=$_post['jqs'];$zqs=$_post['zqs'];$firstarea=$_post['firstarea'];$secondarea=$_post['secondarea'];$thirdarea=$_post['thirdarea'];$db=new mysqli('localhost','admin','admin','ssq') ;  //mysql_connect("localhost","admin","admin");//mysql_selectdb($test);$sql='select l1,l2,l3,l4,l5,l6 from hmk where l1=1 and l2=2 and l3=3 and l4=4 and l5= 5 and l6=6';  $db->query($sql); //$row1=mysql_fetch_array($dbb,MYSQLI_BOTH) ;      echo "试验多次,首先是值没传递进去,其次就算传递进去怎么传递出来，输出到TXT也行" ;?> 
 

[解决办法]
你用数字作字段没报错吗？
[解决办法]
sql语句的各个字段用''包起来啊，很明显表里存的是char
[解决办法]
没搞懂楼主的意思，从你的代码来看：
$_POST的值有什么作用？是要根据其查询还是将其插入？
另，你的数据库表结构是怎样的？和你给出的数据有什么关系？

[解决办法]
怎么是 l1=1 and l2=2 and l3=3 and l4=4 and l5= 5 and l6=6
至少也该是
$dqs=dqs and $jqs=jqs and $zqs=zqs and $firstarea=firstarea and $secondarea=secondarea and $thirdarea=thirdarea

[解决办法]
是这样吗？

PHP code

$sql="select L1,L2,L3,L4,L5,L6 from hmk where dqs={$dqs} and jqs={$jqs} and zqs={$zqs} and firstarea={$firstarea} and secondarea={$secondarea} and thirdarea={$thirdarea}";$res = mysql_query($sql);if(!$res)    die("SQL:{$sql}<br>Error:".mysql_error());if(mysql_affected_rows() > 0){    while($rows = mysql_fetch_array(MYSQL_ASSOC)){……}}else{    echo "查询失败<br>Error:".mysql_error();}
[解决办法]
你的字段不是char类型吗？ 如果是即要加''号、
$sql="select L1,L2,L3,L4,L5,L6 from hmk where dqs=$dqs and jqs='$jqs' and zqs='$zqs' and firstarea='$firstarea' and secondarea='$secondarea' and thirdarea='$thirdarea'"
[解决办法]
PHP code
$sql="select L1,L2,L3,L4,L5,L6 from hmk where dqs='{$dqs}' and jqs='{$jqs}' and zqs='{$zqs}' and firstarea='{$firstarea}' and secondarea='{$secondarea}' and thirdarea='{$thirdarea}'";$res = mysql_query($sql);if(!$res)    die("SQL:{$sql}<br>Error:".mysql_error());if(mysql_affected_rows() > 0){    $arr = array();    while($rows = mysql_fetch_array(MYSQL_ASSOC)){        array_push($arr,$rows);    }}else{    echo "查询失败<br>Error:".mysql_error();}#将结果打出来看看print_r($arr); 

 

查看更多 下一篇