脚本宝典收集整理的这篇文章主要介绍了php – 如何从数据库中提取FAQ页面?,脚本宝典觉得挺不错的,现在分享给大家,也给大家做个参考。
function PRint_categories() { global $MysqL; if (($categories = $MysqL->select_all("SELECT * From QandA_wiki.categories")) !== false) { foreach ($categories as $cITem) { $counter = 1; print"<div id=\"categories_start\" style=\"width:424px; margin:0 auto;\">\n"; print"<div id=\"category\" >\n"; print"<h2> {$citem['description']}</h2>"; print "<div class=\"col-lg-12 footerLine\"><hr /></div>"; if (($questions = $MysqL->select_all("SELECT * From QandA_wiki.qanda")) !== false) { foreach ($questions as $qitem) { print"<div id=\"question_number\" >\n"; print"<div id=\"questions\" >\n"; print"<p>#: {$counter} -<strong>{$qitem['question']}</strong></p>"; print"</div>\n"; print"<p> {$qitem['answer']}</p>"; print "<div class=\"col-lg-12 footerLine\"><hr /></div>"; print"</div>\n"; print"<div style=\"clear:both;\"></div>\n"; print"<br />\n"; $counter=$counter+1; } } print"</div>\n"; print"</div>\n"; print"<div style=\"clear:both;\"></div>\n"; print"<br />\n"; }}}}
SELECT QandA_wiki.qanda.*,QandA_wiki.qanda.id,QandA_wiki.qanda.name_of_your_column FROM QandA_wiki.qanda LEFT JOIN QandA_wiki.categories ON QandA_wiki.qanda.category_id = QandA_wiki.categories.id // This is a guess here...likely will need to modify WHERE QandA_wiki.categories.name_of_your_column = name_you_want; // This where clause does the filtering as you needed
另外,我不确定你的$MysqL函数是做什么的,但在MysqLi中它看起来像这样(其中$link是你的数据库连接信息):
$query = MysqLi_query($link,"SELECT QandA_wiki.qanda.*,QandA_wiki.qanda.name_of_your_column FROM QandA_wiki.qanda LEFT JOIN QandA_wiki.categories ON QandA_wiki.qanda.category_id = QandA_wiki.categories.id WHERE QandA_wiki.categories.name_of_your_column = name_you_want;");
以上是脚本宝典为你收集整理的php – 如何从数据库中提取FAQ页面?全部内容,希望文章能够帮你解决php – 如何从数据库中提取FAQ页面?所遇到的问题。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。