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

请教个问题,比如说我用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>

<!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>

<?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?>

Statement
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
Difficulty in updating caching of official account web pages: How to avoid the old cache affecting the user experience after version update?Difficulty in updating caching of official account web pages: How to avoid the old cache affecting the user experience after version update?Mar 04, 2025 pm 12:32 PM

The official account web page update cache, this thing is simple and simple, and it is complicated enough to drink a pot of it. You worked hard to update the official account article, but the user still opened the old version. Who can bear the taste? In this article, let’s take a look at the twists and turns behind this and how to solve this problem gracefully. After reading it, you can easily deal with various caching problems, allowing your users to always experience the freshest content. Let’s talk about the basics first. To put it bluntly, in order to improve access speed, the browser or server stores some static resources (such as pictures, CSS, JS) or page content. Next time you access it, you can directly retrieve it from the cache without having to download it again, and it is naturally fast. But this thing is also a double-edged sword. The new version is online,

How do I use HTML5 form validation attributes to validate user input?How do I use HTML5 form validation attributes to validate user input?Mar 17, 2025 pm 12:27 PM

The article discusses using HTML5 form validation attributes like required, pattern, min, max, and length limits to validate user input directly in the browser.

How to efficiently add stroke effects to PNG images on web pages?How to efficiently add stroke effects to PNG images on web pages?Mar 04, 2025 pm 02:39 PM

This article demonstrates efficient PNG border addition to webpages using CSS. It argues that CSS offers superior performance compared to JavaScript or libraries, detailing how to adjust border width, style, and color for subtle or prominent effect

What are the best practices for cross-browser compatibility in HTML5?What are the best practices for cross-browser compatibility in HTML5?Mar 17, 2025 pm 12:20 PM

Article discusses best practices for ensuring HTML5 cross-browser compatibility, focusing on feature detection, progressive enhancement, and testing methods.

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 <datalist> element, which enhances forms by providing autocomplete suggestions, improving user experience and reducing errors.Character count: 159

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 <progress> element, its purpose, styling, and differences from the <meter> element. The main focus is on using <progress> for task completion and <meter> for stati

How do I use the HTML5 <time> element to represent dates and times semantically?How do I use the HTML5 <time> element to represent dates and times semantically?Mar 12, 2025 pm 04:05 PM

This article explains the HTML5 <time> element for semantic date/time representation. It emphasizes the importance of the datetime attribute for machine readability (ISO 8601 format) alongside human-readable text, boosting accessibilit

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 <meter> element, used for displaying scalar or fractional values within a range, and its common applications in web development. It differentiates <meter> from <progress> and ex

See all articles

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 Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

DVWA

DVWA

Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

Atom editor mac version download

Atom editor mac version download

The most popular open source editor

Dreamweaver Mac version

Dreamweaver Mac version

Visual web development tools

PhpStorm Mac version

PhpStorm Mac version

The latest (2018.2.1) professional PHP integrated development tool

SecLists

SecLists

SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.