Multiple columns of a single database Field in php

Multiple columns of a single database Field in php

This article mainly introduces the multi-Column Display of a single database Field in php and the display of branch columns. It can also be called Single-field paging and horizontal output. For more information, see

 

 

 

Today, when I was working on a project, I encountered a problem: to display the branches of the same field read from the database, that is, to display 12 columns in each row, and to control the number of cyclic rows based on the total number of records. If multiple fields are well implemented, one loop is done. If it is a field loop, it is troublesome. multiple loops and incremental variables need to be used at the same time, there are also many similar problems on the Internet with Phper. Today, I will share my solutions with you.

When multiple rows and control columns are cyclically displayed in the same field, the principle is to read the first loop by using Limit, and then add the number of records read in the first loop to the number of columns displayed in each row. The following code is directly attached:

Code for the first loop:

<tr><?php$rer=mysql_query(“select EI_EmployeeId,EI_EmployeeName from employeeinfo order by EI_EmployeeId asc limit 0,10″);while($inf=mysql_fetch_array($rer)){?> <td><input type=”checkbox” name=”menuemployname” id=”menuemployname” value=”<?php echo $inf['EI_EmployeeName']?>”/><?php echo $inf['EI_EmployeeName']?></td><?php }?></tr>

Loop code later:

<?php$rer=mysql_query(“select EI_EmployeeId,EI_EmployeeName from employeeinfo order by EI_EmployeeId asc”);$num=mysql_num_rows($rer);$i=0;$j=10;$count=ceil($num/$j);for($k=0;$k<$count;$k++){$i=$i+$j;?> <tr><?php$rer=mysql_query(“select EI_EmployeeId,EI_EmployeeName from employeeinfo order by EI_EmployeeId asc limit $i,$j”);while($inf=mysql_fetch_array($rer)){?> <td><input type=”checkbox” name=”menuemployname” id=”menuemployname” value=”<?php echo $inf['EI_EmployeeName']?>”/><?php echo $inf['EI_EmployeeName']?></td><?php }?></tr><?php }?>

Of course, there is a more direct method, that is, the first loop of multiple cycles, you only need to change the first parameter of Limit. I hope it will be helpful for beginners.