PHP查询MySQL数据库,并将结果分栏显示,如下代码:
<ol class="dp-xml"> <li class="alt"><span><span class="tag"><span class="tag-name">html</span><span class="tag">></span><span> </span></span></span></li> <li><span><span class="tag"><span class="tag-name">head</span><span class="tag">></span><span> </span></span></span></li> <li class="alt"><span><span class="tag"></span><span class="tag-name">php</span><span> </span></span></li> <li><span>session_start(); </span></li> <li class="alt"><span>include("conn.php"); <span class="tag">?></span><span> </span></span></li> <li><span><span class="tag"><span class="tag-name">title</span><span class="tag">></span><span>查询结果的分栏显示 - www.cxybl.com</span><span class="tag"></span><span class="tag-name">title</span><span class="tag">></span><span> </span></span></span></li> <li class="alt"><span><span class="tag"></span><span class="tag-name">head</span><span class="tag">></span><span> </span></span></li> <li><span><span class="tag"><span class="tag-name">body</span><span class="tag">></span><span> </span></span></span></li> <li class="alt"><span><span class="tag"><span class="tag-name">table</span><span> </span><span class="attribute">width</span><span>=</span><span class="attribute-value">"450"</span><span> </span><span class="attribute">border</span><span>=</span><span class="attribute-value">"1"</span><span> </span><span class="attribute">align</span><span>=</span><span class="attribute-value">"center"</span><span> </span><span class="attribute">cellpadding</span><span>=</span><span class="attribute-value">"0"</span><span> </span><span class="attribute">cellspacing</span><span>=</span><span class="attribute-value">"0"</span><span class="tag">></span><span> </span></span></span></li> <li><span><span class="tag"></span><span class="tag-name">php</span><span> for($</span><span class="attribute">i</span><span>=</span><span class="attribute-value">1</span><span>; $i</span><span class="tag"><span>=4; $i++) { //如果变量</span><span class="tag"><span>=4,按照行进行循环,输出行 </span></span></span></span></li> <li class="alt"><span> echo "<span class="tag"><span class="tag-name">tr</span><span class="tag">></span><span>"; </span><span class="tag">?></span><span> </span></span></span></li> <li><span> <span class="tag"></span><span class="tag-name">php</span><span> if($</span><span class="attribute">i</span><span>==1){ </span></span></li> <li class="alt"><span> $<span class="attribute">query</span><span>=</span><span class="attribute-value">"select * from tb_picture where id order by id desc"</span><span>; //从数据表mr_lttb中获取表情图 </span></span></li> <li><span> $<span class="attribute">lttb</span><span>=</span><span class="attribute-value">mysql_query</span><span>($query); } </span></span></li> <li class="alt"><span> $<span class="attribute">j</span><span>=</span><span class="attribute-value">1</span><span>; //设置变量$</span><span class="attribute">j</span><span>=</span><span class="attribute-value">1</span><span> </span></span></li> <li><span> while ($<span class="attribute">lttb_row</span><span>=</span><span class="attribute-value">mysql_fetch_array</span><span>($lttb)){ //进行while循环输出 </span></span></li> <li class="alt"><span> if ($j<span class="tag"><span>=6) { //每行的表情图个数</span><span class="tag"><span>=8,输出如下内容 </span></span></span></span></li> <li><span> if ($<span class="attribute">c</span><span>==0){ $</span><span class="attribute">c</span><span>=</span><span class="attribute-value">"checked"</span><span>; } </span></span></li> <li class="alt"><span> <span class="tag">?></span><span> </span></span></li> <li><span> <span class="tag"><span class="tag-name">td</span><span> </span><span class="attribute">height</span><span>=</span><span class="attribute-value">"26"</span><span> </span><span class="attribute">align</span><span>=</span><span class="attribute-value">"center"</span><span> </span><span class="attribute">valign</span><span>=</span><span class="attribute-value">"middle"</span><span class="tag">></span><span> </span></span></span></li> <li class="alt"><span><span class="tag"><span class="tag-name">input</span><span> </span><span class="attribute">name</span><span>=</span><span class="attribute-value">"xq"</span><span> </span><span class="attribute">type</span><span>=</span><span class="attribute-value">"radio"</span><span> </span><span class="attribute">value</span><span>=</span><span class="attribute-value">"<?php echo $lttb_row[id];?>"</span><span class="tag"></span><span class="tag-name">php</span><span> echo $c;</span><span class="tag">?></span><span class="tag">></span><span> </span></span></span></li> <li><span><span class="tag"><span class="tag-name">img</span><span> </span><span class="attribute">src</span><span>="</span><span class="tag"></span><span class="tag-name">php</span><span> echo "</span><span class="attribute-value">image_1</span><span>.php?</span><span class="attribute">recid</span><span>=$lttb_row[id]";</span><span class="tag">?></span><span>" </span><span class="attribute">width</span><span>=</span><span class="attribute-value">"16"</span><span> </span><span class="attribute">height</span><span>=</span><span class="attribute-value">"16"</span><span class="tag">></span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></span><span> </span></span></span></li> <li class="alt"><span> <span class="tag"></span><span class="tag-name">php</span><span> } </span></span></li> <li><span> $<span class="attribute">c</span><span>=</span><span class="attribute-value">1</span><span>; </span></span></li> <li class="alt"><span> ++$j; //当表情图的个数增加时 </span></li> <li><span> if($<span class="attribute">j</span><span>==7){ break; } //当表情图的个数等于9时,跳转到下一行重新进行循环 </span></span></li> <li class="alt"><span> } </span></li> <li><span> echo "<span class="tag"></span><span class="tag-name">tr</span><span class="tag">></span><span>"; </span></span></li> <li class="alt"><span> } </span></li> <li><span><span class="tag">?></span><span> </span></span></li> <li class="alt"><span><span class="tag"></span><span class="tag-name">table</span><span class="tag">></span><span> </span></span></li> <li><span><span class="tag"></span><span class="tag-name">body</span><span class="tag">></span><span> </span></span></li> <li class="alt"><span><span class="tag"></span><span class="tag-name">html</span><span class="tag">></span><span> </span></span></li> </ol>
conn.php:
<ol class="dp-c"> <li class="alt"><span><span><?php </span></span></span></li> <li><span><span class="vars">$id</span><span>=mysql_connect(</span><span class="string">"localhost"</span><span>,</span><span class="string">"root"</span><span>,</span><span class="string">"mysql"</span><span>) </span><span class="keyword">or</span><span> </span><span class="keyword">die</span><span>(</span><span class="string">'连接失败:'</span><span> . mysql_error()); </span></span></li> <li class="alt"><span><span class="keyword">if</span><span>(mysql_select_db(</span><span class="string">"phpjcdb"</span><span>,</span><span class="vars">$id</span><span>)) </span><span class="comment">//说明:phpjcdb 是数据库名称</span><span> </span></span></li> <li><span> <span class="func">echo</span><span> </span><span class="string">""</span><span>; </span></span></li> <li class="alt"><span> <span class="keyword">else</span><span> </span></span></li> <li><span> <span class="func">echo</span><span> (</span><span class="string">'数据库选择失败:'</span><span> . mysql_error()); </span></span></li> <li class="alt"><span>mysql_query(<span class="string">"set names gb2312"</span><span>); </span><span class="comment">//设置为简体中文</span><span> </span></span></li> <li><span>?> </span></li> </ol>
声明
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn

热AI工具

Undresser.AI Undress
人工智能驱动的应用程序,用于创建逼真的裸体照片

AI Clothes Remover
用于从照片中去除衣服的在线人工智能工具。

Undress AI Tool
免费脱衣服图片

Clothoff.io
AI脱衣机

Video Face Swap
使用我们完全免费的人工智能换脸工具轻松在任何视频中换脸!

热门文章
刺客信条阴影:贝壳谜语解决方案
4 周前ByDDD
Windows 11 KB5054979中的新功能以及如何解决更新问题
3 周前ByDDD
在哪里可以找到原子中的起重机控制钥匙卡
4 周前ByDDD
<🎜>:死铁路 - 如何完成所有挑战
1 个月前ByDDD
如何修复KB5055523无法在Windows 11中安装?
2 周前ByDDD

热工具

MinGW - 适用于 Windows 的极简 GNU
这个项目正在迁移到osdn.net/projects/mingw的过程中,你可以继续在那里关注我们。MinGW:GNU编译器集合(GCC)的本地Windows移植版本,可自由分发的导入库和用于构建本地Windows应用程序的头文件;包括对MSVC运行时的扩展,以支持C99功能。MinGW的所有软件都可以在64位Windows平台上运行。

适用于 Eclipse 的 SAP NetWeaver 服务器适配器
将Eclipse与SAP NetWeaver应用服务器集成。

安全考试浏览器
Safe Exam Browser是一个安全的浏览器环境,用于安全地进行在线考试。该软件将任何计算机变成一个安全的工作站。它控制对任何实用工具的访问,并防止学生使用未经授权的资源。

mPDF
mPDF是一个PHP库,可以从UTF-8编码的HTML生成PDF文件。原作者Ian Back编写mPDF以从他的网站上“即时”输出PDF文件,并处理不同的语言。与原始脚本如HTML2FPDF相比,它的速度较慢,并且在使用Unicode字体时生成的文件较大,但支持CSS样式等,并进行了大量增强。支持几乎所有语言,包括RTL(阿拉伯语和希伯来语)和CJK(中日韩)。支持嵌套的块级元素(如P、DIV),

Dreamweaver CS6
视觉化网页开发工具