csdn 无法上传图片,数据表结构图片看百度知道吧
http://zhidao.baidu.com/question/1047510947746416459.html
这是我的数据表结构,PHP+MYSQL 。我想实现出循环这样的效果
尺码 颜色 图案
36 红色 印花
36 红色 平板
36 白色 印花
36 白色 平板
36 黑色 印花
36 白色 平板
37 红色 印花
37 红色 平板
依次类推, 但是尺码、颜色、图案 并不是固定的,有可能 只有两个 如
尺码 颜色
36 红色
36 白色
36 黑色
37 红色
37 白色
。。。。。。 等
也有可能有4个 如 尺码 、颜色、图案、其它
这样用表格的格式循环 要怎么循环啊。。。我现在用FOR可以循环出来,但是只能是固定的,不能自由选择。
回复讨论(解决方案)
你的尺码 、颜色、图案 的值都是在一个字段里的吗?用什么分隔的?数据类型是什么?
看看这个测试例,你应该会知道怎么做了
create temporary table a (`尺码` varchar(10)) charset gbk;insert into a values (36),(37);create temporary table b (`颜色` varchar(10)) charset gbk;insert into b values ('红'),('白'),('蓝'),('黑');create temporary table c (`图案` varchar(10)) charset gbk;insert into c values ('印花'),('平板');select * from a,b,c;
尺码 颜色 图案 36 红 印花 37 红 印花 36 红 平板 37 红 平板 36 白 印花 37 白 印花 36 白 平板 37 白 平板 36 蓝 印花 37 蓝 印花 36 蓝 平板 37 蓝 平板 36 黑 印花 37 黑 印花 36 黑 平板 37 黑 平板
针对每个产品,首先把有的列出来。
例如尺码、颜色、图案 则会有3个数组, size,color,pattern。
例如尺码、颜色则只有两个数组。
然后循环。
你的尺码 、颜色、图案 的值都是在一个字段里的吗?用什么分隔的?数据类型是什么?
尺码 颜色 图案 分别在三条记录里。比如 尺码的所有值都在一个字段里 用 \n 分开的
针对每个产品,首先把有的列出来。
例如尺码、颜色、图案 则会有3个数组, size,color,pattern。
例如尺码、颜色则只有两个数组。
然后循环。
现在可以分为三个数组了,但是我就是不会循环啊
例
$ar = array( array( "A", "B", "C"), array("1", "2", "3", "4"), array("X", "Y", "Z"),);print_rDescartes($ar));function Descartes($d) { $r = array_pop($d); while($d) { $t = array(); $s = array_pop($d); if(! is_array($s)) $s = array($s); foreach($s as $x) { foreach($r as $y) $t[] = array_merge(array($x), is_array($y) ? $y : array($y)); } $r = $t; } return $r;}
例
$ar = array( array( "A", "B", "C"), array("1", "2", "3", "4"), array("X", "Y", "Z"),);print_rDescartes($ar));function Descartes($d) { $r = array_pop($d); while($d) { $t = array(); $s = array_pop($d); if(! is_array($s)) $s = array($s); foreach($s as $x) { foreach($r as $y) $t[] = array_merge(array($x), is_array($y) ? $y : array($y)); } $r = $t; } return $r;}
分都给您了。谢谢您帮了我

PHPsessionstrackuserdataacrossmultiplepagerequestsusingauniqueIDstoredinacookie.Here'showtomanagethemeffectively:1)Startasessionwithsession_start()andstoredatain$_SESSION.2)RegeneratethesessionIDafterloginwithsession_regenerate_id(true)topreventsessi

In PHP, iterating through session data can be achieved through the following steps: 1. Start the session using session_start(). 2. Iterate through foreach loop through all key-value pairs in the $_SESSION array. 3. When processing complex data structures, use is_array() or is_object() functions and use print_r() to output detailed information. 4. When optimizing traversal, paging can be used to avoid processing large amounts of data at one time. This will help you manage and use PHP session data more efficiently in your actual project.

The session realizes user authentication through the server-side state management mechanism. 1) Session creation and generation of unique IDs, 2) IDs are passed through cookies, 3) Server stores and accesses session data through IDs, 4) User authentication and status management are realized, improving application security and user experience.

Tostoreauser'snameinaPHPsession,startthesessionwithsession_start(),thenassignthenameto$_SESSION['username'].1)Usesession_start()toinitializethesession.2)Assigntheuser'snameto$_SESSION['username'].Thisallowsyoutoaccessthenameacrossmultiplepages,enhanc

Reasons for PHPSession failure include configuration errors, cookie issues, and session expiration. 1. Configuration error: Check and set the correct session.save_path. 2.Cookie problem: Make sure the cookie is set correctly. 3.Session expires: Adjust session.gc_maxlifetime value to extend session time.

Methods to debug session problems in PHP include: 1. Check whether the session is started correctly; 2. Verify the delivery of the session ID; 3. Check the storage and reading of session data; 4. Check the server configuration. By outputting session ID and data, viewing session file content, etc., you can effectively diagnose and solve session-related problems.

Multiple calls to session_start() will result in warning messages and possible data overwrites. 1) PHP will issue a warning, prompting that the session has been started. 2) It may cause unexpected overwriting of session data. 3) Use session_status() to check the session status to avoid repeated calls.

Configuring the session lifecycle in PHP can be achieved by setting session.gc_maxlifetime and session.cookie_lifetime. 1) session.gc_maxlifetime controls the survival time of server-side session data, 2) session.cookie_lifetime controls the life cycle of client cookies. When set to 0, the cookie expires when the browser is closed.


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

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

Hot Article

Hot Tools

VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft

MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function

SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.

Dreamweaver Mac version
Visual web development tools
