首頁 > 後端開發 > php教程 > 搞不懂了,数据库数据查询有关问题

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

WBOY
發布: 2016-06-13 13:30:05
原創
974 人瀏覽過

搞不懂了,数据库数据查询问题。
搞不懂了,数据库数据查询问题。
数据库设计如下
 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
<!--

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/

-->我的想法

如下条件要同时满足   
登入後複製

大号数:

奇数:

质数:

第一部分:

第二部分:

第三部分:

query($sql); //$row1=mysql_fetch_array($dbb,MYSQLI_BOTH) ; echo "试验多次,首先是值没传递进去,其次就算传递进去怎么传递出来,输出到TXT也行" ; ?>
相關標籤:
來源:php.cn
本網站聲明
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn
熱門教學
更多>
最新下載
更多>
網站特效
網站源碼
網站素材
前端模板