跳转到主内容
趣航编程网 - 趣学编程,启航技术之路!

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

搞不懂了,数据库数据查询问题。 搞不懂了,数据库数据查询问题。 数据库设计如下 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
我的想法 如下条件要同时满足
大号数:奇数:质数:第一部分:第二部分:第三部分: 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也行" ; ?>

相关文章