Table of Contents
回复讨论(解决方案)
Home Web Front-end HTML Tutorial 向前辈请教!数据库echo出的值如何在网页中横向每6个一行输出_html/css_WEB-ITnose

向前辈请教!数据库echo出的值如何在网页中横向每6个一行输出_html/css_WEB-ITnose

Jun 24, 2016 am 11:34 AM

请教个问题,比如说我用PHP echo出了数据库的1千条id数据(单列),那我HTML/CSS里的table怎么写或者
怎么设置才能让他自动的每6条数据为一行,然后第二行再显示6个?如下图一样?
mysqltable:

想要HTML变成:

请大神指教!


回复讨论(解决方案)

http://www.cnblogs.com/lhj588/p/3315876.html

http://www.cnblogs.com/lhj588/archive/2012/06/15/2550392.html


http://blog.csdn.net/zhoushengchao/article/details/7321688

你在前端处理的话 直接用两个集合遍历输出 第一个遍历集总页数也就是1000条/6啦 需要167个

  第二个就输出6个值呀。
还有一种 就是在后台处理啊你是用php开发的啊 这个我就不知道了  也就是和分页差不多

遍历、求于、换行

你就求余呗。。。满6个就执行一次换行即可。。。

<!DOCTYPE html><html><head><title></title><meta charset="UTF-8"><style>#calendarTable {width: 100%;}#calendarTable td,#calendarTable th{padding: 4px ; border:1px solid #ccc; width: 14%}</style>	</head><body><script src="http://libs.baidu.com/jquery/1.11.1/jquery.min.js"></script><script>	$(function () {		var str = '<tr>';		// 假如这是你的1000来条数据		for (var i=1;i<=1000; i++) {						str += '<td>' + i + '</td>';			if (i % 6 ==0) {				str += '</tr>';							}		}				$('#calendarList').append(str);			})</script><table id="calendarTable">	<tbody id="calendarList">	</tbody></table></body></html>
Copy after login

<!DOCTYPE html><html><head><style>table{ border-collapse:collapse; }td{ border:1px solid #000;}</style></head><body></body><script>var str='<table>';for(var k=1;k<=100;k++){str+=k%6==1?'<tr>':'';str+='<td>编号'+k+'</td>'str+=k%6==0?'</tr>':'';}str+="</table>";document.body.innerHTML=str;</script></html>
Copy after login

<?php $result=mysql_query(SQL);//你的查询语句;$k=1;$str="<table>";while($row=mysql_fetch_assoc($result)){	$str.=$k%6==1?'<tr>':'';	$str.="<td>".$row['id']."</td>";	$str.=$k%6==0?'</tr>':'';	}$str.="</table>";echo $str;/////$str就是一个完整的表格html?>
Copy after login

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Is HTML easy to learn for beginners? Is HTML easy to learn for beginners? Apr 07, 2025 am 12:11 AM

HTML is suitable for beginners because it is simple and easy to learn and can quickly see results. 1) The learning curve of HTML is smooth and easy to get started. 2) Just master the basic tags to start creating web pages. 3) High flexibility and can be used in combination with CSS and JavaScript. 4) Rich learning resources and modern tools support the learning process.

The Roles of HTML, CSS, and JavaScript: Core Responsibilities The Roles of HTML, CSS, and JavaScript: Core Responsibilities Apr 08, 2025 pm 07:05 PM

HTML defines the web structure, CSS is responsible for style and layout, and JavaScript gives dynamic interaction. The three perform their duties in web development and jointly build a colorful website.

Understanding HTML, CSS, and JavaScript: A Beginner's Guide Understanding HTML, CSS, and JavaScript: A Beginner's Guide Apr 12, 2025 am 12:02 AM

WebdevelopmentreliesonHTML,CSS,andJavaScript:1)HTMLstructurescontent,2)CSSstylesit,and3)JavaScriptaddsinteractivity,formingthebasisofmodernwebexperiences.

What is an example of a starting tag in HTML? What is an example of a starting tag in HTML? Apr 06, 2025 am 12:04 AM

AnexampleofastartingtaginHTMLis,whichbeginsaparagraph.StartingtagsareessentialinHTMLastheyinitiateelements,definetheirtypes,andarecrucialforstructuringwebpagesandconstructingtheDOM.

Gitee Pages static website deployment failed: How to troubleshoot and resolve single file 404 errors? Gitee Pages static website deployment failed: How to troubleshoot and resolve single file 404 errors? Apr 04, 2025 pm 11:54 PM

GiteePages static website deployment failed: 404 error troubleshooting and resolution when using Gitee...

How to use CSS3 and JavaScript to achieve the effect of scattering and enlarging the surrounding pictures after clicking? How to use CSS3 and JavaScript to achieve the effect of scattering and enlarging the surrounding pictures after clicking? Apr 05, 2025 am 06:15 AM

To achieve the effect of scattering and enlarging the surrounding images after clicking on the image, many web designs need to achieve an interactive effect: click on a certain image to make the surrounding...

How to implement adaptive layout of Y-axis position in web annotation? How to implement adaptive layout of Y-axis position in web annotation? Apr 04, 2025 pm 11:30 PM

The Y-axis position adaptive algorithm for web annotation function This article will explore how to implement annotation functions similar to Word documents, especially how to deal with the interval between annotations...

HTML, CSS, and JavaScript: Essential Tools for Web Developers HTML, CSS, and JavaScript: Essential Tools for Web Developers Apr 09, 2025 am 12:12 AM

HTML, CSS and JavaScript are the three pillars of web development. 1. HTML defines the web page structure and uses tags such as, etc. 2. CSS controls the web page style, using selectors and attributes such as color, font-size, etc. 3. JavaScript realizes dynamic effects and interaction, through event monitoring and DOM operations.

See all articles