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

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

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)

What is the purpose of the <progress> element? What is the purpose of the <progress> element? Mar 21, 2025 pm 12:34 PM

The article discusses the HTML &lt;progress&gt; element, its purpose, styling, and differences from the &lt;meter&gt; element. The main focus is on using &lt;progress&gt; for task completion and &lt;meter&gt; for stati

What is the purpose of the <datalist> element? What is the purpose of the <datalist> element? Mar 21, 2025 pm 12:33 PM

The article discusses the HTML &lt;datalist&gt; element, which enhances forms by providing autocomplete suggestions, improving user experience and reducing errors.Character count: 159

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.

What is the purpose of the <meter> element? What is the purpose of the <meter> element? Mar 21, 2025 pm 12:35 PM

The article discusses the HTML &lt;meter&gt; element, used for displaying scalar or fractional values within a range, and its common applications in web development. It differentiates &lt;meter&gt; from &lt;progress&gt; and ex

What is the purpose of the <iframe> tag? What are the security considerations when using it? What is the purpose of the <iframe> tag? What are the security considerations when using it? Mar 20, 2025 pm 06:05 PM

The article discusses the &lt;iframe&gt; tag's purpose in embedding external content into webpages, its common uses, security risks, and alternatives like object tags and APIs.

What is the viewport meta tag? Why is it important for responsive design? What is the viewport meta tag? Why is it important for responsive design? Mar 20, 2025 pm 05:56 PM

The article discusses the viewport meta tag, essential for responsive web design on mobile devices. It explains how proper use ensures optimal content scaling and user interaction, while misuse can lead to design and accessibility issues.

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.

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.

See all articles